This home's estimate is 13.6% higher than the average sale price ($469K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
3 Hennequin Rd, Columbia, CT 06237
About this home
Spectacular contemporary cedar home, only steps (approx. 400') to the Columbia Lake Public Beach. Finished basement. Room for 3 cars-2 side by side, plus another in tandem, custom made cedar garage doors, plus an oversized custom cedar shed. This home features soaring cathedral ceilings, updated kitchen (granite counters), new appliances, central air on 1st floor and in wall units upstairs professional landscaping and stone walls, large composite deck, updated mechanicals, windows and roof. Security system and video system are included. Just move in and enjoy a summer on the lake, boating, fishing, swimming and entertaining. 15000w Generac automatic generator. Columbia high school options are EO Smith or Bolton HS.
Assessor records recently updated to reflect the state square footage.
Redfin Estimate
Earn from this home
List your home with Redfin and save $5,332
Get cash now or lower your monthly rate
List your home for rent
Market trends in 06237, CT
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
Provided by Redfin
Sale history for 3 Hennequin Rd
$102/sq ft
$104/sq ft
$106/sq ft
$109/sq ft
Tax history for 3 Hennequin Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Garage Information
- Garage & Parking: Tandem, Under House Garage
- Garages Number: 3
Interior
- Virtual Tour Information
- Has Virtual Tour
- Interior Information
- Total Rooms: 8
- Laundry Room Info: Lower Level
- Interior Features: Auto Garage Door Opener, Cable - Pre-wired, Open Floor Plan, Security System
- In-Law Apartment: No
- Security System
- Fireplaces Total: 1
- Cooling System: Central Air, Wall Unit
- Appliances Included: Oven/Range, Range Hood, Refrigerator, Dishwasher, Disposal, Washer, Electric Dryer
- Bathroom Information
- # of Baths (Full): 2
- Bedroom Information
- Beds Total: 4
- Room Information
- Rooms Additional: Laundry Room
- Room Count: 10
- Basement Description: Full With Walk-Out, Partially Finished
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Cedar, Wood
- Exterior Features: Deck, Shed, Stone Wall, Underground Utilities, Wrap Around Deck
- Lot Information
- Lot Description: Dry, Cleared, Level Lot, Professionally Landscaped
- Building Information
- Foundation Type: Concrete
- Construction Description: Frame
- Property Information
- Waterfront Description: Lake, Walk to Water
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 2390
Financial
- Assessments Information
- Assessed Value: $200,200
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Septic
- Hot Water Description: 30 Gallon Tank, Oil
- Heat Type: Baseboard, Hot Water, Zoned
- Heat Fuel Type: Oil
- Fuel Tank Location: In Basement
- Energy Features: Programmable Thermostat, Storm Doors, 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: Lake, Park, Public Rec Facilities, Shopping/Mall, Tennis Courts
- Directions: Either Rout 87 to Lake Rd, Left ont Hennequin, on left, or RT 66 to Hennequin, near the end of Hennequin before beach, on Right
- County: Tolland
Public facts
- Beds: 4
- Baths: 2.0
- Sq. Ft.: 2,678
- Stories: 2.0
- Lot Size: 1.21 acres
- Style: Single Family Residential
- Year Built: 1988
- Year Renovated: —
- County: Tolland County
- APN: 2204549
Other
- Documents & Disclosures
- Supplement Count Public: 2
Around this home
Schools
- K - 12
- Preschool & daycare
Public PreK-8 • Assigned • 1.0mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
0.15% chance of being in a wildfire in next 30 years
7 days above 93° expected this year, 16 days in 30 years
47% chance of strong winds in next 30 years
3 unhealthy days expected this year, 4 days in 30 years
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.
Nearby similar homes
Home values near 3 Hennequin Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1828 Sq. Ft. | $427,950 |
4 Beds | 2.5 Baths | 2393 Sq. Ft. | $351,735 |
3 Beds | 2 Baths | 1804 Sq. Ft. | $465,297 |
4 Beds | 2.5 Baths | 2124 Sq. Ft. | $518,801 |
3 Beds | 1 Baths | 1357 Sq. Ft. | $556,935 |
3 Beds | 2.5 Baths | 2522 Sq. Ft. | $475,909 |
3 Beds | 2.5 Baths | 1957 Sq. Ft. | $452,839 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 1076 Sq. Ft. | $301,727 |
3 Beds | 2 Baths | 1918 Sq. Ft. | $452,997 |
3 Beds | 1.5 Baths | 1999 Sq. Ft. | $422,151 |
4 Beds | 2.5 Baths | 2262 Sq. Ft. | $424,561 |
3 Beds | 2 Baths | 1985 Sq. Ft. | $431,531 |
4 Beds | 2.5 Baths | 2016 Sq. Ft. | $475,835 |
3 Beds | 2.5 Baths | 1807 Sq. Ft. | $459,529 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 1200 Sq. Ft. | $380,222 |
3 Beds | 3 Baths | 2595 Sq. Ft. | $592,553 |
3 Beds | 2 Baths | 1454 Sq. Ft. | $429,298 |
4 Beds | 2 Baths | 2265 Sq. Ft. | $435,195 |
4 Beds | 2 Baths | 2512 Sq. Ft. | $491,626 |
3 Beds | 2.5 Baths | 2231 Sq. Ft. | $536,239 |
3 Beds | 3 Baths | 2400 Sq. Ft. | $613,350 |
More real estate resources
- Counties
- Cities
- Popular Searches
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
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.









United States
Canada