Stunning, one-of-a-kind split-level estate ideally situated on the Clinton River, just seconds from Lake St. Clair, offering the ultimate waterfront lifestyle. Extensive recent upgrades make this home truly turnkey, including a brand-new retaining wall and seawall, 40-ft. steel dock, and a new 17,000 lb Golden boat lift. Outdoor living is unmatched with a new composite back deck showcasing a dramatic 360-degree gas fireplace and a fully equipped outdoor kitchen featuring a refrigerator, 22" griddle, and 36" barbecue. A new paver patio and composite boardwalk along the seawall complete this incredible waterfront setting. A whole-house generator provides added peace of mind. Inside, updates continue with fresh paint, new carpet, and luxury vinyl plank flooring. The impressive great room features a step ceiling, cozy gas fireplace, and doorwall leading to your backyard oasis. The open-concept layout flows seamlessly into the chef's kitchen, appointed with brand-new quartzite countertops, premium Wolf and Sub-Zero stainless steel appliances, a built-in wine cooler, and a large island with bar seating-perfect for entertaining. Host elegant gatherings in the formal dining room, and enjoy working from home in the stately office with cathedral ceilings and timeless wainscoting. Designed for ultimate comfort and flexibility, each level offers its own laundry room and primary ensuite. The entry-level ensuite features a walk-in closet and private doorwall to the back deck. The expansive upper-level ensuite is a true retreat with a private balcony overlooking the water, gas fireplace, kitchenette, and custom built-in closet system. Two additional ensuites provide exceptional accommodations, including one with a spacious sitting room. Completing the home is an impressive 40x23 attached garage with new gas heat and epoxy floors. A rare opportunity to own a thoughtfully updated waterfront masterpiece.