152 Old Farms Road

Closed 8/10/26
Closed 8/10/26
Gallery Image 1
Sold
Last Sold Price
$1,400,000
4 beds5,200 sqft$269/sqft
152 Old Farms Rd, Simsbury, CT 06070
Single FamilyProperty Type
7.66 acresLot Size
2018Year Built
$269/sq ftPrice per sq ft
7 carsParking Spaces

Description

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...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.
  • Listed by: Kim Netto 860.978.6053 Kim@tealeafrealty.com • Tea Leaf Realty
Listing closed: 08/10/2026 12:00 AM • Source: SMARTMLS, MLS#: 24184390
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of Tea Leaf Realty, Kim Netto

Sold By William Pitt Sotheby's Int'l, Tom Carroll

Add your commute

Payment Calculator

Get preapproved with Rocket Mortgage1

$9,145 per month

30 year fixed, 6.71% Interest

Principal and Interest

$7,235

Property Taxes

$1,910

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 152 Old Farms Road

Property Details
  • Taxes: $22,922 / year
  • MLS Type: Residential
  • County: Hartford County
  • Basement Description: Full
  • Direct Waterfront: No
  • Expected Active Date: 06-19-2026
  • Garages Number: 7
  • Style: Colonial
  • Garage Parking Info: Attached Garage, Detached Garage
  • Swimming Pool: Yes
  • Expected On Market Date: 06-19-2026
Building Information
  • Year Built: 2018
  • Lot Size: 7.66 AC / 333,669 SF
Summary
Property and Location
  • Acres Source: Public Records
  • Directions: route 10 to Hoskins Rd to County Rd to Holcomb St to Old Farms Rd, property on the left, long private driveway, house set back from the road.
  • Elementary School: Per Board of Ed
  • High School: Per Board of Ed
  • Latitude: 41.890689
  • Longitude: -72.845754
  • Neighborhood Amenities: Golf Course, Health Club, Library, Medical Facilities, Park, Playground/Tot Lot, Private School(s), Shopping/Mall
  • State: Connecticut
HOA and Fees
  • Home Owner's Assocation: No
  • Tax Year: July 2025-June 2026
  • Property Tax: $22,922
Interior and Exterior Features
Exterior Features
  • Pool Description: Pool House, In Ground Pool
  • Waterfront Description: Not Applicable
Interior Features
  • Appliances Included: Oven/Range, Wall Oven, Microwave, Refrigerator, Dishwasher, Washer, Dryer
  • Attic Description: Pull-Down Stairs
  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Attic YN: Yes
  • Fireplaces Total: 1
  • Laundry Room Info: Upper Level
  • Rooms Total: 10
Room 1
  • Room Entry Order: 1
  • Room Level: Main
  • Room Type: Living Room
Room 2
  • Room Entry Order: 2
  • Room Level: Main
  • Room Type: Dining Room
Room 3
  • Room Entry Order: 3
  • Room Level: Upper
  • Room Type: Primary Bedroom
Room 4
  • Room Entry Order: 4
  • Room Level: Upper
  • Room Type: Bedroom
Room 5
  • Listing Key: 545E666F15305167E063E201100A32D7
  • Room Entry Order: 5
  • Room Level: Upper
  • Room Type: Bedroom
Room 6
  • Room Entry Order: 6
  • Room Level: Upper
  • Room Type: Bedroom
Property
Property and Assessments
  • Construction Description: Frame
  • Exterior Siding: Vinyl Siding
  • Foundation Type: Concrete
  • Fuel Tank Location: In Ground
  • New Construction Type: No/Resale
  • Roof: Asphalt Shingle
  • Year Built: 2018
  • Year Built Source: Public Records
  • Bank Owned Property: No
  • In Law Access: Over Garage
  • In Law Apartment: Possible
  • Sq Ft Description: footprint
  • Living Area SQFT Per Public Records: 5036
Lot Information
  • Lot Description: Lightly Wooded, Level Lot
  • Parcel Number: 702478
  • Sq Ft Est Heated Above Grade: 5200.0
  • Sq Ft Total: 5200.0
  • Zoning: R-80
Utilities
  • Energy Features: Active Solar, Generator
  • Heat Fuel Type: Propane, Solar, Wood
  • Hot Water Description: Tankless Hotwater
  • Sewage System: Septic
  • Water Source: Private Well
Multi Family
Income and Expenses
  • Occupied By: Owner

Property History for 152 Old Farms Road

DateEvent & SourcePriceAppreciation
Aug 6, 2026

Closed (Public Record)

Public Record #1947602494

$1,400,000

+12.9% / yr

Aug 2, 2018

Closed (Public Record)

Public Record #629111011

$529,163

+272.9% / yr

Jul 28, 2008

Closed (Public Record)

Public Record #327097172

$1—
DateEvent & SourcePrice
08/06/2026

Closed (Public Record)

Public Record #1947602494

$1,400,000

+12.9% / yr

08/02/2018

Closed (Public Record)

Public Record #629111011

$529,163

+272.9% / yr

07/28/2008

Closed (Public Record)

Public Record #327097172

$1

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 152 Old Farms Road

Taxable ValueLand$104,140Additions$566,870Total$671,010
Tax Record2025$22,922 ($1,910 / month)
Home Facts
Beds4Baths4Total Finished SqFt5,036 SqFtAbove Grade Finished SqFt5,036 SqFtUnfinished Basement SqFt1,716 SqFtStories2Lot Size333,670 SqFtStyleSingle Family ResidenceYear Built2018Year Renovated2018ZoningR-80CountyCAPITOLAPNSIMS M:C07 B:303 L:10

Schools near 152 Old Farms Road

This home is within Simsbury School District.
Rating
School
Type
Grades
Distance
Squadron Line School
Public - PK to 6
Henry James Memorial School
Public - 7 to 8
Simsbury High School
Public - 9 to 12
The Master's School
Private - PK to 12
Rating
School
Distance
Squadron Line School
PublicPK to 6

Henry James Memorial School
Public7 to 8

Simsbury High School
Public9 to 12

The Master's School
PrivatePK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 06070

$634,900 | 39 Laurel Lane, Simsbury, CT 06070
1/39
Open: 9/12 01:30PM - 03:30PMNew

$634,900

4
Bedrooms
2,532
Square Feet
2.31
Acres

39 Laurel Lane, Simsbury, CT 06070

$589,900 | 23 Berkshire Way, Simsbury, CT 06070
1/38
Listed By Coldwell Banker RealtyOpen: 9/12 01:00PM - 03:00PM

$589,900

4
Bedrooms
2,212
Square Feet
0.78
Acres

23 Berkshire Way, Simsbury, CT 06070

$699,000 | 24 Canaan Way, Simsbury, CT 06070
1/39
Open: 9/13 01:00PM - 03:00PM

$699,000

4
Bedrooms
2,267
Square Feet
0.92
Acres

24 Canaan Way, Simsbury, CT 06070

$315,000 | 39 Old Mill Court, Unit 39, Simsbury, CT 06070
1/40
Open: 9/12 02:00PM - 03:00PM

$315,000

2
Bedrooms
1,781
Square Feet

39 Old Mill Court, Unit 39, Simsbury, CT 06070

$579,900 | 160 Nod Road, Simsbury, CT 06070
1/40
Listed By Coldwell Banker Realty

$579,900

4
Bedrooms
1,960
Square Feet
0.58
Acres

160 Nod Road, Simsbury, CT 06070

$549,900 | 2 Cambridge Court, Simsbury, CT 06070
1/13
Open: 9/12 02:00PM - 04:00PM

$549,900

3
Bedrooms
1,480
Square Feet
0.15
Acres

2 Cambridge Court, Simsbury, CT 06070

$524,900 | 16 Cambridge Court, Simsbury, CT 06070
1/18
Open: 9/12 02:00PM - 04:00PM

$524,900

3
Bedrooms
1,450
Square Feet
0.15
Acres

16 Cambridge Court, Simsbury, CT 06070

$599,900 | 21 Musket Trail, Simsbury, CT 06070
1/33

$599,900

4
Bedrooms
2,740
Square Feet
0.7
Acres

21 Musket Trail, Simsbury, CT 06070

$239,999 | 129 Library Lane, Unit 129, Simsbury, CT 06070
1/18
Open: 9/12 12:00PM - 02:00PM

$239,999

2
Bedrooms
1,344
Square Feet

129 Library Lane, Unit 129, Simsbury, CT 06070

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 152 Old Farms Road, Simsbury, CT 06070
$1,400,000
4
5,200
333,669
147 Old Farms Road, Simsbury, CT 06092
$300,000
2
1,309
87,120
144 Old Farms Road, Simsbury, CT 06070
$50,000
–
–
–
108,029
162 Old Farms Road, Simsbury, CT 06070
$610,000
4
3,431
130,680
2 Joshua Drive, Simsbury, CT 06070
$760,000
5
5,012
87,120
18 Joshua Drive, Simsbury, CT 06092
$800,000
5
4,588
87,120

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Tea Leaf Realty, Kim Netto

Based on information from one of the following Multiple Listing Services: Darien MLS, Smart MLS and Greenwich Multiple Listing Service. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Darien MLS, Smart MLS and Greenwich Multiple Listing Service is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.