557 Route 87, Columbia, CT 06237
OFF MARKET

557 Route 87
Columbia, CT 06237

  • 3 Beds
  • 1.5 Baths
  • 1,764 sqft (on 1.43 acres)

$445,100

Trulia Estimate
as of May 23, 2026
Est. Refi. Payment $3,080/mo*
Refinance Your Home

$445,100

Trulia Estimate
as of May 23, 2026
Est. Refi. Payment $3,080/mo*
Refinance Your Home
3 Beds
1.5 Baths
1,764 sqft
(on 1.43 acres)

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

This open concept colonial with an attached two car garage awaits its new owners. Upon entering, you will be greeted by a generous and inviting floor plan, perfect for entertaining! The main level features hardwood flooring and large windows that drench the space with natural sunlight. The kitchen boasts a large island, new stainless steel appliances, and plenty of counterspace & cabinets storage. The living room has natural beams ceiling and offers a fireplace w/pellet stove insert. Also on the main level is a spacious dining room and a half-bath with laundry area. The upper level has a total of three bedrooms, and a full bath. The primary bedroom offers two walk in closets. The lower level is unfinished and offers the possibility for additional living space. Enjoy outdoor entertaining on the park-like grounds, consisting of 1.34 acres with a firepit. The lot is huge and offers a lot of options for vegetable and flower gardens or perhaps even a swimming pool. You will enjoy the seasonal views while relaxing on your the large composite deck, all while enjoying a beverage or perhaps a good book. Backyard storage shed. If you like country but don't want to be too far from town or major routes, this house checks all the boxes. This home is a MUST see and Won't last in todays market!
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from July 10, 2024

Home Highlights

Parking
2 Car Garage
Outdoor
Deck
A/C
Heating only
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 557 Route 87

Interior Features

Interior Details
Basement: FullNumber of Rooms: 7Types of Rooms: Master Bedroom, Bedroom, Bathroom, Dining Room, Kitchen, Living Room
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 2Number of Bathrooms (full): 1Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 1764 Square Feet
Appliances & Utilities
Utilities: Cable AvailableAppliances: Electric Range, Range Hood, Refrigerator, Dishwasher, Water HeaterDishwasherLaundry: Lower LevelRefrigerator
Heating & Cooling
Heating: Baseboard,OilNo CoolingAir Conditioning: NoneHas HeatingHeating Fuel: Baseboard
Fireplace & Spa
Number of Fireplaces: 1Has a Fireplace

Exterior Features

Exterior Home Features
Roof: AsphaltPatio / Porch: DeckOther Structures: Shed(s)Exterior: SidewalkFoundation: Concrete PerimeterNo Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Attached,Garage Door Opener
Frontage
Not on Waterfront
Water & Sewer
Sewer: Septic Tank
Finished Area
Finished Area (above surface): 1764 Square Feet

Property Information

Year Built
Year Built: 1986
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Colonial
Building
Construction Materials: Clapboard, Wood SidingNot a New ConstructionDoes Not Include Home Warranty
Property Information
Parcel Number: 2204649

Price & Status

Price
List Price: $339,000
Status Change & Dates
Off Market Date: Mon Jun 19 2023Possession Timing: Negotiable

Active Status

MLS Status: Closed

Media

Location

Direction & Address
City: Columbia
School Information
Elementary School: Horace W. PorterJr High / Middle School: Per Board of EdHigh School: Per Board of Ed

Building

Building Area
Building Area: 1764 Square Feet

Community

Community Features: Basketball Court, Lake, Library, Park, Playground, Private School(s), Public Rec Facilities, Stables/Riding
Other
Playground

HOA

No HOA

Lot Information

Lot Area: 1.43 Acres

Miscellaneous

BasementMls Number: 170567072Above Grade Unfinished Area: 1764

Additional Information

HOA Amenities: None
Last check for updates: about 3 hours ago
Listed by Marie Michaud-Strout, (860) 377-9881
Simply Sold Real Estate, (860) 786-7277
Bought with: Maria S. Aubey, (860) 214-0435, Silver and Oak Realty, (860) 372-4666
Source: Smart MLS, MLS#170567072

