Listed by Jamieson Duston • Bean Group / Portsmouth. Bought with Bean Group / Portsmouth.
Off market nov 2019 for $1.7M
$4,130,382
4
bd
•
3.5 ba
•
3,575
sq ft
190 PISCATAQUA Rd, Durham, NH 03824
About this home
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!
Single-familyProperty Type
1998Year Built
3.6 acresLot Size
$1,155Est. Price/Sq.Ft.
2 car garageParking
Listed by Jamieson Duston• Bean Group / Portsmouth
Bought with Jamieson Duston• Bean Group / Portsmouth
Country Setting, Farm - Horse/Animal, Secluded, View, Waterfront
Survey Information
Surveyed: Yes
Other Property & Lot Information
Year Built: 1998
Waterfront: Yes
Water Body Access: Yes
Financial
Assessment Information
Assessment Amount: 944600
Assessment Year: 2018
Tax Information
Tax Year: 2018
Tax Rate: 26.8
Gross Amount Tax: 25315
Other Tax Information
Page Deed: 262
Utilities
Heating & Cooling Information
Heat: Hot Water
Heat Fuel: Oil
Sewer Information
1500+ Gallon, Leach Field, Private
Electric Information
200 Amp, Circuit Breaker(s)
Water Information
Drilled Well, Private
Water Frontage Length: 422
Other Utilities Information
Underground Utilities
Location
Road Information
Paved, Public
Other Location Information
Directions: From Portsmouth, take Rte 4 off the Spaulding Turnpike, west towards Durham. Cross the Scammell Bridge and through the next set of lights. Driveway will be on the left. No sign. Follow driveway to the very end of the point.
Block: 0
Public facts
Beds: 4
Baths: 6.0
Sq. Ft.: 10,350
Stories: 1.0
Lot Size: 5.67 acres
Style: Single Family Residential
Year Built: 2023
Year Renovated: —
County: Strafford County
APN: 778260
Home facts updated by county records on Aug 5, 2026
Other
Water Body Information
Bay
Name: Little Bay
Access: Owned
Around this home
Schools
Oyster River Middle School
Public 5-8 • Assigned • 3.0mi
8/10
Oyster River High School
Public 9-12 • Assigned • 2.8mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 94° expected this year, 15 days in 30 years
6/10 Wind Factor
27% chance of strong winds in next 30 years
2/10 Air Factor
2 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Durham, NH • 03824
Average low and high temperatures (°F)
31
16
34
16
48
29
57
38
67
48
80
59
85
63
82
57
75
52
64
42
50
33
36
21
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9 hours in
June and 4.4 hours in December, placing it below the
U.S. average for solar exposure.
9 hrs
4.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$3.92M – $4.75M
Reach more buyers when you sell with Redfin. Save up to $41,304 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.