Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$750,000 Contingent

  • For Sale
  • Contingent
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 2,943 Sq. Ft.
  • 3 Car Garage
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 247 Old Farms Rd

General

  • Price: $750,000
  • Taxes: (July 2025-June 2026)
  • Status: Contingent
  • Type: Single Family
  • Source: SMARTMLS
  • MLS ID: 24127298
  • Updated: 12/22/2025
  • Added to Site: 123 day(s) ago

Interior

  • Number of Rooms: 9
  • Interior Features: Auto Garage Door Opener
  • Fireplace: Yes
  • Number of Fireplaces: 2
  • Appliances: Oven/Range, Microwave, Range Hood, Refrigerator, Dishwasher, Disposal, Washer, Electric Dryer

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1

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, Lower
  • Dining Room: Dining Room, Lower

Exterior

  • Exterior Features: Deck

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 3
  • Parking: Attached Garage

Location

  • County: Hartford
  • Driving Directions: GPS

School Information

  • Elementary School: Squadron Line
  • High School: Simsbury

Heating & Cooling

  • Cooling Type: Central Air
  • Heating Type: Hot Air, Oil
  • Heating Fuel: Oil
  • Water Heater: Other

Utilities

  • Sewer: Septic
  • Water: Public Water Connected

Structural Information

  • Architectural Style: Colonial
  • Construction Status: No/Resale
  • Exterior Const.: Wood
  • Basement Desc.: Full, Garage Access, Full With Walk-Out
  • Roof: Asphalt Shingle
  • Attic: Yes
  • Square Feet: 2,943
  • Above Ground: 2,943 Sq. Ft.
  • Year Built: 1999

Lot Features

  • Lot Size (Acres): 3.44
  • Zoning: R-80
  • Lot Description: Secluded, Lightly Wooded

Financial Considerations

  • Assessment Amount: $409,430
  • Tax Year: July 2025-June 2026

Disclosures and Reports

  • Property ID: 2147402

Listed by LPT Realty, Starr Team At LPT Realty, Jessica Starr

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

— 247 Old Farms Rd —

  • Jessica Starr

    LPT Realty

Agent Contact: (860) 690-0679 Office Contact: (877) 366-2213

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

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

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

Date
Details
Price
Change
Source
9/25/2025
Listed
$750,000
22.95%
MLS
9/21/2022
Sold
$610,000
—
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 247 Old Farms Rd

Year
Property Taxes
Change
Tax Assessment
Change
2024
$13,986
3%
$409,430
—
2023
$13,638
5%
$409,430
—
2023
$13,028
-7%
$409,430
13%
2022
$14,000
—
$362,410
—
2021
$13,961
4%
$362,410
—
2020
$13,442
-1%
$362,410
—
2019
$13,525
-1%
$362,410
—
2018
$13,623
2%
$362,410
5%
2017
$13,345
4%
$344,310
—
2016
$12,781
—
$344,310
—
2015
$12,781
—
$344,310
—
2014
$12,788
-4%
$344,310
—
2011
$13,259
—
$344,310
—
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 247 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 LPT Realty, Starr Team At LPT Realty, Jessica Starr

Similar Properties near 247 Old Farms Rd

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

281 N Granby Rd, Granby, CT 06035 - Photo 1
$749,000

281 N Granby Rd  Granby, CT 06035

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,234
    Sq. Ft.
Listed by MacNaughton Real Estate
200 N Main St, East Granby, CT 06026 - Photo 1
$799,900

200 N Main St  East Granby, CT 06026

  • Single Family
  • Active
  • 5
    Beds
  • 2
    Total Baths
  • 2,560
    Sq. Ft.
Listed by Christine Santaniello Realty
15 Austin Brook Dr, East Granby, CT 06026 - Photo 1 Just Listed
$750,000

15 Austin Brook Dr  East Granby, CT 06026

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,753
    Sq. Ft.
