Off Market May 2019 for $765K

$1,143,934

Est. refi paymentEst. refi $5,473/mo

•

3,990

sq ft

247 Rye St, Broad Brook, CT 06016

About this home

WELCOME TO "THE FARNHAM ESTATE!" This Hidden Paradise, situated on 17 private acres in Broad Brook, includes a stately Federal Colonial-completely renovated remaining true to the original with regard to the doors, hardware, chimney wood paneling & wainscoting. Features all new electrical, plumbing, added insulation, all new energy efficient Anderson 12 over 12 true divided windows, new Hardy Plank Exterior siding, new central air & new heating. Custom builtins & attention to architectural details abound. The designer kitchen, features custom new white cabinetry, Viking gas stove, Bosch dishwasher & center island for 6, is open to the Gathering Room w/gas fireplace & French doors to the native sandstone terrace, perfect for entertaining. Beautiful, original exposed chestnut beams & wide board wood floors throughout the house. A service bar is convenient to the formal living room with original French doors to the Sun room. WOW, what a gorgeous sun room-all windowed-so relaxing with an atrium door to the expansive terrace! A lovely formal dining room w/wainscoting, corner cabinet & French doors that leads to an office. A second floor lavish Master Suite, with three walls of windows to enjoy the serene views, is enhanced by a wood bead board ceiling, and adjoining Master bath with double sinks, a soaking tub, & an oversized tiled shower! All 4 bedrooms enjoy their own private full bathrooms. Garages - 5 bays along with a workshop & storage barn. A truly special property!

The Farnham Estate grounds were designed by Thomas Desmond, a renowned landscape architect. His design included stonewalls and coy ponds. Trees and shrubs were imported from around the world - most are tagged in Latin. Please see attachment showing list of trees and shrubs, along with a map of the property showing their placement. Great Location for a Vineyard, Bed & Breakfast, Beautiful Wedding Venue or even a Horse Farm. Possibility of subdividing. This property is conveniently located midway between Boston and New York - only 30 minutes from Bradley International Airport and in close proximity to shopping, golf clubs - public and private, and medical facilities!!

Single-familyProperty Type

1789Year Built

16.88 acresLot Size

$287Est. Price/Sq.Ft.

5 car garageParking

Listed by Marilyn Dzen • Dzen Realty

Bought with Heather Bennet • Keller Williams Realty-Longmdw

Source:Smart MLS #170153037

Redfin Estimate

$1,143,934

$379K since sold in May 2019$11K since July

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 89.8% higher than the average sale price ($603K) of 5 comparable homes.

SOLD MAY 15, 2026
$415,000
A
4 beds3 baths2,738 sq ft
957 Palisado Ave, Windsor, CT 06095
SOLD MAY 8, 2026
$455,000
B
4 beds2 baths1,840 sq ft
102 Scantic Rd, East Windsor, CT 06088
SOLD APR 13, 2026
$1,050,000
C
4 beds4.5 baths3,452 sq ft
40 Barber Hill Rd, Broad Brook, CT 06016
SOLD FEB 20, 2026
$573,500
D
4 beds2.5 baths2,688 sq ft
18 Deerfield Dr, Windsor, CT 06016
SOLD JUN 22, 2026
$520,000
E
4 beds3 baths2,444 sq ft
277 Windsorville Rd, Ellington, CT 06029

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$554,187

Est. take-home

List your home with Redfin and save $11,439

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$4,122/mo

Redfin rental estimate

List your home for rent

Market trends in 06016, CT

Last updated July 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

108.0%

+3.4% MoM

Median sale price

$351K

$51K MoM

Avg. days on market

21d

8 days MoM

Recently sold homes

3 MoM

New listings for sale

$575,000
3 beds2.5 baths2,041 sq ft
29 Skinner, Broad Brook, CT 06016
$525,000
4 beds2.5 baths2,189 sq ft
119 Windsorville Rd, Broad Brook, CT 06016
See all

