47 Sleepy Hollow
Columbia, CT 06237
- 5 beds
- 6 baths
- 4,694 sqft
- ~1 acre lot
- $617 per sqft
- 1972 build
- – on site
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
Listing courtesy of SMART_MLS / Annmarie Fortier / Coldwell Banker Realty
Last checked:
Checking…
•
Last updated Nov 14, 2024
•
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
MLS# 24041876 —
The Building
-
Year Built:1972
-
Year Built Source:Public Records
-
New Construction Type:No/Resale
-
Style:Cape Cod
-
Roof Information:Asphalt Shingle
-
Attic:Yes
-
Attic Description:Pull-Down Stairs
-
Exterior Siding:Logs
-
Foundation Type:Concrete
-
Basement Description:Full, Fully Finished, Full With Walk-Out
-
SqFt Total:4694
-
SqFt Description:sq ft of house
-
SqFt Est Heated Above Grade:2769
-
SqFt Est Heated Below Grade:1925
Interior
-
Fireplaces Total:2
-
Laundry Room:Main Level
Location
-
Directions:lake road to sleepy hollow ... GPS friendly
-
Neighborhood:N/A
The Property
-
Parcel Number:2205983
-
Property Type:Single Family For Sale
-
Zoning:LAR
-
Acres:1.1
-
Acres Source:Public Records
-
Lot Description:Secluded, Level Lot, Cleared, Professionally Landscaped, Water View
Listing Agent
- Contact info:
- Agent phone:
- (860) 633-3661
Taxes
-
Tax Year:July 2024-June 2025
-
Property Taxes:19448
Beds
-
Beds Total:5
Baths
-
Total Baths:6
-
Full Baths:6
The Listing
-
https://www.dropbox.com/scl/fi/m2q0qpo9e0w4qscxc0ssv/47-Sleepy-Hollow-Video-Cinematic.mp4?rlkey=usljx89w7344o0hawx4g7a088&e=1&st=znga5zq9&dl=0
-
Virtual Tour Branded URL:https://www.dropbox.com/scl/fi/m2q0qpo9e0w4qscxc0ssv/47-Sleepy-Hollow-Video-Cinematic.mp4?rlkey=usljx89w7344o0hawx4g7a088&e=1&st=znga5zq9&dl=0
-
Home Warranty Offered:No
Heating & Cooling
-
Heat Type:Hot Air
-
Heat Fuel Type:Electric, Propane, Solar
-
Cooling System:Central Air
Utilities
-
Water Source:Private Well
-
Sewage System:Septic
Appliances
-
Appliances Included:Gas Range, Oven/Range, Microwave, Refrigerator, Dishwasher
Schools
-
Elementary School:Horace W. Porter
-
High School:E.O. Smith High School
The Community
-
Swimming Pool:No
-
Direct Waterfront:Yes
-
Waterfront Description:Lake
Parking
-
Garage/Parking:Barn, Attached Garage
-
Garages Number:4
Monthly cost estimate
Asking price
$2,900,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$15,528
|
Taxes | N/A |
Insurance | $797 |
Utilities | $493 See report |
Total | $16,818/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
8/29/24
Aug 29, 2024
|
Listed / Active | SMART_MLS | $2,900,000 | |
8/23/24
Aug 23, 2024
|
Coming Soon | SMART_MLS | $2,900,000 | 274.2% (22.0% / YR) |
2/27/12
Feb 27, 2012
|
SMART_MLS | $775,000 |