Listed by Weichert Realtors MRG
2 Ferncliff Dr, West Hartford, CT 06117 - Photo 1
$749,900

2 Ferncliff Dr  West Hartford, CT 06117

  • Single Family
  • Active
  • Updated 11 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,688
    Sq. Ft.
Listed by Steve Joseph (508) 667-3194

Just Listed near 247 Old Farms Rd

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

11 Brenthaven, Avon, CT 06001 - Photo 1 Just Listed
$585,000
Open House

11 Brenthaven  #11  Avon, CT 06001

  • Townhouse
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,717
    Sq. Ft.
Listed by Meyerson Soto Byrnes Team at Coldwell Banker Realty (860) 305-9109
92 Mallard Dr, Avon, CT 06001 - Photo 1 Just Listed
$268,000

92 Mallard Dr  Avon, CT 06001

  • Condo
  • Active
  • Updated 16 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,258
    Sq. Ft.
Listed by William Raveis Real Estate
4 Strathmore Ln, Avon, CT 06001 - Photo 1 Just Listed
$470,000

4 Strathmore Ln  #4  Avon, CT 06001

  • Townhouse
  • Active
  • Updated 10 hours ago
  • 2
    Beds
  • 3
    Total Baths
  • 1,798
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
36 N Farms Rd, Avon, CT 06001 - Photo 1 Just Listed
$595,500
Open House

36 N Farms Rd  Avon, CT 06001

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,536
    Sq. Ft.
Listed by William Raveis Real Estate

Price Reduced near 247 Old Farms Rd

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

41 Applegate Ln, Canton, CT 06019 - Photo 1 Price Reduced
-$14,900 (-2.13%)
$685,000

41 Applegate Ln  #41  Canton, CT 06019

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,103
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
29 Privilege Rd, Bloomfield, CT 06002 - Photo 1 Price Reduced
-$10,100 (-1.89%)
$524,900

29 Privilege Rd  Bloomfield, CT 06002

  • Single Family
  • Active
  • Updated 3 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,080
    Sq. Ft.
Listed by Lock and Key Realty, Inc
81 Silo Way, Bloomfield, CT 06002 - Photo 1 Price Reduced
-$7,400 (-2.69%)
$267,500

81 Silo Way  #81  Bloomfield, CT 06002

  • Townhouse
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,204
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
23 Bradley Brook Dr, Granby, CT 06060 - Photo 1 Price Reduced
-$10,000 (-2.39%)
$409,000

23 Bradley Brook Dr  Granby, CT 06060

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,990
    Sq. Ft.
Listed by Rockoff Realty

Recent Sales near 247 Old Farms Rd

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

21 Wyngate, Simsbury, CT 06070 - Photo 1 Sold
$760,000

21 Wyngate  Simsbury, CT 06070

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 3,485
    Sq. Ft.
Listed by Barile Realty Group
Sold by West Park Realty, LLC
28 Saddle Ridge Dr, Simsbury, CT 06092 - Photo 1 Sold
$701,500

28 Saddle Ridge Dr  Simsbury, CT 06092

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 3,278
    Sq. Ft.
Listed by RE/MAX Prime Realty
Sold by Putnam Agency Real Estate LLC
30 Clifdon Dr, Simsbury, CT 06070 - Photo 1 Sold
$640,000

30 Clifdon Dr  Simsbury, CT 06070

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,168
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
Sold by Tier 1 Real Estate
14 Case Cir, Simsbury, CT 06092 - Photo 1 Sold
$803,000

14 Case Cir  Simsbury, CT 06092

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,305
    Sq. Ft.
Listed by Berkshire Hathaway NE Prop.
Sold by Berkshire Hathaway NE Prop.

247 Old Farms Road, Simsbury, CT 06070 (MLS# 24127298) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 247 Old Farms Road is currently listed for $750,000 and was received on September 16, 2025. Want to learn more about 247 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