2878 Heather Row Ridge

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.