NOT LISTED FOR SALE

23 Macmillan Dr Concord, MA 01742

Estimated Value: $2,427,000 - $2,694,000

5 Beds
6 Baths
7,320 Sq Ft
2.19 Acres

Last Sold August 28, 2020

Last sale price $1,700,000 $232 Per Sq Ft

Est. 51% increase in value since last sale

Current estimated payment $14,285/month

14 Days on Market

Highlights

  • Landscaped Professionally
  • Marble Flooring
  • Wet Bar
  • Willard School Rated A
  • Porch
  • Patio

About This Home

As of August 2020

GREAT NEW PRICE. This gorgeous property expresses traditional sophistication and modern elegance living. Sited on a tranquil CUL-DE-SAC spanning more than 2 acres, this home is notable for its HUGE rounded PICTURE WINDOWS, generous spaces and 16 fully-functional rooms. Superior features include a MAGNIFICENT FOYER with sweeping paneled staircase and MARBLE FLOORS, fabric wall treatments, hand-blocked wallpaper, designer lighting, MARBLE and GRANITE accents, french door and transom windows, MAHOGANY bookcases and architectural MILLWORKS. The masterfully designed floor plan allows for comfortable daily living, entertaining of family and friends, or hosting large-scale events and parties. Impressive landscaping with a SUBSTANTIAL BACKYARD and including a BRICK CIRLE DRIVEWAY with stone piers and COPER LANTERNS, a bluestone patio with a BUILT-IN OUTDOOR GRILL. Near golf course, minutes to train, Rt2, and shoppings. 20 min to BOS.Truly spectacular residence in the historic town of Concord.

Last Listed By

Ying Sun

Compass Listed on: 06/06/2020

Compass

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $322

Year Built

  • Built in 1993

Lot Details

  • Stone Wall
  • Landscaped Professionally
  • Sprinkler System

Parking

  • 3 Car Garage

Interior Spaces

  • Wet Bar
  • Central Vacuum
  • Decorative Lighting
  • French Doors
  • Basement

Kitchen

  • Built-In Oven
  • Range
  • Microwave
  • Dishwasher

Flooring

  • Wall to Wall Carpet
  • Marble
  • Tile

Outdoor Features

  • Patio
  • Rain Gutters
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Oil
  • Water Holding Tank
  • Private Sewer

Property Details

Home Type

Condominium

Est. Annual Taxes

$322

Year Built

Built in 1993

Lot Details

0

Listing Details

  • Property Type: Single Family
  • Single Family Type: Attached
  • Style: Colonial
  • Other Agent: 1.00
  • Sub-Agency Relationship Offered: Yes
  • Year Built Description: Renovated Since
  • List Price Per Sq Ft: 239.07
  • Comp Based On: Gross/Full Sale Price
  • Year Built: 1993
  • Special Features: None
  • Property Sub Type: Condos
  • Year Built: 1993

Interior Features

  • Fireplaces: 3
  • Flooring: Tile, Wall to Wall Carpet, Marble
  • Interior Amenities: Central Vacuum, Wetbar, French Doors
  • Appliances: Range, Wall Oven, Dishwasher, Microwave, Refrigerator
  • No Bedrooms: 5
  • Master Bedroom: On Level: Second Floor, Dimension: 16X21, Fireplace, Closet - Walk-in, Recessed Lighting
  • Bedroom 2: On Level: Second Floor, Dimension: 16X13, Closet - Walk-in, Flooring - Wall to Wall Carpet
  • Bedroom 3: On Level: Second Floor, Dimension: 13X16, Closet, Flooring - Wall to Wall Carpet
  • Bedroom 4: On Level: Second Floor, Dimension: 13X27, Skylight, Closet, Flooring - Wall to Wall Carpet, Attic Access
  • Bedroom 5: On Level: Second Floor, Dimension: 13X13, Bathroom - Half, Closet, Flooring - Wall to Wall Carpet, Recessed Lighting
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Primary Bathroom: Yes
  • Bathroom 1: On Level: Second Floor, Dimension: 15X16, Bathroom - Full, Bathroom - Tiled With Tub, Bathroom - With Tub, Flooring - Marble, Countertops - Stone/Granite/Solid
  • Bathroom 2: On Level: Second Floor, Dimension: 14X5, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid
  • Bathroom 3: On Level: Second Floor, Dimension: 5X14, Bathroom - With Tub & Shower, Countertops - Stone/Granite/Solid
  • No Rooms: 16
  • Dining Room: On Level: First Floor, Dimension: 15X20, Flooring - Hardwood, Window(s) - Bay/Bow/Box, French Doors, Exterior Access
  • Family Room: On Level: First Floor, Dimension: 18X24, Fireplace, Skylight, Ceiling - Cathedral, Ceiling Fan(s), Closet/Cabinets - Custom Built, Exterior Access, Sunken
  • Kitchen: On Level: First Floor, Dimension: 23X15, Flooring - Hardwood, Dining Area, Countertops - Stone/Granite/Solid, Kitchen Island, Recessed Lighting
  • Laundry: On Level: First Floor, Dimension: 7X9
  • Living Room: On Level: First Floor, Dimension: 16X27, Fireplace, Flooring - Hardwood, Wet bar, Recessed Lighting
  • Basement: Y
  • Basement Features: Full, Finished, Interior Access, Garage Access
  • Other Room 1: Name: Sun Room, On Level: First Floor, Dimension: 14X18, Flooring - Hardwood
  • Other Room 2: Name: Sun Room, On Level: First Floor, Dimension: 18X13, Ceiling - Cathedral, Ceiling Fan(s), Flooring - Wall to Wall Carpet, French Doors, Exterior Access
  • Other Room 3: Name: Other, On Level: First Floor, Dimension: 13X16, Flooring - Hardwood, Dining Area, French Doors, Exterior Access, Recessed Lighting
  • Other Room 4: Name: Office, On Level: First Floor, Dimension: 17X13, Fireplace, Closet/Cabinets - Custom Built, Flooring - Hardwood, French Doors
  • Other Room 5: Name: Media Room, On Level: Basement, Dimension: 27X11, Flooring - Wall to Wall Carpet, Recessed Lighting
  • Other Room 6: Name: Game Room, On Level: Basement, Dimension: 16X38, Flooring - Wall to Wall Carpet, Recessed Lighting
  • Main Lo: AC0756
  • Main So: BB3298
  • Estimated Sq Ft: 7320.00
  • Basement Included Sq Ft: Yes

