Welcome to waterfront living at its finest! This pristine, beautifully updated 3-bedroom, 3-bath home is perfectly situated along the picturesque Piscataqua River, offering deep-water access, a private dock, and breathtaking water views. A newly installed shoreline buffer provides added protection while preserving the property's natural beauty and tranquility. Enjoy an exceptional location with immediate access to Great Bay Yacht Club, downtowns Portsmouth, Dover and Durham, Hilton Park, restaurants, shopping, and major commuting routes. Step through the inviting new front porch into a light-filled interior where stunning river views greet you upon entry. The open-concept living area flows seamlessly into the designer kitchen, featuring a large center island that's ideal for entertaining family and friends. The first floor has been thoughtfully updated with new flooring, a stunning new full bath with a tiled walk-in shower, and a separate laundry area. Upstairs, the spacious primary suite offers cathedral ceilings, spectacular waterfront views, a luxurious en-suite bath with dual vanities and a tiled shower, and a generous walk-in closet. A second waterfront bedroom, an additional bedroom, and another full bath complete the second level. Extensive recent improvements include a new propane forced hot air heating system with central air conditioning, new ductwork, fresh interior and exterior paint, custom blinds, and a new deck. Whether you're searching for a year-round residence or the perfect waterfront getaway, this exceptional home offers the ideal blend of modern updates, comfort, and an unbeatable waterfront lifestyle.