Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Hickok & Boardman
Property view
Listing view 2
Listing view 3

245 Piscataqua Road, 
Madbury, NH 03823

$850,000


2

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:

November 4, 2025, 02:46 PM

MLS#

5061309

Source:

PrimeMLS

About This Home

245 Piscataqua Road

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.

Home Facts

Single Family

3 Baths

2 Bedrooms

Built in 2005

Price Summary

850,000

$345 per Sq. Ft.

MLS #:

5061309

Last Updated:

November 4, 2025, 02:46 PM

Added:

1 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

2

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:

$850,000

Price per Sq. Ft:

$345 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 November 5, 2025

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.