Off market jul 2018 for $630K

$956,391

•

2,442

sq ft

22D Lake Rd, Columbia, CT 06237

About this home

Columbia Lake, direct lake front in a home that is expansive, with large, bright open spaces, open floor plan, first floor bedroom suite, second floor master suite, massive window wall overlooking the lake with a spectacular water view. Walk out basement with in-law suite - perfect for entertaining guests. This home was built in the 1990's with great attention to detail, raised panel wall trim installed in the cathedral ceiling great room, mini split heat pump/central ac system, oil hw baseboard heat, 20kw whole house auto generator system (propane fuel). Hardwood floors and more. Beautiful landscaping, retaining walls, patios. Lower level 3 season room.

Single-familyProperty Type

1991Year Built

10,454 sq ftLot Size

$392Est. Price/Sq.Ft.

2 car garageParking

Listed by Rick Nassiff • Keller Williams Realty

Bought with Steven Piro • Aspen Realty Group

Source:Smart MLS #E10179985

Redfin Estimate

$956,391

$326K since sold in July 2018$1,000 since October

Recently sold homes
Estimate history
Homes for sale

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

SOLD MAY 29, 2026
$408,500
A
3 beds1.5 baths1,564 sq ft
146 Lakeside Dr, Andover, CT 06232
SOLD SEP 30, 2026
$530,000
B
3 beds3 baths2,045 sq ft
87 Windrush Ln, Hebron, CT 06248
SOLD SEP 11, 2026
$500,000
C
3 beds3 baths2,748 sq ft
5 Summit Rd, Columbia, CT 06237
SOLD AUG 5, 2026
$470,000
D
3 beds2.5 baths2,010 sq ft
141 Hop River Rd, Coventry, CT 06238
SOLD SEP 8, 2026
$361,000
E
3 beds2 baths2,472 sq ft
63 Midland Rd, Coventry, CT 06238
SOLD AUG 18, 2026
$1,250,000
F
3 beds3 baths2,416 sq ft
145 Edgewater Dr, Coventry, CT 06238

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

Earn from this home

Sell

$482,409

Est. take-home

List your home with Redfin and save $9,564

Rent

$3,393/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 22D Lake Rd

Public record

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Tolland County

APN

2204625

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Apr 9, 2023.

Property details

Parking

Garage Information
Garage & Parking: Attached Garage
Garages Number: 2

Interior

Virtual Tour Information
Has Virtual Tour

Interior Information
Total Rooms: 8
Laundry Room Location: First Floor
Interior Features: Audio System, Auto Garage Door Opener, Cable - Pre-wired, Open Floor Plan
In-Law Apartment: Yes
In-Law Access: Lower Level
Fireplaces Total: 1
Cooling System: Ceiling Fans, Heat Pump, Whole House Fan
Appliances Included: Oven/Range, Range Hood, Refrigerator, Dishwasher, Disposal, Washer, Dryer

Bathroom Information
# of Baths (Full): 4

Bedroom Information
Beds Total: 3

Room Information
Room Count: 7
Basement Description: Full With Walk-Out, Fully Finished, Walk-out, Apartment, Liveable Space
Attic Description: Access Via Hatch

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Vinyl Siding
Exterior Features: Awnings, Balcony, Deck, Patio, Underground Utilities

Lot Information
Lot Description: Non Conforming Lot, Water View, Level Lot, Professionally Landscaped

Building Information
Foundation Type: Concrete
Construction Description: Frame
Color: Lt Blue

Property Information
Waterfront Description: Direct Waterfront, Frontage, Lake, Dock or Mooring
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 2677
Driveway Type: Shared, Asphalt

Financial

Assessments Information
Assessed Value: $390,300

Rental Information
Lease Purchase YN: No

Utilities

Utility Information
Water Source: Private Well
Sewage System: Septic
Hot Water Description: Domestic, Oil
Heat Type: Baseboard
Heat Fuel Type: Oil
Fuel Tank Location: Above Ground
Energy Features: Generator, Ridge Vents, Storm Doors, Thermopane Windows
Electric Amperage: 200

Location

School Information
Middle Jr High School: Horace W. Porter
Intermediate School: Horace W. Porter
High School: PBOE
Elementary School: Horace W. Porter

Location Information
State: Connecticut
Nearby Amenities: Lake, Park, Public Rec Facilities
Directions: Rt 87 to Lake Rd., just after the public beach on the right.
Direct Waterfront
County: Tolland

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Tolland County
APN: 2204625

