Beach Homes Realty
Enter City or Zip
WaterfrontNew Listing

245 piscataqua road

Madbury, NH 03823

$900,000

2 BEDS 1-Full 1-Half 1-¾ BATHS
2,459 SQFT0.33 AC LOT
Residential - Single Family
WaterfrontNew Listing
Image 0
Image 1
Image 2
Image 3
Bedrooms 2
Total Baths 3
Full Baths 1
Square Feet 2459
Acreage 0.33
Status Active
MLS # 5061309
County Strafford
More Info
Category Residential - Single Family
Status Active
Square Feet 2459
Acreage 0.33
MLS # 5061309
County Strafford
Listed By: Listing Agent Mike Rennie
Keller Williams Realty Metro-Concord
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. Showings begin 9/17. Open House 9/20 12-2 & 9/21 11-1.
Location not available

Exterior Features

  • Style Cape
  • Construction Post and Beam, Wood Exterior
  • Siding Post and Beam, Wood Exterior
  • Roof Asphalt Shingle
  • Garage No
  • Garage Description No
  • Water Drilled Well, Private, Reverse Osmosis
  • Sewer 1250 Gallon, Leach Field, Private, Septic
  • Lot Description Level, Waterfront

Interior Features

  • Heating Forced Air
  • Cooling Central AC
  • Basement Yes
  • Fireplaces Description N/A
  • Living Area 2,459 SQFT
  • Year Built 2005
  • Stories 2

Neighborhood & Schools

  • School Disrict Oyster River Cooperative
  • Elementary School Moharimet School
  • Middle School Oyster River Middle School
  • High School Oyster River High School

Financial Information

    Additional Services

    Internet Service Providers

    Listing Information

    Listing Provided Courtesy 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, 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 09/17/2025.
    Listing data is current as of 09/17/2025.

    Contact our Agent !

    By clicking “Submit”, you agree that Beach Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.