Experience the pinnacle of New Hampshire coastal living in this exceptional waterfront home in the coveted Mill Pond community at Wentworth by the Sea. Perfectly sited on the water’s edge, it offers sweeping tidal views and spectacular westerly sunsets. Thoughtfully designed for comfort and connection to nature, the home features a first-floor primary suite, a dramatic vaulted living room, and walls of glass that flood the interior with natural light and panoramic views. The stylish eat-in kitchen blends beauty and function—ideal for daily living and entertaining. A bright sunroom opens to a spacious waterside deck, perfect for alfresco dining or peaceful evenings by the shore. The walk-out basement adds versatility with a fourth bedroom, office space, and direct water access—perfect for guests, multigenerational living, or a serene home office. Residents enjoy resort-style amenities including a pool, tennis and pickleball courts, and private beach access. The nearby Wentworth Marina and acclaimed Salt restaurant at the historic hotel add to the allure. Just minutes from scenic New Castle Common and vibrant downtown Portsmouth, this rare offering delivers a lifestyle of peace, beauty, and convenience.
Closed
Listed by:
Tony Jalbert,
Tate & Foss Sotheby's International Rlty 603-964-8028
Bought with: Carol Parker Real Estate
$3,400,000
24 Mill Pond Road, New Castle, NH 03854
4beds
3,738sqft
Condominium
Built in 1998
-- sqft lot
$3,487,200 Zestimate®
$910/sqft
$5,964 Estimated rent
Home value
$3,487,200
$3.24M - $3.77M
$5,964/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$5,964/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$5,964/mo
Rent Zestimate®
Refinance and save
$18,284/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$18,284/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: July 18, 2025 at 09:06am
Listed by:
Tony Jalbert,
Tate & Foss Sotheby's International Rlty 603-964-8028
Bought with:
Carol Parker
Carol Parker Real Estate
Source: PrimeMLS,MLS#: 5042324
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Cooktop, Dishwasher, Dryer, Microwave, Wall Oven, Refrigerator, Washer, Exhaust Fan
- Laundry: Laundry Hook-ups, 1st Floor Laundry
Features
- Central Vacuum, Cathedral Ceiling(s), Ceiling Fan(s), Kitchen/Family, Living/Dining, Primary BR w/ BA, Natural Light, Indoor Storage, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Hardwood, Tile
- Basement: Climate Controlled,Concrete Floor,Daylight,Finished,Full,Interior Stairs,Storage Space,Walkout,Interior Access,Exterior Entry,Walk-Out Access
- Attic: Attic with Hatch/Skuttle
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 3,738
- Total interior livable area: 3,738 sqft
- Finished area above ground: 2,874
- Finished area below ground: 864
Property
Parking
- Total spaces: 2
- Parking features: Paved, Auto Open, Direct Entry, Off Street, Parking Spaces 2, Attached
- Garage spaces: 2
Features
- Levels: 1.75
- Stories: 1
- Patio & porch: Covered Porch
- Exterior features: Deck, Garden
- Fencing: Partial
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: River Front, Waterfront, Wetlands, Island, Tidal
- Body of water: Mill Pond
- Frontage length: Road frontage: 73
Lot
- Size: 0.28 Acres
- Features: Condo Development, Landscaped, Sloped, Subdivided, Trail/Near Trail, Views, Near Country Club, Near Golf Course, Neighborhood
Details
- Parcel number: NCASM00004B000003L000050
- Zoning description: 06-Planned Development
- Other equipment: Standby Generator
Construction
Type & style
- Home type: Condo
- Architectural style: Contemporary
- Property subtype: Condominium
Materials
- Wood Frame, Shake Siding, Wood Exterior
- Foundation: Concrete
- Roof: Asphalt Shingle
Condition
- New construction: No
- Year built: 1998
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Public Sewer
- Utilities for property: Cable Available, Propane, Underground Gas, Underground Utilities
Community & neighborhood
Security
- Security features: Security, Security System, Smoke Detector(s)
Location
- Region: New Castle
- Subdivision: Wentworth By The Sea
HOA & financial
Other financial information
- Additional fee information: Fee: $960
Price history
| Date | Event | Price |
|---|---|---|
| 7/18/2025 | Sold | $3,400,000+0.1%$910/sqft |
Source:  PrimeMLS #5042324 Report a problem | ||
| 5/27/2025 | Contingent | $3,395,000$908/sqft |
Source: PrimeMLS #5042324 Report a problem | ||
| 5/22/2025 | Listed for sale | $3,395,000+121.2%$908/sqft |
Source: PrimeMLS #5042324 Report a problem | ||
| 8/2/2006 | Sold | $1,535,000+126.7%$411/sqft |
Source: Public Record Report a problem | ||
| 7/17/1998 | Sold | $677,100$181/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $10,536 +8.2% | $1,954,700 |
| 2023 | $9,734 +10.7% | $1,954,700 |
| 2022 | $8,796 -14.1% | $1,954,700 +20.3% |
Find assessor info on the county website
Neighborhood: 03854
Nearby schools
GreatSchools rating
- NAMaude H. Trefethen SchoolGrades: K-6Distance: 0.5 mi
- 7/10Portsmouth Middle SchoolGrades: 6-8Distance: 1.9 mi
- 5/10Robert W Traip AcademyGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: Maude H. Trefethen School
- Middle: Rye Junior High School
- High: Portsmouth High School
- District: New Castle
Source: PrimeMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,487,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,487,200
- New Hampshire
- Rockingham County
- New Castle
- 03854
- 24 Mill Pond Road