Truly One-of-a-Kind Multi-Generational Waterfront Estate! Discover an exceptional opportunity for multi-generational living, extended guests, or income potential with three separate homes under one roof, thoughtfully designed for privacy, comfort, and connection. The main residence offers 3 bedrooms and 2 bathrooms on the main level with an expansive open-concept living, dining, and kitchen area-perfect for gathering and entertaining. Enjoy a sitting area centered around a stunning stone fireplace, plus a light-filled sunroom with breathtaking water views. The finished basement expands the living space with a large living/flex room, dining area, kitchenette, one bedroom, and 1.5 bathrooms-ideal for guests, teens, or in-law accommodations. The second home features its own front entrance while still offering interior access to the main residence for convenience. The upper level includes 2 bedrooms, 1 bathroom, and an open living, dining, and kitchen space highlighted by a gorgeous sunroom overlooking the water. The lower level adds another bedroom and full bathroom, creating a private retreat for extended family or rental use. With three separate garages, each living space enjoys a sense of independence while maintaining the benefits of one cohesive property. Step outside to enjoy both a patio and deck, perfectly positioned to take in the serene waterfront setting and panoramic views for days. This rare property offers endless possibilities-multi-generational living, guest suites, rental income, or a private family compound-all in a stunning waterfront setting.