Off market nov 2018 for $355K

$425,401

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

•

1,256

sq ft

149 Route 87, Columbia, CT 06237

About this home

Rare opportunity to own property directly on Beautiful Columbia Lake (281 acre) with year round home across the street! Kayaking, motor boating, swimming, fishing are just some of the activities you can enjoy at beautiful Columbia Lake. This waterfront includes a newer North East Dock, quality aluminum roll out dock for all your swimming and boating fun. This 3 bedroom home has lots of amenities so pack your bags and move right in. Hardwood through out the home with beautiful views of the lake from all angles. Freshly painted interior with newer windows for cooling and heating efficiency. Lovely dining room with a window seat that you can sit and read with lake views, on those stay at home days. This home is 2 properties, one directly on the lake and the other across the street! New septic system to be installed prior to closing. This property is a rare find don't wait to schedule your tour of this waterfront home!

Single-familyProperty Type

1942Year Built

0.65 acresLot Size

$339Est. Price/Sq.Ft.

2 car garageParking

Listed by Janet Swider • eXp Realty

Bought with Michelle Leonard • Better Homes and Gardens Real Estate Executive Real Estate

Source:Smart MLS #170108545

Redfin Estimate

$425,401

$70K since sold in November 2018$2,000 since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 28, 2026
$380,000
A
3 beds1 bath1,940 sq ft
1A Heritage Rd, Columbia, CT 06237
SOLD DEC 16, 2025
$250,000
B
3 beds1.5 baths1,288 sq ft
14 Edgarton Rd, Columbia, CT 06237
SOLD AUG 21, 2026
$357,000
C
3 beds2 baths1,104 sq ft
13 Route 6, Columbia, CT 06237
SOLD BY REDFIN JUL 10, 2026
$369,000
D
3 beds1 bath1,739 sq ft
222 Route 87, Columbia, CT 06237
SOLD JUN 24, 2026
$370,000
E
3 beds1.5 baths1,520 sq ft
127 Lake Rd, Columbia, CT 06237
SOLD JUL 2, 2026
$353,000
F
3 beds1 bath1,232 sq ft
140 West St, Columbia, CT 06237

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

Earn from this home

Sell

$160,898

Est. take-home

List your home with Redfin and save $4,254

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,237/mo

Redfin rental estimate

List your home for rent

Market trends in 06237, CT

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

105.0%

+0.1% MoM

Median sale price

$427K

$126 MoM

Avg. days on market

26d

0 days MoM

Recently sold homes

4 MoM

New listings for sale

COMING SOON
$339,900
2 beds1 bath1,240 sq ft
150 Route 66 Rd, Columbia, CT 06237
$670,000
3 beds2.5 baths2,897 sq ft
3 Wickford Rd, Columbia, CT 06237
See all

Provided by Redfin

Sale history for 149 Route 87

Year

Property tax

Land + Additions

Assessment*

2023

$4,083 (+0.2%)

$58,380 + $99,190

$157,570

2022

$4,076 (−1.9%)

$58,380 + $99,190

$157,570

2021

$4,156

$61,500 + $80,200

$141,700

2020

$4,156 (+1.2%)

$61,500 + $80,200

$141,700

2019

$4,106

$61,500 + $78,500

$140,000

2018

$4,106 (+1.6%)

$61,500 + $78,500

$140,000

2017

$4,043 (+4.8%)

$61,500 + $78,500

$140,000

2016

$3,858 (+1.2%)

$61,500 + $79,100

$140,600

2014

$3,814

$61,500 + $79,100

$140,600

2011

$3,814

$61,500 + $79,100

$140,600

Tax history for 149 Route 87

Year

Property tax

Land + Additions

Assessment*

2023

$4,083 (+0.2%)

$58,380 + $99,190

$157,570

2022

$4,076 (−1.9%)

$58,380 + $99,190

$157,570

2021

$4,156

$61,500 + $80,200

$141,700

2020

$4,156 (+1.2%)

$61,500 + $80,200

$141,700

2019

$4,106

$61,500 + $78,500

$140,000

2018

$4,106 (+1.6%)

$61,500 + $78,500

$140,000

2017

$4,043 (+4.8%)

$61,500 + $78,500

$140,000

2016

