564 Route 87, Columbia, CT 06237

4 beds3 baths2,078 sqft Edit

Edit home facts for a more accurate Zestimate.
Sold: $1
Sold on 05/19/15
Zestimate®: $320,242
Est. Refi Payment

Estimated Monthly Payment


Please enter a dollar amount between $1,000 and $200,000,000

30 Year Fixed:
15 Year Fixed:
5/1 ARM:
Estimated taxes & insurance of are not included.
See current rates On

A Zestimate® home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

Get Your Home Report

See Zestimate updates, plus the latest sales and listings in your area.

Zestimate Details

A Zestimate home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

The Value Range is the high and low estimate market value for which Zillow values a home. The more information, the smaller the range, and the more accurate the Zestimate. See data coverage and accuracy table

Don't agree with your home's Zestimate? Owners can edit their home facts to make the Zestimate more accurate. Plus, you can leave an opinion on your Zestimate value below. Just click "Owner Estimate".
-$2,440 Last 30 days
Zestimate range
Rent Zestimate A Rent Zestimate is Zillow's estimated monthly rental price, computed using a proprietary formula. It is a starting point in determining the monthly rental price for a specific property. Learn more

The Rent Range is the high and low estimate for which an apartment or home could rent. The more information we have, the smaller the range, and the more accurate the Rent Zestimate. See data coverage and accuracy table
+$6 Last 30 days
Zestimate range
Zestimate forecast
One year
To see Zestimate forecast
Create a free account

Comparable Homes

Homes like this sold for $205-463K.


Improve This Home's Value

Deck Addition

  • See all Decks

  • Estimated value increase: $8.1K

  • The average cost for a deck addition in Columbia is $10,828.

Mid-Range Major Kitchen Remodel

  • See all Kitchens

  • Estimated value increase: $42.6K

  • The average cost for a mid-range major kitchen remodel in Columbia is $59,476.

Price / Tax History

Home Facts

My Notes

Privacy galore! With a modern design featuring fireplaced living rm, form dining rm and 1st floor master suite, 3 car gar. 3 Season sunrm and in-law w/sep entrance is 1 bed/1 bth/full kitchen. Plenty of room for animals. Shared drive.


  • Lot: 5.22 acres
  • Single Family
  • Built in 1986
  • All time views: 9,439
  • Cooling: None
  • Heating: Baseboard
  • Last sold: May 2015 for $1
  • Last sale price/sqft: $0


  • Flooring: Carpet, Hardwood, Tile
  • Parking: Garage - Attached, 3 spaces

Additional Features

  • Appliances Included: Dishwasher
  • Appliances Included: Disposal
  • Appliances Included: Range
  • Basement Type: Unfinished
  • Electrical: Circuit Breaker
  • Appliances Included: Refrigerator
  • Basement Type: Full Basement
  • Laundry Room Info: First Floor
  • Fuel Tank Description: Above Ground Tank
  • Fuel Type: Oil
  • Park Garage Type: Attached
  • Property Sub Type: Single Family
  • In Law Access: Separate Entry
  • Property Type: Residential
  • Last Status: Active
  • Attic: Crawl Space
  • Tax Year: 15
  • Water Sewer Lien: Neither
  • Sewage System: Septic
  • Sq Ft Source: Town Records
  • Style: Contemporary
  • Water Source: Private Well
  • Exterior Siding: Wood
  • Hot Water Fuel: Domestic
  • Appliances Included: Hood
  • Style: Cape Cod
  • Multi Zone Heat
  • Lot Description: Wooded
  • Cooling System: None
  • Driveway Type: Gravel
  • Heat Type: Baseboard
  • Lot Description: Secluded
  • Area Num: Columbia
  • Mill Rate: 27.1300
  • Neighborhood: Columbia (51)
  • Last Change Type: Deposit - Continue To Show
  • Listing Type: Lease Listing Agreement
  • Transaction Type: Sale
  • Thermopane Windows
  • Status: Deposit - Continue To Show

Appliances Included

  • Dishwasher
  • Garbage disposal
  • Range / Oven
  • Refrigerator

Room Types

  • Laundry room


  • Roof type: Other
  • Room count: 5
  • Stories: 2
  • Structure type: Cape cod


  • Floor size: 2,078 sqft
  • Parcel #: 00133900
  • Zillow Home ID: 58987984

Sell your home on Zillow

If this home is listed on Zillow, it will reach the largest real estate network on the web.*
Forecasted views
if you listed your home for sale
all-time (chart)

Neighborhood: 06237

Zillow predicts 06237 home values will rise 1.4% next year, compared to a 1.4% rise for Columbia as a whole. Among 06237 homes, this home is valued 42.8% more than the midpoint (median) home, but is valued 100% less per square foot.

Foreclosures will be a factor impacting home values in the next several years. In the 06237 market, the number of foreclosures waiting to be sold dropped 4.3% in the last year. The number of unsold foreclosures is 2.3% lower than in Columbia, and 53.8% less than the national average. This lower local number could help 06237 home values rise more quickly than other regions in Columbia.
  read more Less 


    For Sale

    See all nearby listings


    • 74 Clarke Rd
      3 beds, 2.5 baths
      2,250 sqft, 236,530 sqft lot, built in 2005
    See all nearby rentals


    Nearby Schools in Columbia

    GreatSchools ratings give an overview of a school's test results. The ratings are based on a comparison of test results for all schools in the state.

    Disclaimer: School attendance zone boundaries are supplied by Maponics and are subject to change. Check with the applicable school district prior to making a decision based on these boundaries.

    Data by GreatSchools.org