152 Old Farms Road
Simsbury, Connecticut 06070
- Beds
- 4
- Baths
- 3 | 2
- SqFt
- 5,200
- Acres
- 7.66
- Year Built
- 2018
- Property Type
- Single Family

Matt Caiola
Luxury Real Estate Advisor
Request a private showing and get Matt's read on price, condition, and next steps.
About This Home
Set on over 7 peaceful acres, this exceptional 2019 custom-build blends luxury, efficiency, and thoughtful design. The expansive kitchen features custom cabinetry and new (2025) appliances, flowing into beautifully appointed living spaces and a welcoming family room with a wood-burning stove, which can be used formal dining. A private study offers the perfect work-from-home retreat. Upstairs, the primary suite includes a spacious walk-in closet, double vanity bath, and private dressing area. An ensuite guest room features its own walk-in closet and full bath, while two additional bedrooms with oversized closets share a full bath. A second-floor laundry room adds convenience. Additional highlights include a large finished rec room over the garage, ideal for a media room, guest space, or potential in-law suite, plus an oversized mudroom with a farmhouse sink. The fully waterproofed basement with comprehensive drainage systems provides lasting peace of mind. Outside, enjoy a resort-style setting with a 40x20 heated pool, expansive stamped concrete patio, and a fully finished pool house complete with a kitchen and full bath-perfect for entertaining or extended outdoor living. Car collectors, hobbyists, and outdoor enthusiasts will appreciate the oversized heated garage, while owned solar panels and a whole-house generator provide efficiency and reliability. Offering privacy, craftsmanship, and exceptional amenities, this remarkable property delivers a truly elevated lifestyle.
Key Facts
- City/Town
- Simsbury
- Neighborhood
- N/A
- Property / Style
- Single Family · Colonial
- Year Built
- 2018
- Days on Market
- 42 days
- Beds
- 4
- Baths
- 3 full · 2 half
- Living Area
- 5,200 sq ft
- Lot Size
- 7.66 acres
- Garage / Parking
- 7 garage
- Property Taxes
- $22,922 / Annually
Market Snapshot
The Simsbury Market
Single Family · trailing 12 months
Active Listings
17
55 under contract
Median List Price
$710,000
17 active listings
Median Closed Price
$577,500
250 sales
Median Days on Market
31
17 active listings
Median $ / Sq Ft
$220
17 active listings
Sale-to-List Ratio
107.2%
250 sales
How this home compares
List Price
$1.29M
vs $710,000 median
82.4% above median
Price / Sq Ft
$249
vs $220 median
13.2% above median
Days on Market
42 days
vs 31 days median
11 days longer than median
Based on 17 active and 250 closed sales (trailing 12 mo) of single family in Simsbury. Source: SmartMLS · As of July 28, 2026.
Location
152 Old Farms Road, Simsbury, Connecticut
Estimate Your Payment
Estimated Monthly Payment
Rates: Freddie Mac PMMS via FRED · Updated Jul 23, 2026per month
- Principal & Interest$6,603
- Property Taxes$1,910
- Insurance$432
- HOA$0
Estimates only. Actual rates, taxes, insurance, and HOA fees vary. Consult a lender for current rates.
Location
- City/Town
- Simsbury
- Neighborhood
- N/A
- County
- Hartford
Residence
- Property Type
- Single Family
- Style
- Colonial
- Year Built
- 2018
- New Construction
- No/Resale
- Living Area
- 5,200 sq ft
Schools
- Elementary
- Per Board of Ed
- High
- Per Board of Ed
Interior
- Heating
- Hot Air
- Heat Fuel
- PropaneSolarWood
- Cooling
- Central Air
- Fireplaces
- 1
- Laundry
- Upper Level
- Appliances
- Oven/RangeWall OvenMicrowaveRefrigeratorDishwasherWasherDryer
- Basement
- Full
- In-Law Apartment
- PossibleOver Garage
Exterior & Lot
- Lot Size
- 7.66 acres
- Zoning
- R-80
- Garage / Parking
- 7 garage spacesAttached GarageDetached Garage
- Waterfront Details
- Not Applicable
- Water Source
- Private Well
- Sewer
- Septic
- Pool
- Pool HouseIn Ground Pool
- Construction
- Vinyl Siding
- Roof
- Asphalt Shingle
- Foundation
- Concrete
- Lot Description
- Lightly WoodedLevel Lot
Listing & Financials
- Property Taxes
- $22,922 / Annually
- Days on Market
- 42
- MLS #
- 24184390
- MLS Status
- Under Contract
Similar Properties
Homes with a close match in area, property type, and price.
This information is believed to be accurate, but without warranty.
The IDX display contains information sourced from SmartMLS, Inc. as of 7/28/2026. This information is provided for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing or leasing. Data is deemed reliable but is not guaranteed accurate by the MLS, the listing broker, the listing agent, or Matt Caiola. Buyers and tenants should independently verify all information that matters to their decision.
Map locations may be approximate. Any offer of compensation, if applicable, is made only to participants of the MLS where the listing is filed. ©2026 Smart MLS, Inc. All rights reserved.
Data last updated on 7/28/2026 at 7:01 AM UTC.