ELITE NEIGHBORHOOD PAIRED WITH UNMATCHED WATERFRONT ACCESS AND THE HIGHEST QUALITY CRAFTSMANSHIP! Privately set on 3.6 lush acres at the confluence of Fresh Creek and the Cocheco River, this exceptional waterfront estate offers refined living in one of the Seacoast's most coveted neighborhoods. The shingle-style Fiorentino-designed home spans 5,247 sq ft featuring 5 bedrooms, 5 baths, a three-season sunroom, formal and casual dining spaces, a private executive office suite, and a rec room with wet bar and covered balcony. Designed for both comfort and elevated entertaining, the outdoor setting is equally impressive. Enjoy tranquil sunrises over Fresh Creek, unwind by the heated saltwater pool with integrated spa and Pebble Tec finish, or gather around the west-facing gas firepit for sunset views. Looking for something a little more rustic?... there is a perfect campsite by the water's edge with wood firepit, and access to water and electric! A private dock provides direct access to New Hampshire’s inland coast and the Atlantic Ocean beyond. Inside, the home showcases exceptional craftsmanship and high-end finishes, including custom cabinetry and built-ins by Jewett Farms, Sub-Zero and Wolf appliances, red birch flooring, twin wood-burning fireplaces, and premium fixtures by Hubbardton Forge and Kohler. Additional features include a heated three-car garage with dog wash, geothermal HVAC, spray foam insulation, and a standby generator for year-round efficiency and peace of mind. Need more space or room for longer-term guests? The lot was pre-planned for a carriage house or barn with living quarters. Ideally located on prestigious Saddle Trail Drive, just minutes to Cochecho Country Club, Berwick Academy, downtown Portsmouth, and the Seacoast’s renowned beaches and dining. It would take years to design and build a home of this caliber. Pair that with pristine grounds, exceptional water views and access to NH's inland coast, and you will not find a better investment!