Truly one-of-a-kind, this waterfront estate offers an exceptional setup for multi-generational living, extended guests, or income-producing possibilities, with three distinct living spaces thoughtfully designed to provide both privacy and connection. The main residence features 3 bedrooms and 2 bathrooms on the main level, along with an expansive open-concept living, dining, and kitchen area designed for gathering and entertaining. A cozy sitting area anchored by a beautiful stone fireplace adds warmth and character, while the light-filled sunroom showcases stunning water views. The finished basement provides even more flexibility with a spacious living/flex room, dining area, kitchenette, 1 bedroom, and 1.5 bathrooms-creating an ideal space for guests, extended family, or a private secondary living area. The second residence offers its own private front entrance while also providing interior access to the main home when desired. Upstairs, you'll find 2 bedrooms, 1 bathroom, and an open-concept kitchen, dining, and living area. A gorgeous sunroom overlooking the water creates the perfect place to relax and enjoy the view. The lower level includes an additional bedroom and full bathroom, offering even more privacy and versatility. Adding to the uniqueness of the property are three separate garages, allowing each living area to maintain a sense of independence while remaining part of one cohesive estate. Outside, a spacious deck and patio invite you to take full advantage of the peaceful waterfront setting, with expansive views creating an incredible backdrop for everyday living and entertaining. Whether envisioned as a multi-generational family compound, private guest accommodations, or a property with rental income potential, this remarkable waterfront estate offers a combination of space, flexibility, and views that is truly hard to find. Located just minutes to Athens or 316, great for commuting!!