This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$800,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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.
Full Property Details
Full Property Details for 245 Piscataqua Rd
General
- Sold For: $800,000
- Taxes: $13,719 (2024)
- Status: Closed
- Type: Single Family
- Source: PrimeMLS
- MLS ID: 5061309
- Added to Site: 124 day(s) ago
Interior
- Number of Rooms: 7
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 1
- 3/4 Bathrooms: 1
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 2
- Primary Bedroom: 12 x 21, Level 1
- Bedroom 1: 16 x 18, Level 2
Other Rooms
- Living Room: 21 x 19, Level 1
- Kitchen: Kitchen, 12 x 13, Level 1
- Dining Room: Dining Room, 11 x 13, Level 1
- Loft: 9 x 33, Level 2
Location
- County: Strafford
- Driving Directions: Route 4 East, house on the left near the Dover line. You may have to put Durham as the city. This is a Madbury residence, with a Durham mailing address near the Dover line.
School Information
- School District: Oyster River Cooperative
- Elementary School: Moharimet School
- Middle School: Oyster River Middle School
- High School: Oyster River High School
Heating & Cooling
- Cooling Type: Central AC
- Heating Type: Forced Air
Utilities
- Sewer: 1250 Gallon, Leach Field, Private, Septic
Structural Information
- Construction Status: Existing
- Basement Entrance: Interior
- Basement Desc.: Unfinished
- Roof: Asphalt Shingles
- Stories/Levels: 2
- Square Feet: 2,459
- Finished Total: 2,459 Sq. Ft.
- Finished Above Grnd: 2,459 Sq. Ft.
- Year Built: 2005
Lot Features
- Lot Size (Acres): 0.33
- Lot Size (Sq. Ft.): 14,375
- Lot Dimensions: 9 x 33
- Frontage: No Road Frontage
- Driveway/Sidewalk: Paved
- Zoning: RA RE
Water Features
- Water Front: Yes
- Water View: Yes
- Water Access: Yes
- Water Front Type: Bay
- Water Front Name: Piscataqua River
- Water Front Owned: 1
Financial Considerations
- Price Per Sq. Ft.: $345.67
- Assessment Year: 2024
- Assessment Amount: $461,900
- Tax Amount: $13,719
- Tax Year: 2024
Disclosures and Reports
- Block: 3
Listed by Keller Williams Realty Metro-Concord, Mike Rennie
Sold by EXP Realty, Doug. Danzey
Get Pre-Approved Today
Schools
Schools serving 245 Piscataqua Rd
School District:Oyster River Cooperative School District
| Name | Grades | Distance |
|---|---|---|
Oyster River Middle School 1 Coe Drive, Durham, NH 03824 | 5-8 | 3.5 mi |
Moharimet School 11 Lee Road, Madbury, NH 03823 | K-4 | 5 mi |
Oyster River High School 55 Coe Drive, Durham, NH 03824 | 9-12 | 3.2 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 245 Piscataqua Rd
Date
Details
Price
Change
Source
1/05/2026
Sold
$800,000
-5.88%
MLS
11/03/2025
Price Reduced
$850,000
-2.86%
MLS
10/06/2025
Price Reduced
$875,000
-2.78%
MLS
9/15/2025
Listed
$900,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
245 Piscataqua Road, Madbury, NH 03823 (MLS# 5061309) is a Single Family property that was sold at $800,000 on January 05, 2026. Want to learn more about 245 Piscataqua Road? Do you have questions about finding other Single Family real estate for sale in Madbury? You can browse all Madbury real estate or contact a Coldwell Banker agent to request more information.