Provided by Redfin

Sale history for 247 Rye St

Year

Property tax

Land + Additions

Assessment*

2025

$11,628 (+7.9%)

$73,260 + $365,710

$438,970

2024

$10,781 (−32.3%)

$73,260 + $365,710

$438,970

2023

$15,922 (−0.3%)

$81,530 + $382,930

$464,460

2022

$15,968 (−0.3%)

$81,530 + $382,930

$464,460

2021

$16,024 (−0.6%)

$81,530 + $382,930

$464,460

2020

$16,126 (+1.4%)

$81,530 + $382,930

$464,460

2019

$15,908 (+96.1%)

$81,530 + $382,930

$464,460

2018

$8,111 (+2.8%)

$81,530 + $157,730

$239,260

2017

$7,893 (+6.0%)

$66,800 + $174,050

$240,850

2016

$7,449 (+3.8%)

$66,800 + $174,050

$240,850

2014

$7,173 (+6.3%)

$66,800 + $174,050

$240,850

2011

$6,749

$52,580 + $174,050

$226,630

Tax history for 247 Rye St

Year

Property tax

Land + Additions

Assessment*

2025

$11,628 (+7.9%)

$73,260 + $365,710

$438,970

2024

$10,781 (−32.3%)

$73,260 + $365,710

$438,970

2023

$15,922 (−0.3%)

$81,530 + $382,930

$464,460

2022

$15,968 (−0.3%)

$81,530 + $382,930

$464,460

2021

$16,024 (−0.6%)

$81,530 + $382,930

$464,460

2020

$16,126 (+1.4%)

$81,530 + $382,930

$464,460

2019

$15,908 (+96.1%)

$81,530 + $382,930

$464,460

2018

$8,111 (+2.8%)

$81,530 + $157,730

$239,260

2017

$7,893 (+6.0%)

$66,800 + $174,050

$240,850

2016

$7,449 (+3.8%)

$66,800 + $174,050

$240,850

2014

$7,173 (+6.3%)

$66,800 + $174,050

$240,850

2011

$6,749

$52,580 + $174,050

$226,630

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

4.5

Stories

Lot width

—

Lot depth

—

Lot size

16.88 Acres

Year renovated

1981

Sq. Ft.

3,990

Year built

1789

Style

Single Family Residential

County

Hartford County

APN

525243

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 10, 2026.

Property details

Parking

Garage Information
Garage & Parking: Attached Garage, Detached Garage
Garages Number: 5

Interior

Interior Information
Total Rooms: 10
Laundry Room Location: Main floor & second floor hookups
Laundry Room Info: Main Level, Upper Level
Interior Features: Auto Garage Door Opener, Cable - Available, Central Vacuum, Open Floor Plan, Security System
Fireplaces Total: 1
Cooling System: Central Air
Appliances Included: Gas Range, Microwave, Dishwasher

Bathroom Information
# of Baths (Full): 4
# of Baths (Half): 1

Bedroom Information
Beds Total: 4

Room Information
Rooms Additional: Foyer, Mud Room
Room Count: 10
Basement Description: Full, Concrete Floor
Has Attic
Attic Description: Pull-Down Stairs

Exterior

Exterior Features
Roof Information: Slate
Exterior Siding: Other
Exterior Features: Barn, Gutters, Lighting, Patio, Stone Wall

Lot Information
Lot Description: Open Lot, May be Subdividable, Secluded, Lightly Wooded

Building Information
Foundation Type: Block, Concrete
Construction Description: Frame

Property Information
Waterfront Description: Brook
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 3990
Driveway Type: Circular, Paved

Financial

Assessments Information
Assessed Value: $239,260

Utilities

Utility Information
Water Source: Public Water Connected
Sewage System: Septic
Hot Water Description: 50 Gallon Tank, Electric
Heat Type: Hot Air, Zoned
Heat Fuel Type: Propane
Fuel Tank Location: In Ground
Energy Features: Extra Insulation, Thermopane Windows

