NOT LISTED FOR SALE

23 Lewis Rd Concord, MA 01742

Estimated Value: $3,815,383 - $4,120,000

6 Beds
6 Baths
8,275 Sq Ft
$472/Sq Ft Est. Value

Last Sold November 18, 2021

Last sale price $3,900,000 $471 Per Sq Ft

Current estimated payment $20,690/month

18 Days on Market

Highlights

  • Wood Flooring
  • Linen Closet
  • High Speed Internet
  • Willard School Rated A

About This Home

As of November 2021

Feel the pride of calling this regal estate home, one of Concord’s coveted estates, as you approach via a long, drive that circles at the entry. Grand columns on either side of wide steps support the stone masonry exterior. This 8200 square foot home with 7+ bedrooms, 6+ baths offers an extraordinary luxury lifestyle amidst a serene surrounding landscape. Custom double doors open to a magnificent, welcoming mahogany-floored reception hall with extra tall ceilings spanning the whole home on every floor. Upon entering, you are led to an extra large formal living room ideal for entertaining. Masterfully renovated with upgraded systems yet leaving the architectural integrity of the home intact.Master chefs and amateur cooks alike will treasure the simple elegance and thoughtful design of the bright gourmet kitchen stretching the entire width of the home. Among the bedrooms upstairs is the impressive Master Suite. 5 Car garage, 2 horse stables and tack room. Separate Guest House.Qualified

Last Agent to Sell the Property

Catherine Bassick

Douglas Elliman Real Estate - Park Plaza Listed on: 10/08/2021

Douglas Elliman Real Estate - Park Plaza

Last Buyer's Agent

Abby Gurall White

LandVest, Inc., Concord

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $519

Year Built

  • 1884

Lot Details

  • 2.19

Parking

  • 5

Bedrooms and Bathrooms

  • Primary bedroom located on second floor
  • Linen Closet
  • Walk-In Closet
  • Dressing Area
  • Dual Vanity Sinks in Primary Bathroom

Additional Features

  • Wood Flooring
  • High Speed Internet

Home Details

Home Type

Single Family

Est. Annual Taxes

$519

Year Built

1884

Lot Details

0

Parking

5

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • SUB AGENCY OFFERED: No
  • Compensation Based On: Gross/Full Sale Price
  • Architectural Style: Colonial, Georgian
  • Carport Y N: No
  • Directions: Please Use GPS
  • Garage Yn: Yes
  • Horses: Yes
  • Property Attached Yn: No
  • Road Frontage Type: Public
  • Year Built Details: Renovated Since
  • Special Features: None
  • Year Built: 1884

Interior Features

  • Appliances: Range,Oven,Dishwasher,Microwave,Countertop Range,Refrigerator,Washer,Dryer,Water Treatment,ENERGY STAR Qualified Refrigerator,Range Hood, Gas Water Heater
  • Has Basement: Full, Partially Finished, Interior Entry, Bulkhead, Radon Remediation System, Concrete
  • Fireplace Features: Master Bedroom
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Area: 216
  • Room Bedroom3 Area: 216
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Area: 140
  • Room Bedroom4 Level: Second
  • Room Bedroom5 Level: Third
  • Room Bedroom5 Area: 324
  • Total Bathrooms: 5.5
  • Room Master Bedroom Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Closet - Linen, Walk-In Closet(s), Closet, Flooring - Hardwood, Dressing Room, High Speed Internet Hookup
  • Room Master Bedroom Level: Second
  • Room Master Bedroom Area: 324
  • Master Bathroom Features: Yes
  • Bathroom 1 Level: First
  • Room Dining Room Level: First
  • Room Dining Room Area: 324
  • Room Family Room Level: First
  • Room Family Room Area: 342
  • Room Kitchen Level: First
  • Room Kitchen Area: 336
  • Room Living Room Level: First
  • Room Living Room Area: 648
  • MAIN LO: AC0342
  • LIST PRICE PER Sq Ft: 519.64
  • PRICE PER Sq Ft: 471.3
  • MAIN SO: C03800
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Door Features: French Doors
  • Fireplace: Yes
  • Fireplaces: 4
  • Flooring: Wood, Tile, Hardwood, Stone / Slate
  • Interior Amenities: Wet Bar, Wired for Sound, Internet Available - Broadband

Exterior Features

  • Roof: Shingle
  • Exterior Features: Balcony, Rain Gutters, Storage, Sprinkler System, Fruit Trees, Garden, Horses Permitted
  • Foundation Details: Concrete Perimeter
  • Construction Type: Brick
  • Fencing: Fenced, Invisible
  • Lot Features: Corner Lot
  • Other Structures: Barn/Stable, Guest House
  • Patio And Porch Features: Porch, Porch - Enclosed, Screened, Deck, Deck - Wood, Patio, Covered
  • Waterfront: No