$3,858 (+1.2%)

$61,500 + $79,100

$140,600

2014

$3,814

$61,500 + $79,100

$140,600

2011

$3,814

$61,500 + $79,100

$140,600

*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

1.5

Stories

Lot width

—

Lot depth

—

Lot size

0.65 Acres

Year renovated

—

Sq. Ft.

1,378

Year built

1942

Style

Single Family Residential

County

Tolland County

APN

2205277

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 14, 2023.

Property details

Parking

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

Interior

Virtual Tour Information
Has Virtual Tour

Interior Information
Total Rooms: 6
Laundry Room Info: Lower Level
In-Law Apartment: No
Fireplaces Total: 1
Cooling System: Ceiling Fans, Wall Unit, Window Unit
Appliances Included: Oven/Range, Refrigerator, Dishwasher

Bathroom Information
# of Baths (Full): 1
# of Baths (Half): 1

Bedroom Information
Beds Total: 3

Room Information
Room Count: 7
Basement Description: Full With Hatchway

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Vinyl Siding
Exterior Features: Patio, Porch-Enclosed

Lot Information
Lot Description: Open Lot

Building Information
Foundation Type: Concrete
Construction Description: Frame

Property Information
Waterfront Description: Frontage, Lake, Dock or Mooring
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 1256

Financial

Assessments Information
Assessed Value: $140,000

Utilities

Utility Information
Water Source: Private Well
Sewage System: Septic
Hot Water Description: 40 Gallon Tank, Oil
Heat Type: Steam
Heat Fuel Type: Oil
Fuel Tank Location: In Basement
Energy Features: Storm Doors, Thermopane Windows

Location

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

Location Information
State: Connecticut
Nearby Amenities: Lake, Playground/Tot Lot
Directions: Rt. 66 to Rt. 87 towards Andover #149 see both sides of the road for waterfront and home
Direct Waterfront
County: Tolland

Public facts

Beds: 2
Baths: 1.5
Sq. Ft.: 1,378
Stories: 2.0
Lot Size: 0.65 acres
Style: Single Family Residential
Year Built: 1942
Year Renovated: —
County: Tolland County
APN: 2205277

Home facts updated by county records on Jul 14, 2023

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

Horace W. Porter School

Public PreK-8 • Assigned • 1.4mi

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

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

$405,000 – $490,000

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

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

Nearby similar homes

$70,000

Land— sq ft

86 Seagraves Rd, Coventry, CT 06238

$699,900

4 beds3.5 baths3,450 sq ft

146 Long Hill Rd, Andover, CT 06232

$995,000

4 beds3 baths3,516 sq ft

106 Hunt Rd, Columbia, CT 06237

$1,349,000

4 beds5 baths9,174 sq ft

648 Tobacco St, Lebanon, CT 06249

$319,000

3 beds1 bath1,444 sq ft

1914 South St, Coventry, CT 06238

$399,000

3 beds2 baths1,716 sq ft

200 Hemlock Point Dr, Coventry, CT 06238

New listings for sale in 06237

COMING SOON

$339,900

2 beds1 bath1,240 sq ft

150 Route 66 Rd, Columbia, CT 06237

$670,000

3 beds2.5 baths2,897 sq ft

3 Wickford Rd, Columbia, CT 06237

Home values near 149 Route 87

Data from public records.

Address	Redfin Estimate
147 Route 87, Columbia, CT 4 Beds \| 2.5 Baths \| 2080 Sq. Ft.	$439,518
150 Route 87, Columbia, CT 3 Beds \| 3 Baths \| 3897 Sq. Ft.	$934,199

Address	Redfin Estimate
140 Route 87, Columbia, CT 2 Beds \| 2 Baths \| 1304 Sq. Ft.	$561,870
144 Route 87, Columbia, CT 3 Beds \| 2 Baths \| 2200 Sq. Ft.	$810,381

Address	Redfin Estimate
168 Route 87, Columbia, CT 3 Beds \| 2 Baths \| 1430 Sq. Ft.	$620,260
143 Route 87, Columbia, CT 2 Beds \| 2 Baths \| 1108 Sq. Ft.	$375,272

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

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 149 Route 87

Tax history for 149 Route 87

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06237

Home values near 149 Route 87

More real estate resources