Joe Waters
JW Realty Group LLC
(475) 263-4868
152 Total Sales
1 in East Windsor
$445,000 Price
247 Rye St Broad Brook, CT 06016
East Windsor AreaEstimated Value: $534,000 - $863,000
4
Beds
4.5
Baths
3,990
Sq Ft
$180/Sq Ft
Est. Value
Highlights
- Barn
- Open Floorplan
- Secluded Lot
- 16.88 Acre Lot
- Colonial Architecture
- Partially Wooded Lot
About This Home
As of May 2019WELCOME 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!
Last Agent to Sell the Property
Marilyn Dzen
Dzen Realty License #REB.0751356 Listed on: 01/29/2019
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,111
Year Built
- Built in 1789
Lot Details
- 16.88 Acre Lot
- Home fronts a stream
- Stone Wall
- Secluded Lot
- Open Lot
- Partially Wooded Lot
- Property is zoned R-3
Home Design
- Colonial Architecture
- Concrete Foundation
- Block Foundation
- Frame Construction
- Slate Roof
Interior Spaces
- 3,990 Sq Ft Home
- Open Floorplan
- Central Vacuum
- 1 Fireplace
- Thermal Windows
- Mud Room
- Entrance Foyer
- Concrete Flooring
- Basement Fills Entire Space Under The House
- Pull Down Stairs to Attic
- Home Security System
- Laundry on main level
Kitchen
- Gas Range
- Microwave
- Dishwasher
Bedrooms and Bathrooms
- 4 Bedrooms
Parking
- 5 Car Garage
- Automatic Garage Door Opener
- Circular Driveway
Outdoor Features
- Patio
- Exterior Lighting
- Rain Gutters
Schools
- Broad Brook Elementary School
- East Windsor High School
Utilities
- Zoned Heating and Cooling System
- Heating System Uses Propane
- Electric Water Heater
- Fuel Tank Located in Ground
- Cable TV Available
Additional Features
- Energy-Efficient Insulation
- Property is near golf course and shops
- Barn
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Apr 8, 2026
Sold by
West Lindsay
Bought by
Current Estimated Value
Purchase Details
Listed on
Jan 29, 2019
Closed on
May 17, 2019
Sold by
Lanza Ann
Bought by
West Derek
Seller's Agent
Marilyn Dzen
Dzen Realty
Buyer's Agent
Heather Bennet
Keller Williams Realty-Longmdw
List Price
$785,000
Sold Price
$765,000
Premium/Discount to List
-$20,000
-2.55%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.83%
Original Mortgage
$688,500
Interest Rate
3.5%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Nov 14, 2006
Sold by
Laughlin Linda
Bought by
Lanza Ann
Purchase Details
Closed on
Jul 26, 2004
Sold by
Homes By Guarino Llc
Bought by
Fletcher Lynn
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$215,000
Interest Rate
6.87%
Purchase Details
Closed on
Jan 30, 2004
Sold by
Moore Randy and Moore Linda
Bought by
Homes By Guarino Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,680
Interest Rate
5%
Purchase Details
Closed on
Dec 28, 1998
Sold by
Lamenzo Marshall and Lamenzo Jean
Bought by
Moore Randy and Moore Linda
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Broad Brook, CT
-
Joe Waters
-
Mela Dieujuste
Mela Dieujuste
IVerty Realty, LLC
(413) 241-7854
87 Total Sales
1 in East Windsor
$162,000 Price
-
Mavourneen Costello
Mavourneen Costello
Nexthome Elite Realty
(860) 607-0155
59 Total Sales
1 in East Windsor
$480,000 Price
-
Felix DuVerger
Felix DuVerger
Berkshire Hathaway NE Prop.
(860) 566-9717
105 Total Sales
1 in East Windsor
$219,900 Price
-
Melania Hasiuk
Melania Hasiuk
William Pitt Sotheby's Int'l
(860) 606-4512
93 Total Sales
2 in East Windsor
$130K - $850K Price Range
-
Trish Russo
Trish Russo
LPT Realty
(860) 791-3720
31 Total Sales
2 in East Windsor
$67K - $260K Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| -- | -- | ||
| Derek Carl West Ret | -- | -- | |
| West Derek | $765,000 | -- | |
| Lanza Ann | $251,575 | -- | |
| Fletcher Lynn | $334,250 | -- | |
| Homes By Guarino Llc | $71,250 | -- | |
| Moore Randy | $400,000 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $680,000 | ||
| Previous Owner | -- | $688,500 | |
| Previous Owner | Lanza Ann-Christine M | $360,000 | |
| Previous Owner | Lanza Ann-Christine M | $199,500 | |
| Previous Owner | Lanza Ann-Christine | $140,000 | |
| Previous Owner | Lanza Ann-Christine | $375,000 | |
| Previous Owner | Lanza Ann Christine | $350,000 | |
| Previous Owner | Lanza Ann Christine | $350,000 | |
| Previous Owner | Atkinson Jerry | $215,000 | |
| Previous Owner | -- | $100,000 | |
| Previous Owner | Homes By Guarino Llc | $250,680 | |
| Previous Owner | Lamenzo Marshall | $37,400 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/17/2019 05/17/19 | Sold | $765,000 | -2.5% | $192 / Sq Ft |
| 04/17/2019 04/17/19 | Pending | -- | -- | -- |
| 01/29/2019 01/29/19 | For Sale | $785,000 | -- | $197 / Sq Ft |
Source: SmartMLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $11,628 | $438,970 | $73,260 | $365,710 |
| 2024 | $10,781 | $438,970 | $73,260 | $365,710 |
| 2023 | $15,922 | $464,460 | $81,530 | $382,930 |
| 2022 | $11,418 | $464,460 | $81,530 | $382,930 |
| 2021 | $16,024 | $464,460 | $81,530 | $382,930 |
| 2020 | $16,126 | $464,460 | $81,530 | $382,930 |
| 2019 | $15,908 | $464,460 | $81,530 | $382,930 |
| 2018 | $8,111 | $239,260 | $81,530 | $157,730 |
| 2017 | $7,893 | $240,850 | $66,800 | $174,050 |
| 2016 | $7,449 | $240,850 | $66,800 | $174,050 |
| 2015 | $7,300 | $240,850 | $66,800 | $174,050 |
| 2014 | $7,173 | $240,850 | $66,800 | $174,050 |
Source: Public Records
Agents Affiliated with this Home
-
MD
Seller's Agent in 2019
Marilyn Dzen
Dzen Realty
-
Heather Bennet
Buyer's Agent in 2019
Heather Bennet
Keller Williams Realty-Longmdw
(413) 374-6833
108 Total Sales
Map
Source: SmartMLS
MLS Number: 170153037
APN: EWIN-000035-000049-000022
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 25 Plantation Rd
- 144 Rye St
- 0 Chamberlain Rd Unit 24154561
- 20 Apothecaries Hall Rd
- 111 Rye St
- 63 Stoughton Rd
- 105 Windsorville Rd
- 33 Norton Rd
- 60 Abbe Rd
- 216 Wells Rd
- 18 Norton Rd
- 119 Windsorville Rd
- 411 Griffin Rd
- 16 David Dr Unit 16
- 18 David Dr
- 18 Folkstone Rd Unit D
- 0 Abbe Rd
- 101 Windsorville Rd
- 17 Cathy (Lot 18) Ln
- 21 Ln
Your Personal Tour Guide
Ask me questions while you tour the home.