Off market dec 2020 for $2.1M

$3,263,821

Est. refi paymentEst. refi $12,047/mo

•

20,047

sq ft

151 Haggetts Pond Rd, Andover, MA 01810

About this home

Rarely does a home like this become available. In a suburb of Boston, situated on almost 4 acres....this house offers over 20,000 sqft of living area, 9 beds and 9 bathrooms......including an attached full court basketball court (can also be used for tennis and volleyball), indoor pool with two story waterslide, bowling alley, 12 seat home theatre, gym, sauna, koi pond, 10 person outdoor jacuzzi, putting green.....you get the idea ;-) Offering the best of both worlds, 9000 sqft of prime residential living space...complemented by 11,000 of amenity space, this home is the perfect balance. Once featured on HGTV's Million Dollar Rooms....Host Carter Oosterhouse called it, "One of the most incredible home sports complexes in the world". You truly never have to leave! Two week call for offers....offers requested by Nov 11 2020.

Single-familyProperty Type

1999Year Built

3.9 acresLot Size

$163Est. Price/Sq.Ft.

3 garage spacesParking

Listed by Paul Campano • Keller Williams Realty Boston Northwest

Bought with Paul Campano • Keller Williams Realty Boston Northwest

Redfin checked: 2 minutes ago

•Source:MLS PIN #72749383

Redfin Estimate

$3,263,821

$1.2M since sold in December 2020$3,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 80.9% higher than the average sale price ($1.80M) of 6 comparable homes.

SOLD JUL 31, 2026
$2,000,000
A
5 beds4.5 baths6,661 sq ft
8 Hitchcock Farm Rd, Andover, MA 01810
SOLD SEP 11, 2026
$1,703,000
B
4 beds3.5 baths4,502 sq ft
1 Preston Cir, Andover, MA 01810
SOLD JUL 15, 2026
$2,400,000
C
4 beds3.5 baths4,800 sq ft
2 Barron Ct, Andover, MA 01810
SOLD JUL 23, 2026
$1,550,000
D
4 beds2.5 baths4,165 sq ft
19 Knollcrest Dr, Andover, MA 01810
SOLD JUN 23, 2026
$1,850,000
E
4 beds3.5 baths6,291 sq ft
21 Greybirch Rd, Andover, MA 01810
SOLD JUN 12, 2026
$1,320,000
F
4 beds3.5 baths4,358 sq ft
23 Greybirch Rd, Andover, MA 01810

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$1,612,066

Est. take-home

List your home with Redfin and save $16,319

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$6,887/mo

Redfin rental estimate

List your home for rent

Market trends in 01810, MA

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

102.7%

0.3% MoM

Median sale price

$1.1M

$19K MoM

Avg. days on market

21d

0 days MoM

Recently sold homes

140

5 MoM

New listings for sale

NEW 16 HRS AGO
$649,900
2 beds2 baths1,341 sq ft
6 Overlook Dr #408, Andover, MA 01810
OPEN SAT, 12PM TO 1PM
$320,000
2 beds1 bath860 sq ft
4 Colonial Dr Unit A4-11, Andover, MA 01810
OPEN SAT, 11AM TO 1PM
$1,475,000
4 beds3.5 baths3,738 sq ft
37 Smithshire Est, Andover, MA 01810
OPEN SUN, 2PM TO 4PM
$1,387,500
4 beds4.5 baths4,381 sq ft
7 Ivana Dr #7, Andover, MA 01810
3D & VIDEO TOUR
$2,488,000
6 beds5.5 baths8,613 sq ft
78 Porter Rd, Andover, MA 01810
$2,695,000
4 beds4.5 baths4,528 sq ft
10 Trevino Cir, Andover, MA 01810
$183,000
Studio1 bath480 sq ft
E2 Colonial Dr #4, Andover, MA 01810
OPEN SAT, 12PM TO 2PM
$699,900
3 beds1 bath1,032 sq ft
90 Summer St, Andover, MA 01810
OPEN SAT, 11AM TO 1PM
$675,000
3 beds1 bath1,152 sq ft
32 Enmore St, Andover, MA 01810
OPEN SAT, 1PM TO 3PM
$1,900,000
3 beds3.5 baths2,391 sq ft
33 Chestnut St #1, Andover, MA 01810
See all

Provided by Redfin

Sale history for 151 Haggetts Pond Rd

Date

Event

Price

Public Records

Dec 24, 2020

Sold

$2,100,000

$105/sq ft

MLS PIN #72749383

Dec 28, 2020

Listing Removed

—

Dec 24, 2020

Sold

$2,100,000

$105/sq ft

Nov 9, 2020

Contingent

—

Oct 28, 2020

Listed

$2,200,000

$110/sq ft

MLS PIN #30556083

Dec 14, 2001

Sold

$675,000

$34/sq ft

Dec 11, 2001

Listing Removed

—

Oct 25, 2001

Listed

$860,000

$43/sq ft

MLS PIN #30051160

