24 Erdoni Road, Columbia, CT 06237
OFF MARKET

$2,968,000

Trulia Estimate
  • 3 Beds
  • 5 Baths
  • 8,144 sqft (on 1.70 acres)

24 Erdoni Road, Columbia, CT 06237

Est. Refi. Payment $21,223/mo*
Refinance Your Home
Currently Off Market - Sold Mar 10, 2025 for $2,750,000

Home Value

Trulia Estimate
$2.97M
Since last month
Decreased$48K (-1.6%)
Since last year
Increased$154K (+5.5%)
Since last sale
Increased$218K (+7.9%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +390% in the last 10 years
MonthEstimated value
2026
October 2026$2.97M
September 2026$3.02M
August 2026$3.03M
July 2026$2.98M
June 2026$3.05M
May 2026$3.02M
April 2026$2.84M
March 2026$2.87M
February 2026$2.75M
January 2026$2.74M
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
47 Sleepy Hollow Road, Columbia, CT
0.46
Single-Family Home
$2,275,000
05/21/26
5
6
5,534
12 Webster Lane, Columbia, CT
0.58
Single-Family Home
$1,950,000
05/15/26
3
3.5
3,415
74 Erdoni Road, Columbia, CT
0.64
Single-Family Home
$580,000
12/12/25
3
3
2,554
112-A Lake Road, Columbia, CT
0.45
Single-Family Home
$480,000
06/17/26
3
1.5
1,544
9 Gavin Drive, Columbia, CT
1.01
Single-Family Home
$790,000
07/17/26
4
3.5
4,367
127 Lake Road, Columbia, CT
0.62
Single-Family Home
$370,000
06/24/26
3
1.5
1,520
43 Route 87, Columbia, CT
0.90
Single-Family Home
$365,000
12/19/25
3
2.5
1,427
4 Tunxis Drive, Columbia, CT
1.23
Single-Family Home
$676,000
07/22/26
4
2.5
2,538

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
20 Erdoni Rd, Columbia, CT 06237
0.02
$683,300
2
1
1,186
Off Market
18 Erdoni Rd, Columbia, CT 06237
0.04
$1,399,700
3
4
3,509
Off Market
30 Erdoni Rd, Columbia, CT 06237
0.05
$762,000
2
2
2,260
Off Market
17 Erdoni Rd, Columbia, CT 06237
0.07
$451,800
3
2
1,367
Off Market
32 Erdoni Rd, Columbia, CT 06237
0.07
$686,900
3
3
1,300
Off Market
16 Erdoni Rd, Columbia, CT 06237
0.07
$775,600
3
2
2,244
Off Market
15 Erdoni Rd, Columbia, CT 06237
0.08
$379,200
3
2
1,631
Off Market
34 Erdoni Rd, Columbia, CT 06237
0.09
$841,100
3
4
3,196
Off Market
14 Erdoni Rd, Columbia, CT 06237
0.10
$849,300
3
2
1,902
Off Market
7 Erdoni Road, Columbia, CT 06237
0.11
$580,400
4
3.5
3,430
Off Market
12 Erdoni Rd, Columbia, CT 06237
0.12
$885,200
4
3
1,612
Off Market
36 Erdoni Rd, Columbia, CT 06237
0.12
$508,900
1
1
684
Off Market
29 Erdoni Rd, Columbia, CT 06237
0.13
$492,100
4
3
2,285
Off Market
10 Erdoni Rd, Columbia, CT 06237
0.14
$806,900
3
3
1,530
Off Market
19 Erdoni Rd, Columbia, CT 06237
0.14
-
-
-
-
Off Market
33 Erdoni Road, Columbia, CT 06237
0.14
$561,600
3
2.5
1,645
Off Market
5 Erdoni Rd, Columbia, CT 06237
0.16
$502,600
2
3
2,454
Off Market
37 Erdoni Rd, Columbia, CT 06237
0.18
$330,600
3
1
1,072
Off Market
42 Erdoni Rd, Columbia, CT 06237
0.22
$583,900
3
1
956
Off Market
44 Erdoni Rd, Columbia, CT 06237
0.23
$444,200
2
1
796
Off Market

Local Information

  • Map ViewExplore the area around 24 Erdoni Road.
  • Schools1 Preschool School1 Elementary School1 Middle School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Single-Family Home
Built in 2010
1.7 acre lot
8,144 sqft
$364/sqft
3 Car Garage

About this House

What's unique:Handsome fireplacesHigh quality finishesPanoramic water viewsManicured lawnsBeautiful landscaped gardensIce fishing
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.)
24 Erdoni Road, Columbia, CT 06237 is a 3 bedroom, 6 bathroom, 8,144 sqft single-family home built in 2010. It last sold for $2,750,000 on Mar 10, 2025 (4% below the $2,850,000 asking price). This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $2,968,000.
Last check for updates: 1 day 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

