Listing by: Mike Rennie, Keller Williams Realty Metro-Concord, 603-226-2220
2 Beds
3 Baths
2,459SqFt
Closed
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.
Property Details | ||
|---|---|---|
| Price | $850,000 | |
| Close Price | $850,000 | |
| Bedrooms | 2 | |
| Full Baths | 1 | |
| Half Baths | 1 | |
| Total Baths | 3 | |
| Property Style | Cape | |
| Lot Size Area | 14375 | |
| Acres | 0.33 | |
| Property Type | Residential | |
| Sub type | SingleFamilyResidence | |
| MLS® Sub type | Single Family | |
| Stories | 2 | |
| Year Built | 2005 | |
| Roof | Asphalt Shingle | |
| Waterfront | Piscataqua River | |
| Heating | Forced Air | |
| Foundation | Concrete | |
| Lot Description | Level,Waterfront | |
| Additional Rooms | 7 | |
Geographic Data | ||
| 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. | |
| County | NH-Strafford | |
| Latitude | 43.130708000001 | |
| Longitude | -70.854631 | |
| Market Area | NH-Strafford | |
Address Information | ||
| Address | 245 Piscataqua Road, Madbury, NH 03823 | |
| Postal Code | 03823 | |
| City | Madbury | |
| State | NH | |
| Country | United States | |
Listing Information | ||
| Listing Office | Keller Williams Realty Metro-Concord | |
| Listing Office Phone | 603-226-2220 | |
| Listing Office Email | ecarrasquillo@kw.com | |
| Listing Agent | Mike Rennie | |
| Listing Agent Phone | 603-226-2220 | |
| Virtual Tour URL | https://andrewspielerphotography.hd.pics/245-Piscataqua-Rd-1/idx | |
School Information | ||
| District | Oyster River Cooperative | |
| Elementary School | Moharimet School | |
| Middle School | Oyster River Middle School | |
| High School | Oyster River High School | |
MLS® Information | ||
| Days on market | 72 | |
| MLS® Status | Closed | |
| Listing Date | Sep 15, 2025 | |
| Listing Last Modified | Jan 6, 2026 | |
| Tax Year | 2024 | |
| Tax Annual Amount | 13719 | |
| MLS® Area | NH-Strafford | |
| MLS® # | 5061309 | |
Map View
This information is believed to be accurate, but without any warranty.