Dec 11, 1998

Sold

$100,000

$5/sq ft

Jun 30, 1997

Listing Removed

—

Jun 5, 1995

Listed

$119,000

$6/sq ft

Year

Property tax

Land + Additions

Assessment*

2023

$38,874 (+4.7%)

$446,900 + $2,398,900

$2,845,800

2022

$37,113 (+3.8%)

$394,600 + $2,147,400

$2,542,000

2021

$35,746 (+3.7%)

$362,800 + $1,975,100

$2,337,900

2020

$34,466 (+0.4%)

$355,000 + $1,941,200

$2,296,200

2019

$34,315 (+5.2%)

$345,900 + $1,901,300

$2,247,200

2018

$32,606 (+3.5%)

$334,500 + $1,750,300

$2,084,800

2017

$31,497 (+1.8%)

$328,900 + $1,746,000

$2,074,900

2016

$30,925 (+4.4%)

$328,900 + $1,757,800

$2,086,700

2015

$29,623 (−6.6%)

$318,000 + $1,660,800

$1,978,800

2014

$31,725 (+4.6%)

$314,500 + $1,775,400

$2,089,900

2013

$30,324 (+2.1%)

$314,500 + $1,775,400

$2,089,900

2012

$29,708 (+4.9%)

$314,500 + $1,785,000

$2,099,500

2011

$28,309 (+4.3%)

$327,500 + $1,677,400

$2,004,900

2010

$27,132 (+8.0%)

$335,400 + $1,721,600

$2,057,000

2009

$25,125

$335,400 + $1,730,800

$2,066,200

Tax history for 151 Haggetts Pond Rd

Year

Property tax

Land + Additions

Assessment*

2023

$38,874 (+4.7%)

$446,900 + $2,398,900

$2,845,800

2022

$37,113 (+3.8%)

$394,600 + $2,147,400

$2,542,000

2021

$35,746 (+3.7%)

$362,800 + $1,975,100

$2,337,900

2020

$34,466 (+0.4%)

$355,000 + $1,941,200

$2,296,200

2019

$34,315 (+5.2%)

$345,900 + $1,901,300

$2,247,200

2018

$32,606 (+3.5%)

$334,500 + $1,750,300

$2,084,800

2017

$31,497 (+1.8%)

$328,900 + $1,746,000

$2,074,900

2016

$30,925 (+4.4%)

$328,900 + $1,757,800

$2,086,700

2015

$29,623 (−6.6%)

$318,000 + $1,660,800

$1,978,800

2014

$31,725 (+4.6%)

$314,500 + $1,775,400

$2,089,900

2013

$30,324 (+2.1%)

$314,500 + $1,775,400

$2,089,900

2012

$29,708 (+4.9%)

$314,500 + $1,785,000

$2,099,500

2011

$28,309 (+4.3%)

$327,500 + $1,677,400

$2,004,900

2010

$27,132 (+8.0%)

$335,400 + $1,721,600

$2,057,000

2009

$25,125

$335,400 + $1,730,800

$2,066,200

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

4.17 Acres

Year renovated

—

Sq. Ft.

20,043

Year built

1999

Style

Single Family Residential

County

Essex County

APN

1846147

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 20, 2023.

Property details

Parking

Parking Information
Has Garage
# of Garage Spaces: 3
# of Covered Spaces: 3
Parking Spaces: 10
AttachedGarageYN: Yes
Parking Features: Attached, Off Street

Interior

Bathroom Information
# of Bathrooms (Full): 7
# of Bathrooms (Half): 2
Master Bathroom Features: Yes

Basement Information
Basement: Full, Finished

Fireplace Information
Has Fireplace
# of Fireplaces (Total): 2

Interior Features
# of Rooms (Total): 15
Flooring: Wood
Interior Features: Central Vacuum, Sauna/Steam/Hot Tub, Wet Bar, Wired for Sound

Exterior

Building Information
Building Area (Total): 20,047
Year Built Source: Public Records
Year Built Details: Actual

Exterior Features
Patio And Porch Features: Deck, Patio
Exterior Features: Deck, Patio, Balcony, Hot Tub/Spa, Storage, Decorative Lighting

Pool Information
Has Private Pool
Has Spa
Pool Features: Indoor
Spa Features: Private

Property Information
PropertySubType: Single Family Residence
Security Features: Security System

Lot Information
Lot Size (Acres): 3.9
Road Frontage Type: Public

Financial

Tax Information
Tax Annual Amount: $34,466
Tax Year: 2020

Utilities

Utility Information
Sewer: Private Sewer
Water Source: Private

Heating & Cooling
Has Heating
Has Cooling
Heating: Forced Air, Radiant, Electric
Cooling: Central Air

Location

Location Information
Directions: Haggetts Pond Road to Holmes Road
UnparsedAddress: 151 Haggetts Pond Rd, Andover MA 01810

Community Information
Senior CommunityYN: No
Community Features: Public Transportation, Shopping

Public facts

