Skip main navigation
Closed
  • Listed by: 

    Mike Rennie,

    Keller Williams Realty Metro-Concord 603-226-2220

    Bought with: EXP Realty
    $800,000

    245 Piscataqua Road, Madbury, NH 03823

    2beds
    2,459sqft
    Single Family Residence
    Built in 2005
    0.33 Acres Lot
    $803,800 Zestimate®
    $325/sqft
    $3,462 Estimated rent

    Home value

    $803,800

    $739,000 - $876,000

    $3,462/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $3,462/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,462/mo

    Rent Zestimate®

    Refinance and save

    $4,529/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,529/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    Zillow last checked: 8 hours ago

    Listing updated: January 06, 2026 at 11:59am

    Listed by:

    Mike Rennie,

    Keller Williams Realty Metro-Concord 603-226-2220

    Bought with:

    Doug Danzey

    EXP Realty

    Source: PrimeMLS,MLS#: 5061309MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 3
    • Full bathrooms: 1
    • 3/4 bathrooms: 1
    • 1/2 bathrooms: 1
    Heating
    • Forced Air
    Cooling
    • Central Air
    Features
    • Basement: Unfinished,Interior Entry
    Interior area
    • Total structure area: 4,439
    • Total interior livable area: 2,459 sqft
    • Finished area above ground: 2,459
    • Finished area below ground: 0

    Property

    Parking
    • Parking features: Paved
    Features
    • Levels: Two
    • Stories: 2
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Waterfront
    • Body of water: Piscataqua River
    Lot
    • Size: 0.33 Acres
    • Features: Level
    Details
    • Parcel number: MADBM00011B000003L000000
    • Zoning description: RA RE

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Cape
    • Property subtype: Single Family Residence
    Materials
    • Post and Beam, Wood Exterior
    • Foundation: Concrete
    • Roof: Asphalt Shingle
    Condition
    • New construction: No
    • Year built: 2005

    Utilities & green energy

    • Electric: 200+ Amp Service, Circuit Breakers
    • Sewer: 1250 Gallon, Leach Field, Private Sewer, Septic Tank
    • Utilities for property: Propane

    Community & neighborhood

    Location
    • Region: Madbury

    Price history

    DateEventPrice
    1/5/2026Sold$800,000-5.9%$325/sqft
    Source: PrimeMLS #5061309 Report a problem
    11/3/2025Price change$850,000-2.9%$346/sqft
    Source: PrimeMLS #5061309 Report a problem
    10/6/2025Price change$875,000-2.8%$356/sqft
    Source: PrimeMLS #5061309 Report a problem
    9/15/2025Listed for sale$900,000+87.5%$366/sqft
    Source: PrimeMLS #5061309 Report a problem
    7/12/2007Sold$480,000$195/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024$13,483 +8.2%$461,900
    2023$12,457 +6.7%$461,900
    2022$11,672 +3.7%$461,900 +4.2%

    Find assessor info on the county website

    Neighborhood: 03823

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Moharimet School
    • Middle: Oyster River Middle School
    • High: Oyster River High School
    • District: Oyster River Cooperative

    Source: PrimeMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value$803,800
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $803,800