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.)
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
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#: 170582587

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