$379,000
OPEN SUN 11AM - 1PM

222 Route 87 Columbia, CT 06237

Estimated payment $2,344/month

3 Beds
1 Bath
1,739 Sq Ft
$218 Price per Sq Ft

Highlights

  • Deck
  • Attic
  • Patio
  • Ranch Style House
  • Porch
  • Shed

About This Home

2 is your lucky number! Sited on a wonderful, verdant lot just moments to the shores of Columbia Lake, this charming ranch features a BRAND NEW roof, new septic system, new well equipment, and new water heater! All of the heavy lifting is done! The perfect canvas for your personal sanctuary awaits! Step inside to a deceivingly spacious and versatile floorplan. With fresh paint, new flooring, & windows in all the right places, The oversized living room is an entertainer's dream with seamless indoor/outdoor flow with slider to a larger deck with pergola. Cheery kitchen features updated appliances & opens to a generously sized dining room with pantry / storage. 2 bright bedrooms share a refreshed hall bath. Need room to expand? Excellent house hacking / blended living potential w the expansive daylit walkout lower level featuring a spacious 3rd BR, large den / flex space, and laundry. Oversized garage w separate work space is a hobbyists dream w plenty of space for tinkering, bikes, kayaks, and more. Outside, enjoy a remarkably private, flat backyard with glorious mature trees, a utility shed, and ample guest parking. All this strollable to Columbia Lake with its public beach and boat launch! A special opportunity in a lake community with fantastic access to outdoor recreation, but easy commutes to UConn, Eastern, & Hartford, and many local amenities. Great value packing a serious punch, come and claim your slice of heaven!

Listing Agent

Tommy Connors

Redfin Corporation Brokerage Phone: (860) 217-7475 License #RES.0824779 Listed on: 05/19/2026

Redfin Corporation

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,864

Year Built

  • Built in 1983

Lot Details

  • 24,829 Sq Ft Lot
  • Stone Wall
  • Property is zoned LAR

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Wood Siding

Interior Spaces

  • Ceiling Fan

Kitchen

  • Oven or Range
  • Microwave

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 1 Full Bathroom

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Attic

  • Attic Fan
  • Attic or Crawl Hatchway Insulated

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior Basement Entry

Parking

  • 1 Car Garage
  • Parking Deck
  • Automatic Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Shed
  • Porch

Location

  • Property is near shops

Utilities

  • Cooling System Mounted In Outer Wall Opening
  • Baseboard Heating
  • Private Company Owned Well
  • Electric Water Heater
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Please see the inclusion exclusions form.
  • Assessor Parcel Number 2206361

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,864

Year Built

Built in 1983

Lot Details

0.57 Acres

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Ranch
  • Sq Ft Est Heated Above Grade: 1168
  • Sq Ft Est Heated Below Grade: 571
  • Total Sq Ft: 1739
  • Year Built: 1983
  • New Construction: No/Resale
  • Nearby Amenities: Lake, Library, Park, Public Rec Facilities, Shopping/Mall
  • Exclusions: Please see the inclusion exclusions form.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Directions: Please use GPS.
  • Office Attribution Contact: (203) 349-8711
  • Reserve Prospect: No
  • Special Features: OpenHouse
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 3
  • Total Bathrooms: 1
  • Full Bathrooms: 1
  • Attic Description: Access Via Hatch
  • Basement Description: Full, Interior Access, Partially Finished, Walk-out
  • Interior Amenities: Auto Garage Door Opener, Cable - Available
  • Appliances: Oven/Range, Microwave, Refrigerator, Washer, Dryer
  • Laundry Room Info: Lower Level
  • Attic: Yes

Exterior Features

  • Exterior Features: Shed, Porch, Deck, Stone Wall, Patio
  • Exterior Siding: Wood
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 1
  • Garage And Parking: Under House Garage

Utilities

  • Cooling System: Attic Fan, Ceiling Fans, Wall Unit
  • Heat Type: Baseboard
  • Heat Fuel Type: Electric
  • Hot Water Description: Electric, Tank Size Unknown
  • Water Source: Private Well
  • Sewer: Septic

Schools

  • Intermediate School: Per Board of Ed

Lot Info

  • Acres: 0.57
  • Lot Description: Lightly Wooded Level Lot
  • Zoning: LAR
  • Parcel #: 2206361

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 3864

MLS Schools

  • Elementary School: Per Board of Ed
  • Middle Jr High School: Per Board of Ed
  • High School: Per Board of Ed

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $3,864 $132,020 $37,380 $94,640
2024 $3,712 $132,020 $37,380 $94,640
2023 $3,421 $132,020 $37,380 $94,640
2022 $3,415 $132,020 $37,380 $94,640
2021 $3,349 $114,200 $34,000 $80,200
2020 $3,349 $114,200 $34,000 $80,200
2019 $3,349 $114,200 $34,000 $80,200
2018 $3,349 $114,200 $34,000 $80,200
2017 $3,298 $114,200 $34,000 $80,200
2016 $3,232 $117,800 $34,000 $83,800
2015 $3,196 $117,800 $34,000 $83,800
2014 $3,196 $117,800 $34,000 $83,800
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/19/2026 05/19/26 For Sale $379,000 +15.5% $218 / Sq Ft
02/21/2024 02/21/24 Sold $328,000 +4.5% $209 / Sq Ft View Prior Sale
01/24/2024 01/24/24 For Sale $314,000 -- $200 / Sq Ft
Source: SmartMLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed -- None Available
Warranty Deed -- None Available
Deed -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $311,600 New Conventional
Closed $311,600 Stand Alone Refi Refinance Of Original Loan
Previous Owner $98,000 No Value Available
Previous Owner $15,000 No Value Available
Previous Owner $85,000 No Value Available
Previous Owner $62,000 No Value Available
Source: Public Records

Source: SmartMLS

MLS Number: 24175744

SmartMLS

APN: COLU-000012B-000000-000051

Your Personal Tour Guide

Ask me questions while you tour the home.