24 Erdoni Road
Columbia, CT 06237
3 Beds
5 Baths
8,144 sqft (on 1.70 acres)
3 Beds
5 Baths
8,144 sqft
(on 1.70 acres)
Local Information
© Google
-- mins to
Description
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.)
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from September 03, 2023
Home Highlights
Parking
3 Car Garage
Outdoor
Yes
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago
Home Details for 24 Erdoni Road
|
|---|
Interior Details Basement: Full,Finished,Heated,Cooled,Liveable SpaceNumber of Rooms: 10Types of Rooms: Living Room |
Beds & Baths Number of Bedrooms: 3Number of Bathrooms: 6Number of Bathrooms (full): 4Number of Bathrooms (half): 2 |
Dimensions and Layout Living Area: 8144 Square Feet |
Appliances & Utilities Appliances: Electric Cooktop, Oven, Convection Oven, Microwave, Range Hood, Refrigerator, Subzero, Dishwasher, Washer, Dryer, Wine Cooler, Water Heater, Tankless Water HeaterDishwasherDryerLaundry: Lower Level,Main Level,Mud RoomMicrowaveRefrigeratorWasher |
Heating & Cooling Heating: Heat Pump,Radiant,Geothermal,PropaneHas CoolingAir Conditioning: Ceiling Fan(s),Central Air,ZonedHas HeatingHeating Fuel: Heat Pump |
Fireplace & Spa Number of Fireplaces: 6Has a Fireplace |
Windows, Doors, Floors & Walls Window: Thermopane WindowsDoor: French Doors |
Levels, Entrance, & Accessibility Elevator |
View Has a ViewView: Water |
Security Security: Security System |
|
|---|
Exterior Home Features Roof: AsphaltPatio / Porch: Covered, Wrap AroundOther Structures: Shed(s)Exterior: Balcony, Lighting, Sidewalk, Stone Wall, Underground SprinklerFoundation: Concrete PerimeterNo Private Pool |
Parking & Garage Number of Garage Spaces: 3Number of Covered Spaces: 3No CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 3Parking: Attached,Garage Door Opener,Private,Circular Driveway,Driveway |
Frontage WaterfrontWaterfront: Waterfront, Lake, Dock or Mooring, Association OptionalOn Waterfront |
Water & Sewer Sewer: Septic Tank |
Finished Area Finished Area (above surface): 5744 Square FeetFinished Area (below surface): 2400 Square Feet |
|
|---|
Year Built Year Built: 2010 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Colonial |
Building Construction Materials: Wood SidingNot a New ConstructionDoes Not Include Home Warranty |
Property Information Parcel Number: 2204157 |
|
|---|
Price List Price: $2,850,000 |
Status Change & Dates Off Market Date: Sat Jul 22 2023Possession Timing: Negotiable |
|
|---|
MLS Status: Closed |
|
|---|
Direction & Address City: Columbia |
School Information Elementary School: Horace W. PorterHigh School: Per Board of Ed |
|
|---|
Building Area Building Area: 8144 Square Feet |
|
|---|
Community Features: Lake, Library, Medical Facilities, Paddle Tennis, Park, Playground, Public Rec Facilities, Tennis Court(s) |
Other Playground |
|
|---|
No HOA |
|
|---|
Lot Area: 1.7 Acres |
|
|---|
Energy Efficiency Features: HVAC, Windows |
|
|---|
BasementMls Number: 170582587Attic: Access Via HatchWater ViewWater View: WaterAbove Grade Unfinished Area: 5744 |
|
|---|
LakeLibraryMedical FacilitiesPaddle TennisParkPlaygroundPublic Rec FacilitiesTennis Court(s) |
Last check for updates: about 3 hours ago
Listed by David S. Holcroft, (860) 690-9238
RE/MAX Precision Realty, (860) 808-2000
Bought with: Ben Castonguay, (860) 874-7900, Sentry Real Estate, (860) 871-2775
Source: Smart MLS, MLS#170582587
Price History for 24 Erdoni Road
| Date | Price | Event | Source |
|---|---|---|---|
| 03/10/2025 | $2,750,000 | Sold | N/A |
| 08/30/2023 | $2,750,000 | Sold | Smart MLS #170582587 |
| 07/24/2023 | $2,850,000 | Pending | Smart MLS #170582587 |
| 07/07/2023 | $2,850,000 | Listed For Sale | Smart MLS #170582587 |
| 10/23/2001 | $265,000 | Sold | N/A |
- Results are loading
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $26,638 |
| Assessment | $910,070 |
Home facts updated by county records
Comparable Sales for 24 Erdoni Road
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.14 | Single-Family Home | $530,000 | 06/20/25 | 3 | 2.5 | 1,645 | |
0.58 | Single-Family Home | $1,950,000 | 05/15/26 | 3 | 3.5 | 3,415 | |
0.60 | Single-Family Home | $890,000 | 07/18/25 | 3 | 3.5 | 3,909 | |
0.64 | Single-Family Home | $580,000 | 12/12/25 | 3 | 3 | 2,554 | |
0.68 | Single-Family Home | $605,000 | 06/06/25 | 3 | 2 | 2,418 | |
0.59 | Single-Family Home | $445,000 | 10/03/25 | 4 | 2 | 2,524 | |
0.93 | Single-Family Home | $525,000 | 10/17/25 | 3 | 2.5 | 2,830 | |
0.90 | Single-Family Home | $365,000 | 12/19/25 | 3 | 2.5 | 1,427 | |
1.03 | Single-Family Home | $435,000 | 05/29/25 | 3 | 2.5 | 1,605 |
Assigned Schools
These are the assigned schools for 24 Erdoni Road.
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.
What Locals Say about Columbia
At least 13 Trulia users voted on each feature.
100 % Say parking is easy
100 % Say car is needed
94 % Say yards are well-kept
89 % Say it's quiet
89 % Say there's wildlife
77 % Say there's holiday spirit
76 % Say it's dog friendly
71 % Say people would walk alone at night
62 % Say neighbors are friendly
59 % Say they plan to stay for at least 5 years
45 % Say kids play outside
38 % Say there are community events
13 % Say streets are well-lit
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
Homes for sale near 24 Erdoni Road
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Homes for rent near 24 Erdoni Road
- Results are loading
Off Market Homes Near 24 Erdoni Road
24 Erdoni Road, Columbia, CT 06237 is a 3 bedroom, 6 bathroom, 8,144 sqft single-family home built in 2010. This property is not currently available for sale. 24 Erdoni Road was last sold on Mar 10, 2025 for $2,750,000 (4% lower than the asking price of $2,850,000). The current Trulia Estimate for 24 Erdoni Road is $2,891,600.