Exterior Features

  • Construction: Frame
  • Roof Material: Asphalt/Fiberglass Shingles
  • Exterior: Clapboard, Brick
  • Exterior Features: Porch, Patio, Gutters, Professional Landscaping, Sprinkler System, Decorative Lighting, Stone Wall
  • Foundation: Poured Concrete

Garage/Parking

  • Parking Feature: Off-Street
  • Parking Spaces: 8
  • Garage Parking: Attached
  • Garage Spaces: 3

Utilities

  • Sewer: Private Sewerage
  • Water: City/Town Water
  • Electric Features: Circuit Breakers
  • Cooling: Central Air
  • Cooling Zones: 6
  • Heating: Forced Air, Oil
  • Heat Zones: 6
  • Hot Water: Tank

Condo/Co-op/Association

  • Amenities: Public Transportation, Shopping, Park, Walk/Jog Trails, Golf Course, Medical Facility, Conservation Area, Highway Access, House of Worship, Private School, Public School
  • Home Own Association: Yes

Schools

  • Elementary School: Willard
  • Middle School: Peabody Sanborn
  • High School: CCHS

Lot Info

  • Assessments: 1729100.00
  • Acre: 2.19
  • Lot Size: 95246.00
  • Page: 49
  • Zoning: Z
  • Lot Description: Paved Drive

Tax Info

  • Taxes: 24350.10
  • Assessor Parcel Number: 457401

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 6, 2020
Closed on
Aug 10, 2020
Sold by
Jiang Qian and Wang Tao
Bought by
Leonard Phillip J and Leonard Elizabeth M
Seller's Agent
Ying Sun
Compass
Buyer's Agent
Beth Sager Group
Keller Williams Realty Boston Northwest
List Price
$1,750,000
Sold Price
$1,700,000
Premium/Discount to List
-$50,000
-2.86%
Total Days on Market
14
Current Estimated Value
$2,559,458

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$859,458
Avg. Annual Appreciation
9.04%
Original Mortgage
$1,275,000
Outstanding Balance
$1,141,706
Interest Rate
2.9%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$1,417,752

Purchase Details

Listed on
May 20, 2016
Closed on
Sep 22, 2016
Sold by
Berman Andrew H and Webster Martha T
Bought by
Wang Tao and Jiang Qian
Seller's Agent
Brigitte Senkler
Coldwell Banker Realty - Concord
Buyer's Agent
Ying Sun
Compass
List Price
$1,875,000
Sold Price
$1,798,000
Premium/Discount to List
-$77,000
-4.11%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-1.42%

Purchase Details

Closed on
Jul 16, 1991
Sold by
Bldrs Collaborative
Bought by
Smith Edward T and Smith Susan C

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

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
Leonard Phillip J $1,700,000 None Available
Wang Tao $1,798,000 --
Smith Edward T $222,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Leonad Phillip J $120,000
Closed Leonard Phillip J $85,000
Open Leonard Phillip J $1,275,000
Previous Owner Wang Tao $1,000,000
Previous Owner Berman Andrew H $600,000
Previous Owner Berman Andrew H $500,000
Previous Owner Berman Andrew H $500,000
Previous Owner Berman Andrew H $1,000,000
Previous Owner Smith Edward T $150,000
Previous Owner Smith Edward T $150,000
Previous Owner Smith Edward T $450,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/28/2020 08/28/20 Sold $1,700,000 -2.9% $232 / Sq Ft
06/20/2020 06/20/20 Pending -- -- --
06/06/2020 06/06/20 For Sale $1,750,000 -2.7% $239 / Sq Ft
09/22/2016 09/22/16 Sold $1,798,000 -4.1% $246 / Sq Ft
07/18/2016 07/18/16 Pending -- -- --
05/20/2016 05/20/16 For Sale $1,875,000 -- $256 / 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
2025 $322 $2,425,700 $588,100 $1,837,600
2024 $32,962 $2,510,400 $588,100 $1,922,300
2023 $26,678 $2,058,500 $535,400 $1,523,100
2022 $26,177 $1,773,500 $383,500 $1,390,000
2021 $26,040 $1,769,000 $418,400 $1,350,600
2020 $26,024 $1,828,800 $418,400 $1,410,400
2019 $24,536 $1,729,100 $389,300 $1,339,800
2018 $24,350 $1,704,000 $381,900 $1,322,100
2017 $23,224 $1,650,600 $363,800 $1,286,800
2016 $23,823 $1,711,400 $404,800 $1,306,600
2015 $22,538 $1,577,200 $375,000 $1,202,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 72668829

MLS Property Information Network (MLS PIN)

APN: CONC-000013E-003106-000015