Using a phone? Switch to mobile mode
Create your own account: Sign Up.
Already a member? Login.

Avenue 3 Real Estate, MA Realtors | 125 Cambridge Park Drive Suite 301 | Cambridge, MA 02140 | 857.209.5037 | info@avenue3re.com
   

 

Our mobile site is optimized for smaller screens.

TRY IT NO THANKS

151 Haggetts Pond RoadAndover, MA 01810MLS Number 71999264

  • Price: $2,895,000The price has recently decreased
  • Est. Mortgage of $/month
  • 386 Days on Market
PrintSave Favorite
Price Down Payment Interest Rate Years
%

Est. Mortgage: $/month

Federal 30-year interest rate: 4.03% last updated on 2017-04-27

This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

  • $2,895,000List Price
  • 8Bedrooms
  • 4.17Acreage
  • 10Bathroom
  • 1999Year Built
  • 20043Square Feet

Awe inspiring architectural wonder combines expansive and luxurious living spaces with amenities typically only seen in an 5 star resort. Upon driving into this privately set estate with professionally manicured grounds and panoramic views, one instantly feels worlds away from it all. This nationally recognized unique property houses a regulation size basketball court, locker rooms, indoor pool with 2 story water slide, bowling alley, classic movie theater, exercise room & poolside bar. Outside the home enjoy gently rolling lawns, putting green, expansive decks for entertaining and a 10 person hot tub overlooking the serenity. Inside the home, gracious and well appointed living areas flow gracefully featuring rich wood detail throughout, cathedral and box beam ceilings, professional custom kitchen and bright and cheerful breakfast room with walls of glass. Too many features & amenities to list, this is truly a one-of-a kind home for the most discerning buyer. Come experience the wonder

Listed by The Jared Wilk Group of Benoit Mizner Simon & Co. - Wellesley - Central St

Driving Directions

Your Local Office

Avenue 3 Real Estate
125 Cambridge Park Drive
Suite 301
Cambridge MA, 02140

Office: 857.209.5037

Ask A Question

Do not fill in this field:

More Info

to get all available property details.

Basic Information

  • List Price$2,895,000
  • Bathroom10
  • Full Baths9
  • Half Baths1
  • Bedrooms8
  • MLS Number71999264
  • Property TypeSF
  • PricePerSqFt$164

Interior

  • Living Room DescriptionFireplace, Ceiling - Cathedral, Closet/Cabinets - Custom Built, Flooring - Hardwood
  • Living Room Dimensions19X16
  • Interior Features
    • Cable Available
    • Central Vacuum
    • Sauna/Steam/Hot Tub
    • Security System
    • Wetbar
    • Wiredfor Surround Sound
  • Kitchen Description
    • Closet/Cabinets - Custom Built
    • Countertops - Stone/Granite/Solid
    • Dining Area
    • Flooring - Hardwood
    • Kitchen Island
    • Open Floor Plan
    • Pantry
    • Recessed Lighting
  • Kitchen Dimensions25X15
  • Laundry LevelSecond Floor
  • Kitchen LevelFirst Floor
  • Master Bed Description
    • Balcony / Deck
    • Bathroom - Full
    • Closet - Walk-in
    • Fireplace
    • Flooring - Hardwood
    • French Doors
  • Dining Room Dimensions17X13
  • Dining Room LevelFirst Floor
  • Bed 5 DescriptionBathroom - Full, Closet, Flooring - Hardwood
  • Dining Room DescriptionFlooring - Hardwood, French Doors, Chair Rail
  • Bed 4 DescriptionBathroom - Full, Closet, Flooring - Hardwood
  • Bed 2 DescriptionBathroom - Full, Closet, Flooring - Hardwood, Balcony / Deck
  • Bed 3 DescriptionBathroom - Full, Closet, Flooring - Hardwood
  • Bath 3 LevelBasement
  • Basement FeatureFull, Finished, Walk Out
  • FlooringWood, Tile, Hardwood
  • Family Room LevelFirst Floor
  • Family Room Dimensions39X35
  • Family Room DescriptionCeiling - Beamed, Closet/Cabinets - Custom Built, Flooring - Hardwood, Balcony / Deck, French Doors, Deck - Exterior, Sunken
  • BasementYes
  • Bed 5 LevelThird Floor
  • Bed 3 LevelSecond Floor
  • Bed 4 LevelSecond Floor
  • Bath 1 LevelBasement
  • Bath 2 LevelFirst Floor
  • Bed 2 LevelSecond Floor
  • Master Bedroom LevelSecond Floor
  • Other Room 1 DescriptionCeiling - Cathedral, Closet/Cabinets - Custom Built, Window(s) - Bay/Bow/Box, French Doors
  • Living Room LevelFirst Floor
  • Other Room 1 LevelFirst Floor
  • Other Room 1 NameHome Office
  • Other Room 5 NameOther
  • Other Room 5 LevelBasement
  • Other Room 5 Dimensions45X90
  • Other Room 5 Description
    • Balcony / Deck
    • Bathroom - 3/4
    • Deck - Exterior
    • Fireplace
    • Hot Tub / Spa
    • Recessed Lighting
    • Steam / Sauna
  • Other Room 4 NameExercise Room
  • Other Room 2 NameGame Room
  • Other Room 3 DescriptionFlooring - Wall to Wall Carpet, Recessed Lighting
  • Other Room 2 LevelBasement
  • Other Room 2 Description
    • Balcony / Deck
    • Bathroom - Full
    • Countertops - Stone/Granite/Solid
    • Exterior Access
    • Fireplace
    • Wine Chiller
  • Other Room 3 LevelBasement
  • Other Room 4 LevelBasement
  • Other Room 3 NameMedia Room

Location

  • StateMA
  • Zip01810
  • Building Number151
  • TownAndover
  • StreetHaggetts Pond Road
  • CountyEssex
  • Zip Code 44202

Exterior

  • Exterior Features
    • Balcony
    • Deck - Composite
    • Deck - Roof
    • Decorative Lighting
    • Hot Tub/Spa
    • Patio
    • Porch
    • Professional Landscaping
    • Sprinkler System
    • Storage Shed
  • ExteriorWood, Stone
  • Lot DescriptionWooded, Paved Drive, Gentle Slope, Scenic View(s)
  • Property StyleContemporary
  • Roof MaterialAsphalt/Fiberglass Shingles
  • Colortaupe tan
  • ConstructionFrame

Amenities

  • Appliances
    • Compactor
    • Dishwasher
    • Dryer
    • Freezer
    • Microwave
    • Range
    • Refrigerator
    • Vacuum System
    • Vent Hood
    • Washer

Water Body

Other

Building

  • Master BathYes
  • Rooms20
  • Property TypeDetached
  • Parking FeaturePaved Driveway

Property

  • Square Feet20043
  • Acreage4.17
  • Year Built1999
  • Garage Spaces3
  • Lot Size181645
  • Parking Spaces15
  • Year Built DescriptionActual
  • Garage ParkingAttached, Heated
  • MAIN LOAC0817
  • Lot0000D

Utilities

  • HeatingForced Air, Radiant, Electric, Geothermal Heat Source, Ground Source Heat Pump
  • CoolingCentral Air, Geothermal Heat Pump
  • Electric FeaturesCircuit Breakers
  • Cooling Zones7
  • Heat Zones12
  • SewerPrivate Sewerage
  • WaterPrivate Water

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

$

Do not fill in this field: