NOT LISTED FOR SALE

140 Mildred Cir Concord, MA 01742

Estimated Value: $2,387,000 - $2,647,000

5 Beds
5.5 Baths
5,230 Sq Ft
$486/Sq Ft Est. Value

Last Sold June 21, 2024

Last sale price $2,520,000 $482 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $14,216/month

4 Days on Market

Highlights

  • Medical Services
  • Heated In Ground Pool
  • Colonial Architecture
  • Alcott Elementary School Rated A
  • Custom Closet System
  • Landscaped Professionally

About This Home

As of June 2024

Perfection plus at every turn! This home is absolutely stunning! The current owners have touched every surface; their comprehensive renovations & attention to detail readily elevate this property to another level. A new white kitchen w quartz counters, center island & stainless appliance package, striking updated baths, new light fixtures & refinished floors...every aspect has been meticulously improved. Generous room proportions & consistency of scale exist throughout the property’s 11 rms; the bonus of a private en-suite = great for hosting guests or creating a dedicated workspace. Outside, a fabulous 82’ long deck offers welcoming places to relax, read or entertain & the heated pool promises endless hours of fun during warmer months. This amazing home is located in a great neighborhood w direct access to conservation land, CCHS & Walden Pond. Together with a sidewalk to Concord Center & local farm stand, this location is the best blend of luxurious living & suburban convenience!

Last Agent to Sell the Property

Barrett & Comeau Group

Barrett Sotheby's International Realty Listed on: 05/16/2024

Barrett Sotheby's International Realty

Last Buyer's Agent

Hongyan Sun

Stonebridge Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,441

Year Built

  • Built in 1985

Lot Details

  • 1.07 Acre Lot
  • Property fronts an easement
  • Near Conservation Area
  • Fenced Yard
  • Fenced
  • Landscaped Professionally
  • Corner Lot
  • Level Lot
  • Sprinkler System
  • Cleared Lot

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • Open Parking
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Frame Construction
  • Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 5,230 Sq Ft Home
  • Central Vacuum
  • Vaulted Ceiling
  • Window Screens
  • French Doors
  • Mud Room
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • 4 Fireplaces
  • Sun or Florida Room
  • Utility Room with Study Area
  • Home Security System

Kitchen

  • Oven
  • Range with Range Hood
  • Plumbed For Ice Maker
  • Dishwasher
  • Wine Refrigerator
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal
  • Pot Filler

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary bedroom located on second floor
  • Custom Closet System
  • Walk-In Closet
  • Double Vanity
  • Bathtub with Shower
  • Bathtub Includes Tile Surround
  • Separate Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry

Pool

  • Heated In Ground Pool
  • Spa

Outdoor Features

  • Deck
  • Outdoor Storage

Location

  • Property is near public transit
  • Property is near schools

Schools

  • Alcott Elementary School
  • Peabody/Sanborn Middle School
  • CCHS High School

Utilities

  • Ductless Heating Or Cooling System
  • Forced Air Heating and Cooling System
  • 3 Cooling Zones
  • 3 Heating Zones
  • Heating System Uses Oil
  • 200+ Amp Service
  • Electric Water Heater
  • Private Sewer

Listing and Financial Details

  • Assessor Parcel Number 456338

Community Details

Overview

  • No Home Owners Association

Amenities

  • Medical Services
  • Shops

Recreation

  • Tennis Courts
  • Community Pool
  • Park
  • Jogging Path
  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,441

Year Built

