David Brewster
Berkshire Hathaway NE Prop.
(224) 479-1612
40 Total Sales
1 in Greenfield Hill
$1,640,000 Price
Welcome to an unrivaled sanctuary of sophistication at 342 Midlock Road, gracefully situated in the prestigious enclave of Greenfield Hill. This stately residence, perched on a coveted cul-de-sac off Burr Street, unfurls over two lush acres of meticulously manicured, fully fenced grounds. Upon entry, be enveloped in luxury as you traverse through spaces adorned with custom millwork, nine ft ceilings, abundant natural light and more. The heart of this home is an eat-in chef's kitchen, replete with top-tier stainless steel appliances, which connects you to multiple other spaces for enjoyment or repose. Entertain with panache in the formal dining room, garden room, library, living room or great room. Five fireplaces spread across this generous layout hosting five bedrooms- all ensuite- plus additional oversized office/media room with kitchenette, as well as third floor rec room with attached full bath and access to boutique-style cedar closet. Outdoors, a resplendent oasis awaits, featuring a pristine gunite with pebble sheen pool, granite heat resistant patio and an exquisite pool house with kitchenette and full bath, and expansive stone outdoor kitchen- a sublime setting for al fresco gatherings. A lifestyle of unparalleled elegance and comfort is a given. Every detail of this meticulously maintained home harmonizes to create an estate that epitomizes refined living. This majestic manor reflects pride in ownership and a timelessness that commands to be experienced.
Last Agent to Sell the Property
Compass Connecticut, LLC Brokerage Phone: (203) 218-0604 License #RES.0808123 Listed on: 10/21/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
David Brewster
Berkshire Hathaway NE Prop.
(224) 479-1612
40 Total Sales
1 in Greenfield Hill
$1,640,000 Price
David Hilliker
William Raveis Real Estate
(844) 977-3149
10 Total Sales
1 in Greenfield Hill
$970,000 Price
Brittany Strouse
Coldwell Banker Realty
(475) 250-1518
10 Total Sales
1 in Greenfield Hill
$2,300,000 Price
Jennifer Runnette
Brown Harris Stevens
(351) 999-8461
33 Total Sales
1 in Greenfield Hill
$2,070,000 Price
Richard Higgins
Higgins Group Bedford Square
(855) 923-4476
19 Total Sales
2 in Greenfield Hill
$1.5M - $3.6M Price Range
Pam Toner
Berkshire Hathaway NE Prop.
(973) 604-2163
25 Total Sales
1 in Greenfield Hill
$1,625,000 Price
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $2,225,000 | -- | |
| Warranty Deed | $1,525,000 | -- |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 07/31/2026 07/31/26 | Sold | $2,750,000 | -1.8% | $378 / Sq Ft |
| 04/22/2026 04/22/26 | Pending | -- | -- | -- |
| 04/22/2026 04/22/26 | For Sale | $2,799,999 | +1.8% | $385 / Sq Ft |
| 12/16/2025 12/16/25 | Off Market | $2,750,000 | -- | -- |
| 10/25/2025 10/25/25 | For Sale | $2,799,999 | -- | $385 / Sq Ft |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $37,387 | $1,316,910 | $268,800 | $1,048,110 |
| 2024 | $36,742 | $1,316,910 | $268,800 | $1,048,110 |
| 2023 | $36,228 | $1,316,910 | $268,800 | $1,048,110 |
| 2022 | $35,873 | $1,316,910 | $268,800 | $1,048,110 |
| 2021 | $35,530 | $1,316,910 | $268,800 | $1,048,110 |
| 2020 | $38,571 | $1,439,760 | $258,930 | $1,180,830 |
| 2019 | $38,571 | $1,439,760 | $258,930 | $1,180,830 |
| 2018 | $37,952 | $1,439,760 | $258,930 | $1,180,830 |
| 2017 | $37,175 | $1,439,760 | $258,930 | $1,180,830 |
| 2016 | $36,642 | $1,439,760 | $258,930 | $1,180,830 |
| 2015 | $39,315 | $1,585,920 | $303,590 | $1,282,330 |
| 2014 | $38,696 | $1,585,920 | $303,590 | $1,282,330 |
Seller's Agent in 2026
AJ Letterman
Compass Connecticut, LLC
(203) 218-0604
1 in this area
43 Total Sales
Buyer's Agent in 2026
Lori Auerbach
Coldwell Banker Realty
(646) 734-3514
5 in this area
37 Total Sales
Buyer Co-Listing Agent in 2026
Anne Frewen
Coldwell Banker Realty
(484) 678-9061
5 in this area
32 Total Sales
Source: SmartMLS
MLS Number: 24134949
APN: FAIR-000155-000000-000019-F000000
Ask me questions while you tour the home.