Nestled along the shores of Pickering's Creek, back channel to the Piscataqua River, this c1886 waterfront home has been masterfully renovated and expanded, blending timeless charm with modern convenience. Glistening water views from every room, graceful architectural lines, and abundant natural light explain why this exceptional property has only had two owners. The open-concept layout draws you to stunning views, while the chef's kitchen-featuring custom Jewett Farms cabinetry, top-tier appliances, and a walk-in pantry-is ideal for both casual living and entertaining. The primary suite offers a spa-like retreat with a luxurious ensuite bath. The finished third floor adds flexible space with panoramic water views-ideal for a studio, office, or extra bedrooms. Outside, enjoy dining under the pergola's lights, cozy up by the firepit, or relax on the deck overlooking the lawn, private dock, and tidal waterfront with seabirds and river activity. A 1-car detached garage, styled like a boathouse, adds storage and offers ADU potential (subject to local approvals). With a cozy gas-fired stove, central air, and thoughtfully oriented for privacy inside and out, this home is comfortable year-round. Located on a quiet no-outlet street, just minutes from downtown, it captures unforgettable sunrises and sunsets. A truly rare find. Owner is a licensed Realtor®.