Home facts updated by county records on Apr 9, 2023

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

K - 12
Preschool & daycare

Horace W. Porter School

Public PreK-8 • Assigned • 1.2mi

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

4/10 Heat Factor

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

6/10 Wind Factor

58% 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

$909,000 – $1.10M

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

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

Nearby similar homes

FOR SALE BY OWNER

$635,000

4 beds3 baths1,883 sq ft

15 Times Farm Rd, Andover, CT 06232

Oversized barn • Peaceful setting • Access to a river

3D WALKTHROUGH

$995,000

4 beds3 baths3,516 sq ft

106 Hunt Rd, Columbia, CT 06237

Waterfront home • Airbnb opportunity • Landscaped acres

$449,900

3 beds3 baths2,228 sq ft

60 West St, Andover, CT 06232

1.09 acres • Front porch • Wideplank floors

$559,900

3 beds1.5 baths1,991 sq ft

2865 South St, Coventry, CT 06238

Two story barn • Large field area • Sunny kitchen

NEW 32 HRS AGO

$299,900

3 beds1 bath1,336 sq ft

349 Mansfield Ave, Windham, CT 06280

Refreshed kitchen • Granite countertops • Major improvements

$489,000

3 beds2.5 baths3,150 sq ft

252-a route 66 Rte, Columbia, CT 06237

Interior lot • Large lawn • Hardwood floors

Home values near 22D Lake Rd

Data from public records.

Address	Redfin Estimate
21 Lake Rd, Columbia, CT 4 Beds \| 2.5 Baths \| 2124 Sq. Ft.	$518,801
20 Lake Rd, Columbia, CT 3 Beds \| 3 Baths \| 2677 Sq. Ft.	$671,412
26 Lake Rd, Columbia, CT 3 Beds \| 2.5 Baths \| 2163 Sq. Ft.	$477,658
30 Lake Rd, Columbia, CT 4 Beds \| 2 Baths \| 2524 Sq. Ft.	$488,578
22 Lake Rd Apt B, Columbia, CT 4 Beds \| 1.5 Baths \| 579 Sq. Ft.	$556,626
22 Lake Rd Apt C, Columbia, CT 3 Beds \| 1 Baths \| 896 Sq. Ft.	$460,637
9 Webster Ln, Columbia, CT 2 Beds \| 1 Baths \| 683 Sq. Ft.	$489,587

Address	Redfin Estimate
27 Lake Rd, Columbia, CT 4 Beds \| 2 Baths \| 2265 Sq. Ft.	$435,195
25 Lake Rd, Columbia, CT 4 Beds \| 2 Baths \| 2512 Sq. Ft.	$491,626
32 Lake Rd, Columbia, CT 3 Beds \| 2.5 Baths \| 1940 Sq. Ft.	$558,980
24 Lake Rd, Columbia, CT 4 Beds \| 3 Baths \| 2327 Sq. Ft.	$918,552
16 Lake Rd, Columbia, CT 2 Beds \| 2 Baths \| 1692 Sq. Ft.	$1,020,330
18 Lake Rd, Columbia, CT - Beds \| - Baths \| 4682 Sq. Ft.	$444,875
6 Webster Ln, Columbia, CT 3 Beds \| 3.5 Baths \| 2398 Sq. Ft.	$739,375

Address	Redfin Estimate
29 Lake Rd, Columbia, CT 3 Beds \| 2 Baths \| 1985 Sq. Ft.	$431,531
22 Lake Rd, Columbia, CT 4 Beds \| 4 Baths \| 2228 Sq. Ft.	$781,343
28 Lake Rd, Columbia, CT 4 Beds \| 3 Baths \| 3178 Sq. Ft.	$1,285,455
17 Lake Rd, Columbia, CT 4 Beds \| 2.5 Baths \| 2568 Sq. Ft.	$599,000
22 Lake Rd Apt A, Columbia, CT 3 Beds \| 1.5 Baths \| 1750 Sq. Ft.	$563,812
78 Hennequin Rd, Columbia, CT 3 Beds \| 1.5 Baths \| 1828 Sq. Ft.	$427,950
11 Webster Ln, Columbia, CT 3 Beds \| 3 Baths \| 2965 Sq. Ft.	$1,413,559

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

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

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