151 Haggetts Pond Rd, Andover, MA 01810

9 beds9.5 baths20,043 sqft

For Sale
$4,500,000
Zestimate®: $2,344,783
Est. Mortgage
/mo

Estimated Monthly Payment

$

Please enter a dollar amount between $0 and $200,000,000

()

Please enter a percent between 0% and 100%

30 Year Fixed:
/mo
15 Year Fixed:
/mo
5/1 ARM:
/mo
Estimated taxes & insurance of are not included.
See current rates On

A Zestimate® home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

If your home facts are wrong this will cause an incorrect Zestimate, click here to update them.

My Notes

Edit
Luxurious private estate set atop Bald Hill, with a panoramic view. Truly an ultimate family dream house with a massive atrium that houses the regulation-size indoor basketball court, complete with a balcony with bleachers. It is also outfitted with a batting cage and a major-league pitching machine, an indoor pool with 2-story water slide, a sauna, a home theater with stage, and even a 10-pin bowling alley. Out door fun includes putting green, hot tub for ten and a fire-pit. The spacious master suite includes a sitting area and a large private deck, An expansive family room with built in media center and a fieldstone fireplace. Its south facing french doors lend directly to the outdoor hot tub. The large chefs kitchen has professional Viking and Wolf appliances, cherry and mahogany custom moldings and built-ins cabinets throughout. The house is heated via both geothermal radiant heat and forced air heat. House is equipped with custom sound and lighting, and a backup generator.  More Less 

Facts

  • Lot: 3.94 acres
  • Single Family
  • Built in 2003
  • 74 days on Zillow
  • Views: 50,789 all time views
  • 51 shoppers saved this home
  • Last sold: Dec 2014 for $2,140,856
  • Last sale price/sqft: $107

Features

  • Deck
  • Finished basement, 4056 sqft
  • Patio
  • Porch
  • Sprinkler System

Additional Features

  • AMENITIES: Conservation Area
  • AMENITIES: Golf Course
  • AMENITIES: Highway Access
  • AMENITIES: Public Transportation
  • AMENITIES: Shopping
  • AMENITIES: Walk/Jog Trails
  • APPLIANCES: Countertop Range
  • APPLIANCES: Dishwasher
  • APPLIANCES: Disposal
  • APPLIANCES: Dryer
  • APPLIANCES: Freezer
  • APPLIANCES: Microwave
  • APPLIANCES: Range
  • APPLIANCES: Refrigerator
  • APPLIANCES: Washer
  • APPLIANCES: Washer / Dryer Combo
  • BASEMENT_FEATURE: Finished
  • BASEMENT_FEATURE: Full
  • BASEMENT_FEATURE: Interior Access
  • BASEMENT_FEATURE: Walk Out
  • BED2_DSCRP: Balcony / Deck
  • BED2_DSCRP: Bathroom - Full
  • BED2_DSCRP: Closet
  • BED2_DSCRP: Flooring - Hardwood
  • BED2_LEVEL: Second Floor
  • BED3_DSCRP: Bathroom - Full
  • BED3_DSCRP: Closet
  • BED3_DSCRP: Flooring - Wood
  • BED3_LEVEL: Second Floor
  • BED4_DSCRP: Bathroom - Full
  • BED4_DSCRP: Closet
  • BED4_DSCRP: Flooring - Wood
  • BED4_LEVEL: Second Floor
  • BED5_DSCRP: Bathroom - Full
  • BED5_DSCRP: Closet
  • BED5_DSCRP: Flooring - Wood
  • BED5_LEVEL: Second Floor
  • BTH1_DSCRP: Bathroom - Full
  • BTH1_DSCRP: Flooring - Stone/Ceramic Tile
  • BTH1_LEVEL: Second Floor
  • BTH2_DSCRP: Bathroom - Full
  • BTH2_DSCRP: Flooring - Stone/Ceramic Tile
  • BTH2_LEVEL: Second Floor
  • BTH3_DSCRP: Bathroom - Half
  • BTH3_LEVEL: First Floor
  • CONSTRUCTION: Frame
  • COOLING: Central Air
  • DIN_DSCRP: Flooring - Hardwood
  • DIN_DSCRP: French Doors
  • DIN_LEVEL: First Floor
  • ELECTRIC_FEATURE: 200 Amps
  • EXTERIOR: Wood
  • EXTERIOR_FEATURES: Balcony
  • EXTERIOR_FEATURES: Deck
  • EXTERIOR_FEATURES: Deck - Composite
  • EXTERIOR_FEATURES: Decorative Lighting
  • EXTERIOR_FEATURES: Gutters
  • EXTERIOR_FEATURES: Hot Tub/Spa
  • EXTERIOR_FEATURES: Patio
  • EXTERIOR_FEATURES: Pool - Inground
  • EXTERIOR_FEATURES: Professional Landscaping
  • EXTERIOR_FEATURES: Sprinkler System
  • EXTERIOR_FEATURES: Storage Shed
  • FAM_DSCRP: Cable Hookup
  • FAM_DSCRP: Ceiling - Coffered
  • FAM_DSCRP: Closet/Cabinets - Custom Built
  • FAM_DSCRP: Deck - Exterior
  • FAM_DSCRP: Exterior Access
  • FAM_DSCRP: Fireplace
  • FAM_DSCRP: Flooring - Hardwood
  • FAM_DSCRP: High Speed Internet Hookup
  • FAM_DSCRP: Main Level
  • FAM_DSCRP: Open Floor Plan
  • FAM_DSCRP: Recessed Lighting
  • FAM_DSCRP: Sunken
  • FAM_DSCRP: Window(s) - Picture
  • FAM_LEVEL: First Floor
  • FOUNDATION: Poured Concrete
  • GARAGE_PARKING: Attached
  • GARAGE_PARKING: Heated
  • HEATING: Electric
  • HEATING: Geothermal Heat Source
  • HEATING: Radiant
  • HOT_WATER: Propane Gas
  • HOT_WATER: Tank
  • HOW_SHOWN_BB: Appointment Required
  • HOW_SHOWN_BB: Call List Office
  • HOW_SHOWN_FB: Call List Office
  • HOW_SHOWN_SB: Call List Office
  • INSULATION_FEATURE: Full
  • INTERIOR_FEATURES: Cable Available
  • INTERIOR_FEATURES: French Doors
  • INTERIOR_FEATURES: Indoor Pool
  • INTERIOR_FEATURES: Other (See Remarks)
  • INTERIOR_FEATURES: Sauna/Steam/Hot Tub
  • INTERIOR_FEATURES: Security System
  • INTERIOR_FEATURES: Wetbar
  • KIT_DSCRP: Breakfast Bar / Nook
  • KIT_DSCRP: Cabinets - Upgraded
  • KIT_DSCRP: Cable Hookup
  • KIT_DSCRP: Closet/Cabinets - Custom Built
  • KIT_DSCRP: Countertops - Stone/Granite/Solid
  • KIT_DSCRP: Flooring - Hardwood
  • KIT_DSCRP: High Speed Internet Hookup
  • KIT_DSCRP: Main Level
  • KIT_DSCRP: Pantry
  • KIT_DSCRP: Stainless Steel Appliances
  • KIT_LEVEL: First Floor
  • LAUNDRY_DSCRP: Closet - Walk-in
  • LAUNDRY_LEVEL: Second Floor
  • LEAD_PAINT: None
  • LIV_DSCRP: Cable Hookup
  • LIV_DSCRP: Ceiling - Cathedral
  • LIV_DSCRP: Closet/Cabinets - Custom Built
  • LIV_DSCRP: Fireplace
  • LIV_DSCRP: Flooring - Hardwood
  • LIV_DSCRP: French Doors
  • LIV_DSCRP: Main Level
  • LIV_DSCRP: Window(s) - Bay/Bow/Box
  • LIV_DSCRP: Window(s) - Picture
  • LIV_LEVEL: First Floor
  • LOT_DESCRIPTION: Paved Drive
  • LOT_DESCRIPTION: Scenic View(s)
  • LOT_DESCRIPTION: Wooded
  • MBR_DSCRP: Balcony / Deck
  • MBR_DSCRP: Bathroom - Full
  • MBR_DSCRP: Cable Hookup
  • MBR_DSCRP: Closet - Walk-in
  • MBR_DSCRP: Exterior Access
  • MBR_DSCRP: Fireplace
  • MBR_DSCRP: Flooring - Hardwood
  • MBR_DSCRP: High Speed Internet Hookup
  • MBR_DSCRP: Hot Tub / Spa
  • MBR_DSCRP: Steam / Sauna
  • MBR_LEVEL: Second Floor
  • OTH1_DSCRP: Cabinets - Upgraded
  • OTH1_DSCRP: Cable Hookup
  • OTH1_DSCRP: Ceiling - Cathedral
  • OTH1_DSCRP: Flooring - Hardwood
  • OTH1_

