247 Rye St

East Windsor, CT 06016

$765,000
Last Sold Price
4
Beds
3,990 Sq. Ft.
$192 / Sq. Ft.
3,990
Sq. Ft.
$192
per Sq. Ft.
Get preapproved with Rocket Mortgage1
Closed 5/17/19
Closed 5/17/19
Aerial views of this stately Federal Colonial situated on 17 acres bordering Ketch Brook.

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...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!
  1. Listed by Marilyn Dzen • Dzen Realty
    P: (860)-930-8040 C: (860)-930-8040 mdzen@dzen.com

Property Details for 247 Rye Street

Basement Description
Full, Concrete Floor
Direct Waterfront
No
Garages Number
5
Neighborhood
Broad Brook
Style
Colonial
Garage Parking Info
Attached Garage, Detached Garage
Swimming Pool
No
LISTING CLOSED: 05/17/2019 12:00 AM

Property Details for 247 Rye Street

StatusClosed
MLS #170153037
Days on Market78
Taxes$8,111 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential
Year Built1789
Lot Size16.88 AC / 735,292 SF
CountyHartford County
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of Dzen Realty, Marilyn Dzen

Sold By Keller Williams Realty-Longmdw, Heather Bennet

Add your commute

Building Information for 247 Rye Street

Stories-Year Built1789Building Size-Lot Size16.88 AC / 735,292 SF

Payment Calculator

Get preapproved with Rocket Mortgage1

$4,488 per month

30 year fixed, 6.36% Interest

Principal and Interest

$3,812

Property Taxes

$676

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 247 Rye Street

Summary
Property and Location
  • Acres Source: Public Records
  • Directions: Route 5 to Sullivan Ave, So Windsor, to left on Rye Street.
  • Elementary School: Broad Brook
  • High School: East Windsor
  • Latitude: 41.884968
  • Longitude: -72.56798
  • Neighborhood Amenities: Golf Course, Health Club, Library, Medical Facilities, Park, Public Pool, Public Rec Facilities, Shopping/Mall
  • State: Connecticut
HOA and Fees
  • Home Owner's Assocation: No
  • Tax Year: July 2018-June 2019
  • Property Tax: $8,111
Virtual Tour
  • Virtual Tour: No
Interior and Exterior Features
Exterior Features
  • Exterior Features: Barn, Gutters, Lighting, Patio, Stone Wall
  • Waterfront Description: Brook
Interior Features
  • Appliances Included: Gas Range, Microwave, Dishwasher
  • Attic Description: Pull-Down Stairs
  • Cooling System: Central Air
  • Heat Type: Hot Air, Zoned
  • Attic YN: Yes
  • Fireplaces Total: 1
  • Interior Features: Auto Garage Door Opener, Cable - Available, Central Vacuum, Open Floor Plan, Security System
  • Laundry Room Info: Main Level, Upper Level
  • Laundry Room Location: Main floor & second floor hookups
  • Rooms Additional: Foyer, Mud Room
  • Room Count: 10
  • Rooms Total: 10
Room 1
  • Room Entry Order: 1
  • Room Features: Beams,Breakfast Bar,Island,Pantry,Quartz Counters,Wide Board Floor
  • Room Length: 22.0
  • Room Level: Main
  • Room Type: Kitchen
  • Room Width: 12.0
Room 2
  • Room Entry Order: 10
  • Room Features: Wide Board Floor
  • Room Length: 12.0
  • Room Level: Upper
  • Room Type: Bedroom
  • Room Width: 8.0
Room 3
  • Room Entry Order: 2
  • Room Features: French Doors,Gas Log Fireplace,Wide Board Floor
  • Room Length: 22.0
  • Room Level: Main
  • Room Type: Great Room
  • Room Width: 15.0
Room 4
  • Room Entry Order: 3
  • Room Features: Built-In Hutch,French Doors,Wide Board Floor
  • Room Length: 15.0
  • Room Level: Main
  • Room Type: Formal Dining Room
  • Room Width: 14.0
Room 5
  • Room Entry Order: 4
  • Room Features: Wide Board Floor
  • Room Length: 27.0
  • Room Level: Main
  • Room Type: Living Room
  • Room Width: 14.0
Room 6
  • Room Entry Order: 5
  • Room Features: Wide Board Floor
  • Room Length: 13.0
  • Room Level: Main
  • Room Type: Office
  • Room Width: 9.0
