Last Sold Price
4 beds2,943 sqft$256/sqft
247 Old Farms Rd, Simsbury, CT 06070

Description

This beautiful custom-built 4-bedroom, 3.5-bath Colonial is nestled on 3.44 private acres and offers over 3,700 sq ft of living space. A gracious two-story foyer welcomes you into a private office with built-ins and glass French doors, and a front-to-back living/dining room. The chef's kitchen spans the back of the home with stainless appliances, double ovens, 5-burner gas range, pantry, breakfast bar, and eat-in dining, opening to a spacious family room highlighted by a dramatic 2-story stone fireplace...This beautiful custom-built 4-bedroom, 3.5-bath Colonial is nestled on 3.44 private acres and offers over 3,700 sq ft of living space. A gracious two-story foyer welcomes you into a private office with built-ins and glass French doors, and a front-to-back living/dining room. The chef's kitchen spans the back of the home with stainless appliances, double ovens, 5-burner gas range, pantry, breakfast bar, and eat-in dining, opening to a spacious family room highlighted by a dramatic 2-story stone fireplace and second staircase. Upstairs, the primary suite features a tray ceiling, custom walk-in closet, and spa-style bath with whirlpool, shower, and dual vanities. Three additional bedrooms, a full bath, laundry, and an unfinished bonus room over the 3-car garage provide flexibility. The finished walk-out lower level with full bath, laundry, and kitchenette is ideal for guests, in-laws, or a teen suite. Additional highlights include central air, hardwood floors, 9' ceilings, central vac, and security system. Located in a classic New England town with shops, restaurants, and endless outdoor recreation-near McLean Game Refuge, Rails-to-Trails, Simsbury Farms, and Simsbury Meadows. Convenient to Routes 10 & 202, Hartford, Bradley Airport, and midway between Boston & NYC.
LISTING CLOSED: 01/30/2026 12:00 AM

  1. Listed by Jessica C Starr • LPT Realty
    P: (860)-690-0679 C: (860)-690-0679 Jessica@StarrTeam.com

Property Details for 247 Old Farms Road

Status
MLS #
24127298
Days on Market
86
Taxes
$13,986 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential
Year Built
1999
Lot Size
3.44 AC / 149,846 SF
Basement Description
Full, Garage Access, Full With Walk-Out
Direct Waterfront
No
Expected Active Date
09-25-2025
Garages Number
3
Neighborhood
N/A
Style
Colonial
Garage Parking Info
Attached Garage
Swimming Pool
No
Expected On Market Date
09-25-2025

Location

Add your commute

Building Information for 247 Old Farms Road

Stories-Year Built1999Building Size-Lot Size3.44 AC / 149,846 SF

Payment Calculator

$4,988 per month

30 year fixed, 6.55% Interest

Principal and Interest

$3,822

Property Taxes

$1,166

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 247 Old Farms Road

Summary
Property and Location
  • Acres Source: Public Records
  • Directions: GPS
  • Elementary School: Squadron Line
  • High School: Simsbury
  • Latitude: 41.903101
  • Longitude: -72.846547
  • State: Connecticut
HOA and Fees
  • Home Owner's Assocation: No
  • Tax Year: July 2025-June 2026
  • Property Tax: $13,986
Interior and Exterior Features
Exterior Features
  • Exterior Features: Deck
  • Waterfront Description: Not Applicable
Interior Features
  • Appliances Included: Oven/Range, Microwave, Range Hood, Refrigerator, Dishwasher, Disposal, Washer, Electric Dryer
  • Attic Description: Storage Space, Pull-Down Stairs
  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Attic YN: Yes
  • Fireplaces Total: 2
  • Interior Features: Auto Garage Door Opener
  • Rooms Total: 9
Room 1
  • Room Entry Order: 1
  • Room Level: Lower
  • Room Type: Living Room
