Off market may 2022 for $305K

$390,372

Est. refi paymentEst. refi $1,194/mo

•

1,730

sq ft

24 Hennequin Rd, Columbia, CT 06237

About this home

LOCATION, LOCATION, LOCATION! Columbia Lake and Columbia Recreational Complex are both a short walk from this wonderful property. A serene country setting with easy access to commuter routes. Enjoy the natural scenery with a variety of mature trees, shrubs and flowering plants. A quaint stone wall runs across the back of this property. Hardwood flooring is found throughout the main level. Large windows and two sliders make this a bright and sunny home. The large main bedroom has sliders to a private deck and double closets. Many of the original mid century modern features can be found in this unique home. Enjoy the natural beauty of this property while relaxing on the back stone patio. The owners of this home have enjoyed watching a wide variety of birds and other wildlife visit this property. The electrical panel will be upgraded to 200 amp before closing. This home well maintained is truly a rare gem.

Single-familyProperty Type

1956Year Built

0.73 acresLot Size

$226Est. Price/Sq.Ft.

1 car garageParking

Listed by Ruth Chandler • RE/MAX Compass

Bought with Erin McNamara • RE/MAX on the Bay

Source:Smart MLS #170468287

Redfin Estimate

$390,372

$85K since sold in May 2022$0 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 1.3% higher than the average sale price ($385K) of 6 comparable homes.

SOLD OCT 15, 2026
$381,000
A
3 beds1.5 baths1,632 sq ft
4 Timber Trl, Columbia, CT 06237
SOLD JUN 24, 2026
$370,000
B
3 beds1.5 baths1,520 sq ft
127 Lake Rd, Columbia, CT 06237
SOLD AUG 21, 2026
$489,000
C
4 beds2.5 baths2,096 sq ft
52 Whitney Rd, Columbia, CT 06237
SOLD MAY 29, 2026
$365,000
D
3 beds2 baths1,682 sq ft
17 Ireland Dr, Coventry, CT 06238
SOLD JAN 7, 2026
$338,000
E
3 beds2 baths1,622 sq ft
26 Edgarton Rd, Columbia, CT 06237
SOLD BY REDFIN JUL 10, 2026
$369,000
F
3 beds1 bath1,739 sq ft
222 Route 87, Columbia, CT 06237

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$142,880

Est. take-home

List your home with Redfin and save $3,904

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,620/mo

Redfin rental estimate

List your home for rent

Market trends in 06237, CT

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

103.7%

1.3% MoM

Median sale price

$381K

$47K MoM

Avg. days on market

32d

6 days MoM

Recently sold homes

10 MoM

Provided by Redfin

Sale history for 24 Hennequin Rd

Join or sign in to view all info

Year

Property tax

Land + Additions

Assessment*

2023

$3,631 (+0.2%)

$43,190 + $96,950

$140,140

2022

$3,625 (−0.2%)

$43,190 + $96,950

$140,140

2021

$3,631

$44,000 + $79,800

$123,800

2020

$3,631

$44,000 + $79,800

$123,800

2019

$3,631

$44,000 + $79,800

$123,800

2018

$3,631 (+1.6%)

$44,000 + $79,800

$123,800

2017

$3,575 (+8.2%)

$44,000 + $79,800

$123,800

2016

$3,304 (+1.2%)

$44,000 + $76,400

$120,400

2014

$3,266

$44,000 + $76,400

$120,400

2011

$3,266

$44,000 + $76,400

$120,400

Tax history for 24 Hennequin Rd

Year

Property tax

Land + Additions

Assessment*

2023

$3,631 (+0.2%)

$43,190 + $96,950

$140,140

2022

$3,625 (−0.2%)

$43,190 + $96,950

$140,140

2021

$3,631

$44,000 + $79,800

$123,800

2020

$3,631

$44,000 + $79,800

$123,800

2019

$3,631

$44,000 + $79,800

$123,800

2018

$3,631 (+1.6%)

$44,000 + $79,800

$123,800

2017

$3,575 (+8.2%)

$44,000 + $79,800

$123,800

2016

$3,304 (+1.2%)

$44,000 + $76,400

$120,400

2014

$3,266

$44,000 + $76,400

$120,400

2011

$3,266

$44,000 + $76,400

$120,400

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

0.73 Acres

Year renovated

—

Sq. Ft.

1,436

Year built

1956

Style

Single Family Residential

County

Tolland County

APN

2204138

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 14, 2023.

Property details

Parking

Garage Information
Garage & Parking: Under House Garage
Garages Number: 1

Interior

Virtual Tour Information
Has Virtual Tour

Interior Information
Total Rooms: 5
Laundry Room Info: Lower Level
Interior Features: Cable - Available
Fireplaces Total: 2
Cooling System: Wall Unit
Appliances Included: Electric Cooktop, Wall Oven, Refrigerator, Dishwasher, Washer, Dryer

Bathroom Information
# of Baths (Full): 2

Bedroom Information
Beds Total: 3

Room Information
Rooms Additional: Workshop
Room Count: 8
Basement Description: Partial With Walk-Out, Partially Finished
Has Attic
Attic Description: Pull-Down Stairs

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Wood
Exterior Features: Deck, Gutters, Patio, Stone Wall

Lot Information
Lot Description: Sloping Lot, Fence - Partial, Fence - Stone

Building Information
Foundation Type: Concrete
Construction Description: Frame

Property Information
Waterfront Description: Walk to Water
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 1436

Financial

Assessments Information
Assessed Value: $123,800

Utilities

Utility Information
Water Source: Private Well
Sewage System: Septic
Hot Water Description: Electric
Heat Type: Hot Air
Heat Fuel Type: Oil
Fuel Tank Location: Above Ground

