151 Haggetts Pond RoadAndover, MA 01810MLS Number 71999264

  • Price: $3,295,000
  • Est. Mortgage of $/month
  • 324 Days on Market
$
$
%
$/month over payments
Federal 30-year interest rate: 4.09% last updated on Jan 19, 2017
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.
  • 8Bedrooms
  • 4.17Acreage
  • 10Bathroom
  • 1999Year Built

Driving Directions

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

Ask A Question

Do not fill in this field:

More Info

to get all available property details.

Basic Information

  • List Price$3,295,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

Contact Hans Brings

Hans Brings

Andover, MA Real Estate Market Data

There is no data available

Andover, MA Demographics

There is no data available

Andover, MA Schools

School NameDistanceTypeGradesTest Score RatingParent Rating
n/a

The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information, and the Images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLS Property Information Network, Inc. and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the Images, set forth herein.


Neighborhood Information Powered by Onboard Informatics. Copyright © 2017 Onboard Informatics. School Performance Data by SchoolDigger.com, and School Review data provided by Niche.com. Information is deemed reliable but not guaranteed.

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: