NOT LISTED FOR SALE

511 Route 87 Columbia, CT 06237

Estimated Value: $623,513 - $771,000

4 Beds
2.5 Baths
2,864 Sq Ft
$234/Sq Ft Est. Value

Last Sold August 29, 2022

Last sale price $560,000 $196 Per Sq Ft

Est. 20% increase in value since last sale

Current estimated payment $4,169/month

51 Days on Market

Highlights

  • Waterfront
  • Attic
  • Mud Room
  • Contemporary Architecture
  • 1 Fireplace
  • No HOA

About This Home

As of August 2022

Welcome to one of the most meticulously maintained homes you've ever laid your eyes on, complete with some of the most stunning views the town has to offer. You will be greeted every morning with sunrises over the valley right in your very own backyard oasis. The exterior of the home offers stunning landscaping, lush green grass, a paver driveway that makes for an impressive grand entrance. As you enter this home you will be welcomed by an impressive grand foyer & open floor plan with gorgeous natural light as well as a generously sized kitchen with beautiful granite counter tops. The primary suite has recently been updated beautifully & as you make your way upstairs you'll find an additional 3 bedrooms! This home is an amazing space for entertaining, as the homeowners have added a custom, oversized timber tech deck where you'll enjoy your morning coffee or entertain a large party comfortably. Countless updates over the years really shows pride of ownership, impressive updates as follows: Anderson windows installed in every room of the home 3 years ago, completely repainted exterior, a permanently wired generator, a 30 year shingle roof done 9 years ago, BUDERUS furnace installed 5 years ago, oversized two tiered Timber-tech deck installed in 2021, a brand new well installed weeks ago, & APOXY floors throughout all 3 bays of the garage, one bay is used as a work shop is heated as well. Do not miss this opportunity to view this impressive home. Photos to be uploaded July 2nd

Last Agent to Sell the Property

Victoria Tuttle

William Raveis Real Estate License #RES.0815488 Listed on: 06/29/2022

William Raveis Real Estate

Last Buyer's Agent

Kimberly Veronesi

Coldwell Banker Realty License #RES.0757807

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,204

Year Built

  • Built in 1988

Lot Details

  • 1.17 Acre Lot
  • Waterfront
  • Open Lot
  • Property is zoned RA

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Wood Siding

Interior Spaces

  • 2,864 Sq Ft Home
  • 1 Fireplace
  • Mud Room
  • Water Views
  • Basement Fills Entire Space Under The House
  • Attic or Crawl Hatchway Insulated
  • Laundry Room

Kitchen

  • Gas Cooktop
  • Microwave

Bedrooms and Bathrooms

  • 4 Bedrooms

Schools

  • Horace W. Porter Elementary School

Utilities

  • Central Air
  • Baseboard Heating
  • Heating System Uses Oil
  • Private Company Owned Well
  • Fuel Tank Located in Basement

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,204

Year Built

Built in 1988

Lot Details

1.17 Acres

Listing Details

  • Property Type: Single Family For Sale
  • Style: Contemporary
  • Sq Ft Est Heated Above Grade: 2864
  • Public Record Living Room Sq Ft: 2722
  • Total Sq Ft: 2864
  • Year Built: 1988
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Public Record Gross Sq Ft: 7841
  • Tax Year Updated Dt: 07/13/2022
  • Directions: route 6 to route 87
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 1
  • Total Bedrooms: 4
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Attic Description: Access Via Hatch
  • Basement Description: Full With Hatchway
  • Appliances: Gas Cooktop, Microwave
  • Additional Rooms: Laundry Room, Mud Room
  • Attic: Yes

Exterior Features

  • Exterior Siding: Wood
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: View
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garage Parking Info: Attached Garage
  • Garages Number: 3

Utilities

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

Condo/Co-op/Association

  • HOA: No
  • Special Association Assessment Y: No

Lot Info

  • Acres: 1.1700
  • Lot Description: Open Lot
  • Zoning: RA

Tax Info

  • Tax Year: July 2022-June 2023
  • Property Tax: 7204
  • Mil Rate Base: 25.870
  • Assessor Parcel Number: 2457997

MLS Schools

  • Elementary School: Horace W. Porter
  • High School: Per Board of Ed

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 29, 2022
Closed on
Aug 24, 2022
Sold by
Noyes Raplh E and Noyes Kathleen E
Bought by
Stolpe Brett and Stolpe Coleen
Seller's Agent
Victoria Tuttle
William Raveis Real Estate
Buyer's Agent
Kimberly Veronesi
Coldwell Banker Realty
List Price
$585,000
Sold Price
$560,000
Premium/Discount to List
-$25,000
-4.27%
Views
22
Current Estimated Value
$670,628

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$110,628
Avg. Annual Appreciation
5.22%

Purchase Details

Closed on
Jul 15, 1994
Sold by
Kaplan Morris
Bought by
Noyes Ralph and Noyes Kathleen

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$232,750
Interest Rate
3%
Mortgage Type
Unknown
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Stolpe Brett $560,000 None Available
Noyes Ralph $245,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Noyes Ralph $232,200
Previous Owner Noyes Ralph $231,500
Previous Owner Noyes Ralph $232,750
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/29/2022 08/29/22 Sold $560,000 -4.3% $196 / Sq Ft
07/08/2022 07/08/22 For Sale $585,000 -- $204 / Sq Ft
Source: SmartMLS

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 $8,151 $278,460 $58,380 $220,080
2024 $7,830 $278,460 $58,380 $220,080
2023 $7,215 $278,460 $58,380 $220,080
2022 $7,204 $278,460 $58,380 $220,080
2021 $7,221 $246,200 $52,900 $193,300
2020 $7,221 $246,200 $52,900 $193,300
2019 $7,221 $246,200 $52,900 $193,300
2018 $7,221 $246,200 $52,900 $193,300
2017 $7,110 $246,200 $52,900 $193,300
2016 $6,723 $245,000 $52,900 $192,100
2015 $6,647 $245,000 $52,900 $192,100
2014 $6,647 $245,000 $52,900 $192,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170504674

SmartMLS

APN: COLU-000031-000000-000027

Your Personal Tour Guide

Ask me questions while you tour the home.