Skip to content
Skip to content
TopHapOpen in map
Single Family ResidenceResidential
$418,221$766 / ft²
TopHap EstimateOur estimate of what this home would sell for today, based on nearby sales, the home's size and features, and local price trends. It is a starting point, not an appraisal.· confidence 82How well the pricing models agreed with each other on this home. Higher means the estimate rests on stronger, more consistent data.· as of Jul 14, 2026

196 ROUTE 87

COLUMBIA, CT 06237
2
Beds
1.5
Baths
546 ft²
Living AreaTotal finished area of the structures, from county records. Some counties include shared space like hallways or a building gym, so it may not match a listing.
0.17 ac
Lot SizeThe size of the land the home sits on, from county records.
1929
Year BuiltThe year the home was originally built, according to county records.
1
StoriesHow many floors the home has above ground.
4
RoomsThe total room count in county records. Counties differ on which rooms they count, so compare it loosely.

Valuation

$418K
$344K low$492K high

Tax & Assessment

Property TaxThe property tax billed for this tax year. It usually pays for schools, roads, and local services.$6,755 (2025)
Assessed ValueThe value the county assigns to this home to calculate property tax. It is often lower than what the home would sell for.$230,790 (2025)
Assessed LandThe share of the county's assessed value that comes from the land itself, not the buildings.$191,940
Assessed ImprovementsThe share of the county's assessed value that comes from the buildings and other structures on the land.$38,850
Previous AssessedThe county's assessed value from the year before, useful for seeing how the assessment changed.$230,790
Assessor Market ValueThe county assessor's own opinion of market value. It is separate from our estimate and updates on the county's schedule.$161,553

Climate Risk

Overall riskThe average of the five hazard scores below, on a 0 to 100 scale. Higher means greater projected risk over the coming decades.36
1
FloodProjected flooding risk from rivers, heavy rain, and storm surge, scored 0 to 100. Higher is riskier.
12
WildfireProjected wildfire risk, scored 0 to 100, based on how much land burns in a typical year. Higher is riskier.
52
HeatProjected heat risk, scored 0 to 100, based on how many extremely hot days a year are expected. Higher is riskier.
96
StormProjected risk from heavy rainstorms, scored 0 to 100, based on how often extreme rainfall is expected. Higher is riskier.
21
DroughtProjected water shortage risk, scored 0 to 100. Higher means more strain on the local water supply.

Scores 0–100; higher = greater projected risk.

Property Facts

Property TypeThe broad category the county puts this property in, such as residential or commercial.Single Family Residence
StyleThe architectural style of the home, such as ranch or colonial.Bungalow
CountyCAPITOL
Lot (acres)The size of the land the home sits on, from county records.0.17
ConstructionThe main material the home's frame and walls are built from.Frame (Unspecified)
RoofThe main material covering the roof, such as asphalt shingle or tile.Asphalt
HeatingThe type of heating system in the home.None
PoolWhether the property has a pool, and what kind, such as in-ground.No
FeaturesExtra features found in county records. Records are not complete everywhere, so a missing feature does not always mean the home lacks it.Boat access

Assigned SchoolsThe public schools this address is zoned for. Boundaries change, so confirm with the district before you count on it.

E
Horace W. Porter SchoolB
Elementary · Grades PK–8 · 1.1 mi
H
Bolton High SchoolB
High · Grades 9–12 · 6.2 mi

District: Bolton School District

Neighborhood · ZIP 06237These are comparison scores, not percentages. 100 equals the national average, so 150 means about 50% above average.

CrimeLocal crime compared with the rest of the country, where 100 is average. It reflects things like population density, income, and how crime gets reported.82
Air pollutionOverall air pollution compared with the rest of the country, where 100 is average. Lower is cleaner.114
EarthquakeEarthquake risk and likely building damage compared with the rest of the country, where 100 is average. Scores can run far above 100.63

Index scale: 100 = US average (tick). Lower is better.

Homes occupiedThe share of homes here that someone lives in. The rest sit empty, including vacation and for-sale homes.93%
Bachelor's or higherThe share of adults 25 and older whose highest degree is a bachelor's degree.20%
Poverty rateThe share of people whose household income falls below the federal poverty line, which varies by family size.4.8%
UnemploymentThe share of men 16 and older who are out of work and actively looking. Only men are counted in this figure.1.0%
PopulationHow many people live in this area.5,044
DensityPeople per square mile. Higher numbers mean a more crowded, urban area.241 / mi²
Median incomeThe middle household income here — half of households earn more, half earn less.$133,715
Average incomeThe average household income. It runs higher than the median when a few high earners pull it up.$141,728
Average tempThe average temperature here across a full year.48°F
Annual precipHow much rain and melted snow falls here in a typical year.52 in
SunshineThe share of daylight hours that get direct sun in a typical year, counting cloud cover.56%

