Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,295,000 Coming Soon

  • For Sale
  • Coming Soon
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 2 Partial Baths
  • 5,200 Sq. Ft.
  • 7 Car Garage
  • Updated 1 day ago
See This Home
Save This Home
See This Home
Save This Home
Set on over 7 peaceful acres, this exceptional 2019 custom-built estate 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. 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 bedroom 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.

Full Property Details for 152 Old Farms Rd

General

  • Price: $1,295,000
  • Taxes: (July 2025-June 2026)
  • Status: Coming Soon
  • Type: Single Family
  • Source: SMARTMLS
  • MLS ID: 24184390
  • Updated: 6/16/2026
  • Added to Site: 1 day(s) ago
  • Expected Market Date: 6/19/2026

Interior

  • Number of Rooms: 10
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Appliances: Oven/Range, Wall Oven, Microwave, Refrigerator, Dishwasher, Washer, Dryer

Rooms

Bathrooms

  • Total Bathrooms: 5
  • Full Bathrooms: 3
  • Half Bathrooms: 2

Bedrooms

  • Total Bedrooms: 4
  • Primary Bedroom: Primary Bedroom, Upper
  • Bedroom 1: Bedroom, Upper
  • Bedroom 2: Bedroom, Upper
  • Bedroom 3: Bedroom, Upper

Other Rooms

  • Living Room: Living Room, Main
  • Dining Room: Dining Room, Main
  • Laundry: Upper Level

Additional Information

  • Pool: Yes
  • Pool Description: Pool House, In Ground Pool

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 7
  • Parking: Attached Garage, Detached Garage

Location

  • County: Hartford
  • Driving 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.

School Information

  • Elementary School: Per Board of Ed
  • High School: Per Board of Ed

Heating & Cooling

  • Cooling Type: Central Air
  • Heating Type: Hot Air, Propane, Solar, Wood
  • Heating Fuel: Propane, Solar, Wood
  • Water Heater: Tankless Hotwater

Utilities

  • Sewer: Septic
  • Water: Private Well

Structural Information

  • Architectural Style: Colonial
  • Construction Status: No/Resale
  • Exterior Const.: Vinyl Siding
  • Basement Desc.: Full
  • Roof: Asphalt Shingle
  • Attic: Yes
  • Square Feet: 5,200
  • Above Ground: 5,200 Sq. Ft.
  • Year Built: 2018

Lot Features

  • Lot Size (Acres): 7.66
  • Zoning: R-80
  • Lot Description: Lightly Wooded, Level Lot

Green Features

  • Energy Features: Active Solar, Generator

Financial Considerations

  • Assessment Amount: $671,010
  • Tax Year: July 2025-June 2026

Disclosures and Reports

  • Property ID: 702478

Listed by Tea Leaf Realty, Kim Netto

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 152 Old Farms Rd —

  • Kim Netto

    Tea Leaf Realty

Agent Contact: (860) 978-6053 Office Contact: (860) 796-4555

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 152 Old Farms Rd

School District:Simsbury School District
NameGradesDistance
Squadron Line School
44 Squadron Line Road, Simsbury, CT 06070
PK-62.2 mi
Henry James Memorial School
155 Firetown Road, Simsbury, CT 06070
7-81.7 mi
Simsbury High School
34 Farms Village Road, Simsbury, CT 06070
9-121.9 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 152 Old Farms Rd Get Price Alerts and Save Property

Date
Details
Price
Change
Source
6/16/2026
Listed
$1,295,000
144.73%
MLS
8/02/2018
Sold
$529,163
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 152 Old Farms Rd

Year
Property Taxes
Change
Tax Assessment
Change
2025
$22,922
4%
$671,010
2%
2023
$21,958
5%
$659,190
—
2023
$20,975
—
$659,190
21%
2022
$21,004
—
$543,730
5%
2021
$20,946
31%
$518,790
20%
2020
$15,987
168%
$431,040
170%
2019
$5,966
-53%
$159,870
-52%
2018
$12,570
-1%
$334,400
2%
2017
$12,710
4%
$327,910
—
2016
$12,172
3%
$327,910
3%
2015
$11,775
—
$317,220
—
2014
$11,782
-4%
$317,220
—
2011
$12,216
—
$317,220
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 152 Old Farms Rd

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Tea Leaf Realty, Kim Netto

Similar Properties near 152 Old Farms Rd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

207 Great Pond Rd, Simsbury, CT 06070 - Photo 1
$1,150,000

207 Great Pond Rd  Simsbury, CT 06070

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 5
    Total Baths
  • 5,192
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
15 Old Orchard Rd, Granby, CT 06090 - Photo 1
$1,125,000

15 Old Orchard Rd  Granby, CT 06090

  • Single Family
  • Active
  • Updated 10 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 4,388
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
41 Ridgebury Rd, Avon, CT 06001 - Photo 1 Just Listed
$1,495,000

41 Ridgebury Rd  Avon, CT 06001

  • Single Family
  • Active
  • Updated 5 days ago
  • 5
    Beds
  • 7
    Total Baths
  • 7,716
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
9 Brian Ln, Avon, CT 06001 - Photo 1
$1,200,000

9 Brian Ln  Avon, CT 06001

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 6
    Total Baths
  • 5,798
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.

Just Listed near 152 Old Farms Rd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2 Thistle Hollow, Avon, CT 06001 - Photo 1 Just Listed
$799,900

2 Thistle Hollow  #2  Avon, CT 06001

  • Townhouse
  • Active
  • Updated 10 hours ago
  • 3
    Beds
  • 4
    Total Baths
  • 3,264
    Sq. Ft.
Listed by The Steffen Reich Team (860) 674-0300 and Najwah Nakad (347) 290-6374
8 Sepous Rd, Avon, CT 06001 - Photo 1 Just Listed
$349,000

8 Sepous Rd  Avon, CT 06001

  • Single Family
  • Active
  • Updated 14 hours ago
  • 2
    Beds
  • 1
    Total Bath
  • 1,200
    Sq. Ft.
Listed by Rockoff Realty
124 Hollister Dr, Avon, CT 06001 - Photo 1 Just Listed
$249,000

124 Hollister Dr  Avon, CT 06001

  • Land Residential
  • Active
  • Updated 1 hour ago
  • 3.22
    Acres
Listed by eXp Realty
25 Breezy Knoll, Avon, CT 06001 - Photo 1 Just Listed
$1,500,000

25 Breezy Knoll  Avon, CT 06001

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,669
    Sq. Ft.
Listed by RE/MAX Prime Realty

Price Reduced near 152 Old Farms Rd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

83 Bayberry Hill Rd, Avon, CT 06001 - Photo 1 Price Reduced
-$70,000 (-3.56%)
$1,895,000

83 Bayberry Hill Rd  Avon, CT 06001

  • Single Family
  • Active
  • Updated 5 days ago
  • 6
    Beds
  • 8
    Total Baths
  • 8,798
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
14 Vermillion Dr, Avon, CT 06001 - Photo 1 Price Reduced
-$1,000 (-0.06%)
$1,599,000
Open House

14 Vermillion Dr  Avon, CT 06001

  • Single Family
  • Active
  • Updated 1 day ago
  • 7
    Beds
  • 5
    Total Baths
  • 6,144
    Sq. Ft.
Listed by Derek Greene
17 Briar Hill Rd, Avon, CT 06001 - Photo 1 Price Reduced
-$20,000 (-2.37%)
$824,900
Open House

17 Briar Hill Rd  Avon, CT 06001

  • Single Family
  • Active
  • Updated 11 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,218
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
6 Spyglass Dr, Avon, CT 06001 - Photo 1 Price Reduced
-$20,000 (-3.7%)
$519,900

6 Spyglass Dr  #6  Avon, CT 06001

  • Townhouse
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,476
    Sq. Ft.
Listed by Singh Realty

Recent Sales near 152 Old Farms Rd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

12 The Glade, Simsbury, CT 06070 - Photo 1 Sold
$1,330,000

12 The Glade  Simsbury, CT 06070

  • Single Family
  • Closed
  • Updated 6 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 4,381
    Sq. Ft.
Listed by Melissa Carman
Sold by Berkshire Hathaway NE Prop.
7 School House Ln, Simsbury, CT 06070 - Photo 1 Sold
$1,208,000

7 School House Ln  Simsbury, CT 06070

  • Single Family
  • Closed
  • 5
    Beds
  • 5
    Total Baths
  • 4,344
    Sq. Ft.
Listed by Katie French
Sold by Berkshire Hathaway NE Prop.
2 Murphys Turn, Simsbury, CT 06070 - Photo 1 Sold
$1,300,000

2 Murphys Turn  Simsbury, CT 06070

  • Single Family
  • Closed
  • Updated 13 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 4,218
    Sq. Ft.
Listed by Starr Team at LPT Realty
Sold by Sally Albrecht
17 Stillwood Chase, Simsbury, CT 06089 - Photo 1 Sold
$1,104,000

17 Stillwood Chase  Simsbury, CT 06089

  • Single Family
  • Closed
  • Updated 8 hours ago
  • 4
    Beds
  • 4
    Total Baths
  • 4,960
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
Sold by William Raveis Real Estate

152 Old Farms Road, Simsbury, CT 06070 (MLS# 24184390) is a Single Family property with 4 bedrooms, 3 full bathrooms and 2 partial bathrooms. 152 Old Farms Road is currently listed for $1,295,000 and was received on June 16, 2026. Want to learn more about 152 Old Farms Road? Do you have questions about finding other Single Family real estate for sale in Simsbury? You can browse all Simsbury real estate or contact a Coldwell Banker agent to request more information.

Tour this property