Beds: 5
Baths: 8.0
Sq. Ft.: 20,043
Stories: 2.0
Lot Size: 4.17 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: —
County: Essex County
APN: 1846147

Home facts updated by county records on Jul 20, 2023

Other

Listing Information
StandardStatus: Closed

Around this home

Schools

High Plain Elementary School

Public K-5 • Assigned • 0.9mi

9/10

Andover West Middle School

Public 6-8 • Assigned • 3.3mi

8/10

Andover High School

Public 9-12 • Assigned • 3.1mi

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

3/10 Fire Factor

0.15% chance of being in a wildfire in next 30 years

4/10 Heat Factor

6 days above 97° expected this year, 13 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

Andover, MA • 01810

Average low and high temperatures (°F)

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

Estimated sale price

$3.10M – $3.75M

Reach more buyers when you sell with Redfin. Save up to $32,638 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$810,000

4 beds2.5 baths2,300 sq ft

135 Jennies Way, Tewksbury, MA 01876

$799,999

3 beds1.5 baths1,269 sq ft

159 High Plain Rd, Andover, MA 01810

OPEN SUN, 11AM TO 12:30PM

$619,000

4 beds2 baths1,581 sq ft

1569 Main St, Tewksbury, MA 01876

$635,000

3 beds1.5 baths1,758 sq ft

320 North St, Tewksbury, MA 01876

$1,999,000

4 beds5.5 baths4,838 sq ft

48 Reservation Rd, Andover, MA 01810

$750,000

4 beds2.5 baths2,100 sq ft

15 Ellington Rd, Tewksbury, MA 01876

New listings for sale in 01810

NEW 16 HRS AGO

$649,900

2 beds2 baths1,341 sq ft

6 Overlook Dr #408, Andover, MA 01810

OPEN SAT, 12PM TO 1PM

$320,000

2 beds1 bath860 sq ft

4 Colonial Dr Unit A4-11, Andover, MA 01810

OPEN SAT, 11AM TO 1PM

$1,475,000

4 beds3.5 baths3,738 sq ft

37 Smithshire Est, Andover, MA 01810

OPEN SUN, 2PM TO 4PM

$1,387,500

4 beds4.5 baths4,381 sq ft

7 Ivana Dr #7, Andover, MA 01810

3D & VIDEO TOUR

$2,488,000

6 beds5.5 baths8,613 sq ft

78 Porter Rd, Andover, MA 01810

$2,695,000

4 beds4.5 baths4,528 sq ft

10 Trevino Cir, Andover, MA 01810

$183,000

Studio1 bath480 sq ft

E2 Colonial Dr #4, Andover, MA 01810

OPEN SAT, 12PM TO 2PM

$699,900

3 beds1 bath1,032 sq ft

90 Summer St, Andover, MA 01810

OPEN SAT, 11AM TO 1PM

$675,000

3 beds1 bath1,152 sq ft

32 Enmore St, Andover, MA 01810

Home values near 151 Haggetts Pond Rd

Data from public records.

Address	Redfin Estimate
123 Haggetts Pond Road, Andover, MA 3 Beds \| 1.5 Baths \| 1275 Sq. Ft.	$656,782
152 Haggetts Pond Road, Andover, MA 4 Beds \| 3.5 Baths \| 3900 Sq. Ft.	$1,695,776

Address	Redfin Estimate
110 Haggetts Pond Road, Andover, MA 3 Beds \| 1.5 Baths \| 2838 Sq. Ft.	$854,643
156 Haggetts Pond Road, Andover, MA 4 Beds \| 2.5 Baths \| 2722 Sq. Ft.	$1,077,119

Address	Redfin Estimate
148 Haggetts Pond Road, Andover, MA 4 Beds \| 3 Baths \| 3800 Sq. Ft.	$1,713,059
162 Haggetts Pond Road, Andover, MA 4 Beds \| 2.5 Baths \| 2619 Sq. Ft.	$1,044,188

Property information provided by MLS PIN when last listed in 2020. This data may not match . Learn more.

More real estate resources

Minor Civil Divisions
Neighborhoods
Cities
Zip Codes
Popular Searches

Rye homes for sale
Bedford homes for sale
Pelham homes for sale
Windham homes for sale
Merrimack homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

South Lawrence homes for sale
West Andover homes for sale
West Methuen homes for sale
North Andover Center homes for sale
Arlington homes for sale

01845 homes for sale
01887 homes for sale
01864 homes for sale
01810 homes for sale
01844 homes for sale

Houses for rent in Andover	Agents near me	Quincy, MA homes for sale	Andover Housing Market
Houses for sale near me	Boston, MA homes for sale	Brookline, MA homes for sale
Land for sale near me	Newton, MA homes for sale	Arlington, MA homes for sale
Open Houses near me	Cambridge, MA homes for sale	Andover Property Records
Condos for sale near me	Lexington, MA homes for sale	MA New Listings

Cambridge homes for sale
Boston homes for sale
Newton homes for sale