Room 2
  • Room Entry Order: 2
  • Room Level: Lower
  • 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: 3F01481B38216FCCE0631A01100A44DD
  • 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: Wood
  • Foundation Type: Concrete
  • Fuel Tank Location: Above Ground
  • New Construction Type: No/Resale
  • Roof: Asphalt Shingle
  • Year Built: 1999
  • Year Built Source: Public Records
  • Bank Owned Property: No
  • Living Area SQFT Per Public Records: 2943
Lot Information
  • Lot Description: Secluded, Lightly Wooded
  • Parcel Number: 2147402
  • Sq Ft Est Heated Above Grade: 2943.0
  • Sq Ft Total: 2943.0
  • Zoning: R-80
Utilities
  • Heat Fuel Type: Oil
  • Hot Water Description: Other
  • Sewage System: Septic
  • Water Source: Public Water Connected
Multi Family
Income and Expenses
  • Occupied By: Owner

Property History for 247 Old Farms Road

DateEvent & SourcePriceAppreciation
Jan 30, 2026

Closed (Public Record)

Public Record #1928799413

$752,000

+6.4% / yr

Sep 21, 2022

Closed (Public Record)

Public Record #1498544236

$610,000

+0.1% / yr

Mar 12, 2007

Closed (Public Record)

Public Record #216829869

$604,000
DateEvent & SourcePrice
01/30/2026

Closed (Public Record)

Public Record #1928799413

$752,000

+6.4% / yr

09/21/2022

Closed (Public Record)

Public Record #1498544236

$610,000

+0.1% / yr

03/12/2007

Closed (Public Record)

Public Record #216829869

$604,000

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

Public Records for 247 Old Farms Road

Taxable ValueLand$91,700Additions$317,730Total$409,430
Tax Record2025$13,986 ($1,166 / month)
Home Facts
Beds4Baths3.5Total Finished SqFt2,943 SqFtAbove Grade Finished SqFt2,943 SqFtUnfinished Basement SqFt618 SqFtStories2Lot Size149,846 SqFtStyleSingle Family ResidenceYear Built1999Year Renovated2007ZoningR-80CountyCAPITOLAPNSIMS M:C05 B:203 L:5

Schools near 247 Old Farms Road

This home is within Simsbury School District.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 7 to 8
Public - 9 to 12
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

$724,900 | 100 Cambridge Court, Simsbury, CT 06070
1/12
New

$724,900

3
Bedrooms
2,240
Square Feet
0.25
Acres
$249,000 | 38 Library Lane, Unit 38, Simsbury, CT 06070
1/17

$249,000

2
Bedrooms
1,100
Square Feet
$599,999 | 18 Cambridge Court, Simsbury, CT 06070
1/13

$599,999

3
Bedrooms
1,759
Square Feet
0.15
Acres
$599,900 | 161 Great Pond Road, Simsbury, CT 06070
1/8
Coming SoonOpen: 8/15 12:00PM - 03:00PM

$599,900

4
Bedrooms
2,573
Square Feet
2
Acres
$599,900 | 69 Cambridge Court, Simsbury, CT 06070
1/20
Open: 8/8 01:00PM - 03:00PM

$599,900

3
Bedrooms
1,740
Square Feet
0.25
Acres
$575,000 | 30 Cambridge Court, Simsbury, CT 06070
1/18

$575,000

3
Bedrooms
1,450
Square Feet
0.15
Acres
$435,000 | 22 Willard Street, Simsbury, CT 06070
1/40

$435,000

4
Bedrooms
2,178
Square Feet
0.63
Acres
$599,000 | 20 Munnisunk Drive, Simsbury, CT 06070
1/40
Listed By Coldwell Banker RealtyUnder Contract - Continue To Show

$599,000

4
Bedrooms
2,414
Square Feet
0.69
Acres
a front view of a house with a yard
1/40

$1,125,000

4
Bedrooms
5,192
Square Feet
2
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 247 Old Farms Road, Simsbury, CT 06070
$752,000
4
2,943
149,846
4
2.5
2,399
65,776
$417,500
4
2,432
87,120
$417,500
4
2.5
2,432
87,120
$394,900
5
2,610
71,438
$290,000
4
2,007
74,923

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 LPT Realty, Jessica C Starr

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.