NOT LISTED FOR SALE

404 Elm St Concord, MA 01742

Estimated Value: $2,781,000 - $3,627,000

6 Beds
4.5 Baths
6,126 Sq Ft
$525/Sq Ft Est. Value

Last Sold July 13, 2012

Last sale price $1,580,000 $258 Per Sq Ft

Est. 104% increase in value since last sale

Current estimated payment $17,880/month

64 Days on Market

Highlights

  • Golf Course Community
  • Wine Cellar
  • Colonial Architecture
  • Willard School Rated A
  • Medical Services
  • Landscaped Professionally

About This Home

As of July 2012

Elegant and spacious, completely renovated in 2006. New heating system, ac, flooring, addition of master suite with radiant heat in bathroom, sep laundry room, family room, kitchen and breakfast area. Gourmet kitchen with granite counters, Wolf stove, breakfast bar, hdwd floors, pantry. FR with gas FP, Located on desirable Elm street, walk to Concord Center. 2 car garage, nice appointments. Legal 2 bdrm apt great for in-laws, adult child, or even rental. This is a very special property.

Last Listed By

Lorna Rush

Barrett Sotheby's International Realty Listed on: 04/10/2012

Barrett Sotheby's International Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $22,279

Year Built

  • Built in 1959

Lot Details

  • 0.92 Acre Lot
  • Near Conservation Area
  • Stone Wall
  • Landscaped Professionally
  • Level Lot
  • Sprinkler System

Parking

  • 2 Car Attached Garage
  • Parking Storage or Cabinetry
  • Garage Door Opener
  • Driveway
  • Open Parking
  • Off-Street Parking

Home Design

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

Interior Spaces

  • 6,126 Sq Ft Home
  • Insulated Windows
  • French Doors
  • Insulated Doors
  • Wine Cellar
  • Family Room with Fireplace
  • 3 Fireplaces
  • Living Room with Fireplace
  • Sitting Room
  • Dining Area
  • Home Office
  • Game Room
  • Play Room
  • Screened Porch
  • Utility Room with Study Area
  • Storm Doors

Kitchen

  • Breakfast Bar
  • Built-In Range
  • Range Hood
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Stainless Steel Appliances
  • Solid Surface Countertops

Flooring

  • Wood
  • Wall to Wall Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Dressing Area

Laundry

  • Laundry on upper level
  • Electric Dryer Hookup

Finished Basement

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

Outdoor Features

  • Balcony
  • Patio
  • Outdoor Storage

Location

  • Property is near public transit
  • Property is near schools

Schools

  • Willard Elementary School
  • Concord Middle School
  • Concord/Carlisl High School

Utilities

  • Forced Air Heating and Cooling System
  • 4 Cooling Zones
  • 4 Heating Zones
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Natural Gas Connected
  • Private Water Source
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 453075

Community Details

Overview

  • No Home Owners Association

Amenities

  • Medical Services
  • Shops

Recreation

  • Golf Course Community
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$22,279

Year Built

Built in 1959

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Colonial
  • Year Built: 1959
  • Buyer Agency: 2.5
  • Buyer Agency Type: %
  • Transaction Broker: 1
  • Transaction Broker Type: %
  • Year Built Details: Actual,Renovated Since
  • SUB AGENCY OFFERED: No
  • Year Round: Yes
  • ResoPropertyType: Residential
  • Special Features: VirtualTour

