Skip main navigation
Off market
Street View
  • $1,092,800

    247 Rye St, Broad Brook, CT 06016

    4beds
    3,990sqft
    SingleFamily
    Built in 1789
    16.88 Acres Lot
    $1,092,800 Zestimate®
    $274/sqft
    $5,922 Estimated rent

    Home value

    $1,092,800

    $994,000 - $1.21M

    $5,922/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $5,922/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,922/mo

    Rent Zestimate®

    Refinance and save

    $6,587/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,587/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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 Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Oil
    Features
    • Security System, Cable - Available, Open Floor Plan, Auto Garage Door Opener, Central Vacuum
    • Basement: None
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 3,990 sqft

    Property

    Parking
    • Parking features: Garage - Attached, Garage - Detached
    Features
    • Exterior features: Wood
    • Has spa: Yes
    Lot
    • Size: 16.88 Acres
    Details
    • Parcel number: EWINM35B49L22

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Frame
    • Roof: Slate
    Condition
    • Year built: 1789

    Utilities & green energy

    • Water: Public Water Connected

    Community & neighborhood

    Location
    • Region: Broad Brook

    Other

    Other facts
    • Appliances Included: Dishwasher, Microwave, Gas Range
    • Attic Description: Pull-Down Stairs
    • Attic YN: 1
    • Driveway Type: Paved, Circular
    • Direct Waterfront YN: 0
    • Exterior Features: Barn, Stone Wall, Gutters, Lighting, Patio
    • Energy Features: Thermopane Windows, Extra Insulation
    • Interior Features: Security System, Cable - Available, Open Floor Plan, Auto Garage Door Opener, Central Vacuum
    • Fuel Tank Location: In Ground
    • Fireplaces Total: 1
    • Home Warranty Offered YN: 0
    • Nearby Amenities: Library, Park, Public Rec Facilities, Shopping/Mall, Health Club, Medical Facilities, Public Pool, Golf Course
    • Lot Description: Lightly Wooded, Open Lot, Secluded, May be Subdividable
    • Basement Description: Concrete Floor, Full
    • Property Type: Single Family For Sale
    • Cooling System: Central Air
    • Sewage System: Septic
    • Style: Colonial
    • Swimming Pool YN: 0
    • Heat Type: Hot Air, Zoned
    • Hot Water Description: Electric, 50 Gallon Tank
    • Water Source: Public Water Connected
    • Heat Fuel Type: Propane
    • Waterfront Description: Brook
    • Rooms Additional: Mud Room, Foyer
    • Room Count: 10
    • Exterior Siding: Other
    • Construction Description: Frame
    • Assessed Value: 239260
    • Property Tax: 8111
    • Foundation Type: Concrete, Block
    • Roof Information: Slate
    • Laundry Room Info: Upper Level, Main Level
    • Tax Year: July 2018-June 2019

    Price history

    DateEventPrice
    5/17/2019Sold$765,000-2.5%$192/sqft
    Source: Smart MLS #170153037 Report a problem
    2/15/2019Pending sale$785,000$197/sqft
    Source: Dzen Realty #170153037 Report a problem
    1/29/2019Listed for sale$785,000+212%$197/sqft
    Source: Dzen Realty #170153037 Report a problem
    11/14/2006Sold$251,575-24.7%$63/sqft
    Source: Public Record Report a problem
    7/26/2004Sold$334,250+369.1%$84/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$11,628 +7.9%$438,970
    2024$10,781 -32.3%$438,970 -5.5%
    2023$15,922 -0.3%$464,460

    Find assessor info on the county website

    Neighborhood: 06016

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Broad Brook
    • High: East Windsor

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.