Our mobile site is optimized for smaller screens.

Advanced Options

      190 PISCATAQUA RoadDurham, NH 03824MLS Number 4775328

      • Price: $1,700,000The price has recently decreased
      • Est. Mortgage of $/month
      • 44 Days on Market
      PrintSave Favorite
      Price Down Payment Interest Rate Years

      Est. Mortgage: $/month

      Federal 30-year interest rate: 3.69% last updated on 2019-10-17

      This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

      • 4Bedrooms
      • 4Bathroom
      • 3.6Acreage
      • 3,575Square Feet
      Listed by Jamieson Duston of Bean Group / Portsmouth

      LITTLE BAY LEGACY! In the same family for over 60 years, this property offers what most would agree is the best available view on the inland coast of NH! Properties like this come along once in a lifetime! The views stretch northeast to Cedar Cove and the Bellamy River, 2 miles east past Goat Island to Great Bay Marine (the Seacoast's only year round marina), 5+ miles south past Adams Point and deep into Great Bay and west to the mouth of the Oyster River, just a short kayak ride to Wagon Hill Farm! This setting could be best described as a boater's paradise. One of the only privately owned boat houses on the Seacoast, this structure features a large deck, great dockage, access to a mooring with 25' depth and stairs to the beach! The main home was built new in 1998 and offers approx. 3600SF, 4Beds/4Baths with an in-law suite on the main level. It offers amazing water views from nearly every room in the house, a fireplace in the 2-story great room, 2-car garage, artists studio and a roof deck that allows you to see fireworks from Portsmouth to Hampton! The seasonal guest cottage offers approx. 788SF with 3Beds/1Bath and there's a large "Yankee" barn on the property. Privately set at the end of a 3 acre peninsula with +400' of frontage, the VIEWS are indescribable and the location is ideal! The property is just minutes to the Pease Intl Airport and less than 10 minutes to downtown Portsmouth. Start making memories with family & friends that will last a lifetime!

      Driving Directions

      Mariner Realty

      Your Local Office

      Mariner Realty
      54 Main Street
      Durham NH, 03824

      Office: 603-868-5600

      Ask A Question

      Do not fill in this field:

      More Info


      • Parking Spaces2


      • Year Built1998
      • Building ConstructionWood Frame
      • ConstructionExisting
      • Property StyleAdirondack, Contemporary, Cottage/Camp
      • Full Baths3
      • Half Bath1
      • Bathroom4
      • Total Baths4
      • Bedrooms4
      • Total Rooms9
      • FoundationPoured Concrete
      • Square Feet3,575
      • APX Unfin Below Grade1414
      • BasementBulkhead, Concrete, Concrete Floor, Full, Stairs - Interior, Unfinished

      Basic Information

      • Virtual TourClick Here
      • StatusPEN
      • Property TypeSingle Family
      • List Price$1,700,000
      • Listing Agent NameJamieson Duston
      • Broker NameBean Group / Portsmouth
      • LM MST WGARAttached
      • MLS Number4775328


      • Stories2


      • ExteriorVinyl Siding
      • RoofShingle - Asphalt

      Water Body

      • Water Body NameLittle Bay
      • Water Body TypeBay
      • Waterfront422
      • Water AccessOwned


      • SeasonalNo
      • Page262
      • Delayed ShowingsNo
      • View Count14


      • Building Number190
      • StreetPISCATAQUA Road
      • TownDurham
      • StateNH
      • Zip03824
      • CountyStrafford
      • Flood Zone Y/NNo
      • Map12


      • Acreage3.6
      • Lot DescriptionCountry Setting, Farm - Horse/Animal, Secluded, View, Waterfront
      • Lot7
      • DrivewayGravel, Paved
      • RoadsPaved, Public


      • Heat FuelOil
      • Heat SystemHot Water
      • WaterDrilled Well, Private
      • Water HeaterElectric, Heat Pump
      • Sewer1500+ Gallon, Leach Field, Private
      • Electric200 Amp, Circuit Breaker(s)
      Broker Reciprocity

      Copyright 2019 New England Real Estate Network, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate for sale on this web site comes in part from the IDX Program of NEREN. 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 October 20, 2019.


      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:


      Do not fill in this field: