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,307 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
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 Sep 3, 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
85
65
81
59
77
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
This home receives average direct sun exposure in Simsbury. 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.31M – $1.59M
Reach more buyers when you sell with Redfin. Plus, you'll save $13,806 in fees.