Discover the ultimate solution for multi-generational living and flexible space at 25 Fosters Drive. Perched on a scenic hill, this exceptional home is intelligently designed with two primary suites, including a serene first-floor owner's retreat. Perfect for in-laws or one-level living, it offers privacy, stunning Piscataqua River views, and a spacious en-suite bath. The heart of the home is the sun-drenched, open-concept main level, where breathtaking water vistas are visible from the chef's kitchen, living room, and dining area. Upstairs, a second, palatial primary suite provides a private escape with a spa-like bath, while two additional bedrooms offer abundant space for family. The 2,100+ sq. ft. finished, walk-out lower level acts as a complete third living zone. This versatile space is ideal for a private guest suite, an au pair, or a teen retreat, featuring a media room, home gym, and direct access to the patio and hot tub. Enjoy the best of the Fosters Drive community with exclusive private access to a community dock. It's the perfect spot for launching kayaks, paddleboards, or simply enjoying the riverside tranquility. This rare property offers a sophisticated lifestyle with the space and privacy to accommodate everyone. Square footage estimated, buyer to verify. Seller is a licensed agent.