This extraordinary waterfront estate offers luxury, privacy and breathtaking water views. Comprised of nearly 400ft of water frontage, situated on approximately 12 acres, this beautifully updated residence features a sought after first floor primary suite, an additional 2nd floor ensuite, and full bath in the family room (frog) to serve as an ensuite ideal for guests. This property's main house has a thoughtfully designed layout, a spacious 3 bay garage, new roof, two new hvac systems and new LVP flooring. Highlighted inside is a chef inspired gourmet kitchen with updated high end appliances, and an expansive island perfect for entertaining or casual dining while over-looking the water. A well-appointed 900+sqft guest apartment is located on the right end of the 8 stall modern stables and would provide comfortable accommodations for visitors, multigenerational living or rental potential. The turn key equestrian facility features a temperature controlled tack room, dedicated feed room, additional water softener system, vast equipment and supplies storage. Not an equine person? There is lease potential to horse owners, or use as hobby space, possible venue space, fruit tree orchards, the possibilities are very versatile. Whether enjoying the peaceful waterfront setting, hosting gatherings or caring for your equine partners, this exceptionally hard to find property delivers an unparalleled lifestyle.