247 Rye St, Broad Brook, CT 06016
OFF MARKET

247 Rye St
Broad Brook, CT 06016

  • 4 Beds
  • 4.5 Baths
  • 3,990 sqft (on 16.88 acres)

$1,164,700

Trulia Estimate
as of May 20, 2026
Est. Refi. Payment $8,085/mo*
Refinance Your Home

$1,164,700

Trulia Estimate
as of May 20, 2026
Est. Refi. Payment $8,085/mo*
Refinance Your Home
4 Beds
4.5 Baths
3,990 sqft
(on 16.88 acres)

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

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!
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources.

Home Highlights

Parking
Garage
Outdoor
Patio
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
No Info

Home Details for 247 Rye St

Interior Features

Heating & Cooling
Heating: Forced Air, OilAir ConditioningHeating Fuel: Forced Air
Levels, Entrance, & Accessibility
Stories: 2
Interior Details
AtticNumber of Rooms: 10
Fireplace & Spa
FireplaceHot Tub or Spa

Exterior Features

Exterior Home Features
Roof: SlateExterior: WoodPatio
Parking & Garage
GarageParking: Garage Attached, Garage Detached

Property Information

Year Built
Year Built: 1789Year Updated: 1981
Property Type / Style
Property Type: Single Family HomeArchitecture: Colonial

Community

Units in Building: 1

Lot Information

Lot Area: 16.88 acres

Price History for 247 Rye St

DatePriceEventSource
05/17/2019$765,000Sold
Smart MLS #170153037
02/15/2019$785,000PendingAgent Provided
01/29/2019$785,000Listed For SaleAgent Provided
11/14/2006$251,575Sold
N/A
07/26/2004$334,250Sold
N/A
01/30/2004$71,250Sold
N/A
12/28/1998$400,000Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$11,628
Assessment$438,970
Home facts updated by county records

Comparable Sales for 247 Rye St

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
18 Deerfield Drive, Broad Brook, CT
0.94
Single-Family Home
$573,500
02/20/26
4
2.5
2,688
231 Rye Street, Broad Brook, CT
0.19
Single-Family Home
$345,000
05/28/25
2
1
1,771
16 Ellsworth Road, Broad Brook, CT
0.47
Single-Family Home
$352,000
07/03/25
3
2
1,741
16 Ellsworth Rd, Broad Brook, CT
0.47
Single-Family Home
$352,000
07/14/25
3
2
1,346
9 Pine Drive, Broad Brook, CT
0.64
Single-Family Home
$346,500
08/29/25
4
2
1,537
9 Pine Dr, Broad Brook, CT
0.64
Single-Family Home
$346,500
09/02/25
4
2
1,537
43 Green Lane, South Windsor, CT
1.28
Single-Family Home
$900,000
06/30/25
4
2.5
3,960
10 Hayfield Lane, Broad Brook, CT
1.39
Single-Family Home
$600,000
01/16/26
4
2.5
2,520
155 Griffin Rd, South Windsor, CT
1.53
Single-Family Home
$1,200,000
11/04/25
2
2
2,258
60 Abbe Road, East Windsor, CT
1.54
Single-Family Home
$566,100
10/20/25
9
5
8,022

Assigned Schools

These are the assigned schools for 247 Rye St.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Broad Brook

At least 38 Trulia users voted on each feature.

  • 96 % Say car is needed

  • 93 % Say it's dog friendly

  • 80 % Say kids play outside

  • 80 % Say parking is easy

  • 79 % Say yards are well-kept

  • 78 % Say there's holiday spirit

  • 67 % Say there's wildlife

  • 60 % Say neighbors are friendly

  • 59 % Say it's quiet

  • 57 % Say people would walk alone at night

  • 46 % Say there are sidewalks

  • 40 % Say streets are well-lit

  • 39 % Say they plan to stay for at least 5 years

  • 31 % Say there are community events

  • 23 % Say it's walkable to restaurants

  • 22 % Say it's walkable to grocery stores

Sourced by Trulia users. Learn more about our methodology.
  • Shineka A.
    "There are a variety of families with different racial and religious beliefs. The are is a wonderful place to live and has a great school system. But be very careful with your kids."
    0
    Flag
  • Marie A. B.
    "Not enough sidewalks. No dog parks. But there are a lot of dog and the people are understanding of the circumstances "
    1
    Flag
  • Marie A. B.
    "Unreachable. Only taxi comes to my neighborhood. I drive to everywhere I go. No buses comes here. But easy "
    1
    Flag
  • Marie A. B.
    "It’s country living in a city. Everything I need is within 20 miles radius. The neighbors don’t speak or wave. Feel very alone "
    4
    Flag
  • Ellie m.
    "Mill Pond Village. KingsWay convenience store. Dollar General. Elaine’s Pizza. The Pond. The Rez. "
    0
    Flag
  • Scott G. p.
    "This area is the best. It's a property for adults who want their adult child or their parent/s to live with them. Beautiful setting, quiet, safe, and very secure. We've been here for 6 years, Lived in the little home and then bought the whole property. We have no children at home so we are looking for smaller as we are getting older. But the right price is the buyer. Paved Driveway to both buildings. Well for water, Satellite service excellent/ cable available, Septic on site with secondary septic for little home. Electrical metering for each home which may be combined thru proper channels."
    2
    Flag
  • mkob4u
    "I lived there for a short period of time. It is very quite, nice and freindly neighborhood. "
    1
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Homes for sale near 247 Rye St

Skip to last item
Skip to first item

Off Market Homes Near 247 Rye St

Skip to last item
Skip to first item

Homes for rent near 247 Rye St

Skip to last item
Skip to first item
247 Rye St, Broad Brook, CT 06016 is a 4 bedroom, 5 bathroom, 3,990 sqft single-family home built in 1789. This property is not currently available for sale. 247 Rye St was last sold on May 17, 2019 for $765,000. The current Trulia Estimate for 247 Rye St is $1,164,700.