Modern Farmhouse with a WALKOUT on a premium WATERFRONT lot from Modello Homes!! This is the home you have been waiting for. Boasting over 5800sqft of finished living space with 3 of the 5 bedrooms being ideal for primary bedrooms, making this the perfect GENERATIONAL HOME. Main floor features a spacious foyer, glass walled office and 24ft high ceiling/fireplace in the great room. Irpinia kitchen, with commercial fridge/freezer and hidden pantry.The dining room has breathtaking views of the water which can be enjoyed further by stepping onto the 16x15 covered balcony.Primary bedroom is an absolute showstopper!Coffered ceiling/brick tile fireplace w walk around closet featuring end to end millwork/makeup desk leading to a sun filled ensuite with endless views of the water. Mono stringer floating staircase leads to a loft with a large living area, bedroom, WIC and ensuite. Basement showcases one more bed/bath and an massive unobstructed great room.$350/yr fee covers community pool/gym.