Welcome to this exceptional to be constructed modern farmhouse, located in the prestigious Shackford Point Estates. Offering approximately 5,416 square feet of finished living space above ground, with an option to add a home theater and additional finished space in the lower level, this luxurious home is designed for both comfort and style. The property boasts a spacious 3-car garage, 4 bedrooms, and 5.5 baths, providing ample room for family and guests. Set on roughly 225 feet of stunning water frontage, this home offers breathtaking views of Great Bay, the Piscataqua River, and access to the Atlantic Ocean. With the potential to obtain permits for a deep-water dock, this property is perfect for boating enthusiasts and those who appreciate waterfront living. Experience the ultimate in privacy and elegance in one of the most exclusive communities on the seacoast.