Google street view image for 242 Lake Rd, Andover, CT 06232

Local rules require you to be signed in to see more photos.

 or  for free with no obligation.

Sold
$533,244
Est. refi paymentEst. refi $1,857/mo
2
bd
•
2 ba
•
1,210
sq ft

242 Lake Rd, Andover, CT 06232

map-entry

About this home

Year-round waterfront home on beautiful andover lake! Remodeled kitchen with quartz countertops, stainless steel appliances,tile flooring. Large living room with gleaming hardwood floors. 3Rd bedroom option in lower level w/closets.Large yard,shed & dock.

Single-familyProperty Type
1968Year Built
10,454 sq ftLot Size
$441Est. Price/Sq.Ft.
Source:Public Records

Redfin Estimate

$533,244
$263K since sold in November 2012$9,000 since September

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

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

Earn from this home

Sell
$500,551
Est. take-home

List your home with Redfin and save $5,332

Refinance
$0
Est. cash available

Get cash now or lower your monthly rate

Rent
$2,447/mo
Redfin rental estimate

List your home for rent

Market trends in 06232, CT

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price
102.6%

4.5% MoM

Median sale price
$572K

$107K MoM

Avg. days on market
9d

2 days MoM

Recently sold homes
4

1 MoM

New listings for sale

Provided by Redfin

Sale history for 242 Lake Rd

Tax history for 242 Lake Rd

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

Public record

Beds
2
Baths
2
Stories
2
Lot width
—
Lot depth
—
Lot size
10,454 Sq. Ft.
Year renovated
—
Sq. Ft.
1,210
Year built
1968
Style
Single Family Residential
County
Tolland County
APN
1598965
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 14, 2023.

Property details

Around this home

Schools

Andover Elementary School

Public PreK-6 • Assigned • 1.3mi

5/10
Rham Middle School

Public 7-8 • Assigned • 3.4mi

7/10
Rham High School

Public 9-12 • Assigned • 3.3mi

9/10
Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Historical weather

Andover, CT • 06232
Average low and high temperatures (°F)
33
19
35
21
52
32
61
41
69
51
80
60
83
65
80
58
75
55
65
45
52
36
38
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Sun exposure

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

8.9 hrs
4.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$507,000 – $614,000

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

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

Nearby similar homes

$549,900
4 beds2 baths2,178 sq ft
261 Hebron Rd, Bolton, CT 06043
$559,900
3 beds1.5 baths1,991 sq ft
2865 South St, Coventry, CT 06238
$689,000
3 beds2.5 baths3,424 sq ft
18 Route 87, Columbia, CT 06237
$299,000
3 beds1 bath1,220 sq ft
92 Pine St, Columbia, CT 06237
FOR SALE BY OWNER
$675,000
4 beds3 baths1,883 sq ft
15 Times Farm Rd, Andover, CT 06232
$459,900
3 beds3 baths2,228 sq ft
60 West St, Andover, CT 06232

New listings for sale in 06232

$459,900
3 beds3 baths2,228 sq ft
60 West St, Andover, CT 06232

Home values near 242 Lake Rd

Data from public records.

More real estate resources

Storrs homes for sale
Manchester homes for sale
Willimantic homes for sale
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

Download the Redfin App on the Apple App Store
Download the Redfin App from the Google Play Store

About us

Why Redfin?
Community Impact
Inclusion
Culture
Press
Investors
Blog
Real Estate News

Find us

Contact Us
Help Center
Advertise

Subsidiaries

Rent.
ApartmentGuide

Affiliated Business

Rocket Close
Rocket Mortgage

Countries

US flagUnited States

Canadian flagCanada

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.

GreatSchools Ratings provided by GreatSchools.org.