Exceptional space, timeless elegance, and thoughtful updates define this beautifully maintained 1998 colonial, boasting 5326 sf above-grade living space, set on 1.59 acres in a desirable cul-de-sac. A dramatic two-story marble foyer welcomes you into an impressive main level filled with natural light and architectural detail. The gourmet kitchen features quartz counters, SS appliances, an oversized island, and a 6-burner Thermador gas range, flowing seamlessly into the spectacular two-story great room—the heart of the home. A separate family room with wet bar, fireplace, French doors, bath, and exterior access provides another inviting space for entertaining. Just a few steps above the main level, the spacious primary suite offers custom built-ins, hardwood floors, a walk-in closet, and a beautifully renovated bath with soaking tub, custom double vanity, and luxurious marble shower. Upstairs are three additional generously sized bedrooms and two full baths. Outside, an expansive brick patio overlooks a beautifully landscaped, fenced yard with irrigation, creating an ideal setting for outdoor entertaining and relaxation. A 3-car attached garage with epoxy flooring leads to a large unfinished basement offering excellent storage and future possibilities. Additional highlights include a temperature-controlled wine cellar, whole-house generator, and whole-house sound system for music and entertaining. Surrounded by walking trails, nearby ponds/lakes for fishing and kayaking, and local recreational amenities, this exceptional property offers a wonderful combination of luxury, space, privacy, and an active New England lifestyle. Cameras and video surveillance are in use on the premises.
Primary bedroom on the first floor with walk-in closet, custom built cabinetry, hardwood flooring, attic access, recessed lighting, sconce and overhead lighting, crown molding and tray ceiling
Additional bedrooms on the second floor with ceiling fans, closets and wall-to-wall carpet; one has bay/bow/box windows
Bathrooms
Three full bathrooms
Two half bathrooms
Primary bathroom with double vanity, marble floors, stone/granite countertops, custom built cabinetry, linen closet, skylight, recessed lighting, sconces and a soaking tub
First-floor full bathroom tiled with tub and shower
First-floor half bathrooms with stone/ceramic tile and pedestal sink or stone counters and sconces
Kitchen
Custom built cabinets and upgraded cabinetry
Stone/granite countertops
Kitchen island
Dining area and open sightlines to adjacent rooms
French doors and slider providing exterior access
Stainless steel appliances
Gas stove with range hood
Wine chiller
Pendant and recessed overhead lighting
Laundry & utility
First-floor laundry with custom built cabinets, stone/ceramic tile flooring, French doors, washer hookup and electric dryer hookup, overhead lighting
Flooring
Hardwood flooring in primary living areas
Tile and stone/ceramic tile floors in kitchen, bathrooms and office
Marble flooring in primary bath
Wall-to-wall carpet in secondary bedrooms
Heating & cooling
Baseboard heating
Oil heating
Fireplaces contribute to heating
Central air conditioning
Exterior features
Patio
Rain gutters
Professional landscaping
Sprinkler system
Decorative exterior lighting
Screens
Fenced/enclosed yard
Located on a cul-de-sac
Home design
Single family residence
Built with frame construction
Shingle roof
Concrete perimeter foundation
Above-grade finished living area
Parking
Attached garage with 3 covered spaces and garage door opener
Paved driveway and off-street paved parking
Total parking for 9 vehicles (including 6 open parking spaces)
Construction
Frame construction
Shingle roof
Concrete perimeter foundation
Year built per public records
Utilities
Public water
Private sewer
200+ amp electric service
Generator and generator connection available
Washer hookup and electric dryer hookup
Gas range hookup
HOA & community
Community amenities include shopping, walk/jog trails, stables, conservation area, highway access, places of worship, private and public schools, university access and sidewalks
Not a senior community
Electricity and solar
View estimated energy costs and solar savings for this home
Spectacular Colonial home in beautiful cul-de-sac neighborhood offering perfect blend of luxury & comfort! 5300sqft of stunning living space includes two story marble foyer, gorgeous new chef's kitchen w/quartzite, stainless, 6-burner gas range & oversized island, new laundry/mudroom & powder room. Sprawling main level also showcases soaring great room w/floor to ceiling stone fireplace, dining & living rooms w/hardwood & cozy sitting room off kitchen. Separate family room w/wet bar, French doors & bath complete this floor. Exquisite mid-level main suite has built-ins, walk-in closet & new lavish bath featuring custom double vanity, soaking tub & marble shower. Second floor offers 3 spacious bedrooms & 2 full baths. 3-car garage w/epoxy floors leads to huge unfinished basement. 4 sets of glass doors along back of home open to vast brick patio & lovely backyard. Impeccable maintenance & upgrades include newer roof, Anderson windows, wine cellar, 3 gas fireplaces & whole house generator.
Public Records
Dec 4, 1997
Sold
$642,000
$121/sq ft
Year
Property tax
Land + Additions
Assessment*
2023
$14,794 (+4.7%)
$337,000 + $871,700
$1,208,700
2022
$14,129 (+4.0%)
$293,400 + $750,900
$1,044,300
2021
$13,590 (+3.8%)
$267,300 + $691,800
$959,100
2020
$13,087 (+2.5%)
$260,700 + $691,800
$952,500
2019
$12,773 (−7.7%)
$260,700 + $691,800
$952,500
2018
$13,840 (+2.0%)
$260,700 + $691,800
$952,500
2017
$13,566 (+6.5%)
$235,400 + $714,600
$950,000
2016
$12,736 (−16.5%)
$239,700 + $652,800
$892,500
2015
$15,259 (+1.5%)
$224,200 + $836,200
$1,060,400
2014
$15,027 (+3.8%)
$232,200 + $810,600
$1,042,800
2013
$14,472 (+6.4%)
$244,200 + $810,600
$1,054,800
2012
$13,597 (+3.0%)
$234,500 + $742,300
$976,800
2011
$13,206 (+0.2%)
$234,500 + $742,300
$976,800
2010
$13,174 (+1.4%)
$234,500 + $799,600
$1,034,100
2009
$12,989
$231,400 + $873,100
$1,104,500
Public record
Public record
Permits
Beds
4
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
1.59 Acres
Year renovated
—
Finished Sq. Ft.
5,326
Unfinished Sq. Ft.
—
Total Sq. Ft.
5,326
Year built
1998
Style
Single Family Residential
County
Essex County
APN
3767878
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 19, 2023.
Jan 24, 2023 • Final
Gas
Reconfigure the gas line for a gas fireplace.
Gas
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
1% chance of being in a wildfire in next 30 years
4/10 Heat Factor
7 days above 98° expected this year, 14 days in 30 years
6/10 Wind Factor
27% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
North Andover, MA • 01845
Average low and high temperatures (°F)
32
17
34
18
49
30
58
38
68
49
79
60
84
64
79
58
74
54
63
43
51
34
37
22
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 4.4 hours in December, placing it below the
U.S. average for solar exposure.
9.1 hrs
4.4 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 97 Windkist Farm Rd
$1,649,871
$871 over list price of $1.65M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $1.1M to $1.9M.