Interior Features

  • Flooring: Tile, Carpet, Hardwood, Flooring - Wall to Wall Carpet, Flooring - Hardwood
  • Interior Amenities: Play Room, Study, Office, Sitting Room, Wine Cellar, Game Room
  • Door Features: French Doors, Insulated Doors, Storm Door(s)
  • Fireplace Features: Family Room, Living Room
  • Fireplace YN: Yes
  • Fireplaces: 3
  • Appliances: Range,Dishwasher,Microwave,Countertop Range,Refrigerator,Wine Refrigerator,Range Hood, Gas Water Heater,Tank Water Heater, Utility Connections for Gas Range, Utility Connections for Electric Dryer
  • Total Bedrooms: 6
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Flooring - Hardwood
  • Room Bedroom2 Area: 240
  • Room Bedroom3 Features: Flooring - Hardwood
  • Room Bedroom3 Area: 182
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Area: 195
  • Room Bedroom4 Level: Second
  • Room Bedroom4 Features: Flooring - Hardwood
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Total Bathrooms: 4.5
  • Room Master Bedroom Features: Bathroom - Full, Walk-In Closet(s), Flooring - Hardwood, Dressing Room
  • Room Master Bedroom Level: Second
  • Room Master Bedroom Area: 240
  • Master Bathroom Features: Yes
  • Room Dining Room Features: Flooring - Hardwood
  • Room Dining Room Level: First
  • Room Dining Room Area: 182
  • Room Family Room Level: First
  • Room Family Room Features: Flooring - Hardwood
  • Room Family Room Area: 240
  • Room Kitchen Level: First
  • Room Kitchen Features: Flooring - Hardwood, Dining Area, Countertops - Stone/Granite/Solid, Breakfast Bar / Nook, Cabinets - Upgraded, Stainless Steel Appliances
  • Room Kitchen Area: 432
  • Laundry Features: Second Floor
  • Room Living Room Level: First
  • Room Living Room Area: 360
  • Room Living Room Features: Flooring - Hardwood
  • Room Office Level: Basement
  • Room Office Area: 308
  • Room Office Features: Flooring - Wall to Wall Carpet
  • Basement: Full, Finished, Interior Entry
  • Living Area: 6126
  • Window Features: Insulated Windows
  • MAIN LO: an0538
  • LIST PRICE PER Sq Ft: 273.42
  • PRICE PER Sq Ft: 257.92
  • MAIN SO: an0538

Exterior Features

  • Exterior Features: Balcony, Storage, Professional Landscaping, Sprinkler System, Stone Wall
  • Construction Materials: Frame
  • Foundation Details: Concrete Perimeter
  • Patio And Porch Features: Screened, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Roof: Shingle
  • Waterfront YN: No

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage YN: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 2
  • Garage YN: Yes
  • Open Parking YN: Yes
  • Parking Features: Attached, Garage Door Opener, Storage, Paved Drive, Off Street, Paved
  • Total Parking Spaces: 10

Utilities

  • Sewer: Public Sewer
  • Utilities: for Gas Range, for Electric Dryer
  • Cooling: Central Air
  • Heating: Forced Air, Radiant, Natural Gas
  • Cooling Y N: Yes
  • Electric: Circuit Breakers
  • Heating YN: Yes
  • Water Source: Public, Private
  • HEAT ZONES: 4
  • COOLING ZONES: 4

Condo/Co-op/Association

  • Association YN: No
  • Community Features: Shopping, Park, Golf, Medical Facility, Conservation Area, Highway Access, House of Worship, Private School, Public School, T-Station, Sidewalks
  • Senior Community YN: No

Lot Info

  • Parcel Number: 453075
  • Zoning: A
  • Farm Land Area Units: Square Feet
  • Lot Features: Level
  • Lot Size Acres: 0.92
  • Lot Size Area: 0.92
  • Lot Size Sq Ft: 40075.2
  • Lot Size Units: Acres
  • Property Attached YN: No
  • LOT SIZE: 40000
  • PAGE: 427

Tax Info

  • Tax Year: 2012
  • Tax Annual Amount: 22279.3
  • Tax Book Number: 47642

Multi Family

  • Basement Included Sq Ft: Yes

