Mary Collins
Berkshire Hathaway NE Prop.
(959) 210-6341
145 Total Sales
1 in Union
$579,000 Price
Estimated Value: $928,000 - $977,179
This stunning, custom-designed, year-round waterfront home offers the perfect blend of luxury and comfort on over 4.3 beautifully landscaped acres with expansive 708' of water frontage on the coveted Hamilton Reservoir. Featuring 3 spacious bedrooms and 4 bathrooms, this thoughtfully crafted home is ideal for everyday living or as the ultimate stay-home vacation retreat. With your choice of a 4-car garage or a 3-car garage with dedicated boat storage, it's built for both convenience and adventure. Entertain with ease at the charming party pavilion, relax by the water, or set off from your private boat dock to explore the reservoir. Panoramic water views and serene surroundings complete this one-of-a-kind property-truly a lakeside paradise for all seasons. With a quick ride in either direction and you could be in Hartford, Boston or downtown Sturbridge to enjoy the Village, shops and fabulous Restaurants. The perfect spot to relax and unwind. Highest and best by Sunday at noon
Last Agent to Sell the Property
BHHS Realty Professionals Brokerage Phone: (860) 748-6801 License #RES.0789448 Listed on: 09/30/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Mary Collins
Berkshire Hathaway NE Prop.
(959) 210-6341
145 Total Sales
1 in Union
$579,000 Price
Melania Hasiuk
William Pitt Sotheby's Int'l
(860) 606-4512
93 Total Sales
1 in Union
$477,000 Price
Sharon Watson Stokland
List N Show LLC
(866) 789-5844
133 Total Sales
1 in Union
$579,000 Price
Amy Rio
Better Homes and Gardens Real Estate Executive Real Estate
(860) 321-8567
1,025 Total Sales
1 in Union
$380,000 Price
Andy Goodhall
Connecticut Crossroads Realty
(860) 851-3927
113 Total Sales
22 in Union
$35K - $660K Price Range
Dan Keune
Campbell-Keune Realty Inc
(860) 259-2181
172 Total Sales
1 in Union
$295,000 Price
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 |
|---|---|---|---|
| $935,000 | -- | ||
| Noel Kevin | $935,000 | -- | |
| Denning Franklin | $129,000 | -- | |
| Shaw Dennis | $77,600 | -- | |
| Gilmore Steven | $65,000 | -- |
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 | $180,000 | ||
| Previous Owner | Denning Franklin G | $250,000 |
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 |
|---|---|---|---|---|
| 11/18/2025 11/18/25 | Sold | $935,000 | +4.1% | $326 / Sq Ft |
| 10/13/2025 10/13/25 | Pending | -- | -- | -- |
| 10/07/2025 10/07/25 | For Sale | $898,000 | -- | $313 / Sq Ft |
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,854 | $500,610 | $173,400 | $327,210 |
| 2024 | $11,404 | $500,610 | $173,400 | $327,210 |
| 2023 | $9,955 | $351,130 | $137,560 | $213,570 |
| 2022 | $9,779 | $351,130 | $137,560 | $213,570 |
| 2021 | $10,042 | $351,130 | $137,560 | $213,570 |
| 2020 | $10,179 | $351,130 | $137,560 | $213,570 |
| 2019 | $10,860 | $351,130 | $137,560 | $213,570 |
| 2018 | $11,677 | $375,480 | $184,460 | $191,020 |
| 2017 | $11,580 | $375,480 | $184,460 | $191,020 |
| 2015 | $11,114 | $375,480 | $184,460 | $191,020 |
| 2014 | $10,889 | $375,480 | $184,460 | $191,020 |
Seller's Agent in 2025
Paula Smith
BHHS Realty Professionals
(860) 748-6801
84 Total Sales
Buyer's Agent in 2025
Ed Richman
Lakefront Living Realty, LLC
(860) 209-7620
18 Total Sales
Source: SmartMLS
MLS Number: 24130025
APN: UNIO-000011-000004-000001
Ask me questions while you tour the home.