Skip To Content

47 Sleepy Hollow Road

Columbia, CT 06237
  • $2,900,000
  • STATUS: Active
  • ON SITE: 92 Days
  • MLS #: 24081677
UPDATED: 50 min ago
$2,900,000
  • 5
    BEDS
  • 1.1
    ACRES
  • 5
    BATHS
  • 0
    1/2 BATHS
  • 2,769
    SQFT
  • $1,047
    $/SQFT
Type:
Single-Family Home
Built:
1972
County:
Area:

School Information

Elementary School:
High School:

Description

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

Monthly Payment Calculator



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. Copyright 2025 SmartMLS, Inc. Data last updated: 2025-06-20T20:11:10.16.
www.lowerhudsonvalleyproperties.com/homes/161654816
Print Image

47 Sleepy Hollow Road Columbia, CT 06237

  • Price: $2,900,000
  • Status: Active
  • On Site: 92 Days
  • Updated: 50 min ago
  • MLS #: 24081677
5
Beds
5
Baths
0
½ Baths
1.1
Acres
2,769
SQFT
$1,047
$/SQFT
1972
Built
County:
Tolland
Area:
Columbia
Elementary School:
Horace W. Porter
High School:
E.O. Smith High School
Property Description
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
Exterior Features

Direct Waterfront YN Yes Exterior Siding Logs Garage And Parking BarnAttached Garage Lot Description SecludedLevel LotClearedProfessionally LandscapedWater View Roof Information Asphalt Shingle Style Cape Cod Swimming Pool YN No Waterfront Description Lake

Interior Features

Appliances Included Gas RangeOven/RangeMicrowaveRefrigeratorDishwasher Attic Description Pull-Down Stairs Attic YN Yes Basement Description FullFully FinishedFull With Walk-Out Cooling System Central Air Fireplaces Total 2 Heat Type Hot Air In Law Access Over GarageSeparate Entry In Law Apartment Yes Laundry Room Info Main Level Rooms Living Room (Main Level) Bedroom (Upper Level) Dining Room (Main Level) Bedroom (Upper Level) Bedroom (Upper Level) Bedroom (Main Level) Primary Bedroom (Main Level) Sq Ft Est Heated Above Grade 2769 Sq Ft Est Heated Below Grade 1925 Sq Ft Total 4694 Total Rooms 8

Property Features

Agent Owner YN No Bank Owned Property No Foundation Type Concrete Fuel Tank Location In Ground Heat Fuel Type ElectricPropaneSolar Home Owners Assocation No Home Warranty Offered YN No Hot Water Description Tankless Hotwater New Construction Type No/Resale Potential Short Sale No Sewage System Septic Tax Year July 2024-June 2025 Water Source Private Well Zoning LAR

Listing information © 2025 Smart MLS
Listing provided courtesy of Annmarie Fortier of Coldwell Banker Realty: (860) 633-3661.


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. Copyright 2025 SmartMLS, Inc. Data last updated: 2025-06-20T20:11:10.16.
 
https://bt-photos.global.ssl.fastly.net/ctmls/1280_boomver_1_24081677-1.jpg https://bt-photos.global.ssl.fastly.net/ctmls/1280_boomver_1_24081677-1.jpg https://bt-photos.global.ssl.fastly.net/ctmls/1280_boomver_1_24081677-1.jpg
Logo
Mark Seiden Real Estate Team
1238 Pleasantville Rd
Briarcliff Manor NY, 10510