(603)-770-4079

Realtors Licensed in New Hampshire, Maine, Massachusetts, Rhode Island, Alabama and Florida.

attalla@comcast.com

Save
Ask
Tour
Hide
Share
$875,000
38 Days On Site

245 Piscataqua Road
Madbury, NH 03823

For Sale|Single Family Residence|Active
2
Beds
3
Total Baths
1
Full Bath
2
Partial Baths
2,459
SqFt
$356
/SqFt
2005
Built
County:
NH-Strafford
Listing courtesy of Mike Rennie of Keller Williams Realty Metro-Concord

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: 603-770-4079
Is this the listing for you? We can help make it yours.
603-770-4079
245 Piscataqua Road245 Piscataqua Road245 Piscataqua Road245 Piscataqua Road
Save
Ask
Tour
Hide
Share

Price Improvement!! Now $875,000. Welcome to this 2-bedroom, 3-bath 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 Atlantic. The open-concept kitchen with cherry cabinetry, granite counters, and stainless appliances flows into a dining and living area anchored by a stone fireplace with woodstove insert rising to the cathedral ceiling. The first-floor primary suite features a tiled bath with jacuzzi and laundry. Upstairs, a loft overlooks the living room, ideal for an office, studio, or reading nook. You’ll also find a second bedroom plus a large bonus room big enough to serve as a third bedroom, offering comfort and flexibility. Just two houses from the historic Scammell Bridge, enjoy views of 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 quick access to I-95, beaches, outlets, and airports. Boating enthusiasts will love tide-dependent access to Portsmouth and Newburyport, while outdoor lovers can explore Hilton Park, Odiorne Point, Wallis Sands Beach, and the Bellamy Wildlife Refuge. Located in the Oyster River School District, this home blends timeless character, natural beauty, and Seacoast convenience. Open House: Saturday, 10/11: 11am to 12:30pm AND Sunday, 10/12: 12pm to 1:30pm.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$875,000
Days On Site 
38 Days
Bedrooms 
2
Inside Area (SqFt) 
2,459 sqft
Total Baths 
3
Full Baths 
1
Partial Baths 
2
Lot Size 
0.33 Acres
Year Built 
2005
MLS® Number 
5061309
Status 
Active
Property Tax 
$13,483
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a week agoListing updated with changes from the MLS®
3 weeks agoPrice changed to $875,000
a month agoListing first seen on site
General Features
Acres 
0.33
Number Of Stories 
2
Parking 
Paved
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
SqFt Above 
2459
SqFt Total 
4439
Style 
Cape
Water Source 
WellPrivate
Zoning 
RA RE
Interior Features
Appliances 
Water Purifier
Basement 
Unfinished
Cooling 
Central Air
Electric 
200+ Amp ServiceCircuit Breakers
Interior 
High Speed Internet
Bedroom 2 
Dimensions - 16x18
Bonus Room 
Dimensions - 10x16
Dining Room 
Dimensions - 11x13
Kitchen 
Dimensions - 12x13
Living Room 
Dimensions - 21x19
Loft 
Dimensions - 9x33
Primary Bedroom 
Dimensions - 12x21
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Wood Siding
Lot Features 
LevelWaterfront
Roof 
Shingle
View 
Water
Waterfront 
Yes
Waterfront Features 
Piscataqua River
Waterview 
Water
Community Features
School District 
Oyster River Cooperative
Schools
School District
Oyster River Cooperative
Elementary School
Moharimet School
Middle School
Oyster River Middle School
High School
Oyster River High School
Listing courtesy of Mike Rennie of Keller Williams Realty Metro-Concord



Copyright 2025, PrimeMLS, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this display comes in part from the IDX Program of PrimeMLS. 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.
Last checked: 2025-10-24 09:37 AM UTC
Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share