NOT LISTED FOR SALE

Estimated Value: $1,822,000 - $2,044,000

4 Beds
5 Baths
5,114 Sq Ft
$377/Sq Ft Est. Value

Last Sold March 30, 2012

Last sale price $1,000,000 $196 Per Sq Ft

Est. 93% increase in value since last sale

Current estimated payment $12,594/month

40 Days on Market

About This Home

As of March 2012

ON A QUIET CUL DE SAC! WORK OF ART! A TRUE MASTERPIECE! PERFECT COMBINATION OF EVERTYTHING! BEST LOCATION! BRILLIANT FLOOR PLAN! NO EXPENSES SPARED in recent design & construction of this awe-inspiring gourmet kitchen, sunroom, paver patio w/double-sided block seating walls & top of the line Artesian Spa overlooking privacy & resort like landscaping! 1st flr office, 3 full baths on 2nd flr. Playroom, study area, 5th bedrm, full bath, art studio on lower level. ONE-OF-A-KIND-BEAUTY! NONE COMPARE!

Last Listed By

Carla Burns

Listed on: 02/01/2012

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,662

Year Built

1993

Lot Details

0

Listing Details

  • Lot Description: Wooded, Paved Drive
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1993

Interior Features

  • Has Basement: Yes
  • Fireplaces: 3
  • Primary Bathroom: Yes
  • Number of Rooms: 13
  • Amenities: Public Transportation, Shopping, Swimming Pool, Tennis Court, Park, Walk/Jog Trails, Golf Course, Highway Access, Public School
  • Electric: Circuit Breakers
  • Energy: Insulated Windows, Insulated Doors, Backup Generator
  • Flooring: Wood, Tile, Wall to Wall Carpet
  • Insulation: Full
  • Interior Amenities: Central Vacuum, Security System, Cable Available
  • Basement: Full, Partially Finished, Walk Out, Interior Access, Garage Access, Concrete Floor
  • Bedroom 2: Second Floor, 18X13
  • Bedroom 3: Second Floor, 15X13
  • Bedroom 4: Second Floor, 12X11
  • Bedroom 5: Basement, 15X15
  • Bathroom #1: First Floor, 8X4
  • Bathroom #2: Second Floor, 14X13
  • Bathroom #3: Second Floor, 9X4
  • Kitchen: First Floor, 27X16
  • Laundry Room: Second Floor
  • Living Room: First Floor, 22X16
  • Master Bedroom: Second Floor, 19X15
  • Master Bedroom Description: Walk-in Closet, Wall to Wall Carpet
  • Dining Room: First Floor, 15X14
  • Family Room: First Floor, 35X23

Exterior Features

  • Construction: Frame
  • Exterior: Wood
  • Exterior Features: Patio, Gutters, Hot Tub/Spa, Prof. Landscape, Sprinkler System, Decor. Lighting, Screens
  • Foundation: Poured Concrete

Garage/Parking

  • Garage Parking: Attached, Garage Door Opener
  • Garage Spaces: 3
  • Parking: Off-Street
  • Parking Spaces: 6

Utilities

  • Cooling Zones: 3
  • Heat Zones: 3
  • Hot Water: Natural Gas
  • Utility Connections: for Gas Range, for Electric Dryer, Washer Hookup, Icemaker Connection

Condo/Co-op/Association

  • HOA: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 28, 2008
Sold by
Gustin Susan K
Bought by
Gustin Tr Thomas R and Gustin Susan K
Total Days on Market
40
Current Estimated Value
$1,927,477

Purchase Details

