Off Market Apr 2020 for $265K

$462,749

Est. refi paymentEst. refi $2,069/mo

•

1,600

sq ft

54 Hennequin Rd, Columbia, CT 06237

About this home

FANTASTIC 7.5 ACRE PROPERTY, BRING YOUR HORSES, BRING YOUR CARS AND BOATS, BRING YOUR GARDENING SKILLS IF YOU WANT. PROPERTY BOASTS A 50X25 BARN THAT HAS AN AUTO 12’ GARAGE DOOR, CAN PARK AT LEAST 6 CARS WITH WORKSHOPS ATTACHED. ON THE PROPERTY, IT ALSO HAS A HEATED 2 CAR OVERSIZED GARAGE WITH UPPER LEVEL FOR STORAGE, 2 STORY BARN WITH STALLS, GARDEN SHED. SPECTACULAR MAN MADE POND WITH CUSTOM BRIDGE TO OPEN LAND, SURROUNDED BY 80+ ACRES OF TOWN RECREATION PARK. BEAUTIFUL VICTORIAN GAZEBO AND WONDERFUL ROCK ISLANDS. PROPERTY HAS BEEN USED FOR WEDDINGS AND SPECIAL OCCASIONS IN THE PAST. ALSO ONLY ½ MILE TO COLUMBIA LAKE. AND OF COURSE A 1855 ANTIQUE HOME WITH MANY COMFORTS, NEWER THERMOPANE WINDOWS, WIDE WOOD FLOORS AND SOME OAK WOOD FLOORS, 14X14 FORMAL DINING ROOM WITH CHAIR RAILS AND WIDE WOOD FLOORS, COZY LIVING ROOM WITH WOOD FIREPLACE AND BUILT IN SHELVES AND WIDE WOOD FLOORS. FULLY UPDATED BATH WITH QUARTZ COUNTER, TUB SHOWER AND RADIANT HEATED FLOORS. LAUNDRY SHOOT IN CLOSET. HEATED SUNROOM WITH ELECTRIC HEAT FIREPLACE. IN ADDITION, ENTRANCE TO PRIVATE OFFICE. UPSTAIRS YOU WILL FIND A MASTER BEDROOM WITH NEW OAK FLOORS AND 2 WALK IN CLOSETS WITH AN ADDITIONAL HIDDEN STORAGE AREA. QUAINT SITTING AREA. HOME FEATURES 3 ZONE HEATING AND A GENERAC FULL HOME GENERATOR WITH A 300 GAL PROPANE TANK THAT IS OWNED NOT LEASED.

SEPTIC SYSTEM WAS REPLACED 17 YEARS AGO, ROOF ON HOME IS A 50 YEAR SHINGLE THAT IS 3 YEARS OLD. BASEMENT HAS CURTAIN DRAIN INSTALLED. A PLACE YOU CAN ENJOY NATURE AND LIVE COMFORTABLY. YOU SHOULD COME LOOK. GREAT PRICE FOR WHAT YOU ARE GETTING.

Single-familyProperty Type

1855Year Built

7.35 acresLot Size

$289Est. Price/Sq.Ft.

6 car garageParking

Listed by Fred Martins • Berkshire Hathaway NE Prop.

Bought with Lisa Sherman • My Realtor, LLC

Source:Smart MLS #170278885

Redfin Estimate

$462,749

$198K since sold in April 2020$7,000 since August

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUN 18, 2026
$446,000
A
3 beds2 baths1,512 sq ft
234 Route 66, Columbia, CT 06237
SOLD FEB 5, 2026
$250,000
B
3 beds1.5 baths1,828 sq ft
78 Hennequin Rd, Columbia, CT 06237
SOLD JUL 2, 2026
$353,000
C
3 beds1 bath1,232 sq ft
140 West St, Columbia, CT 06237
SOLD JUL 28, 2026
$380,000
D
3 beds1 bath1,940 sq ft
1A Heritage Rd, Columbia, CT 06237
SOLD AUG 28, 2026
$224,000
E
3 beds1.5 baths1,597 sq ft
24 Trumbull Hwy, Lebanon, CT 06249
SOLD AUG 14, 2026
$304,990
F
3 beds1.5 baths1,642 sq ft
51 Marjorie Cir, Hebron, CT 06248

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

