Welcome to your own private resort in the heart of Dundee! Custom built in 2005, this meticulously-designed brick luxury estate offers 5 bedrooms, 4.5 baths, and an exceptional blend of elegance, recreation, and waterfront living. Situated on a deep 0.61-acre riverfront lot, this property features a private in-ground pool, movie theater, outdoor basketball court, outdoor kitchen, gazebo, and upper and lower custom wood decks that create an incredible multi-level outdoor living experience. A completely finished walkout basement with an en-suite bedroom offers abundant additional living space and plenty of storage, designed for both entertaining and everyday functionality. Inside, soaring ceilings and expansive windows in the living room create a dramatic, light-filled space with beautiful views of the surrounding landscape. The home showcases granite countertops, high-end finishes throughout, and a thoughtfully designed open layout that enhances both comfort and flow. The scenic waterfront setting offers a peaceful, natural backdrop while remaining conveniently located near local amenities, dining, shopping, and major commuter routes. A rare opportunity to own a true one-of-a-kind property offering resort-style living with exceptional indoor and outdoor spaces!