24 Erdoni Road, Columbia, CT 06237
OFF MARKET

24 Erdoni Road
Columbia, CT 06237

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

$2,994,600

Trulia Estimate
as of Aug 18, 2026
Est. Refi. Payment $20,548/mo*

$2,994,600

Trulia Estimate
as of Aug 18, 2026
Est. Refi. Payment $20,548/mo*
3 Beds
5 Baths
8,144 sqft
(on 1.70 acres)

Home Value

Trulia Estimate
$3M
Since last month
Increased$16K (+0.5%)
Since last year
Increased$211K (+7.6%)
Since last sale
Increased$241K (+8.8%)
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 +389% in the last 10 years
MonthEstimated value
2026
August 2026$2.99M
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
0.46
Single-Family Home
$2,275,000
05/21/26
5
6
5,534
0.58
Single-Family Home
$1,950,000
05/15/26
3
3.5
3,415
0.64
Single-Family Home
$580,000
12/12/25
3
3
2,554
0.45
Single-Family Home
$480,000
06/17/26
3
1.5
1,544
0.59
Single-Family Home
$445,000
10/03/25
4
2
2,524
1.01
Single-Family Home
$790,000
07/17/26
4
3.5
4,367
0.62
Single-Family Home
$370,000
06/24/26
3
1.5
1,520
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

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
0.11
$567,000
4
3.5
3,430
Off Market
0.14
$562,000
3
2.5
1,645
Off Market
0.29
$867,100
3
2.5
2,101
Off Market
0.38
$520,900
4
2.5
2,280
Off Market
0.45
$480,000
3
1.5
1,544
Recently Sold
0.44
$606,100
3
2.5
2,023
Off Market
0.46
$2,275,000
5
6
5,534
Recently Sold
0.49
$625,500
4
2.5
2,128
Off Market
0.50
$602,400
3
2.5
1,972
Off Market
0.62
$370,000
3
1.5
1,520
Recently Sold
0.58
$1,950,000
3
3.5
3,415
Recently Sold

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

Property Type
Single-Family Home
Year Built
2010
Lot Size
1.7 acres
Living Area
8,144 sqft
Price/Sqft
$368
Parking
3 Car Garage

About this House

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). It is currently off market. The Trulia Estimate is $2,994,600, with a rent estimate of $4,784/month.

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)
Last check for updates: about 18 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 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 July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
Sale-to-List Price
Price per sq ft
Available listings
8
5
MoM
Skip to last item
  • Results are loading
Skip to first item

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

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

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Homes for sale near 24 Erdoni Road

Skip to last item
Skip to first item

Off Market Homes Near 24 Erdoni Road

Skip to last item
Skip to first item

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,994,600.
  • 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.
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.