247 Rye Street, Broad BrookEast Windsor, CT 06016MLS Number 170153037

  • Price: $785,000
  • Est. Mortgage of $/month
$/month over payments
Federal 30-year interest rate: 4.37% last updated on Feb 14, 2019
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.
  • 4Bedrooms
  • 16.88Acreage
  • 5Bathroom
  • 1789Year Built

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!

Listed by Marilyn Dzen of Dzen Realty

Driving Directions

Vernon Office
Vernon Office
Office: 860-871-2775
646 Hartford Turnpike
Vernon, CT 06066

Ask A Question


Sentry Real Estate 860-871-2775
Vernon Office 860-871-2775

or send a message:

Do not fill in this field:

More Info

Basic Information

  • MLS Number170153037
  • StatusSHOW
  • List Price$785,000
  • Square Feet3,990
  • Property TypeSingle Family For Sale
  • HoaNo
  • Lease purchaseNo


  • Acreage16.88
  • Building ConstructionFrame
  • Lot DescriptionOpen Lot, May be Subdividable, Secluded, Lightly Wooded
  • Driveway TypeCircular, Paved
  • Garages5
  • Parking spaces per 1000sqft
  • Parking spaces uncovered
  • Parking Spaces
  • Parking spaces covered
  • FloodzoneNo
  • SwimmingpoolNo


  • Waters ourcePublic Water Connected
  • Cooling SystemCentral Air
  • Hot water description50 Gallon Tank, Electric
  • Heating FuelPropane
  • Fuel tank locationIn Ground
  • Heat SystemHot Air, Zoned
  • Septic approvalNo
  • Septic plan availableNo
  • Sewage systemSeptic

Tax Information

  • Assessed value$239,260
  • Milrate base33
  • Milrate total33.9
  • Taxes$8,111
  • Tax YearJuly 2018-June 2019


  • StateCT
  • Zip06016
  • CountyHartford
  • NeighborhoodBroad Brook
  • Short SaleNo


  • Rooms10
  • Rooms additionalFoyer, Mud Room
  • Interior featuresAuto Garage Door Opener, Cable - Available, Central Vacuum, Open Floor Plan, Security System
  • RoofSlate
  • Room count10


  • Exterior featuresBarn, Gutters, Lighting, Patio, Stone Wall
  • Exterior sidingOther


  • Amenities
    • Golf Course
    • Health Club
    • Library
    • Medical Facilities
    • Park
    • Public Pool
    • Public Rec Facilities
    • Shopping/Mall


  • Appliances IncludedGas Range, Microwave, Dishwasher
  • Fha approvedNo
  • SubletableNo
  • Space is leasedNo
  • Remarks addendumThe 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!!

School Information

  • Elementary SchoolBroad Brook
  • High SchoolEast Windsor


  • Laundry room locationMain floor & second floor hookups
  • Laundry room infoMain Level, Upper Level


  • Full Bath4
  • Half Bath1
  • BasementFull, Concrete Floor
  • Attic descriptionPull-Down Stairs
  • AtticYes
  • Bedrooms4
  • Bathroom5
  • Year Built1789
  • Property StyleColonial
  • Energy FeaturesExtra Insulation, Thermopane Windows
  • Fireplaces1
  • FoundationBlock, Concrete
  • Garage Parking InfoAttached Garage, Detached Garage
  • New construction typeNo

Water Body

  • Waterfront DescriptionBrook


Room LevelRoom TypeRoom WidthRoom LengthRoom Features
MainFormal Dining Room1415Built-In Hutch,French Doors,Wide Board Floor
MainGreat Room1522French Doors,Gas Log Fireplace,Wide Board Floor
MainKitchen1222Beams,Breakfast Bar,Island,Pantry,Quartz Counters,Wide Board Floor
MainLiving Room1427Wide Board Floor
MainOffice913Wide Board Floor
MainSun Room1426French Doors,Wide Board Floor
UpperBedroom812Wide Board Floor
UpperBedroom1212Walk-In Closet,Wide Board Floor
UpperBedroom1415Full Bath,Walk-In Closet,Wide Board Floor
UpperMBR Suite1426Full Bath,Stall Shower,Walk-In Closet,Wide Board Floor

Information contained in this Smart MLS listing has been compiled from various sources, all of which may not be completely accurate. Smart MLS makes no warranty or representation as to the accuracy of listing information. All information that influences a decision to purchase a listed property should be independently verified by the purchaser. Copyright 2017 Smart MLS, Inc. All rights reserved.

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:


Do not fill in this field: