NOT LISTED FOR SALE

27 Route 87 Columbia, CT 06237

Estimated Value: $394,000 - $432,000

3 Beds
2 Baths
1,882 Sq Ft
$217/Sq Ft Est. Value

Last Sold May 06, 2022

Last sale price $325,000 $173 Per Sq Ft

Est. 26% increase in value since last sale

Current estimated payment $2,513/month

2 Days on Market

Highlights

  • Above Ground Pool
  • Deck
  • 1 Fireplace
  • Fruit Trees
  • Contemporary Architecture
  • Screened Porch

About This Home

As of May 2022

This 3 bedroom, 2 bathroom contemporary on 1.28 acres has been refreshed throughout in the past 10 years. During a complete exterior renovation in 2017, the roof, siding, rear slider, and all windows were replaced. There are two first floor bedrooms with a master suite loft overlooking an open kitchen/dining/sitting area with a floor to ceiling artisan-built stone propane fireplace. There is also an 8.5'x10' extra room adjacent to the main floor bedrooms that can be used for an office, craft room, or whatever you'd like. The large, 24'x15.5' entertainment living room can be overseen from the kitchen through an open window above the sink. A 2nd full bathroom central to the main floor was 100% remodeled in 2017. Overlook the stock tank pool with filter system and level, open yard from the large, 12.5'x34' screened porch or fieldstone patio deck - both perfect for evenings in three seasons. There is a fenced garden area in a sunny portion of the yard. New garage doors and openers installed in 2014. Well pump and well tank replaced in 2016. Water filtration unit replaced in 2015. New chimney liner, playscape, hot water heater, and generator hook-up with interlock were installed in 2020. There is an invisible pet fence with two collars included that encompasses most of the acreage including the woods. This is a charming country home with plenty of character. All square footages in the floor plans are estimated. The owner of this property is a licensed real estate broker.

Last Agent to Sell the Property

Robert Aheart

Aheart & Associates Realty License #REB.0789741 Listed on: 02/27/2022

Last Buyer's Agent

Marni Lewis

Realty One Group Cutting Edge License #REB.0794593

Realty One Group Cutting Edge

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,910

Year Built

  • Built in 1952

Lot Details

  • 1.28 Acre Lot
  • Stone Wall
  • Fruit Trees
  • Garden
  • Property is zoned RA

Home Design

  • Contemporary Architecture
  • Flat Roof Shape
  • Concrete Foundation
  • Stone Foundation
  • Frame Construction
  • Flat Tile Roof
  • Vinyl Siding
  • Radon Mitigation System

Interior Spaces

  • 1,882 Sq Ft Home
  • 1 Fireplace
  • Thermal Windows
  • Screened Porch
  • Concrete Flooring

Kitchen

  • Electric Cooktop
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Unfinished Basement

  • Partial Basement
  • Sump Pump

Home Security

  • Smart Lights or Controls
  • Smart Thermostat

Parking

  • 2 Car Garage
  • Parking Deck
  • Gravel Driveway

Eco-Friendly Details

  • Energy-Efficient Lighting
  • Pre-Wired For Photovoltaic Solar

Pool

  • Above Ground Pool
  • Pool has a Solar Cover

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Shed
  • Outdoor Grill

Location

  • Property is near a golf course

Utilities

  • Central Air
  • Heating System Uses Oil
  • Programmable Thermostat
  • Power Generator
  • Private Company Owned Well
  • Oil Water Heater
  • Fuel Tank Located in Basement
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 2204102

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,910

Year Built

Built in 1952

Lot Details

0

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Contemporary
  • Sq Ft Est Heated Above Grade: 1882
  • Total Sq Ft: 1882
  • Year Built: 1952
  • New Construction: No/Resale
  • Nearby Amenities: Golf Course, Lake, Library, Medical Facilities, Park, Playground/Tot Lot, Public Rec Facilities, Stables/Riding
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Yes
  • Radon Mitigation Water Ynu: No
  • Public Record Gross Sq Ft: 4374
  • Directions: The home is between Columbia Lake and the Route 87 x Route 6 intersection at the bottom of the hill in Andover. The home is close to the Andover/Columbia line. GPS sometimes prefers 27 Jonathan Trumbull Highway.
  • Financing Used: Cash
  • In Law Apartment: No
  • Living Area Sq Ft Per Public Record: 1882
  • Spec Assoc Asses: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 8
  • Total Bedrooms: 3
  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Fireplaces: 1
  • Basement Description: Partial With Hatchway, Unfinished, Concrete Floor, Sump Pump
  • Interior Amenities: Cable - Pre-wired
  • Appliances: Electric Cooktop, Electric Range, Microwave, Refrigerator, Freezer, Dishwasher, Washer, Dryer
  • Laundry Room Location: Washer/Dryer in concrete basement
  • Laundry Room Info: Lower Level
  • Attic: No
  • Home Automation: Lighting, Thermostat(s)
  • Street Number Modifier: 27

Exterior Features

  • Exterior Features: Deck, Fruit Trees, Garden Area, Grill, Lighting, Patio, Porch-Screened, Shed, Stone Wall
  • Exterior Siding: Vinyl Siding
  • Foundation Type: Concrete, Stone
  • Roof Information: Flat
  • Waterfront Description: Not Applicable
  • Swimming Pool: Yes
  • Pool: Above Ground Pool, Solar Cover
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 2
  • Driveway Type: Private, Asphalt, Gravel
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: 30 Gallon Tank, Oil
  • Water Source: Private Well
  • Sewer: Septic

Schools

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

Green Features

  • Energy Features: Generator Ready, Programmable Thermostat, Thermopane Windows

Lot Info

  • Acres: 1.28
  • Lot Description: Level Lot Lightly Wooded Fence - Electric Pet
  • Zoning: RA
  • Parcel #: 2204102

Tax Info

  • Tax Year: July 2021-June 2022
  • Property Tax: 3910
  • Total Assessed Value: 133300
  • Mil Rate Total: 29.33

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 27, 2022
Closed on
Apr 14, 2022
Sold by
Aheart Robert L
Bought by
Dziubinski Rosemary
Seller's Agent
Robert Aheart
Aheart & Associates Realty
Buyer's Agent
Marni Lewis
Realty One Group Cutting Edge
List Price
$314,999
Sold Price
$325,000
Premium/Discount to List
$10,001
3.17%
Current Estimated Value
$407,875

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$82,875
Avg. Annual Appreciation
6.89%

Purchase Details

Listed on
May 16, 2012
Closed on
Sep 12, 2012
Sold by
Graves-Douville Lyn
Bought by
Aheart Robert L
Seller's Agent
Joseph Marinelli
Carriage Barn Realty
Buyer's Agent
Robert Aheart
Aheart & Associates Realty
List Price
$234,900
Sold Price
$219,000
Premium/Discount to List
-$15,900
-6.77%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.17%
Original Mortgage
$220,190
Interest Rate
3.57%

Purchase Details

Closed on
May 17, 2011
Sold by
Richard J Bourque Lt
Bought by
Graves-Douville Lyn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$160,000
Interest Rate
4.88%

Purchase Details

Closed on
Apr 30, 1992
Sold by
Ramm Anita
Bought by
Bourque Richard
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Dziubinski Rosemary $325,000 None Available
Aheart Robert L $227,000 --
Graves-Douville Lyn $203,000 --
Bourque Richard $150,000 --
Bourque Richard $150,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Bourque Richard $35,000
Previous Owner Bourque Richard $220,190
Previous Owner Bourque Richard $160,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/06/2022 05/06/22 Sold $325,000 +3.2% $173 / Sq Ft
03/11/2022 03/11/22 Pending -- -- --
03/08/2022 03/08/22 For Sale $314,999 +43.8% $167 / Sq Ft
09/07/2012 09/07/12 Sold $219,000 -6.8% $108 / Sq Ft
07/09/2012 07/09/12 Pending -- -- --
05/16/2012 05/16/12 For Sale $234,900 -- $116 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

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 $4,200 $143,500 $37,730 $105,770
2024 $4,035 $143,500 $37,730 $105,770
2023 $3,718 $143,500 $37,730 $105,770
2022 $3,712 $143,500 $37,730 $105,770
2021 $3,910 $133,300 $34,300 $99,000
2020 $3,910 $133,300 $34,300 $99,000
2019 $3,910 $133,300 $34,300 $99,000
2018 $3,596 $122,600 $34,300 $88,300
2017 $3,541 $122,600 $34,300 $88,300
2016 $3,359 $122,400 $34,300 $88,100
2015 $3,321 $122,400 $34,300 $88,100
2014 $3,321 $122,400 $34,300 $88,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170468419

SmartMLS

APN: COLU-000004-000000-000014