Garage/Parking

  • Parking Features: Detached, Garage Door Opener, Storage, Workshop in Garage, Carriage Shed, Barn, Oversized, Tandem, Deeded, Paved
  • Attached Garage: No
  • Covered Parking Spaces: 5
  • Garage Spaces: 5
  • Open Parking: Yes
  • Total Parking Spaces: 8

Utilities

  • Cooling: Central Air
  • Heating: Central, Baseboard, Hot Water, Radiant
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Laundry Features: Second Floor
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Shopping, Tennis Court(s), Park, Walk/Jog Trails, Stable(s), Medical Facility, Highway Access, House of Worship, Private School, Public School
  • Senior Community: No

Schools

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

Lot Info

  • LOT SIZE: 95356
  • PAGE: 268
  • Farm Land Area Units: Square Feet
  • Horse Amenities: Paddocks
  • Lot Size Sq Ft: 95396.4
  • Zoning: A

Tax Info

  • Tax Annual Amount: 38883
  • Tax Book Number: 72044
  • Tax Year: 2021

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 8, 2021
Closed on
Nov 10, 2021
Sold by
Cb 353 Llc
Bought by
Lily T
Seller's Agent
Catherine Bassick
Douglas Elliman Real Estate - Park Plaza
Buyer's Agent
Abby Gurall White
LandVest, Inc., Concord
List Price
$4,300,000
Sold Price
$3,900,000
Premium/Discount to List
-$400,000
-9.3%
Current Estimated Value
$3,909,846

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$9,846
Avg. Annual Appreciation
0.01%

Purchase Details

Closed on
Dec 19, 2018
Sold by
Pine Hill Crossing Llc
Bought by
Carmusin Amy S

Purchase Details

Listed on
Mar 25, 2015
Closed on
Jun 16, 2015
Sold by
Foley Kevin C and Flanigan Leah A
Bought by
Cb 353 Llc
Seller's Agent
Brigitte Senkler
Coldwell Banker Realty - Concord
Buyer's Agent
Brigitte Senkler
Coldwell Banker Realty - Concord
List Price
$2,398,000
Sold Price
$2,398,000

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 30, 2004
Sold by
Mahoney Sally Ann and Mahoney Stephen W
Bought by
Foley Kevin C and Flanigan Leah A

Purchase Details

Closed on
Sep 26, 2002
Sold by
Lance Schuyler G and Merwin Linda R
Bought by
Foley Kevin J and Flanigan Leah A

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.25%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Nov 4, 1998
Sold by
Williams J Kress and Williams Lesley C
Bought by
Lance Schuyler G and Merwin Linda R

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 9, 1997
Sold by
Haver Thomas M and Curran-Haver Christine
Bought by
Williams J Kress and Williams Lesley C

Purchase Details

Closed on
Jan 30, 1996
Sold by
Desuze Carlyne N
Bought by
Haver Thomas M and Curran-Haver Christine
Source: Public Records

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
Lily T $3,900,000 None Available
Carmusin Amy S $466,500 --
Cb 353 Llc $2,398,000 --
Foley Kevin C $4,375 --
Foley Kevin J $2,500,000 --
Lance Schuyler G $1,675,000 --
Williams J Kress $889,000 --
Haver Thomas M $825,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lily T $1,875,000
Previous Owner Foley Kevin C $625,000
Previous Owner Foley Kevin C $999,500
Previous Owner Foley Kevin J $1,000,000
Previous Owner Haver Thomas M $625,000
Previous Owner Lance Schuyler G $488,000
Previous Owner Haver Thomas M $488,000
Previous Owner Haver Thomas M $500,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/18/2021 11/18/21 Sold $3,900,000 -9.3% $471 / Sq Ft
10/27/2021 10/27/21 Pending -- -- --
10/08/2021 10/08/21 For Sale $4,300,000 +79.3% $520 / Sq Ft
06/15/2015 06/15/15 Sold $2,398,000 0.0% $319 / Sq Ft
05/11/2015 05/11/15 Pending -- -- --
05/04/2015 05/04/15 Off Market $2,398,000 -- --
03/25/2015 03/25/15 For Sale $2,398,000 -- $319 / 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 $519 $3,911,600 $1,092,200 $2,819,400
2024 $51,359 $3,911,600 $1,092,200 $2,819,400
2023 $40,836 $3,150,900 $893,600 $2,257,300
2022 $36,163 $2,450,100 $714,800 $1,735,300
2021 $38,883 $2,641,500 $714,800 $1,926,700
2020 $39,239 $2,757,500 $714,800 $2,042,700
2019 $40,334 $2,842,400 $745,600 $2,096,800
2018 $574 $2,573,700 $661,100 $1,912,600
2017 $34,832 $2,475,600 $606,300 $1,869,300
2016 $35,238 $2,531,500 $606,300 $1,925,200
2015 -- $2,431,400 $561,400 $1,870,000
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: 72906300

MLS Property Information Network (MLS PIN)

APN: CONC-000008F-000000-001804