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

Tue

Sep

Wed

Sep

Thu

Sep

Keith Vaillancourt

keith@kvrealtynh.net +1(603) 540-1072

Listed by Mike Rennie • Keller Williams Realty Metro-Concord

$ 900,000

Est. payment | -/mo

3 Beds

3 Baths

2,459 SqFt

Save Virtual Tour

$ 900,000

Est. payment | -/mo

Save Virtual Tour

3 Beds

3 Baths

2,459 SqFt

Open House

Sat Sep 20, 12:00pm - 2:00pm

Sun Sep 21, 11:00am - 1:00pm

Key Details

Property Type Single Family Home

Sub Type Single Family

Listing Status Active

Purchase Type For Sale

Square Footage 2,459 sqft

Price per Sqft $366

MLS Listing ID 5061309

Style Cape

Bedrooms 3

Full Baths 1

Half Baths 1

Three Quarter Bath 1

Construction Status Existing

Year Built 2005

Annual Tax Amount $13,483

Tax Year 2024

Lot Size 0.330 Acres

Acres 0.33

Property Sub-Type Single Family

Property Description

Welcome to this classic 3-bedroom, 3-bathroom Post and Beam home with sweeping views of the Bellamy River and Royal Cove, where the river meets Little Bay and flows into Great Bay, the Piscataqua River, and out to the Isles of Shoals and the Atlantic Ocean. The open-concept kitchen with cherry cabinetry, granite counters, and stainless appliances flows into a dining and living area anchored by a magnificent stone fireplace with woodstove insert rising to the cathedral ceiling. The first-floor primary suite features a tiled bath with jacuzzi and convenient laundry. Upstairs, a versatile loft overlooks the living room, ideal for an office, studio, or reading nook. The other two spacious bedrooms are also upstairs, providing comfort and flexibility for family or guests. Just two houses from the historic Scammell Bridge, enjoy a front-row seat to lobstering, oyster farms, and wildlife including herons, eagles, and seasonal visitors by kayak or sail. This waterfront property offers privacy yet is minutes to downtown Portsmouth, Dover, and UNH, with easy access to I-95, beaches, outlets, and airports. Boating enthusiasts will love tide-dependent access to Portsmouth and Newburyport, while outdoor lovers will enjoy Hilton Park, Odiorne Point, Wallis Sands Beach, and the Bellamy Wildlife Refuge. Located in the Oyster River School District, this home blends timeless character, stunning scenery, and Seacoast convenience. Showings begin 9/17/2025. Open House 9/20 12-2 & 9/21 11-1.

Location

State NH

County Nh-strafford

Area Nh-Strafford

Zoning RA RE

Body of Water Bay

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

"My job is to find and attract mastery-based agents to the office, protect the culture, and make sure everyone is happy! "

+1(603) 540-1072

keith@kvrealtynh.net

12 Concord Ave, Derry, New Hampshire, 03038, USA

245 Piscataqua RD Madbury, NH 03823