$10,000 Closing Credit¹
#24079641, Rick Nassiff, Listing Office: KW Legacy Partners
#24081677·
Listing office: Coldwell Banker Realty·
Listing agent: Annmarie Fortier·
Listing office phone: (860) 633-3661
$2,900,000 List price
47 Sleepy Hollow Rd Columbia, CT 06237
5 beds
5 full
4,694 sqft
1.1 acres
$618 / sqft
House
Property details
About 47 Sleepy Hollow Rd
Welcome to your dream lakefront property! This breathtaking 5-bedroom, 6-bathroom lake house resort has unparalleled luxury and privacy on the pristine Columbia Lake. Spanning 4,416 square feet, this exquisite estate boasts the only private beach frontage on the entire lake, with over 300 feet of direct lake access. In addition to the main residence, the property features a brand new, state-of-the-art barn/ 2 car garage. One of the garages is equipped with a loft and a full basement, providing ample space for storage, a workshop, or additional living quarters. View Listing Video: https://www.dropbox.com/scl/fi/m2q0qpo9e0w4qscxc0ssv/47-Sleepy-Hollow-Video-Cinematic.mp4?rlkey=usljx89w7344o0hawx4g7a088&e=1&st=znga5zq9&dl=0
Highlights
Home typeOther
HeatingForced Air
StatusActive
CoolingCentral Air
Size4,694 sqft
BasementYes
Lot size1.1 Acres
Year built1972
ParkingBarn, Attached Garage
MLS #24081677
Attached garage4 spaces
WaterfrontLake Front
ViewWater
Summary
- Full Bathrooms: 5
- Appliances: Gas Range, Oven/Range, Microwave, Refrigerator, Dishwasher
- Basement: Yes
- Total Bedroom Count: 5
- Garage Space: 4 spaces
- Attached Garage: Yes
- Private Pool: No
- Parking: Barn, Attached Garage
- Waterfront: Lake Front
- View: Water
- Heating: Forced Air
- Cooling: Central Air
- List Price: $2,900,000
- Price/SqFt: $617
- Annual Tax Amount: $19,448
- Tax Year: 2024
- Lot: Secluded, Level, Cleared, Landscaped, Views
- Directions: lake road to sleepy hollow ... GPS friendly
- Year Built: 1972
- Living Area: 4,694 SqFt
- Lot Size: 1.1 Acres
- MLS Number: 24081677
- Office Name: Coldwell Banker Realty
- Office Phone: (860) 633-3661
- Office Email: annmarie.fortier@cbmoves.com
- Listing Agent: Annmarie Fortier
Copyright © 2025 Smart MLS. The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 5/6/2025, 8:20:32 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$2,900,000
47 Sleepy Hollow Rd
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Feb 28, 2012 | Home Sold | $775,000 |
| Apr 01, 1998 | Home Sold | $335,000 |
| Apr 01, 1998 | Home Sold | $335,000 |
| May 27, 1988 | Home Sold | $475,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $691,600 | $19,448 |
| 2023 | $691,600 | $17,919 |
| 2022 | $588,140 | $15,215 |
| 2021 | $545,300 | $15,994 |
| 2020 | $545,300 | $15,994 |
| 2019 | $545,300 | $15,994 |
History based on county public records data.
Nearby schools
6
Andover Elementary School
Public District PK-6
2.4 mi
•35 School Rd
8
George Hersey Robertson School
Public District 3-5
3.6 mi
•227 Cross St
7
Hebron Elementary School
Public District 3-6
4.4 mi
•92 Church St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $95,652. Typical income of Columbia, CT residents is between $35k-100k annually. The most common type of family is married, no kids. Typical level of education for residents in this area is post secondary degree.
How much money do the neighbors make?
9%
<35k
45%
35k-100k
39%
100k-200k
7%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
30%
Single, No Kids
5%
Single, with Kids
41%
Married, No Kids
24%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
11%
<11 yrs old
8%
12-17 yrs old
14%
18-34 yrs old
49%
35-64 yrs old
18%
65+ yrs old
What do the neighbors do for fun?
Hunting
Figure Skating
NASCAR
Where do the neighbors shop?
Dillards
Dick's Sporting Goods
Dollar General
Where do the neighbors go to eat?
Cracker Barrel
Texas Roadhouse
Applebees
What do the neighbors drive?
Cadillac
Subaru
Oldsmobile
What do the neighbors listen to?
News/Talk/Information
New Country
Classic Country
All data provided by Home Junction and Claritas
Similar homes for sale
Frequently asked questions
About 47 Sleepy Hollow Rd
The listing price of 47 Sleepy Hollow Rd property is $2,900,000.
The property 47 Sleepy Hollow Rd is a house located in Columbia, Connecticut, 06237.
Active Listing: 47 Sleepy Hollow Rd is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 47 Sleepy Hollow Rd are: Andover Elementary School (GreatSchools Rating 6/10), George Hersey Robertson School (GreatSchools Rating 8/10), Hebron Elementary School (GreatSchools Rating 7/10), Horace W. Porter School (GreatSchools Rating 5/10), Rham Middle School (GreatSchools Rating 6/10), Capt. Nathan Hale School (GreatSchools Rating 6/10), Rham High School (GreatSchools Rating 5/10), Coventry High School (GreatSchools Rating 10/10), Windham Technical High School (GreatSchools Rating 4/10).
According to the records, the last property tax for 2024 is $19,448 (source: MLS/based on county public records data).
The last sale was on February 28, 2012 for $775,000 (source: MLS/tax record).
The property at 47 Sleepy Hollow Rd has 5 bedrooms and 5 bathrooms.
The property 47 Sleepy Hollow Rd is 4,694 SqFt (source: MLS/tax record).
The year of construction for 47 Sleepy Hollow Rd is 1972.
This home is located at 47 Sleepy Hollow Rd in Columbia, CT and zip code 06237. This 4,694 square foot home, which was built in 1972, sits on a 1.10 acre lot. Features: 5 bedrooms, 5 bathrooms. It has been listed on Rocket Homes since March 19, 2025 and is currently priced at $2,900,000.
Columbia, CT housing market in April 2025 saw over 3 listings sold above listed price, more than 0 sold at listed price and over 0 sold below. Between March and April 2025, Columbia, CT real estate market has seen decrease in the number of listings by 18.8%.
From Rocket Homes Real Estate and based on county public records data.