Skip To Content
Courtesy of Mike Rennie of Keller Williams Realty Metro-Concord: .

245 Piscataqua Road

Madbury, NH 03823
  • $850,000
  • STATUS: Active Under Contract
  • ON SITE: 80 Days
  • MLS #: 5061309
Under Contract
UPDATED: 44 min ago
$850,000
  • 2
    BEDS
  • 0.33
    ACRES
  • 2
    BATHS
  • 1
    1/2 BATHS
  • 2,459
    SQFT
  • $346
    $/SQFT
Type:
Single-Family Home
Built:
2005
County:
Area:

School Information

Elementary School:
School District:

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.

Monthly Payment Calculator



© Copyright 2025 PrimeMLS. 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 PrimeMLS. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated 2025-12-05T12:06:18.64.
www.welcomeaboderealty.com/homes/167916422
Print Image

245 Piscataqua Road Madbury, NH 03823

  • Price: $850,000
  • Status: Active Under Contract
  • On Site: 80 Days
  • Updated: 44 min ago
  • MLS #: 5061309
2
Beds
2
Baths
1
½ Baths
0.33
Acres
2,459
SQFT
$346
$/SQFT
2005
Built
County:
Strafford
Area:
Madbury
Elementary School:
Moharimet School
Middle School:
Oyster River Middle School
High School:
Oyster River High School
School District:
Oyster River Cooperative
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.
Exterior Features

Architectural Style Cape Construction Materials Post and BeamWood Exterior Driveway Paved Has Garage No Lot Features LevelWaterfront Lot Number 0 Owned Land Yes Road Frontage No Roof Asphalt Shingle Water Access Details Deep Water Access Water Body Access YN Yes Water Body Type Bay Water View YN Yes Waterfront Property Yes Waterfront Property Rights Exclusively Owned

Interior Features

Basement Access Type Interior Basement Description Unfinished Cooling Central AC Foundation Concrete Has Basement Yes Heating Forced Air Quarter Baths 0 Rooms Level1 Level 1: Dining RoomLevel 1: KitchenLevel 1: Living RoomLevel 1: Primary Bedroom Rooms Level2 Level 2: BedroomLevel 2: Bonus RoomLevel 2: Loft Rooms Total 7 Sq Ft Approx Fin Above Grade 2459 Sq Ft Approx Fin Below Grade 0

Property Features

Assessment Amount 461900 Assessment Year 2024 Auction No Block 3 Construction Status Existing Covenants No Electric 200+ Amp ServiceCircuit Breaker(s) Flood Zone No Foreclosed / Bank Owned / REO No Pre Construction No Property Type Single Family Road Frontage Type Public Seasonal No Sewer 1250 GallonLeach FieldPrivateSeptic Surveyed Unknown Tax Gross Amount 13719 Tax Year 2024 Taxes Tbd Yes Timeshare Fractional Own No Utilities Propane Water Restrictions Unknown Water Source Drilled WellPrivateReverse Osmosis Zoning RA RE

Courtesy of Mike Rennie of Keller Williams Realty Metro-Concord: .


© Copyright 2025 PrimeMLS. 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 PrimeMLS. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated 2025-12-05T12:06:18.64.
 
https://bt-photos.global.ssl.fastly.net/nneren/1280_boomver_2_5061309-2.jpg https://bt-photos.global.ssl.fastly.net/nneren/1280_boomver_2_5061309-2.jpg https://bt-photos.global.ssl.fastly.net/nneren/1280_boomver_2_5061309-2.jpg
Logo
Keller Williams Coastal and Lakes & Mountains
750 Lafayette Road
Portsmouth NH, 03801