MLS Schools

  • High School: Concord/Carlisl
  • Elementary School: Willard
  • Middle Or Junior School: Concord Middle

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 10, 2012
Closed on
Jul 13, 2012
Sold by
Chateauneuf Dennis and Chateauneuf Linda
Bought by
Debra A Logue Ret
Seller's Agent
Lorna Rush
Barrett Sotheby's International Realty
Buyer's Agent
Rita Bissonnette Clark
Barrett Sotheby's International Realty
List Price
$1,799,000
Sold Price
$1,580,000
Premium/Discount to List
-$219,000
-12.17%
Total Days on Market
64
Current Estimated Value
$3,219,208

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,639,208
Avg. Annual Appreciation
5.57%

Purchase Details

Closed on
Jun 16, 2006
Sold by
Russell Albert H and Russell Claire T
Bought by
Chateauneuf Dennis and Chateauneuf Linda

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
6.62%
Mortgage Type
Purchase Money Mortgage

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 Concord, MA

  • 23 Lewis Rd, Concord, MA 01742

    $3,900,000

    • 6 Beds
    • 4.5 Baths
    • 7,510 Sq Ft
    • 23 Lewis Rd
    • Concord, MA

    Landmark elegance meets modern comfort in the Augustus P. Chamberlaine House, beautifully renovated and expanded for today's lifestyle. This gracious home offers 3 levels of living with 14 rooms, including a stunning primary suite with sitting/dressing area and marble bath, plus 5 additional bedrooms. Classic details abound—mahogany inlaid floors, intricate staircases, built-ins, hand-carved

    Senkler, Pasley & Dowcett Coldwell Banker Realty - Concord

    Section Image
  • 32 Wilson Rd, Concord, MA 01742

    $2,750,000

    • 5 Beds
    • 4.5 Baths
    • 5,560 Sq Ft
    • 32 Wilson Rd
    • Concord, MA

    This Exceptional Luxury Residence is set on a beautifully landscaped property. It's a move-in ready masterpiece, designed for effortless elegance and modern living with expansive, light-filled interiors and exquisite craftsmanship throughout. Offering five+ spacious bedrooms, this home has a magnificent primary suite, featuring oversized bedroom, 2 walk-in closets, ensuite office and a

    Susan Livingston William Raveis R.E. & Home Services

    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

    $2,499,000

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

    Modern living with historic features offered in this stunning farmhouse providing a floorplan for today’s living! Prepare sumptuous meals in the gourmet kitchen with Viking range, Sub Zero & Fisher Paykel appliances that is open to the spacious family room w/fireplace & French doors to brick terrace. 2 separate Home Offices allow for work from home options. Gorgeous king pine floors & beautifully

    Kevin Balboni William Raveis R.E. & Home Services

    Section Image
  • 602 Main St, Concord, MA 01742

    $2,998,900

    • 5 Beds
    • 4.5 Baths
    • 6,577 Sq Ft
    • 602 Main St
    • Concord, MA

    BEAUTIFULLY RENOVATED HOME WITH DRAMATIC GUEST HOUSE! Spectacular MATURE LANDSCAPING with a stunning SALT WATER POOL & plenty of yard to throw a ball around! The main house is elegant – A FORMAL DINING ROOM OFFERS WALLS OF WINDOWS! Bask in the glow of sunset in a brilliant 4 SEASON SUNROOM – with a full WET BAR that is perfect for entertaining! The kitchen is grand with a center island, sleek

    The Zur Attias Team The Attias Group, LLC

    Section Image
  • 90 Coolidge Rd, Concord, MA 01742

    $2,995,000

    • 4 Beds
    • 4.5 Baths
    • 4,008 Sq Ft
    • 90 Coolidge Rd
    • Concord, MA

    Welcome to this timeless, elegant & chic colonial nestled in one of Concord’s premier neighborhoods. Built in 1934 and recently renovated by the Milk and Honey Group, its the perfect blend of historic charm & modern luxury. East Coast meets West coast featured in 2024 Elle Decor magazine, & boasting 4,008 sq ft of thoughtfully designed space. Featuring 4 generously sized bedrooms & 5 bathrooms

    The Patenaude and Fivek Team Barrett Sotheby's International Realty

    Section Image
  • 109 Oak Rd, Concord, MA 01742

    $3,950,000

    • 4 Beds
    • 4.5 Baths
    • 5,973 Sq Ft
    • 109 Oak Rd
    • Concord, MA

    Custom built in 2010, this exquisite waterfront home is privately located on 7 acres at the end of a peaceful road in the sought-after Coolidge Park neighborhood. The home blends privacy, beauty and convenience. The sunny main floor features a chef’s kitchen with custom cabinetry, stone counters, and professional-grade appliances, flowing seamlessly into the dining and family rooms, ideal for

    The Ridick Revis Group Compass

    Section Image
  • 57 Elsinore St, Concord, MA 01742

    $2,890,000

    • 4 Beds
    • 5.5 Baths
    • 5,457 Sq Ft
    • 57 Elsinore St
    • Concord, MA

    OFFER ACCEPTED, OPEN HOUSES CANCELLED. Experience refined living at 57 Elsinore Street, Concord. Ideally situated near vibrant Concord Center, this beautifully renovated home blends timeless elegance with modern luxury. The airy, open-concept layout is enhanced by soaring ceilings, designer finishes, and carefully curated details throughout. The second level offers four spacious bedrooms,

    Jonathan Caldwell ACRE Property Advisors LLC

    Section Image
  • 12 Bow St, Concord, MA 01742

    $3,180,000

    • 5 Beds
    • 4.5 Baths
    • 4,602 Sq Ft
    • 12 Bow St
    • Concord, MA

    In the heart of Historic Concord Center, this young, custom home sits on a beautifully landscaped, half-acre fenced property on a quiet side street.Designed with smart finishes,it offers an exceptional blend of elegance and modern comfort.Enjoy the stunning backyard retreat featuring a grand patio with a fire pit, a grill master’s barbecue area, a hot tub, and a brand-new in-ground pool with a

    Greg Higgins Barrett Sotheby's International Realty

    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