Price History for 557 Route 87

DatePriceEventSource
08/01/2023$368,000Sold
Smart MLS #170567072
07/10/2023$339,000PendingSmart MLS #170567072
06/19/2023$339,000ContingentSmart MLS #170567072
06/15/2023$339,000Listed For SaleSmart MLS #170567072
09/29/2021$285,000Sold
Smart MLS #170419132
08/08/2021$289,900ContingentSmart MLS #170419132
07/22/2021$289,900PendingToActiveSmart MLS #170419132
07/17/2021$289,900ContingentSmart MLS #170419132
07/13/2021$289,900Listed For SaleSmart MLS #170419132
02/14/2012$226,000Sold
Smart MLS #G609956
07/12/2004$255,000Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$5,327
Assessment$182,000
Home facts updated by county records

Comparable Sales for 557 Route 87

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
556 Route 87, Columbia, CT
0.07
Single-Family Home
$420,000
07/07/25
4
2.5
1,894
36 Doubleday Road, Columbia, CT
0.89
Single-Family Home
$175,000
01/13/26
3
2
1,200
27 Latham Hill Road, Columbia, CT
0.76
Single-Family Home
$525,000
06/06/25
3
2.5
1,836
98 Trumbull Highway, Lebanon, CT
0.73
Single-Family Home
$432,000
08/28/25
4
2.5
1,845
93 Clarke Road, Lebanon, CT
1.17
Single-Family Home
$375,000
09/04/25
3
1
1,028
201 Trumbull Highway, Lebanon, CT
1.27
Single-Family Home
$365,000
07/17/25
4
2
1,732
2 Doubleday Road, Columbia, CT
1.34
Single-Family Home
$400,000
01/12/26
3
1
1,680
27 Doubleday Road, Columbia, CT
0.94
Single-Family Home
$450,000
09/05/25
4
3.5
2,650
11 Sunrise Drive, Columbia, CT
0.80
Single-Family Home
$810,000
09/05/25
4
3.5
3,396

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 557 Route 87.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Columbia

At least 13 Trulia users voted on each feature.

  • 100 % Say parking is easy

  • 100 % Say car is needed

  • 94 % Say yards are well-kept

  • 89 % Say it's quiet

  • 89 % Say there's wildlife

  • 77 % Say there's holiday spirit

  • 76 % Say it's dog friendly

  • 71 % Say people would walk alone at night

  • 62 % Say neighbors are friendly

  • 59 % Say they plan to stay for at least 5 years

  • 45 % Say kids play outside

  • 38 % Say there are community events

  • 13 % Say streets are well-lit

Sourced by Trulia users. Learn more about our methodology.
  • Brittyfra
    "Not the safest road to walk on, but plenty of trails around. Lots of wild life around, quiet road. never any problems."
    1
    Flag
  • Brittyfra
    "no side walks , narrow road and suggest walking dog during day so you are seen. Not busy but some turns are blind. "
    2
    Flag
  • Chathammullins
    "Halloween is safe here. Everyone drives slow and is respectful of each other’s kids. Always wave hello to each other. "
    1
    Flag
  • Chathammullins
    "Great neighborhood for well off middle class folks. People all know each other and it’s a great place to grow up. "
    3
    Flag
  • Axlsmom21
    "I have lived in this neighborhood for 17 years. People are nice, it is quiet and close to shopping and my job. "
    0
    Flag
  • Fran R.
    "Excellent community, schools and town wide involvement."
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
  • Results are loading
Skip to first item

Homes for sale near 557 Route 87

Skip to last item
Skip to first item

Off Market Homes Near 557 Route 87

Skip to last item
Skip to first item
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Homes for rent near 557 Route 87

Skip to last item
  • Results are loading
Skip to first item
557 Route 87, Columbia, CT 06237 is a 3 bedroom, 2 bathroom, 1,764 sqft single-family home built in 1986. This property is not currently available for sale. 557 Route 87 was last sold on Aug 1, 2023 for $368,000 (9% higher than the asking price of $339,000). The current Trulia Estimate for 557 Route 87 is $445,100.