190 Piscataqua Rd

Durham, NH 03824

$1,750,000
Last Sold Price
4
Beds
3,575 Sq. Ft.
$490 / Sq. Ft.
3,575
Sq. Ft.
$490
per Sq. Ft.
Get preapproved with Rocket Mortgage1
Closed 11/15/19Virtual Tour
Closed 11/15/19Virtual Tour

Description

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!...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!
  1. Listed by Jamieson Duston • Bean Group / Portsmouth

Sold By Bean Group / Portsmouth

Property Details for 190 Piscataqua Road

Water Body Type
Bay
Waterfront Property
Yes
Zoning
RC RES COASTAL
LISTING CLOSED: 11/15/2019 12:00 AM

Property Details for 190 Piscataqua Road

StatusClosed
MLS #4775328
Days on Market15
Taxes$25,315 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family
Year Built1998
Lot Size3.60 AC / 156,816 SF
CountyStrafford County
Get preapproved with Rocket Mortgage1

Location

Add your commute

Virtual Tour

Building Information for 190 Piscataqua Road

Stories2Year Built1998Building Size-Lot Size3.60 AC / 156,816 SF

Payment Calculator

Get preapproved with Rocket Mortgage1

$11,005 per month

30 year fixed, 6.55% Interest

Principal and Interest

$8,895

Property Taxes

$2,110

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 190 Piscataqua Road

Summary
Location and General Information
  • City: Durham
  • County: NH-Strafford
  • 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.
  • Latitude: 43.127740819828183
  • Longitude: -70.865542568122805
  • Road Frontage: No
  • Seasonal: No
  • State: NH
  • Street Designation: Road
  • Map: 12
  • Zip: 03824
Taxes and HOA Information
  • Tax - Gross Amount: $25,315.00
  • Tax Rate: 26.80%
  • Tax Year: 2018
  • Taxes TBD: No
Parking
  • Garage: Yes
  • Garage Capacity: 2.00
  • Driveway: Gravel, Paved
Property
Lot Information
  • Block: 0
  • Lot: 7
  • Lot - Sqft: 156816.0
  • Lot Size Acres: 3.6
  • Square Feet Apx Finished Above Grade: 3575.0
  • Square Feet Apx Finished AG Source: Public Records
  • Square Feet Apx Finished Below Grade: 0.0
  • Square Feet Apx Finished BG Source: Public Records
  • Square Feet Apx Total: 4989.0
  • Square Feet Apx Total Finished: 3575.0
  • Square Feet Apx Unfinished Above Grade: 0.0
  • Square Feet Apx Unfinished AG Source: Public Records
  • Square Feet Apx Unfinished Below Grade: 1414.0
  • Square Feet Apx Unfinished BG Source: Public Records
  • Water Frontage Length: 422.0
  • Water Body Access: Yes
  • Water Body Access- EX: Owned
  • Water Body Name- EX: Little Bay
Property and Assessments
  • Assessment Amount: $944,600
  • Assessment Year: 2018
  • Property Class: Residential
  • Property Type: Single Family
  • Construction Status: Existing
  • Easements: Unknown
  • Flood Zone: No
  • Foundation: Poured Concrete
  • PreConstruction: No
  • Surveyed: Yes
  • Year Built: 1998
Utilities
  • Electric: 200 Amp, Circuit Breaker(s)
  • Sewer: 1500+ Gallon, Leach Field, Private
  • Utilities: Underground Utilities
Interior and Exterior Features
Exterior Features
  • Roads: Paved, Public
  • Roof: Shingle - Asphalt
Interior Features
  • Basement: Yes
  • Basement Access Type: Interior
  • Basement Description: Bulkhead, Concrete, Concrete Floor, Full, Stairs - Interior, Unfinished
  • Baths - Total: 4
  • Baths - Full: 3
  • Half Baths: 1
  • One Quarter Baths: 0
  • Three Quarter Bath: 0
  • Rooms - Total: 9
  • Bedrooms - Total: 4
  • Heat Fuel: Oil
  • Heating: Hot Water
  • Cooling: None
  • Total Stories: 2

Property History for 190 Piscataqua Road

DateEvent & SourcePriceAppreciation
Nov 15, 2019

Sold

New England Real Estate Network #4775328

$1,750,000—
Sep 22, 2019

Pending

New England Real Estate Network #4775328

—
Sep 7, 2019

Listed (Active)

New England Real Estate Network #4775328

$1,700,000—
DateEvent & SourcePrice
11/15/2019

Sold

New England Real Estate Network #4775328

$1,750,000
09/22/2019

Pending

New England Real Estate Network #4775328

—
09/07/2019

Listed (Active)

New England Real Estate Network #4775328

$1,700,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 190 Piscataqua Road

Taxable ValueLand$1,821,200Additions$4,662,500Total$6,483,700
Tax Record2025$122,347 ($10,196 / month)
Home Facts
Beds4Baths6Total Finished SqFt10,350 SqFtAbove Grade Finished SqFt10,350 SqFtUnfinished Basement SqFt4,720 SqFtStories1Lot Size246,985 SqFtStyleSingle Family ResidenceYear Built2023Year Renovated2023ZoningRCCountySTRAFFORDAPNDRHM M:216 L:12

Schools near 190 Piscataqua Road

This home is within Oyster River Coop School District.
Rating
School
Type
Grades
Distance
Mast Way School
Public - K to 4
Oyster River Middle School
Public - 5 to 8
Oyster River High School
Public - 9 to 12
Rating
School
Distance
Mast Way School
PublicK to 4

Oyster River Middle School
Public5 to 8

Oyster River High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
194 Piscataqua Road, Durham, NH 03824
–
3
2
1,647
179,467
184 Piscataqua Road, Durham, NH 03824
–
2
2
1,653
740,520
196 Piscataqua Road, Durham, NH 03824
$2,300,000
3
4,058
186,436
180 Piscataqua Road, Durham, NH 03824
–
3
2
1,325
514,008
191 Piscataqua Road, Durham, NH 03824
–
2
1
1,091
574,992

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Bean Group / Portsmouth

Copyright 2026 PrimeMLS, Inc. 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 07/31/2026 04:29 PM