Built in 1985

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Colonial
  • Year Built: 1985
  • Buyer Agency: 2.5 %
  • Buyer Agency Type: %
  • Transaction Broker: 0%
  • Transaction Broker Type: %
  • Year Built Details: Actual,Renovated Since
  • SUB AGENCY OFFERED: No
  • Year Round: Yes
  • Compensation Based On: Net Sale Price
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Tile, Hardwood, Flooring - Stone/Ceramic Tile, Flooring - Hardwood
  • Interior Amenities: Bathroom - Tiled With Shower Stall, Closet/Cabinets - Custom Built, Vaulted Ceiling(s), Bathroom, Study, Sun Room, Mud Room, Central Vacuum
  • Door Features: French Doors
  • Fireplace Features: Dining Room, Family Room, Living Room
  • Fireplace YN: Yes
  • Fireplaces: 4
  • Appliances: Electric Water Heater, Water Heater, Oven, Dishwasher, Disposal, Range, Refrigerator, Washer, Dryer, Wine Refrigerator, Range Hood, Plumbed For Ice Maker
  • Total Bedrooms: 5
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Closet, Flooring - Hardwood
  • Room Bedroom2 Area: 238
  • Room Bedroom3 Features: Closet, Flooring - Hardwood
  • Room Bedroom3 Area: 210
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Area: 210
  • Room Bedroom4 Level: Second
  • Room Bedroom4 Features: Closet, Flooring - Hardwood
  • Room Bedroom5 Level: Second
  • Room Bedroom5 Features: Flooring - Hardwood
  • Room Bedroom5 Area: 260
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bathrooms: 6
  • Total Bathrooms: 5.5
  • Room Master Bedroom Features: Walk-In Closet(s), Flooring - Hardwood
  • Room Master Bedroom Level: Second
  • Room Master Bedroom Area: 320
  • Master Bathroom Features: Yes
  • Bathroom 1 Area: 224
  • Bathroom 1 Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile
  • Bathroom 1 Level: Second
  • Bathroom 2 Level: Second
  • Bathroom 2 Area: 77
  • Bathroom 2 Features: Bathroom - Full, Bathroom - Tiled With Tub, Flooring - Stone/Ceramic Tile
  • Bathroom 3 Features: Bathroom - Full, Bathroom - Tiled With Tub
  • Bathroom 3 Level: Second
  • Bathroom 3 Area: 77
  • Room Dining Room Features: Flooring - Hardwood
  • Room Dining Room Level: First
  • Room Dining Room Area: 240
  • Room Family Room Level: First
  • Room Family Room Features: Closet/Cabinets - Custom Built, Flooring - Hardwood, Exterior Access
  • Room Family Room Area: 480
  • Room Kitchen Level: First
  • Room Kitchen Features: Closet/Cabinets - Custom Built, Flooring - Hardwood, Dining Area, Kitchen Island, Deck - Exterior, Stainless Steel Appliances, Pot Filler Faucet
  • Room Kitchen Area: 432
  • Laundry Features: Closet/Cabinets - Custom Built, First Floor, Electric Dryer Hookup, Washer Hookup
  • Room Living Room Level: First
  • Room Living Room Area: 378
  • Room Living Room Features: Closet/Cabinets - Custom Built, Flooring - Hardwood, French Doors, Exterior Access
  • Basement: Full, Interior Entry, Unfinished
  • Living Area: 5230
  • Spa Features: Private
  • Spa YN: Yes
  • Window Features: Screens
  • MAIN LO: AN0538
  • LIST PRICE PER Sq Ft: 470.36
  • PRICE PER Sq Ft: 481.84
  • MAIN SO: AN5513
  • Insulation: Unknown

Exterior Features

  • Exterior Features: Deck - Composite, Pool - Inground Heated, Hot Tub/Spa, Storage, Professional Landscaping, Sprinkler System, Screens, Fenced Yard
  • Construction Materials: Frame
  • Fencing: Fenced/Enclosed, Fenced
  • Foundation Details: Concrete Perimeter
  • Home Warranty YN: No
  • Patio And Porch Features: Deck - Composite
  • Pool Features: Pool - Inground Heated
  • Pool Private YN: Yes
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Roof: Shingle
  • Waterfront Features: Beach Front, Lake/Pond, 1/2 to 1 Mile To Beach, Beach Ownership(Public)
  • Waterfront YN: No
  • Waterview Flag: No

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage YN: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 3
  • Garage YN: Yes
  • Open Parking YN: Yes
  • Parking Features: Attached, Garage Door Opener, Garage Faces Side, Paved Drive, Off Street, Paved
  • Total Parking Spaces: 4

Utilities

  • Sewer: Private Sewer
  • Utilities: for Electric Range, for Electric Oven, for Electric Dryer, Washer Hookup, Icemaker Connection
  • Cooling: Central Air, Ductless
  • Heating: Forced Air, Oil, Ductless, Fireplace
  • Cooling Y N: Yes
  • Electric: Circuit Breakers, 200+ Amp Service
  • Heating YN: Yes
  • Security Features: Security System
  • Water Source: Public
  • HEAT ZONES: 3
  • COOLING ZONES: 3

Condo/Co-op/Association

  • Association YN: No
  • Community Features: Public Transportation, Shopping, Pool, Tennis Court(s), Park, Walk/Jog Trails, Medical Facility, Bike Path, Conservation Area, Highway Access, House of Worship, Private School, Public School, T-Station
  • Senior Community YN: No

Lot Info

  • Parcel Number: 456338
  • Zoning: SFR
  • Farm Land Area Units: Square Feet
  • Lot Features: Corner Lot, Easements, Cleared, Level
  • Lot Size Acres: 1.07
  • Lot Size Area: 1.07
  • Lot Size Sq Ft: 46534
  • Lot Size Units: Acres
  • Property Attached YN: No
  • PAGE: 414
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 27441
  • Tax Book Number: 69753

