Skip main navigation
Sold
  • $2,750,000

    24 Erdoni Road, Columbia, CT 06237

    3beds
    8,144sqft
    Single Family Residence
    Built in 2010
    1.7 Acres Lot
    $2,778,300 Zestimate®
    $338/sqft
    $4,955 Estimated rent

    What's special

    One of the largest waterfront parcels on beautiful Columbia Lake provides privacy for this superbly crafted home designed to make the most of its idyllic setting. The open floor plan showcases panoramic water views from most of the rooms. The property encompasses a stately main house with manicured lawns, beautiful landscaped gardens and an attached carriage house ideal for guests. This 5700 sq. ft. house on 1.70 acres was built for glorious summering by the water. In addition, winter provides opportunities for cross country skiing, ice skating, ice fishing or just walking around the private, town owned lake. Upon entering this home, the center foyer features a spectacular double helix spiral staircase that spans all three levels of the main house as does a convenient elevator. The interiors are highlighted by 10-foot coffered ceilings on the first floor and cathedral ceilings on the second floors. This stunning home features high quality finishes, birch hardwood floors, handsome fireplaces and numerous cherry built-ins to complete the charm of this custom home. Columbia Lake is a beautiful 300+ acre fully recreational lake located in Columbia, CT. Columbia Lake is easily accessed and within 10-30 minutes of UCONN, ECSU and Hartford. Columbia Lake is one of the premier lakes in CT, owned and operated by the Town of Columbia, the lake is carefully maintained and properties surrounding the lake have a significant premium attached to them. Unlike many large lakes, Columbia lake is private for the property owners in Columbia and there is no state boat launch. Lake property owners feel that the advantage to not having a state boat launch is a quieter, peaceful lake. Even though power boats and jet skis are allowed, and there is a lot of fun to be had on the lake, the traffic is limited to direct lakefront property owners and other Columbia property owners. The lake has a fun and yet private and serene atmosphere. A truly rare and highly desirable offering. Travel distances to Key Cities; Hartford 25.5 miles (under 30 mins.), Boston 95 miles, Providence 52.5 miles, NYC 136.3 miles, Stamford 95.9 miles, New Haven 57.9 miles, Bradley Airport 35.9 miles(under 40 mins.)

    Zillow last checked: 7 hours ago

    Listing updated: September 03, 2023 at 05:14am

    Listed by:

    David S. Holcroft,

    RE/MAX Precision Realty

    Bought with:

    Ben Castonguay, REB.0789871

    Sentry Real Estate

    Source: Smart MLS,MLS#: 170582587MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 6
    • Full bathrooms: 4
    • 1/2 bathrooms: 2
    Living room
    • Level: Main
    Heating
    • Heat Pump, Radiant, Geothermal, Propane
    Cooling
    • Ceiling Fan(s), Central Air, Zoned
    Appliances
    • Included: Electric Cooktop, Oven, Convection Oven, Microwave, Range Hood, Refrigerator, Subzero, Dishwasher, Washer, Dryer, Wine Cooler, Water Heater, Tankless Water Heater
    • Laundry: Lower Level, Main Level, Mud Room
    Features
    • Sound System, Elevator, Open Floorplan, Entrance Foyer, In-Law Floorplan, Smart Thermostat
    • Doors: French Doors
    • Windows: Thermopane Windows
    • Basement: Full,Finished,Heated,Cooled,Liveable Space
    • Attic: Access Via Hatch
    • Number of fireplaces: 6
    Interior area
    • Total structure area: 8,144
    • Total interior livable area: 8,144 sqft
    • Finished area above ground: 5,744
    • Finished area below ground: 2,400

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Garage Door Opener, Private, Circular Driveway, Driveway
    • Attached garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Covered, Wrap Around
    • Exterior features: Balcony, Lighting, Sidewalk, Stone Wall, Underground Sprinkler
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Waterfront, Lake, Dock or Mooring, Association Optional
    Lot
    • Size: 1.70 Acres
    • Features: Wetlands, Wooded, Landscaped
    Details
    • Additional structures: Shed(s)
    • Parcel number: 2204157
    • Zoning: LAR
    • Other equipment: Intercom, Generator, Entertainment System

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Wood Siding
    • Foundation: Concrete Perimeter
    • Roof: Asphalt
    Condition
    • New construction: No
    • Year built: 2010

    Utilities & green energy

    • Sewer: Septic Tank
    • Water: Well
    Green energy
    • Energy efficient items: HVAC, Windows

    Community & neighborhood

    Security
    • Security features: Security System
    Community
    • Community features: Lake, Library, Medical Facilities, Paddle Tennis, Park, Playground, Public Rec Facilities, Tennis Court(s)
    Location
    • Region: Columbia
    Services availability