Earn from this home

Sell

$249,102

Est. take-home

List your home with Redfin and save $4,627

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,149/mo

Redfin rental estimate

List your home for rent

Market trends in 06237, CT

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

105.2%

+0.4% MoM

Median sale price

$445K

$599 MoM

Avg. days on market

26d

2 days MoM

Recently sold homes

8 MoM

Provided by Redfin

Sale history for 54 Hennequin Rd

Date

Event

Price

Public Records

Apr 16, 2020

Sold

$265,000

$166/sq ft

Smart MLS #170278885

Apr 23, 2020

Pending

—

Apr 15, 2020

Sold

$265,000

$166/sq ft

Mar 8, 2020

Contingent

—

Mar 5, 2020

Listed

$258,883

$162/sq ft

Smart MLS #170175644

Nov 27, 2019

Pending

—

Nov 27, 2019

Listing Removed

—

Nov 12, 2019

Contingent

—

Jun 28, 2019

Price Changed

$269,900

$169/sq ft

Mar 25, 2019

Listed

$279,500

$175/sq ft

Smart MLS #G493943

May 27, 2008

Listing Removed

—

Apr 23, 2008

Listed

$395,000

$247/sq ft

Smart MLS #E166071

Dec 31, 2005

Listing Removed

—

Aug 1, 2005

Listed

$499,900

$312/sq ft

Year

Property tax

Land + Additions

Assessment*

2023

$4,658 (+0.2%)

$60,620 + $119,140

$179,760

2022

$4,650 (+3.5%)

$60,620 + $119,140

$179,760

2021

$4,493

$61,600 + $91,600

$153,200

2020

$4,493

$61,600 + $91,600

$153,200

2019

$4,493

$61,600 + $91,600

$153,200

2018

$4,493 (+1.6%)

$61,600 + $91,600

$153,200

2017

$4,424 (+2.2%)

$61,600 + $91,600

$153,200

2016

$4,330 (+1.1%)

$61,600 + $96,200

$157,800

2014

$4,281

$61,600 + $96,200

$157,800

2011

$4,281

$61,600 + $96,200

$157,800

Tax history for 54 Hennequin Rd

Year

Property tax

Land + Additions

Assessment*

2023

$4,658 (+0.2%)

$60,620 + $119,140

$179,760

2022

$4,650 (+3.5%)

$60,620 + $119,140

$179,760

2021

$4,493

$61,600 + $91,600

$153,200

2020

$4,493

$61,600 + $91,600

$153,200

2019

$4,493

$61,600 + $91,600

$153,200

2018

$4,493 (+1.6%)

$61,600 + $91,600

$153,200

2017

$4,424 (+2.2%)

$61,600 + $91,600

$153,200

2016

$4,330 (+1.1%)

$61,600 + $96,200

$157,800

2014

$4,281

$61,600 + $96,200

$157,800

2011

$4,281

$61,600 + $96,200

$157,800

*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

7.35 Acres

Year renovated

—

Sq. Ft.

1,178

Year built

1850

Style

Single Family Residential

County

Tolland County

APN

2204014

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 14, 2023.

Property details

Parking

Garage Information
Garage & Parking: Tandem, Barn, Unpaved
Garages Number: 6

Interior

Virtual Tour Information
Has Virtual Tour

Interior Information
Total Rooms: 8
Laundry Room Location: LAUNDRY SHOOT IN BATHROOM
Laundry Room Info: Lower Level
Interior Features: Auto Garage Door Opener, Cable - Pre-wired
Thermostat(s)
Fireplaces Total: 1
Cooling System: Window Unit
Appliances Included: Electric Range, Oven/Range, Microwave, Refrigerator, Washer, Dryer

Bathroom Information
# of Baths (Full): 1

Bedroom Information
Beds Total: 3

Room Information
Rooms Additional: Sitting Room, Workshop
Room Count: 10
Basement Description: Full With Hatchway, Unfinished, Interior Access
Has Attic
Attic Description: Access Via Hatch

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Clapboard
Exterior Features: Barn, Garden Area, Gazebo, Patio, Porch-Heated, Shed, Stable, Stone Wall