Location

School Information
High School: Windham
Elementary School: Horace W. Porter

Location Information
State: Connecticut
Nearby Amenities: Basketball Court, Lake, Park, Private School(s), Public Rec Facilities, Shopping/Mall, Tennis Courts
Directions: Rt 6 to Rt 87 then turn a right onto Lake Rd.Take a left onto Hennequin Rd.
County: Tolland

Public facts

Beds: 3
Baths: 2.0
Sq. Ft.: 1,436
Stories: 1.0
Lot Size: 0.73 acres
Style: Single Family Residential
Year Built: 1956
Year Renovated: —
County: Tolland County
APN: 2204138

Home facts updated by county records on Jul 14, 2023

Other

Documents & Disclosures
Supplement Count Public: 3

Around this home

Schools

K - 12
Preschool & daycare

Horace W. Porter School

Public PreK-8 • Assigned • 1.0mi

6/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

3/10 Fire Factor

0.15% chance of being in a wildfire in next 30 years

3/10 Heat Factor

7 days above 93° expected this year, 15 days in 30 years

6/10 Wind Factor

46% chance of strong winds in next 30 years

3/10 Air Factor

3 unhealthy days expected this year, 4 days in 30 years

Provided by First Street

Historical weather

Columbia, CT • 06237

Average low and high temperatures (°F)

33°

18°

36°

19°

52°

31°

61°

40°

68°

49°

80°

59°

83°

64°

80°

57°

75°

55°

63°

44°

52°

35°

38°

23°

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9 hours in June and 4.5 hours in December, placing it below the U.S. average for solar exposure.

9 hrs

4.5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$371,000 – $449,000

Reach more buyers when you sell with Redfin. Save up to $3,904 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$64,900

Land— sq ft

86 Seagraves Rd, Coventry, CT 06238

Listed 61 days

$339,900

4 beds2 baths1,346 sq ft

339 Wall St, Hebron, CT 06248

Picturesque pond • Spacious grounds • 5.95 acre lot

3D WALKTHROUGH

$995,000

4 beds3 baths3,516 sq ft

106 Hunt Rd, Columbia, CT 06237

Waterfront home • Airbnb opportunity • Landscaped acres

$489,000

3 beds2.5 baths3,150 sq ft

252-a route 66 Rte, Columbia, CT 06237

Interior lot • Large lawn • Hardwood floors

NEW 32 HRS AGO

$299,900

3 beds1 bath1,336 sq ft

349 Mansfield Ave, Windham, CT 06280

Refreshed kitchen • Granite countertops • Major improvements

$449,900

3 beds3 baths2,228 sq ft

60 West St, Andover, CT 06232

1.09 acres • Front porch • Wideplank floors

Home values near 24 Hennequin Rd

Data from public records.

Address	Redfin Estimate
17 Hennequin Rd, Columbia, CT 3 Beds \| 2.5 Baths \| 1218 Sq. Ft.	$446,574
37 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1694 Sq. Ft.	$472,820
14 Hennequin Rd Apt A, Columbia, CT 3 Beds \| 2 Baths \| 1431 Sq. Ft.	$394,676
8 Hennequin Rd, Columbia, CT 4 Beds \| 2.5 Baths \| 2393 Sq. Ft.	$351,735
32 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1248 Sq. Ft.	$351,628
40 Hennequin Rd, Columbia, CT 4 Beds \| 1.5 Baths \| 1228 Sq. Ft.	$435,136
36 Hennequin Rd, Columbia, CT 3 Beds \| 3 Baths \| 2129 Sq. Ft.	$455,822

Address	Redfin Estimate
38 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1196 Sq. Ft.	$360,525
33 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1876 Sq. Ft.	$456,893
20 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1144 Sq. Ft.	$408,649
34 Hennequin Rd, Columbia, CT 2 Beds \| 1 Baths \| 1107 Sq. Ft.	$325,100
15 Hennequin Rd, Columbia, CT 3 Beds \| 2.5 Baths \| 1511 Sq. Ft.	$476,342
14 Hennequin Rd, Columbia, CT 4 Beds \| 2 Baths \| 1764 Sq. Ft.	$375,480
13 Hennequin Rd, Columbia, CT 3 Beds \| 2 Baths \| 1286 Sq. Ft.	$413,450

Address	Redfin Estimate
38 Hennequin Rd Apt A, Columbia, CT 4 Beds \| 3.5 Baths \| 3961 Sq. Ft.	$1,030,804
10 Hennequin Rd, Columbia, CT 3 Beds \| 2 Baths \| 1200 Sq. Ft.	$380,222
16 Hennequin Rd, Columbia, CT 3 Beds \| 3 Baths \| 1549 Sq. Ft.	$313,888
26 Hennequin Rd, Columbia, CT 3 Beds \| 2 Baths \| 1736 Sq. Ft.	$416,869
7 Hennequin Rd, Columbia, CT 3 Beds \| 2 Baths \| 1804 Sq. Ft.	$465,297
12 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1999 Sq. Ft.	$422,151
11 Hennequin Rd, Columbia, CT 3 Beds \| 2 Baths \| 1454 Sq. Ft.	$429,298

Property information provided by Smart MLS when last listed in 2022. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Tolland County	Agents near me	Westport, CT homes for sale	Tolland County Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	Tolland County Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

Worcester County homes for sale
Suffolk County homes for sale
Middlesex County homes for sale

Storrs homes for sale
Manchester homes for sale
Willimantic homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06237, CT

Sale history for 24 Hennequin Rd

Tax history for 24 Hennequin Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

Home values near 24 Hennequin Rd

More real estate resources