Data by ATTOM. Valuations are automated estimates, not appraisals. Photos from Google Street View and may not depict the current property state.

How this home compares

196 Route 87 measured against every home in its neighborhood, its ZIP code and its county, using county assessor records refreshed nightly. A home can stand out in one of those areas and look ordinary in another, because each one holds a different mix of homes.

  • Among the highest price per square foot in Columbia 06237
  • Among the smallest homes in Columbia 06237
  • Among the smallest lots in Columbia 06237
  • Older than 92% of homes in Columbia 06237

What homes are worth in Columbia 06237

Each bar is how many homes fall in that price range. The marker is this home.

This home
$289K$870K

This home is worth more than 41% of homes in Columbia 06237.

How it measures up in Columbia 06237

The dot is this home. The mark in the middle is the typical home in Columbia 06237.

Estimated value$418,221
CheaperTypical $447,648Pricier

Pricier than 41% of homes nearby

Price per ft²$766
CheaperTypical $267Pricier

Pricier than almost all homes nearby

Living area546 ft²
SmallerTypical 1,728 ft²Bigger

Smaller than almost all homes nearby

Lot size0.17 ac
SmallerTypical 1.38 acBigger

Smaller than almost all homes nearby

Year built1929
OlderTypical 1979Newer

Newer than 8% of homes nearby

How 196 Route 87 ranks against every home in each area.
MeasureThis homeColumbia 06237Capitol County
Estimated valuepricier than$418,22141% of homes55% of homes
Price per ft²pricier than$766almost all homesalmost all homes
Living areabigger than546 ft²almost no homesalmost no homes
Lot sizebigger than0.17 acalmost no homes15% of homes
Year builtnewer than19298% of homes14% of homes

About 196 Route 87

How much is 196 Route 87, Columbia, CT worth?

The TopHap Estimate for 196 Route 87, Columbia, CT is $418,221 as of Jul 14, 2026. The likely range is $343,975 to $492,467. The estimate is modelled from recorded sales, assessments and the property's own characteristics — it is not an appraisal.

When did 196 Route 87, Columbia, CT last sell?

196 Route 87, Columbia, CT last sold on Jan 1, 1900, according to the county's recorded deed.

How big is 196 Route 87, Columbia, CT?

196 Route 87, Columbia, CT has 2 bedrooms, 1.5 bathrooms, 546 square feet of living space and a 0.17-acre lot.

When was 196 Route 87, Columbia, CT built?

196 Route 87, Columbia, CT was built in 1929, making it 97 years old. It is a bungalow home. The building has 1 story.

What schools serve 196 Route 87, Columbia, CT?

196 Route 87, Columbia, CT is assigned to Horace W. Porter School (elementary), rated B; Bolton High School (high), rated B. All sit in Bolton School District. Attendance boundaries change — confirm with the district before relying on an assignment.

How does 196 Route 87, Columbia, CT compare to other homes in Columbia 06237?

Among the 2,207 homes in Columbia 06237, it is worth more than 41% of them ($418,221 against a typical $447,648), its price per square foot is higher than almost all of them ($766 against a typical $267), it is bigger than almost none of them (546 ft² against a typical 1,728 ft²), its lot is bigger than almost none of them (0.17 ac against a typical 1.38 ac) and it is newer than 8% of them (1929 against a typical 1979). Measured against all of Capitol County, it is worth more than 55% of homes there. These shares are recounted nightly from the full county assessor record for each area, not from active listings.

What are the property taxes on 196 Route 87, Columbia, CT?

The 2025 property tax bill for 196 Route 87, Columbia, CT was $6,755. The county assessed it at $230,790.

More homes on Route 87

Closest homes

More homes in Columbia 06237

Assigned schools

Explore the area

See this home in context

Open 196 Route 87 on TopHap’s interactive map to compare it against every sale nearby, overlay school zones and flood risk, and run a CMA.

Open in map
A flyover of TopHap's photorealistic 3D map, with recorded sale prices pinned to homes
Search any address, city, zip, or county…3D$1.9M$6.25MOpen in map