$2,900,000

47 Sleepy Hollow Rd Columbia, CT 06237

Estimated payment $17,770/month

Total Views 12,661
5 Beds
5 Baths
4,694 Sq Ft
$618 Price per Sq Ft

Highlights

  • Lake Front
  • Attic
  • Tankless Water Heater
  • Cape Cod Architecture
  • 2 Fireplaces
  • Heating system powered by solar not connected to the grid

About This Home

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:

Listing Agent

Annmarie Fortier

Coldwell Banker Realty License #RES.0762509 Listed on: 03/19/2025

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $23,982

Year Built

  • Built in 1972

Lot Details

  • 1.1 Acre Lot
  • Lake Front
  • Property is zoned LAR

Parking

  • 4 Car Garage

Home Design

  • Cape Cod Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Log Siding

Interior Spaces

  • 2 Fireplaces
  • Pull Down Stairs to Attic
  • Laundry on main level

Kitchen

  • Oven or Range
  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms
  • 5 Full Bathrooms

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Eco-Friendly Details

  • Heating system powered by solar not connected to the grid

Schools

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

Utilities

  • Central Air
  • Heating System Uses Propane
  • Private Company Owned Well
  • Tankless Water Heater
  • Fuel Tank Located in Ground

Listing and Financial Details

  • Assessor Parcel Number 2205983

Home Details

Home Type

Single Family

Est. Annual Taxes

$23,982

Year Built

Built in 1972

Lot Details

0

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Cape Cod
  • Sq Ft Est Heated Above Grade: 2769
  • Sq Ft Est Heated Below Grade: 1925
  • Total Sq Ft: 4694
  • Year Built: 1972
  • New Construction: No/Resale
  • In Law Access: GARAG,ENTRY
  • Direct Waterfront: Yes
  • Home Warranty Offered: No
  • Directions: lake road to sleepy hollow ... GPS friendly
  • In Law Apartment: Yes
  • Living Area Sq Ft Per Public Record: 3609
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 5
  • Total Bathrooms: 5
  • Full Bathrooms: 5
  • Fireplaces: 2
  • Attic Description: Pull-Down Stairs
  • Basement Description: Full, Fully Finished, Full With Walk-Out
  • Appliances: Gas Range, Oven/Range, Microwave, Refrigerator, Dishwasher
  • Laundry Room Info: Main Level
  • Attic: Yes
  • Street Number Modifier: 47
  • Other SqFt Description: sq ft of house

Exterior Features

  • Exterior Siding: Logs
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Lake
  • Swimming Pool: No
  • Construction Description: Frame, Log

Garage/Parking

  • Garages Number: 4
  • Garage And Parking: Barn, Attached Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Electric, Propane, Solar
  • Fuel Tank Location: In Ground
  • Hot Water Description: Tankless Hotwater
  • Water Source: Private Well
  • Sewer: Septic

Schools

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

Lot Info

  • Acres: 1.1
  • Lot Description: Secluded Level Lot Cleared Professionally Landscaped Water View
  • Zoning: LAR
  • Parcel #: 2205983

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 23982
  • Total Assessed Value: 819350
  • Mil Rate Total: 29.27

MLS Schools

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

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

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 $23,982 $819,350 $306,460 $512,890
2024 $19,448 $691,600 $306,460 $385,140
2023 $17,919 $691,600 $306,460 $385,140
2022 $15,215 $588,140 $306,460 $281,680
2021 $15,994 $545,300 $299,100 $246,200
2020 $15,994 $545,300 $299,100 $246,200
2019 $15,994 $545,300 $299,100 $246,200
2018 $15,994 $545,300 $299,100 $246,200
2017 $15,748 $545,300 $299,100 $246,200
2016 $14,834 $540,600 $299,100 $241,500
2015 $14,666 $540,600 $299,100 $241,500
2014 $14,666 $540,600 $299,100 $241,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/19/2025 03/19/25 For Sale $2,900,000 +274.2% $618 / Sq Ft
02/27/2012 02/27/12 Sold $775,000 -20.9% $232 / Sq Ft
11/17/2011 11/17/11 Pending -- -- --
10/27/2011 10/27/11 For Sale $980,000 -- $294 / Sq Ft
Source: SmartMLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $775,000 --
Warranty Deed $335,000 --
Warranty Deed $335,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $225,070 Credit Line Revolving
Open $417,000 No Value Available
Source: Public Records

Source: SmartMLS

MLS Number: 24081677

SmartMLS

APN: COLU-000016B-000000-000027