- 7 beds
- 8 baths
- 9,465 sqft
- ~2 acre lot
- $417 per sqft
- 2014 build
- – on site
Located in one of Windham’s most desirable executive neighborhoods and just minutes from schools, this extraordinary home blends luxury and fun - designed to impress at every turn. Enter the foyer and take in the soaring great room with fir timber accents and a stunning double-sided stone fireplace. The chef’s kitchen features high-end appliances, stone surround, and a spacious walk-in pantry and connected built-in lined mudroom. A curved wrought iron staircase ties the levels together. Upstairs, four bedrooms each include en suite baths, with a separate guest suite for added privacy. The primary retreat boasts a knotty pine ceiling, large walk-in closet, and private balcony with mountain views. The finished basement offers rustic charm with timber ceilings, live edge bar, second full kitchen, media and family rooms, plus two flex rooms and a bright sunroom ready for a hot tub or lap pool. A 3.5-car main floor garage adds convenience. The showstopper? An indoor basketball half-court with gym, loft lounge, wet bar, and home office overlooking the court. With two oversized garage doors, the space easily doubles as a car showroom. Outside, enjoy your personal resort: sport court, lush yard, in-ground saltwater pool with waterfall and slide, and two sheds. A 700+ sq ft pool house includes its own kitchen, fireplace, and bath. This is the dream home that has it all..
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 11, 2025
•
MLS# 5045782 —
The Building
-
Year Built:2014
-
Pre-Construction:No
-
Construction Status:Existing
-
Construction Materials:Wood Frame
-
Architectural Style:Colonial, Craftsman
-
Roof:Shingle - Asphalt
-
Foundation:Poured Concrete
-
Equipment:Radon Mitigation, Security System, Smoke Detector
-
Total Stories:3
-
Approx SqFt Total:9825
-
Approx SqFt Total Finished:9,465 Sqft
-
Approx SqFt Finished Above Grade:6,645 Sqft
-
Approx SqFt Finished Below Grade:2,820 Sqft
-
Approx SqFt Unfinished Below Grade:360
-
Approx SqFt Finished Building Source:Measured
-
Approx SqFt Unfinished Building Source:Measured
-
Approx SqFt Finished Above Grade Source:Measured
Interior
-
Total Rooms:22
-
Features - Interior:Central Vacuum, Bar, Blinds, Cathedral Ceiling, Ceiling Fan, Fireplace - Gas, Kitchen Island, Primary BR w/ BA, Surround Sound Wiring, Walk-in Closet, Walk-in Pantry, Wet Bar, Laundry - 1st Floor, Laundry - 2nd Floor, Attic - Pulldown
-
Flooring:Hardwood, Tile
-
Basement:Yes
-
Basement Description:Finished
-
Basement Access Type:Walkout
-
Room 1 Level:1
-
Room 2 Level:1
-
Room 3 Level:1
-
Room 4 Level:1
-
Room 5 Level:1
-
Room 6 Level:1
-
Room 7 Level:1
-
Room 8 Level:1
-
Room 9 Level:2
-
Room 10 Level:2
-
Room 11 Level:2
-
Room 12 Level:2
-
Room 13 Level:2
-
Room 14 Level:2
-
Room 15 Level:2
-
Room 16 Level:2
-
Room 17 Level:1
-
Room 18 Level:Basement
-
Room 19 Level:Basement
-
Room 20 Level:Basement
-
Room 21 Level:Basement
-
Room 22 Level:Basement
-
Room 1 Type:Kitchen
-
Room 2 Type:Living Room
-
Room 10 Type:Laundry Room
-
Room 9 Type:Bedroom with Bath
-
Room 8 Type:Bath - 1/2
-
Room 7 Type:Bedroom
-
Room 5 Type:Laundry Room
-
Room 4 Type:Dining Room
-
Room 3 Type:Mudroom
-
Room 6 Type:Playroom
-
Room 11 Type:Bedroom with Bath
-
Room 12 Type:Bedroom
-
Room 14 Type:Primary BR Suite
-
Room 13 Type:Bedroom with Bath
-
Room 15 Type:Loft
-
Room 16 Type:Office/Study
-
Room 17 Type:Recreational Room
-
Room 18 Type:Family Room
-
Room 19 Type:Media Room
-
Room 20 Type:Bedroom
-
Room 21 Type:Bedroom
-
Room 22 Type:Sunroom
-
Rooms Level 1:Level 1: Bedroom, Level 1: Bath - 1/2, Level 1: Dining Room, Level 1: Kitchen, Level 1: Laundry Room, Level 1: Living Room, Level 1: Mudroom, Level 1: Playroom, Level 1: Rec Room
-
Rooms: Level 2Level 2: Bedroom, Level 2: Laundry Room, Level 2: Loft, Level 2: Primary Bdm Ste, Level 2: Office/Study
-
Rooms Level B:Level B: Bedroom, Level B: Family Room, Level B: Media Room, Level B: Sunroom
Location
-
Directions:Use GPS
-
Map:TBD
-
Latitude:42.787845126386827
-
Longitude:-71.325979000000004
The Property
-
Property Type:Single Family
-
Property Class:Residential
-
Seasonal:No
-
Lot:3017
-
Lot Features:Landscaped, Level, Abuts Conservation, Near Paths, Near School(s)
-
Lot SqFt:76,666 Sqft
-
Lot Acres:1 Sqft
-
Zoning:Residential
-
Exterior Features:Balcony, Basketball Court, Deck, Fence - Partial, Outbuilding, Patio, Playground, Pool - In Ground, Shed
-
Driveway:Paved
-
Waterview:No
-
Waterfront:No
-
Water Body Access:No
Listing Agent
- Contact info:
- Office phone:
- (978) 479-1794
Taxes
-
Tax Year:2024
-
Taxes TBD:No
-
Tax - Gross Amount:$34,510
Beds
-
Total Bedrooms:7
Baths
-
Total Baths:8
-
Full Baths:4
-
Three Quarter Baths:1
-
Half Baths:3
The Listing
-
Price Per SqFt:417.33
-
Foreclosed/Bank-Owned/REO:No
Heating & Cooling
-
Heating:Forced Air, Radiant Floor
-
Cooling:Central AC
Utilities
-
Utilities:Cable, Gas - LP/Bottle
-
Sewer:Septic
-
Electric:200 Amp
-
Water Source:Drilled Well
Appliances
-
Appliances:Dishwasher, Dryer, Range Hood, Microwave, Mini Fridge, Refrigerator, Washer, Wine Cooler, Stove - Dual Fuel, Range - Dual Fuel
Schools
-
Elementary School:Golden Brook Elementary School
-
Middle Or Junior School:Windham Middle School
-
High School:Windham High School
-
School District:Windham School District
The Community
-
Covenants:Yes
Parking
-
Garage:Yes
-
Garage Capacity:5
Monthly cost estimate

Asking price
$3,950,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$21,151
|
Taxes | $2,875 |
Insurance | $1,086 |
Utilities | $413 See report |
Total | $25,525/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/11/25
Jun 11, 2025
|
Listed / Active | PRIME_MLS | $3,950,000 | |
2/29/16
Feb 29, 2016
|
Price Changed | PRIME_MLS | ||
8/3/15
Aug 3, 2015
|
Sold | PRIME_MLS |