Construction

  • Exterior material: Other
  • Roof type: Asphalt
  • Room count: 12
  • Stories: 2
  • Structure type: Contemporary
  • Unit count: 1

Other

  • Floor size: 20,043 sqft
  • Parcel #: M:00219 B:00018 L:0000D
  • Zillow Home ID: 56037878

Zestimate Details

Zestimate
A Zestimate home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

The Value Range is the high and low estimate market value for which Zillow values a home. The more information, the smaller the range, and the more accurate the Zestimate. See data coverage and accuracy table

Don't agree with your home's Zestimate? Owners can edit their home facts to make the Zestimate more accurate. Plus, you can leave an opinion on your Zestimate value below. Just click "Owner Estimate".
$2,344,783
+$55,639 Last 30 days
$1.90M
$2.77M
Zestimate range
Rent Zestimate A Rent Zestimate is Zillow's estimated monthly rental price, computed using a proprietary formula. It is a starting point in determining the monthly rental price for a specific property. Learn more

The Rent Range is the high and low estimate for which an apartment or home could rent. The more information we have, the smaller the range, and the more accurate the Rent Zestimate. See data coverage and accuracy table
$7,630/mo
-$723 Last 30 days
$3.5K
$15K
Zestimate range
Zestimate forecast
$XXX,XXX
0
One year
To see Zestimate forecast
Create a free account

Popularity on Zillow

5,813 views since listing
50,789 all-time (chart)
51 shoppers saved
this home to their list of favorites

Mortgages

Neighborhood: 01810

Zillow predicts 01810 home values will fall 0% next year, compared to a 0% increase for Town of Andover as a whole. Among 01810 homes, this home is 727.7% more expensive than the midpoint (median) home, but is priced 0.4% less per square foot.

Foreclosures will be a factor impacting home values in the next several years. In 01810, the number of foreclosures waiting to be sold is 10% less than in Town of Andover, and 91.4% less than the national average. This lower local number could help 01810 home values rise more quickly than other regions in Town of Andover.
  read more Less 

Nearby

    For Sale

    See all nearby listings

    Rentals

    See all nearby rentals

    Nearby Schools in Town of Andover

    GreatSchools ratings give an overview of a school's test results. The ratings are based on a comparison of test results for all schools in the state.

    Disclaimer: School attendance zone boundaries are supplied by Maponics and are subject to change. Check with the applicable school district prior to making a decision based on these boundaries.

    Data by GreatSchools.org