2878 Heather Row Ridge SW

Experience timeless elegance and rare riverfront privacy on 13 pristine acres with direct access to the Yellow River. This luxury estate offers grand entertaining spaces, high-end finishes, and flexible multi-generational living across three levels. A dramatic two-story foyer with white and gold tile and a curved staircase sets the tone for this exceptional home. The sunken formal living room features 12FT ceilings, black lacquer floors, and a gold and white stone fireplace, while the formal dining room comfortably seats 12 and is wrapped in gold fabric wallpaper. The gourmet kitchen is a chef's dream: gas and electric cooktops (4 burners each), stone counters, double ovens, two dishwashers, a hidden pantry, prep sink, recessed lighting, built-in bookshelf, and a cozy breakfast nook with bay windows and stone fireplace. The main-level primary suite includes a sitting area, private balcony, fireplace with porcelain surround, and views of a peaceful koi pond. The spa-inspired bathroom features heated/cooled porcelain floors, floor-to-ceiling tile, a 6-ft floating vanity, LED mirror, 5-head shower, freestanding Kallista tub, and Kohler bidet toilet with electric controls. Dual closets and access to a semi-finished attic (ideal for expanding to a two-story closet) complete the suite. Upstairs offers two renovated en-suite bedrooms, a third large bedroom with walk-in closet and window seat, a full hallway bath, a game room or potential bedroom, and a walk-in attic. Bathrooms include floating vanities, LED mirrors, recessed lighting, tiled showers, and designer finishes. The finished basement offers a private bonus room with skylight windows, a 8-ft island/bar, under-stair storage, full bathroom, laundry, and an LED light feature in progress. A separate basement apartment includes two bedrooms (one en-suite), a full kitchen, living room, and private entrance with separate driveway-ideal for guests, in-laws, or rental income. Additional highlights: * 3 driveways including Bernard Rd access * Tri-zone HVAC with 3 AC units * 2 gas water heaters (2009) * 3 full bathrooms upstairs * 1 full bath with laundry on main * Laundry in basement * Office with oversized window * Rain guards on gutters * Private back staircase from kitchen * Walk-in attic , Multiple fireplaces (living, kitchen, and primary). This home is built for both elevated everyday living and grand-scale entertaining. From luxury finishes to practical amenities and unforgettable Yellow River views, this estate is more than a home, it's a lifestyle.