$1,750,000
About this home
This updated 4 bedroom, 4 bath colonial has a fantastic location just a short stroll from access to Great Bay. Enter through a huge foyer/ mudroom with a turning staircase. An expanded eat in kitchen with walk-in pantry and private office, and oversized deck overlook magical sunrises over Great Bay. The spacious sunny family room has a cathedral ceiling and large windows overlooking the water views and loads of built-ins. Formal dining and living spaces are also on the first floor. The second floor has 4 bedrooms and 3 full baths, giving guests their own bathroom. The primary suite has 2 walk in closets and a bath with oversized walk in shower and soaking tub overlooking Great Bay. The lower level has a playroom and a walkout office or workout room along with abundant storage spaces. A walkout 17x26 ft room is waiting for your finishing touches. The large fenced lawns behind the home are perfect for pet or children play areas. After dinner each evening go for a walk around the Tidewater Farms loop or on the raised trails at the Great Bay Estuary Discovery center, or launch your kayak from the Estuary boat launch. All this just minutes from downtown Portsmouth, the Atlantic Coast beaches or the Stratham Hill dog park and hiking and cross country trails. Friday and Saturday open houses!
Property details
- MLS
- Prime MLS
- MLS #
- 5100218
- Property type
- Single Family Residence
- Subdivision
- Tidewater Farms
- Status
- Active
- Days on market
- 27
- On market date
- N/A
- Stories
- N/A
- Total bathrooms
- 3
- Garage spaces
- 3
- Parking spaces
- N/A
- Lot size
- 1.46 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card.
- Enrollment
- 539
- Student:teacher ratio
- 11.0:1
- District
- Stratham School District
- Enrollment
- 237
- Student:teacher ratio
- 11.3:1
- District
- Newmarket School District
- Enrollment
- 270
- Student:teacher ratio
- 9.3:1
- District
- Newmarket School District
Walkability
Blended score for Greenland's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Copyright 2026 PrimeMLS. 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 08/11/26.