Listing provided courtesy of @properties Christie's Int'l R.E. BirminghamMLS# 61003009MLS Provider
  • 13 days on site
  • 0 views

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!

Source: Great Lakes Repository, MLS#: 61003009

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    0.61 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Kevin Prokopp

Create a profile so you can receive updates on this property as soon as they happen!

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Life at 595 Ridge Point Drive


Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
6/19/2026Source: Great Lakes Repository Status Change
Active
6/17/2026Source: Great Lakes Repository Added to Database
June 17, 2026