Home Details for 24 Erdoni Road

Interior Features

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 Features

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

Property Information

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 & Status

Price
List Price: $2,850,000
Status Change & Dates
Off Market Date: Sat Jul 22 2023Possession Timing: Negotiable

Active Status

MLS Status: Closed

Location

Direction & Address
City: Columbia
School Information
Elementary School: Horace W. PorterHigh School: Per Board of Ed

Building

Building Area
Building Area: 8144 Square Feet

Community

Community Features: Lake, Library, Medical Facilities, Paddle Tennis, Park, Playground, Public Rec Facilities, Tennis Court(s)
Other
Playground

HOA

No HOA

Lot Information

Lot Area: 1.7 Acres

Energy

Energy Efficiency Features: HVAC, Windows

Miscellaneous

BasementMls Number: 170582587Attic: Access Via HatchWater ViewWater View: WaterAbove Grade Unfinished Area: 5744

Additional Information

LakeLibraryMedical FacilitiesPaddle TennisParkPlaygroundPublic Rec FacilitiesTennis Court(s)

Price and Tax history

DateEventPrice
Mar 10, 2025
Source: N/A
Sold
$2,750,000
Aug 30, 2023
Source: Smart MLS #170582587
Sold
$2,750,000
Jul 24, 2023
Source: Smart MLS #170582587
Pending
$2,850,000
Jul 7, 2023
Source: Smart MLS #170582587
Listed For Sale
$2,850,000
Oct 23, 2001
Source: N/A
Sold
$265,000

Market trends in Columbia

Last updated September 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
—
Sale-to-List Price
—
Price per sq ft
—
Available listings
7
1MoM
Sourced by Trulia Market Trends

Around this home

What Locals Say about Columbia

This October

Trick-or-Treat Score

Built from what locals say about this neighborhood.
  • 77% say there's holiday spirit
  • 60% say neighbors are friendly
  • 38% say there are community events
Trulia Trick or TreatStart Ghost Hunt
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

  • 60 % 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.
  • Brittyfra
    "Not the safest road to walk on, but plenty of trails around. Lots of wild life around, quiet road. never any problems."
    1
    Flag
  • Brittyfra
    "no side walks , narrow road and suggest walking dog during day so you are seen. Not busy but some turns are blind. "
    2
    Flag
  • Chathammullins
    "Halloween is safe here. Everyone drives slow and is respectful of each other’s kids. Always wave hello to each other. "
    1
    Flag
  • Chathammullins
    "Great neighborhood for well off middle class folks. People all know each other and it’s a great place to grow up. "
    3
    Flag
  • Axlsmom21
    "I have lived in this neighborhood for 17 years. People are nice, it is quiet and close to shopping and my job. "
    0
    Flag
  • Fran R.
    "Excellent community, schools and town wide involvement."
    0
    Flag

LGBTQ Local Legal Protections

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.

Frequently asked questions about 24 Erdoni Road

  • What is 24 Erdoni Road estimated to be worth?
    Trulia's estimated value for 24 Erdoni Road in Columbia, CT is $2,968,000.
  • What is the price history for 24 Erdoni Road?
    24 Erdoni Road in Columbia, CT last sold for $2,750,000 in March 2025.
  • Is Columbia a buyer's or seller's market?
    Columbia is currently a seller's market, based on recent for-sale activity.
  • What do residents say about Columbia?
    Residents describe Columbia, CT as easy to park in, well-kept, and quiet. Most residents say you need a car. See recently sold homes in Columbia, CT.
  • Does 24 Erdoni Road have air conditioning?
    Yes, 24 Erdoni Road in Columbia, CT has air conditioning.
  • Does 24 Erdoni Road have laundry facilities?
    Yes, 24 Erdoni Road in Columbia, CT has in-unit laundry.

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 24 Erdoni Road

Skip to last item
Skip to first item

Homes for sale near 24 Erdoni Road

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item