152 Old Farms Rd

Simsbury, CT 06070

$1,295,000
Price
4
Beds
5,200 Sq. Ft.
$249 / Sq. Ft.
5,200
Sq. Ft.
$249
per Sq. Ft.
Get preapproved with Rocket Mortgage1
Coming Soon
Coming Soon
Detached 4 car garage with heat and electricity
Resort style pool area ideal for entertaining with fully finished pool house with kitchenette and full bathroom
Inviting foyer leading into a private study
Beautifully updating kitchen with brand new appliances, double wall oven, pot filler, and beverage refrigerator.
walk-in pantry to the right and additional pantry space to the left
A spacious living room is located off the kitchen with access to the study and mudroom
An exceptionally beautiful and cozy family room with wood burning stove ideal for game nights
Family room has access out to a charming covered porch
A private study with views of the expansive and private front yard
one of two powder rooms- centrally located on the main floor
convenient second floor laundry room
The spacious primary suite features a large walk-in closet, dressing area, and private bath
Primary bathroom features a double vanity and private water closet for the toilet and shower
Each spacious bedroom features a walk-in closet
Hall Bathroom with double vanity and water closet for the toilet and shower for privacy
ensuite bedroom with walk-in closet and a spacious bath
ensuite bath
An incredible mudroom is located off the garage with a powder room and two large closets for ample storage
An incredible rec room is located above the garage with potential to add a full bathroom allowing flexibility as a future in-law or guest suite.
A charming covered porch overlooks the pool and backyard
The pool features a fully finished pool house
Pool house includes a kitchenette, hang out space, and full bathroom
Pool house bathroom with shower

Description

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...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.
  1. Listed by Kim Netto • Tea Leaf Realty
    P: (860)-978-6053 C: (860)-978-6053 Kim@tealeafrealty.com

Property Details for 152 Old Farms Road

Basement Description
Full
Direct Waterfront
No
Expected Active Date
06-19-2026
Garages Number
7
Neighborhood
N/A
Style
Colonial
Garage Parking Info
Attached Garage, Detached Garage
Swimming Pool
Yes
LISTING UPDATED: 06/17/2026 06:16 PM

Property Details for 152 Old Farms Road

StatusComing Soon
MLS #24184390
Days on Market-
Taxes$22,922 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential
Year Built2018
Lot Size7.66 AC / 333,669 SF
CountyHartford County
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of Tea Leaf Realty, Kim Netto
Add your commute

Building Information for 152 Old Farms Road

Stories-Year Built2018Building Size-Lot Size7.66 AC / 333,669 SF

Payment Calculator

Get preapproved with Rocket Mortgage1

$8,363 per month

30 year fixed, 6.36% Interest

Principal and Interest

$6,453

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

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
Virtual Tour
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 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/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 Record2024$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 Built2018ZoningR-80CountyCAPITOLAPNSIMS M:C07 B:303 L:10Fireplace TypeHas Fireplace

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

Explore Nearby Homes

More information about 152 Old Farms Road, Simsbury, CT 06070

152 Old Farms Road is a single family home Coming Soon in Simsbury, CT 06070. This property is currently priced at $1,295,000. This listing's school district is Simsbury School District. Nearby schools include Squadron Line School, Henry James Memorial School and Simsbury High School. 152 Old Farms Road is a 4-bed, 5-bath, 5,200 sqft single family home built in 2018.

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.