Debra A Logue Ret $1,580,000 --
Chateauneuf Dennis $1,255,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Russell Albert H $1,267,500
Previous Owner Chateauneuf Dennis R $1,000,000
Previous Owner Chateauneuf Dennis R $250,000
Previous Owner Chateauneuf Dennis R $1,000,000
Previous Owner Chateauneuf Dennis $1,000,000
Previous Owner Chateauneuf Dennis R $128,245
Previous Owner Russell Albert H $225,000
Previous Owner Russell Albert H $200,000
Previous Owner Russell Albert H $165,000
Previous Owner Russell Albert H $175,000
Previous Owner Russell Albert H $35,000
Previous Owner Russell Albert H $10,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/13/2012 07/13/12 Sold $1,580,000 -5.7% $258 / Sq Ft
06/13/2012 06/13/12 Pending -- -- --
05/07/2012 05/07/12 Price Changed $1,675,000 -6.9% $273 / Sq Ft
04/10/2012 04/10/12 For Sale $1,799,000 -- $294 / 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 $387 $2,919,200 $1,088,400 $1,830,800
2024 $38,023 $2,895,900 $1,088,400 $1,807,500
2023 $30,094 $2,322,100 $890,500 $1,431,600
2022 $29,795 $2,018,600 $712,300 $1,306,300
2021 $29,151 $1,980,400 $712,300 $1,268,100
2020 $28,745 $2,020,000 $712,300 $1,307,700
2019 $28,170 $1,985,200 $743,000 $1,242,200
2018 $6,834 $1,884,600 $658,800 $1,225,800
2017 $25,288 $1,797,300 $604,200 $1,193,100
2016 $25,302 $1,817,700 $604,200 $1,213,500
2015 $23,776 $1,663,800 $559,500 $1,104,300
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: 71364767

MLS Property Information Network (MLS PIN)

APN: CONC-000008F-000000-001798