Closed on
Aug 27, 1993
Sold by
Cs Investment T
Bought by
Gustin Thomas R

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Similar Homes in Andover, MA

  • 57 William St, Andover, MA 01810

    $1,850,000

    • 5 Beds
    • 6.5 Baths
    • 4,361 Sq Ft
    • 57 William St
    • Andover, MA

    Welcome to 57 William Street, where modern updates meet timeless charm in this spacious and thoughtfully designed home. Nestled in the desirable Brick Shawsheen neighborhood, this property offers an exceptional blend of comfort, style, and functionality.The heart of the home features a stunning, updated kitchen, featuring granite countertops, a large center island, high-end Miele appliances, and

    The Lucci Witte Team William Raveis R.E. & Home Services

    Section Image
  • 3 Weeping Willow Way, Andover, MA 01810

    $2,095,000

    • 5 Beds
    • 4.5 Baths
    • 5,277 Sq Ft
    • 3 Weeping Willow Way
    • Andover, MA

    BRAND NEW construction 9 home subdivision in Andover, each home with its own distinctive design & floorplan! An Interior designer choosing all finishes– every home will have its own uniqueness & high-end design w/ great attention to detail. This 5 bed home feature amenities galore w/ the first floor boasting chef’s kitchen's w/ monogram appliances & quartz countertops, walk in pantry, stand-alone

    Ashley Bergin Keller Williams Realty-Merrimack

    Section Image
  • Lot 7 Weeping Willow Way, Andover, MA 01810

    $2,365,000

    • 5 Beds
    • 4.5 Baths
    • 5,628 Sq Ft
    • Lot 7 Weeping Willow Way
    • Andover, MA

    BRAND NEW construction 9 home subdivision in Andover, each home with its own distinctive design & floorplan! An Interior designer choosing all finishes– every home will have its own uniqueness & high-end design w/ great attention to detail. This 5 bedrm, open floorplan home feature amenities galore w/ the first floor boasting chef’s kitchen's w/ monogram appliances & quartz countertops, walk in

    Ashley Bergin Keller Williams Realty-Merrimack

    Section Image
  • 67 Salem St, Andover, MA 01810

    $2,388,000

    • 4 Beds
    • 4.5 Baths
    • 6,344 Sq Ft
    • 67 Salem St
    • Andover, MA

    Exceptional property. Outstanding In-Town location. Just steps from Phillips Academy, this 6,344 sq ft estate blends classic New England charm with a luminous 5,000+ sq ft, three-story custom addition (2008). Inside: a custom zinc-clad hood crowns a chef's kitchen with Viking 48” cooktop, double ovens, warming drawer, Sub-Zero Pro 48 glass-door refrigerator, and dual dishwashers. Chestnut island,

    JoAnn Spaneas Land and Sea Real Estate, Inc.

    Section Image
  • 13 Alden Rd, Andover, MA 01810

    $2,499,999

    • 5 Beds
    • 4.5 Baths
    • 5,200 Sq Ft
    • 13 Alden Rd
    • Andover, MA

    This custom-built home is a luxurious retreat with 5 bedrooms and 4.5 bathrooms. The beautiful open concept kitchen with 11ft Quartz Island and top of the line SS appliances including Viking 8 Burner Gas range is complemented by a butler's pantry with additional sink and dishwasher providing ample storage and prep space. The primary suite is a haven, featuring a huge walk-in closet and spa-like

    The Joe & Cindy Team William Raveis R.E. & Home Services

    Section Image
  • 14 Acorn Dr, Andover, MA 01810

    $1,988,000

    • 4 Beds
    • 5 Baths
    • 6,536 Sq Ft
    • 14 Acorn Dr
    • Andover, MA

    Spectacular brick home w/ AMAZING backyard awaits you in desirable Fieldstone Meadows. Custom built Wynwood colonial is IMPRESSIVE, beginning with the paver driveway & walkways, wonderful patio w/ pergola & a fenced-in area for a garden w/ irrigation. From the minute you enter the 2-story Foyer you will feel the attention to detail. Curved staircase, marble floor w/ custom design leads to Home

    Peggy Patenaude William Raveis R.E. & Home Services

    Section Image
  • 3 West Hollow, Andover, MA 01810

    $2,495,000

    • 5 Beds
    • 6.5 Baths
    • 6,814 Sq Ft
    • 3 West Hollow
    • Andover, MA

    Welcome to this amazing Colonial on a picturesque 3+ Acre Lot, in a highly sought-after neighborhood. Perfectly located near both the Pike School and Phillip's Academy. This meticulously detailed home boasts 5 Beds, 6.5 Baths, private deck, 3 car garage & ample parking. Step into the lovely open foyer with curved staircase, marble & hardwood flooring & the sun-drenched 1st floor, which has a

    Team Lillian Montalto Lillian Montalto Signature Properties

    Section Image
  • 7 Orchard Crossing, Andover, MA 01810

    $1,675,000

    • 4 Beds
    • 4 Baths
    • 6,169 Sq Ft
    • 7 Orchard Crossing
    • Andover, MA

    Step into luxury w/ this stunning custom-built residence, where exquisite craftsmanship meets thoughtful design. At the heart of this home is a captivating indoor pool, framed by rich cedar walls & floor-to-ceiling windows that bathe the space in natural light, creating your own private retreat. Whether you're hosting friends or enjoying a quiet evening, the adjacent hot tub & wet bar make it

    The Lucci Witte Team William Raveis R.E. & Home Services

    Section Image
  • 72 Tewksbury St, Andover, MA 01810

    $1,895,000

    • 5 Beds
    • 6.5 Baths
    • 5,499 Sq Ft
    • 72 Tewksbury St
    • Andover, MA

    Design and customize your own brand new home in Andover!!! With tons of options & upgrades available, make this one of a kind home uniquely yours w/ all of the modern amenities & features one could hope for. Sprawling over 5400 living sqft this showstopper of a home has 3 levels of living space w/ an open floor plan, cathedral ceilings & interior balconies creating incredible height & flow while

    The North Star Group Keller Williams Realty Evolution

    Section Image

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Gustin Tr Thomas R -- --
Gustin Tr Thomas R -- --
Gustin Susan K -- --
Gustin Thomas R $540,000 --
Gustin Thomas R $540,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Sood Sanjeev $912,000
Closed Sood Sanjeev $400,000
Closed Sood Babita $667,500
Closed Sood Sanjeev $726,000
Closed Altieri Bernard R $750,000
Previous Owner Gustin Susan $300,000
Previous Owner Sideri Nancy A $195,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/30/2012 03/30/12 Sold $1,000,000 +2.1% $196 / Sq Ft
03/12/2012 03/12/12 Pending -- -- --
02/01/2012 02/01/12 For Sale $979,900 -- $192 / Sq Ft
Source: MLS Property Information Network (MLS PIN)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $21,662 $1,681,800 $631,400 $1,050,400
2023 $20,539 $1,503,600 $539,700 $963,900
2022 $19,669 $1,347,200 $486,200 $861,000
2021 $18,921 $1,237,500 $442,000 $795,500
2020 $18,380 $1,224,500 $442,000 $782,500
2019 $18,046 $1,181,800 $412,000 $769,800
2018 $17,378 $1,111,100 $399,900 $711,200
2017 $16,715 $1,101,100 $392,100 $709,000
2016 $16,378 $1,105,100 $392,100 $713,000
2015 $15,982 $1,067,600 $392,100 $675,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 71333213

MLS Property Information Network (MLS PIN)

APN: ANDO-000070-000076