481 Route 87
Columbia, CT 06237
5 bd 2 ba 2,835 sqft Built 1890 Lot 74,923 sqft single_family
Most recent sale
$400,000
Apr 15, 2024
Location
Timeline: Sale, Listing & Tax History
Recorded events
| Date | Event | Price | Source |
|---|---|---|---|
| Apr 15, 2024 | Sold | $400,000 | SMARTMLS |
| Aug 22, 2023 | Price changed | $420,000 | SMARTMLS |
| Jul 25, 2023 | Price changed | $434,900 | SMARTMLS |
| Jun 23, 2023 | Listed | $450,000 | SMARTMLS |
| Sep 8, 2022 | Sold | $415,000 | Public Record |
| Jun 23, 2022 | Listed | $395,000 | MLS #170501244 |
| Oct 31, 2005 | Sold | $315,000 | Public Record |
| Jun 8, 2005 | Sold | $200,000 | Public Record |
Tax assessment history
| Year | Building | Land | Total assessed | Tax paid |
|---|---|---|---|---|
| 2025 | $156,730 | $44,100 | $200,830 | $5,878 |
| 2023 | $155,050 | $44,100 | $199,150 | $5,160 |
| 2022 | $155,050 | $44,100 | $199,150 | $5,152 |
| 2021 | $140,300 | $40,000 | $180,300 | $5,288 |
| 2020 | $140,300 | $40,000 | $180,300 | $5,288 |
| 2019 | $140,300 | $40,000 | $180,300 | $5,288 |
| 2018 | $140,300 | $40,000 | $180,300 | $5,288 |
| 2017 | $140,300 | $40,000 | $180,300 | $5,207 |
| 2016 | $111,600 | $40,000 | $151,600 | $4,160 |
| 2015 | $111,600 | $40,000 | $151,600 | $4,113 |
| 2013 | $111,600 | $40,000 | $151,600 | $4,113 |
| 2006 | $96,200 | $28,800 | $125,000 | $3,788 |
| 2005 | $102,100 | $36,680 | $138,780 | $4,136 |
| 2004 | $102,100 | $36,680 | $138,780 | $4,052 |
| 2001 | $100,900 | $35,400 | $136,300 | $3,517 |
Property facts
Year built
1890
Property type
single_family
Stories
—
Beds
5
Baths
2
Living area
2,835 sqft
Lot size
74,923 sqft
ZIP code
06237
City
Columbia
Street
Route 87
Coordinates
41.68516, -72.28188
Comparable properties nearby
Block-level micro-comps
Same street, ±3 house numbers, sold in the last 24 monthsInvestment analysis
Estimates based on local averages — not personalized adviceEstimated monthly rent
$4,253
Gross rental yield
12.76%
Implied cap rate
8.29%
Trend-extrapolated value
—
Frequently asked questions
When did 481 Route 87 last sell?
481 Route 87 most recently sold on Apr 15, 2024 for $400,000.
What is the current tax assessment for 481 Route 87?
The most recent total assessment for 481 Route 87 (year 2025) is $200,830 with $5,878 in property tax.
How does 481 Route 87's assessment compare to its last sale price?
The current assessment is 49.8% below the last sale price of $400,000.
When was 481 Route 87 built?
481 Route 87 was built in 1890.
How does 481 Route 87 compare to others on Route 87?
We track 8 other properties on Route 87. Browse the list under "Other properties on Route 87" to compare beds, baths, and sale history.
What are the property facts for 481 Route 87?
481 Route 87 is a 5 bed, 2 bath, 2,835 sqft, 74,923 sqft lot single_family.
Is 481 Route 87 a flip candidate?
No — 481 Route 87 does not appear in our flips dataset.
Is 481 Route 87 a tax-appeal candidate?
No — 481 Route 87 is not currently flagged as a tax-appeal candidate.
Forecast for this area
ZIP-area linear projection — not a per-property automated valuationQuarterly trend
+4.0%
Implied 1-yr
+15.9%
2026 Q1
$568.3K
2026 Q2
$586.3K
ZIP 06237 — Median Price History + Forecast
Explore nearby
Geography
Other properties on Route 87