Skip main navigation
For sale
  • $2,900,000

    47 Sleepy Hollow Rd, Columbia, CT 06237

    5beds
    4,694sqft
    : 
    Single Family Residence
    Built in 1972
    1.1 Acres Lot
    $-- Zestimate®
    $618/sqft
    $-- HOA

    What's special

    Direct lake accessPrivate beach frontage
    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
    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#: 24081677MLS Logo
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 47 Sleepy Hollow Rd.

    Next available tour time:Tomorrow at 11am

    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

    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