Location

School Information
High School: East Windsor
Elementary School: Broad Brook

Location Information
State: Connecticut
Nearby Amenities: Golf Course, Health Club, Library, Medical Facilities, Park, Public Pool, Public Rec Facilities, Shopping/Mall
Directions: Route 5 to Sullivan Ave, So Windsor, to left on Rye Street.
County: Hartford

Public facts

Beds: 4
Baths: 4.5
Sq. Ft.: 3,990
Stories: 2.0
Lot Size: 16.88 acres
Style: Single Family Residential
Year Built: 1789
Year Renovated: 1981
County: Hartford County
APN: 525243

Home facts updated by county records on Jul 10, 2026

Other

Documents & Disclosures
Supplement Count Public: 4

Around this home

Schools

Broad Brook Elementary School

Public PreK-4 • Assigned • 2.0mi

5/10

East Windsor Middle School

Public 5-8 • Assigned • 2.8mi

6/10

East Windsor High School

Public 9-12 • Assigned • 2.5mi

2/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 97° expected this year, 15 days in 30 years

6/10 Wind Factor

27% chance of strong winds in next 30 years

3/10 Air Factor

2 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Broad Brook, CT • 06016

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.1 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.

9.1 hrs

4.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.09M – $1.32M

Reach more buyers when you sell with Redfin. Save up to $11,439 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$59,900

2 beds1 bath784 sq ft

9 North Rd, East Windsor, CT 06088

NEW CONSTRUCTION

$825,000

3 beds2.5 baths2,875 sq ft

22 Broad Brook Rd, Ellington, CT 06029

$369,900

4 beds2 baths1,742 sq ft

93 Steele Rd, Enfield, CT 06082

$305,000

4 beds1.5 baths1,333 sq ft

7 Maple Ave, East Windsor, CT 06106

OPEN TODAY, 12PM TO 1:30PM

$559,900

4 beds2.5 baths2,144 sq ft

839 Palisado Ave, Windsor, CT 06095

$399,900

3 beds3 baths2,722 sq ft

106 Cobblestone Way, Windsor, CT 06095

New listings for sale in 06016

$575,000

3 beds2.5 baths2,041 sq ft

29 Skinner, Broad Brook, CT 06016

$525,000

4 beds2.5 baths2,189 sq ft

119 Windsorville Rd, Broad Brook, CT 06016

Home values near 247 Rye St

Data from public records.

Address	Redfin Estimate
240 Rye Street, Broad Brook, CT 3 Beds \| 2.5 Baths \| 2410 Sq. Ft.	$514,104
263 Rye Street, Broad Brook, CT 5 Beds \| 3 Baths \| 2770 Sq. Ft.	$569,839

Address	Redfin Estimate
245 Rye Street, Broad Brook, CT 4 Beds \| 2.5 Baths \| 2448 Sq. Ft.	$559,547
257 Rye Street, Broad Brook, CT 3 Beds \| 2.5 Baths \| 2076 Sq. Ft.	$554,716

Address	Redfin Estimate
265 Rye Street, Broad Brook, CT 3 Beds \| 1.5 Baths \| 1460 Sq. Ft.	$468,104
254 Rye Street, Broad Brook, CT 2 Beds \| 2 Baths \| 1876 Sq. Ft.	$369,372

Property information provided by Smart MLS when last listed in 2019. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

South Windsor homes for sale
Glastonbury homes for sale
Southington homes for sale
Farmington homes for sale
Avon homes for sale

Houses for rent in Broad Brook	Agents near me	Westport, CT homes for sale	Broad Brook Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	Broad Brook Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

06082 homes for sale
06088 homes for sale
06016 homes for sale

West Hartford homes for sale
Springfield homes for sale
Hartford homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06016, CT

Sale history for 247 Rye St

Tax history for 247 Rye St

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06016

Home values near 247 Rye St

More real estate resources