Closed
Listed by:
Mike Rennie,
Keller Williams Realty Metro-Concord 603-226-2220
Bought with: EXP Realty
$800,000
245 Piscataqua Road, Madbury, NH 03823
2beds
2,459sqft
Single Family Residence
Built in 2005
0.33 Acres Lot
$803,800 Zestimate®
$325/sqft
$3,462 Estimated rent
Home value
$803,800
$739,000 - $876,000
$3,462/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Price Improvement — now offered at $850,000! Welcome to this 2-bedroom, 3-bath Post & Beam home. The first-floor primary suite features a tiled bath w/ jacuzzi tub. The main floor bathroom also includes the laundry. The open-concept kitchen with cherry cabinetry, granite counters, and stainless appliances flows into the dining/living area anchored by a stone fireplace with woodstove insert rising to the cathedral ceiling. Upstairs, a loft overlooks the living room—ideal for an office or studio—plus a second bedroom and a large bonus room that can serve as a third bedroom. Spacious bedrooms and the open-concept flow extend to a large deck—perfect for entertaining and taking in the view. This property offers scenic views of the Bellamy River and Royal Cove as the waterways open toward Little Bay and out to the Atlantic. Just two homes away from the historic Scammell Bridge, enjoy views of lobstering, oyster farming, and seasonal wildlife from shore or by kayak or sail. The location provides a private waterfront feel yet is minutes to Portsmouth, Dover, UNH, I-95, beaches, shopping, and airports. Boaters will appreciate tide-dependent access to Portsmouth and Newburyport, and outdoor lovers can enjoy nearby Hilton Park, Odiorne Point, Wallis Sands Beach, and the Bellamy Wildlife Refuge. Situated in the Oyster River School District, this home blends natural beauty with Seacoast convenience. Open House on Saturday, 11/8, from 12:00pm to 2:00pm.
Zillow last checked: 8 hours ago
Listing updated: January 06, 2026 at 11:59am
Listed by:
Mike Rennie,
Keller Williams Realty Metro-Concord 603-226-2220
Bought with:
Doug Danzey
EXP Realty
Source: PrimeMLS,MLS#: 5061309
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
Heating
- Forced Air
Cooling
- Central Air
Features
- Basement: Unfinished,Interior Entry
Interior area
- Total structure area: 4,439
- Total interior livable area: 2,459 sqft
- Finished area above ground: 2,459
- Finished area below ground: 0
Property
Parking
- Parking features: Paved
Features
- Levels: Two
- Stories: 2
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Waterfront
- Body of water: Piscataqua River
Lot
- Size: 0.33 Acres
- Features: Level
Details
- Parcel number: MADBM00011B000003L000000
- Zoning description: RA RE
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape
- Property subtype: Single Family Residence
Materials
- Post and Beam, Wood Exterior
- Foundation: Concrete
- Roof: Asphalt Shingle
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Electric: 200+ Amp Service, Circuit Breakers
- Sewer: 1250 Gallon, Leach Field, Private Sewer, Septic Tank
- Utilities for property: Propane
Community & neighborhood
Location
- Region: Madbury
Price history
| Date | Event | Price |
|---|---|---|
| 1/5/2026 | Sold | $800,000-5.9%$325/sqft |
Source: | ||
| 11/3/2025 | Price change | $850,000-2.9%$346/sqft |
Source: | ||
| 10/6/2025 | Price change | $875,000-2.8%$356/sqft |
Source: | ||
| 9/15/2025 | Listed for sale | $900,000+87.5%$366/sqft |
Source: | ||
| 7/12/2007 | Sold | $480,000$195/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $13,483 +8.2% | $461,900 |
| 2023 | $12,457 +6.7% | $461,900 |
| 2022 | $11,672 +3.7% | $461,900 +4.2% |
Find assessor info on the county website
Neighborhood: 03823
Nearby schools
GreatSchools rating
- 8/10Oyster River Middle SchoolGrades: 5-8Distance: 3.5 mi
- 10/10Oyster River High SchoolGrades: 9-12Distance: 3.2 mi
- 7/10Moharimet SchoolGrades: K-4Distance: 5.1 mi
Schools provided by the listing agent
- Elementary: Moharimet School
- Middle: Oyster River Middle School
- High: Oyster River High School
- District: Oyster River Cooperative
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$803,800
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
$803,800