Room 7
  • Room Entry Order: 6
  • Room Features: French Doors,Wide Board Floor
  • Room Length: 26.0
  • Room Level: Main
  • Room Type: Sun Room
  • Room Width: 14.0
Room 8
  • Room Entry Order: 7
  • Room Features: Full Bath,Stall Shower,Walk-In Closet,Wide Board Floor
  • Room Length: 26.0
  • Room Level: Upper
  • Room Type: Primary BR Suite
  • Room Width: 14.0
Room 9
  • Room Entry Order: 8
  • Room Features: Full Bath,Walk-In Closet,Wide Board Floor
  • Room Length: 15.0
  • Room Level: Upper
  • Room Type: Bedroom
  • Room Width: 14.0
Room 10
  • Room Entry Order: 9
  • Room Features: Walk-In Closet,Wide Board Floor
  • Room Length: 12.0
  • Room Level: Upper
  • Room Type: Bedroom
  • Room Width: 12.0
Property
Property and Assessments
  • Construction Description: Frame
  • Driveway Type: Circular, Paved
  • Exterior Siding: Other
  • Foundation Type: Block, Concrete
  • Fuel Tank Location: In Ground
  • New Construction Type: No/Resale
  • Roof: Slate
  • Year Built: 1789
  • Year Built Source: Public Records
  • Bank Owned Property: No
  • Living Area SQFT Per Public Records: 3990
Lot Information
  • Lot Description: Open Lot, May be Subdividable, Secluded, Lightly Wooded
  • Parcel Number: 525243
  • Sq Ft Est Heated Above Grade: 3990.0
  • Sq Ft Total: 3990.0
  • Zoning: R-3
Utilities
  • Energy Features: Extra Insulation, Thermopane Windows
  • Heat Fuel Type: Propane
  • Hot Water Description: 50 Gallon Tank, Electric
  • Sewage System: Septic
  • Water Source: Public Water Connected
Multi Family
Income and Expenses
  • Occupied By: Owner

Property History for 247 Rye Street

DateEvent & SourcePriceAppreciation
May 17, 2019

Closed (Public Record)

Public Record #646377760

$765,000—
May 17, 2019

Closed (Public Record)

Public Record #1316964134

$765,000

+9.3% / yr

Nov 14, 2006

Closed (Public Record)

Public Record #211168606

$251,575

+2.2779663082125678e+58% / yr

DateEvent & SourcePrice
05/17/2019

Closed (Public Record)

Public Record #646377760

$765,000
05/17/2019

Closed (Public Record)

Public Record #1316964134

$765,000

+9.3% / yr

11/14/2006

Closed (Public Record)

Public Record #211168606

$251,575

+2.2779663082125678e+58% / yr

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 247 Rye Street

Taxable ValueLand$73,260Additions$365,710Total$438,970
Tax Record2024$11,628 ($969 / month)
Home Facts
Beds4Baths4.5Total Finished SqFt3,990 SqFtAbove Grade Finished SqFt3,990 SqFtUnfinished Basement SqFt1,756 SqFtStories2Lot Size735,293 SqFtStyleSingle Family ResidenceYear Built1987ZoningR-3CountyCAPITOLAPNEWIN M:35 B:49 L:22Fireplace TypeHas Fireplace

Schools near 247 Rye Street

This home is within East Windsor School District.
Rating
School
Type
Grades
Distance
Broad Brook Elementary School
Public - PK to 4
East Windsor Middle School
Public - 5 to 8
East Windsor High School
Public - 9 to 12
Rating
School
Distance
Broad Brook Elementary School
PublicPK to 4

East Windsor Middle School
Public5 to 8

East Windsor High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Nearby off-market homes

AddressSold priceBedsBathsSqftLot AC
241 Rye Street, East Windsor, CT 06016
$210,000
5
3,212
4.14
245 Rye Street, East Windsor, CT 06016
$375,000
4
2,448
0.69
251 Rye Street, East Windsor, CT 06016
$390,000
3
1,839
0.9
259 Rye Street, Broad Brook, CT 06016
$1
3
2,248
5.32
239 Rye Street, East Windsor, CT 06016
$329,000
3
1,420
0.78

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Dzen Realty, Marilyn Dzen

Based on information from one of the following Multiple Listing Services: Darien MLS, Smart MLS and Greenwich Multiple Listing Service. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Darien MLS, Smart MLS and Greenwich Multiple Listing Service is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.