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.
***Multiple offers received, sellers are asking for highest and best by 12pm Thursday 7/2
Est. $4,300 per month, based on comparable rentals
Sale and tax history for 152 Old Farms Rd
Sale History
Tax History
Date
Event
Price
Smart MLS #24184390
Aug 10, 2026
Sold
$1,400,000
$269/sq ft
Jul 3, 2026
Pending
—
Jun 19, 2026
Listed
$1,295,000
$249/sq ft
Jun 16, 2026
Coming Soon
$1,295,000
$249/sq ft
Public Records
Aug 6, 2018
Sold
$529,163
$102/sq ft
Smart MLS #170072493
Aug 3, 2018
Sold
$652,000
$125/sq ft
Jun 25, 2018
Contingent
—
May 25, 2018
Relisted
—
May 3, 2018
Contingent
—
Apr 20, 2018
Listed
$875,000
$168/sq ft
Charming Country Estate featuring a Classic Reproduction Colonial setback from quiet road and situated on 20 magnificient acres abutting Land Trust Open Space. Nestled in the vibrant, award-winning town of Simsbury, CT, this is indeed a special find and phenomenal opportunity with so many possibilities. A Relaxing Private Retreat to escape the everyday hubbub, a Horse Property, a Vineyard, a Gardener's Delight - the world is your oyster. This wonderfully inviting 5 Bedroom Home is well proportioned with fine attention to detail. A welcoming Foyer beckons you. A stunning Walk-in Fireplace, Exposed Rafters and Hand-hewn Beams grace the Kitchen. Master Bedroom Suites on both levels are a desirable Multigenerational Option. Beautiful Hardwood Flooring, Spacious 1st Floor Office/Library, Cheery Sunroom, Impressive Attic, & lower level Game Room with separate Workshop are just a few more of the many appealing interior attributes. Outdoors, an ideal blend of open fields and woods, the grounds are absolutely captivating and handsomely distinguished by a Picturesque Pond, Mountain Views, extensive Stonework, Tiered Landscaping, a 4 Car Garage and Large Barn, and a gorgeous Heated Inground Gunite Pool with Cabana that is strategically positioned to savor the breathtaking panorama. A Premier Property for personal delight and entertaining. Convenient to Bradley International Airport and Downtown Hartford, CT/Springfield, MA.
Nearby Amenities: Golf Course, Health Club, Library, Medical Facilities, Park, Playground/Tot Lot, Private School(s), Shopping/Mall
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.
County: Hartford
Public facts
Beds: 4
Baths: 4.0
Sq. Ft.: 5,036
Stories: 2.0
Lot Size: 7.66 acres
Style: Single Family Residential
Year Built: 2018
Year Renovated: —
County: Hartford County
APN: 702478
Home facts updated by county records on Jul 30, 2026
Other
Documents & Disclosures
Supplement Count Public: 5
Around this home
Schools
Squadron Line School
Public PreK-6 • Assigned • 2.2mi
9/10
Henry James Memorial School
Public 7-8 • Assigned • 1.7mi
8/10
Simsbury High School
Public 9-12 • Assigned • 1.8mi
10/10
Provided by GreatSchools
Historical weather
Simsbury, CT • 06070
Average low and high temperatures (°F)
34
18
36
19
53
31
63
41
70
50
81
60
86
67
81
59
76
55
66
44
53
36
38
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
90/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.7 hrs
5.8 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.27M – $1.53M
Reach more buyers when you sell with Redfin. Plus, you'll save $13,329 in fees.