Multi Family

  • Basement Included Sq Ft: No

MLS Schools

  • High School: Cchs
  • Elementary School: Alcott
  • Middle Or Junior School: Peabody/Sanborn

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 25, 2017
Closed on
Aug 10, 2017
Sold by
Yamin Deborah A
Bought by
Jackson Corwin F and Belmonte Kathleen A
Seller's Agent
Amy Barrett
Barrett Sotheby's International Realty
Buyer's Agent
Diana Jarvis
Coldwell Banker Realty - Concord
List Price
$1,499,999
Sold Price
$1,480,000
Premium/Discount to List
-$19,999
-1.33%
Total Days on Market
4
Current Estimated Value
$2,540,500

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,060,500
Avg. Annual Appreciation
7.13%
Original Mortgage
$250,000
Interest Rate
3.88%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 14, 2004
Sold by
Cohen Sumner H
Bought by
Yamin Deborah A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$656,250
Interest Rate
5.47%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Similar Homes in the area

  • 20 Flint Rd, Concord, MA 01742

    $2,985,000

    • 5 Beds
    • 5.5 Baths
    • 5,744 Sq Ft
    • 20 Flint Rd
    • Concord, MA

    Located in Concord’s desirable Monument Farm neighborhood, this custom brick Colonial offers timeless design & thoughtful updates on 2 private acres. The open layout features a 2-story LR w/ elegant columns, updated kitchen w/ quartz counters, new lighting & sunlit breakfast area. A vaulted FR w/ fireplace opens to a stone patio & landscaped yard—ideal for indoor-outdoor living. The 1st flr

    Peggy Dowcett Coldwell Banker Realty - Concord

    Section Image
  • 37 Independence Rd, Concord, MA 01742

    $2,075,000

    • 4 Beds
    • 5 Baths
    • 4,532 Sq Ft
    • 37 Independence Rd
    • Concord, MA

    Steps to Concord Center in beloved Ridge neighborhood! Stunning NEW eat-in-kitchen is a chef's dream with custom cabinetry, granite and oak countertops that flows into sun drenched family room with bay window. A large screened in porch with wooden beams and exterior stone patio are perfect for indoor/outdoor living. Formal living room with fireplace has adjoining private vaulted room ideal as an

    Lisanne Wheeler Coldwell Banker Realty - Concord

    Section Image
  • 84 Bruce Rd, Concord, MA 01742

    $2,595,000

    • 4 Beds
    • 6 Baths
    • 5,400 Sq Ft
    • 84 Bruce Rd
    • Concord, MA

    Curb appeal! Young colonial on RARE 1.2 ACRE LOT w/ ideal, cul-de-sac location in neighborhood b/n Crosby's Market & CA athletic fields. Just short walk to Concord Ctr, commuter rail, Emerson Park & easy access to Rte. 2! This 4BR house is beautifully maintained and thoughtfully upgraded. 1st Fl boasts an open concept layout, cathedral ceiling in generous family room w/ gas fireplace, kitchen

    Daniel Loring Keller Williams Realty North Central

    Section Image
  • 67 Butternut Cir, Concord, MA 01742

    $2,399,000

    • 5 Beds
    • 5 Baths
    • 5,005 Sq Ft
    • 67 Butternut Cir
    • Concord, MA

    Exceptional NEW HOME prominently sited on a corner level lot towards a cul-de-sac to capture natural light from all directions. Superb architectural design combines refined finishes w/top-notch materials & efficient HVAC to afford sustainability and modern luxury on three distinctive levels. This stylish home features well-appointed living spaces, enhanced by exquisite wainscoting in foyer, LR

    Vivien Tao Coldwell Banker Realty - Concord

    Section Image
  • 38 McCallar Ln, Concord, MA 01742

    $2,998,000

    • 5 Beds
    • 5.5 Baths
    • 4,969 Sq Ft
    • 38 McCallar Ln
    • Concord, MA

    Experience unparalleled luxury and sophisticated design in this exquisite Modern Farmhouse, set on 8+ acres of scenic landscape in an enclave of beautiful homes just ¾ of a mile to the center. Designed with an exceptional blend of elegance & comfort for both entertaining and relaxed living. 11 spacious rooms in a flowing floorplan. Details include Custom millwork, coffered ceilings, wide plank

    Senkler, Pasley & Dowcett Coldwell Banker Realty - Concord

    Section Image
  • 138 Baker Ave, Concord, MA 01742

    $1,999,000

    • 5 Beds
    • 6 Baths
    • 5,561 Sq Ft
    • 138 Baker Ave
    • Concord, MA

    Beautifully renovated farmhouse just minutes from vibrant Concord Center, offering modern comfort with historic charm. The gourmet kitchen with Viking, Sub-Zero, and Fisher & Paykel appliances opens to a sunlit family room with fireplace and French doors to a brick terrace. Wide-plank king pine floors and spacious rooms provide the perfect setting for both entertaining and quiet living. Two home

    Kevin Balboni William Raveis R.E. & Home Services

    Section Image
  • 306 Laws Brook Rd, Concord, MA 01742

    $2,469,000

    • 5 Beds
    • 6 Baths
    • 5,200 Sq Ft
    • 306 Laws Brook Rd
    • Concord, MA

    Due to unexpected relocation Sellers are parting with this cherished home. 3 years young, stylish, thoughtfully designed, convenient to West Concord Village and effortless access to Commuter Rail, parks, schools, local coffee shops, restaurants, and Bruce Freeman Rail Trail. Inside discover modern charm light filled spaces, custom touches including wainscoting, crown molding and coffered

    Faith Pulis Engel & Volkers By the Sea

    Section Image
  • 150 Dakin Rd, Sudbury, MA 01776

    $1,995,000

    • 4 Beds
    • 5 Baths
    • 5,041 Sq Ft
    • 150 Dakin Rd
    • Sudbury, MA

    SUDBURY/CONCORD LINE. ART STUDIO & 8+ GARAGE SPACE. This stunning 5.47 acre lot includes a beautiful Cape Cod-Style house with 5041 sq ft of living space & custom pool. Built in 1981, this home features 4 bedrooms, 3 full & 2 half baths, & spacious 2-car garage w/ ample attic storage. An additional garage (1089 sq ft) can accommodate 2 cars with upstairs ART STUDIO/HOME OFFICE. THE BARN (1333 sq

    Nikki Milott McCay Advisors Living - Weston

    Section Image
  • 65 Summit St, Concord, MA 01742

    $1,995,000

    • 4 Beds
    • 5.5 Baths
    • 4,802 Sq Ft
    • 65 Summit St
    • Concord, MA

    PRICE IMPROVEMENT!! EXPANSIVE & BRIGHT! This tremendous home is nestled at the end of a QUIET CUL-DE-SAC & w/4 levels of gorgeous living space, your lifestyle here is built for comfort! The entrance is grand, showcasing a dramatic staircase & HIGH CEILINGS! The KITCHEN IS DRENCHED IN NATURAL LIGHT featuring a center island, casual dining area, WET BAR & direct access to the back patio! As the

    The Zur Attias Team The Attias Group, LLC

    Section Image

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
Jackson Corwin F $1,480,000 --
Yamin Deborah A $1,275,000 --
Yamin Deborah A $1,275,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Han Xinwei $1,080,000
Open Han Xinwei $1,700,000
Closed Han Xinwei $1,700,000
Closed Jackson Corwin F $250,000
Previous Owner Yamin Deborah A $391,000
Previous Owner Yamin Deborah A $400,000
Previous Owner Yamin Deborah A $656,250
Previous Owner Yamin Deborah A $300,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/21/2024 06/21/24 Sold $2,520,000 +2.4% $482 / Sq Ft
05/21/2024 05/21/24 Pending -- -- --
05/16/2024 05/16/24 For Sale $2,460,000 +66.2% $470 / Sq Ft
08/10/2017 08/10/17 Sold $1,480,000 -1.3% $316 / Sq Ft
05/26/2017 05/26/17 Pending -- -- --
04/25/2017 04/25/17 For Sale $1,499,999 -- $321 / 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 $280 $2,112,500 $585,600 $1,526,900
2024 $27,442 $2,090,000 $585,600 $1,504,400
2023 $22,453 $1,732,500 $532,300 $1,200,200
2022 $22,686 $1,537,000 $425,800 $1,111,200
2021 $22,133 $1,503,600 $425,800 $1,077,800
2020 $21,816 $1,533,100 $425,800 $1,107,300
2019 $20,530 $1,446,800 $392,900 $1,053,900
2018 $19,061 $1,333,900 $393,800 $940,100
2017 $19,206 $1,365,000 $403,200 $961,800
2016 $18,909 $1,358,400 $384,400 $974,000
2015 $17,877 $1,251,000 $355,900 $895,100
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 73238795

MLS Property Information Network (MLS PIN)

APN: CONC-000010I-000259-000021