47 Sleepy Hollow Road, Columbia, Connecticut

$2,750,000

Previous Next

5

Beds

5

Baths

4,694

Square feet

1.10

Acres

About 47 Sleepy Hollow Road

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

Features of 47 Sleepy Hollow Road

MLS® # 24081677
Price $2,750,000
Bedrooms 5
Bathrooms 5.00
Full Baths 5
Square Footage 4,694
Acres 1.10
Type Single Family For Sale
Style Cape Cod
Status Active

Community Information

Address 47 Sleepy Hollow Road
Area N/A
City Columbia
County Tolland
State Connecticut
Zip Code 06237

Amenities

Parking Barn, Attached Garage
# of Garages 4
Is Waterfront Yes
Waterfront Lake
Has Pool No

Interior

Appliances Gas Range, Oven/Range, Microwave, Refrigerator, Dishwasher
Heating Hot Air, Electric, Propane, Solar
Cooling Central Air
Fireplace Yes
# of Fireplaces 2
Has Basement Yes
Basement Full, Fully Finished, Full With Walk-Out

Exterior

Exterior Logs
Lot Description Secluded, Level Lot, Cleared, Professionally Landscaped, Water View
Roof Asphalt Shingle
Foundation Concrete

School Information

Elementary Horace W. Porter
High E.O. Smith High School

Additional Information

Date Listed March 19th, 2025
Days on Market 202
Zoning LAR
RE / Bank Owned No

Listing Details

OfficeColdwell Banker Realty

Listing Map

Request a Showing

Provide a valid email address.
When would you like to view this property?

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.

Listing information last updated on October 20th, 2025 at 5:50pm EDT.