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
For sale
$2,900,000
47 Sleepy Hollow Rd, Columbia, CT 06237
5beds
4,694sqft
Est.:
Single Family Residence
Built in 1972
1.1 Acres Lot
$-- Zestimate®
$618/sqft
$-- HOA
What's special
Direct lake accessPrivate beach frontage
- 38 days
- on Zillow |
- 1,550 |
- 56 |
Zillow last checked: 7 hours ago
Listing updated: March 19, 2025 at 12:55pm
Listed by:
Annmarie A. Fortier,
Coldwell Banker Realty
Source: Smart MLS,MLS#: 24081677

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 5
Primary bedroom
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Dining room
- Level: Main
Living room
- Level: Main
Heating
- Forced Air, Electric, Propane, Solar
Cooling
- Central Air
Appliances
- Included: Gas Range, Oven/Range, Microwave, Refrigerator, Dishwasher, Tankless Water Heater
- Laundry: Main Level
Features
- In-Law Floorplan
- Basement: Full,Finished
- Attic: Pull Down Stairs
- Number of fireplaces: 2
Interior area
- Total structure area: 4,694
- Total interior livable area: 4,694 sqft
- Finished area above ground: 2,769
- Finished area below ground: 1,925
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Barn, Attached
- Attached garage spaces: 4
Features
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Waterfront, Lake
Lot
- Size: 1.1 Acres
- Features: Secluded, Level, Cleared, Landscaped
Details
- Parcel number: 2205983
- Zoning: LAR
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence
Materials
- Log
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1972
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $618/sqft
- Tax assessed value: $691,600
- Annual tax amount: $19,448
- Date on market: 3/19/2025
- Loading
- Loading