A rare opportunity to own in one of New Castle's most sought-after coastal communities. Perfectly positioned along the Piscataqua River with tidal frontage, direct water access, and expansive water views, this exceptional residence offers a unique blend of waterfront living, privacy, and resort-style amenities. One of the few homes in the neighborhood with direct backyard access for kayaking, paddleboarding, and waterfront recreation, the property captures the essence of New Hampshire Seacoast living. Enjoy watching the tides change, boats pass by, and coastal wildlife from your own backyard retreat. Designed for both comfort and flexibility, the home features a sought-after first-floor primary suite with ensuite bath, sun-filled living spaces, hardwood floors, perennial gardens, whole-house generator, and a walkout finished lower level ideal for a home office, media room, fitness space, guest overflow, or playroom. Community amenities include a pool, tennis and pickleball courts, beach access, and function rooms. Nearby golf courses, marinas, yacht clubs, waterfront dining, and the iconic Wentworth by the Sea further enhance the coastal lifestyle experience. Located just minutes from downtown Portsmouth, private airports, and some of the Seacoast's most desirable beaches, this property offers a rare combination of luxury, recreation, low New Castle taxes, and one of the region's most exceptional waterfront settings.