Welcome to your dream waterfront retreat in the desirable neighborhood of The Farms! With over 200 ft of shoreline, this luxurious 4 bed, 5.5 bath estate boasts a stunning kitchen featuring a large island, 6-burner gas range, double ovens & an inviting keeping room. The main level has soaring 12-foot ceilings, hardwood floors, a private guest suite, an office & a large great room with a see-through fireplace shared with the screened porch. The second level includes 2 ensuites, a loft & 2 large walk-in attics - 1 is plumbed for a bath. The finished basement is an entertainer's paradise with a second kitchen & an additional guest suite. Step outside to your private oasis: a saltwater pool & pier with a boat slip that promises endless adventures on the water. This home perfectly blends luxury, comfort & breathtaking natural beauty. Don’t miss this unique opportunity to own a slice of waterfront paradise in this coveted community with tennis, pickleball courts, a pool, a clubhouse & more!