Lot Information
Lot Description: Farm Land, Open Lot, Cleared, Rolling

Building Information
Foundation Type: Stone
Construction Description: Frame
Color: TAN

Property Information
Waterfront Description: Pond, Lake, Beach, Walk to Water
Property Type: Single Family For Sale
Property Info: Horse Property
Living Area SQFT Per Public Record: 1178
Driveway Type: Private, Circular, Gravel

Financial

Assessments Information
Assessed Value: $153,200

Utilities

Utility Information
Water Source: Private Well
Sewage System: Septic
Hot Water Description: Domestic
Heat Type: Baseboard, Radiant
Heat Fuel Type: Oil, Propane
Fuel Tank Location: In Basement
Energy Features: Generator, Programmable Thermostat, Thermopane Windows

Location

School Information
Middle Jr High School: Per Board of Ed
Intermediate School: Per Board of Ed
High School: Per Board of Ed
Elementary School: Horace W. Porter

Location Information
State: Connecticut
Nearby Amenities: Basketball Court, Lake, Library, Medical Facilities, Playground/Tot Lot, Public Rec Facilities, Tennis Courts
Directions: 384 EAST TO RT 6 EAST RIGHT ON JONATHAN TRUMBULL HWY RIGHT ON LAKE ROAD LEFT ON HENNEQUIN RD
County: Tolland

Public facts

Beds: 3
Baths: 1.0
Sq. Ft.: 1,178
Stories: 1.0
Lot Size: 7.35 acres
Style: Single Family Residential
Year Built: 1850
Year Renovated: —
County: Tolland County
APN: 2204014

Home facts updated by county records on Jul 14, 2023

Other

Documents & Disclosures
Supplement Count Public: 6

Listing Information
Has Home Warranty Offered

Around this home

Schools

Horace W. Porter School

Public PreK-8 • Assigned • 1.1mi

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.31% chance of being in a wildfire in next 30 years

4/10 Heat Factor

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

6/10 Wind Factor

49% 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)

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

$440,000 – $533,000

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

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

Nearby similar homes

$254,900

1 bed1 bath600 sq ft

57 Barry Rd, Coventry, CT 06238

OPEN TODAY, 11AM TO 12PM

$329,900

2 beds1 bath1,109 sq ft

48 Washburn Ave, Coventry, CT 06238

$299,000

3 beds1 bath1,220 sq ft

92 Pine St, Columbia, CT 06237

NEW 27 HRS AGO

$245,000

2 beds1 bath1,056 sq ft

33 Reynolds Dr, Coventry, CT 06238

FOR SALE BY OWNER

$700,000

2 beds1.5 baths1,000 sq ft

605 Route 6, Andover, CT 06232

$559,900

3 beds1.5 baths1,991 sq ft

2865 South St, Coventry, CT 06238

Home values near 54 Hennequin Rd

Data from public records.

Address	Redfin Estimate
41 Hennequin Road, Columbia, CT 3 Beds \| 1 Baths \| 1008 Sq. Ft.	$306,177
46 Hennequin Road, Columbia, CT 3 Beds \| 1 Baths \| 1188 Sq. Ft.	$330,107

Address	Redfin Estimate
47 Hennequin Road, Columbia, CT 3 Beds \| 1 Baths \| 1080 Sq. Ft.	$352,178
69 Hennequin Road, Columbia, CT 3 Beds \| 2 Baths \| 2088 Sq. Ft.	$489,556

Address	Redfin Estimate
71 Hennequin Road, Columbia, CT 3 Beds \| 1 Baths \| 1512 Sq. Ft.	$387,015
68 Hennequin Road, Columbia, CT 4 Beds \| 2 Baths \| 1855 Sq. Ft.	$404,370

Property information provided by Smart MLS when last listed in 2020. 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.

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

Manchester homes for sale
Willimantic homes for sale
Stafford Springs homes for sale

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

About this home

Redfin Estimate

Earn from this home

Market trends in 06237, CT

Sale history for 54 Hennequin Rd

Tax history for 54 Hennequin Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

Home values near 54 Hennequin Rd

More real estate resources