Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Old Mill Properties
Property view
Listing view 2
Listing view 3

245 Piscataqua Road, 
Madbury, NH 03823

$900,000


3

Beds


3

Baths


2,459

Sq Ft


Single Family


Virtual Tour

Active

Listed by

Mike Rennie

Keller Williams Realty Metro-Concord

603-226-2220

Last updated:

September 15, 2025, 01:58 PM

MLS#

5061309

Source:

PrimeMLS

About This Home

245 Piscataqua Road

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.

Home Facts

Single Family

3 Baths

3 Bedrooms

Built in 2005

Price Summary

900,000

$366 per Sq. Ft.

MLS #:

5061309

Last Updated:

September 15, 2025, 01:58 PM

Added:

1 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

1

Interior

Living Area:

2,459 Sq. Ft.


Structure

Structure

Building Area:

4,439 Sq. Ft.

Year Built:

2005


Lot

Lot Size (Sq. Ft):

14,375


Finances & Disclosures

Finances

Price:

$900,000

Price per Sq. Ft:

$366 per Sq. Ft.

MLS Logo
Copyright 2025 Prime MLS, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of Prime MLS. The information being provided is for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated September 16, 2025
See this home in person
245 Piscataqua Road
Attend an upcoming open house
Sat, Sep 20
12:00 PM02:00 PM
Sun, Sep 21
11:00 AM01:00 PM

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.