REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

2026

Jan

Fri

Jan

Sat

Jan

The Scoville Foley Team

info@scovillefoleyhomes.com +1(207) 885-0500

Listed by Mike Rennie • Keller Williams Realty Metro-Concord

$ 850,000

Est. payment -/mo

Save Virtual Tour

Under Contract

245 Piscataqua RD Madbury, NH 03823

2 Beds

3 Baths

2,459 SqFt

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family

Listing Status Under Contract

Purchase Type For Sale

Square Footage 2,459 sqft

Price per Sqft $345

MLS Listing ID 5061309

Style Cape

Bedrooms 2

Full Baths 1

Half Baths 1

Three Quarter Bath 1

Construction Status Existing

Year Built 2005

Annual Tax Amount $13,719

Tax Year 2024

Lot Size 0.330 Acres

Acres 0.33

Property Sub-Type Single Family

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.

Location

State NH

County Nh-strafford

Area Nh-Strafford

Zoning RA RE

Body of Water Piscataqua River

Rooms

Basement Entrance Interior

Basement Unfinished

Interior

Heating Forced Air

Cooling Central AC

Exterior

Parking Features No

Utilities Available Propane

Waterfront Description Yes

View Y/N Yes

Water Access Desc Yes

View Yes

Roof Type Asphalt Shingle

Building

Lot Description Level, Waterfront

Story 2

Sewer 1250 Gallon, Leach Field, Private, Septic

Water Drilled Well, Private, Reverse Osmosis

Architectural Style Cape

Construction Status Existing

Schools

Elementary Schools Moharimet School

Middle Schools Oyster River Middle School

High Schools Oyster River High School

School District Oyster River Cooperative

Others

Virtual Tour https://andrewspielerphotography.hd.pics/245-Piscataqua-Rd-1/idx

The Scoville Foley Team

+1(207) 885-0500

GET MORE INFORMATION

QUICK SEARCH

Scarborough, ME

The Scoville Foley Team

245 Piscataqua RD Madbury, NH 03823

Key Details

Location

Rooms

Interior

Exterior

Building

Schools

Others

GET MORE INFORMATION

Go tour this home

245 Piscataqua RD

QUICK SEARCH