NOT LISTED FOR SALE

511 Route 87 Columbia, CT 06237

Estimated Value: $611,000 - $667,000

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

Last Sold August 29, 2022

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

Est. 14% increase in value since last sale

Current estimated payment $4,249/month

51 Days on Market

Highlights

  • Waterfront
  • Attic
  • No HOA
  • Contemporary Architecture
  • 1 Fireplace
  • 3 Car Attached Garage

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
  • Water Views
  • Basement Fills Entire Space Under The House
  • Attic or Crawl Hatchway Insulated

Kitchen

  • Gas Cooktop
  • Microwave

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry in Mud Room
  • Laundry Room

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

0

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
  • Street Number Modifier: 511

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

Schools

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

Lot Info

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

Tax Info

  • Tax Year: July 2022-June 2023
  • Property Tax: 7204
  • Total Assessed Value: 278460
  • Mil Rate Base: 25.870
  • Mil Rate Total: 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%
Total Days on Market
51
Views
22
Current Estimated Value
$640,604

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$80,604
Avg. Annual Appreciation
4.97%

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

Similar Homes in Columbia, CT

  • 27 Latham Hill Rd, Columbia, CT 06237

    $499,900

    • 3 Beds
    • 2.5 Baths
    • 1,836 Sq Ft
    • 27 Latham Hill Rd
    • Columbia, CT

    Welcome to this special 3 bedroom, 2.1 bath Colonial built in 1995, and set privately on 7.74 wooded acres! This home has lots of updates, including a new roof in 2024, new boiler in 2018, new refrigerator in 2022, new stove in 2017, and is wired for generator! The main floor features all hardwood floors, an open living room with pellet stove, dining area with breakfast nook leading to the

    Lynn Minnick Carl Guild & Associates

    Section Image
  • 103 Pine St, Columbia, CT 06237

    $779,000

    • 3 Beds
    • 3 Baths
    • 2,467 Sq Ft
    • 103 Pine St
    • Columbia, CT

    True Country Living on 12+ Acres - Equestrian Estate, Family Compound, or Investment Opportunity Discover the charm of New England living on this private 12+ acre estate-ideal for a horse farm, multigenerational retreat, or potential 3-lot subdivision. Set among scenic ponds, stone walls, and rolling pastures, this versatile property offers peace, privacy, and plenty of possibilities. At its

    David Cappucci KEY Real Estate Services LLC

    Section Image
  • 13 Scalise Dr, Columbia, CT 06237

    $569,900

    • 5 Beds
    • 2.5 Baths
    • 2,730 Sq Ft
    • 13 Scalise Dr
    • Columbia, CT

    SELLER MOTIVATED BRING OFFERS. This 5 room Colonial sits beautifully on 1.19 acres at the end of a Culdesac. A peaceful and quiet location. The main floor features a formal dining room, eat-in kitchen, half bathroom, laundry room, bedroom and a massive front to back living room with a propane fireplace and wet bar. The kitchen has newer stainless steal appliances, an island and granite counter

    Simonne Corriveau KW Legacy Partners

    Section Image
  • 12 Dilaj Dr, Columbia, CT 06237

    $519,900

    • 3 Beds
    • 2.5 Baths
    • 2,240 Sq Ft
    • 12 Dilaj Dr
    • Columbia, CT

    **MULTI OFFERS** Best & Final due by 2pm Saturday 5/31/25 Rarely available "Heritage Farms" Lovely Gambrel Colonial. This custom built, well cared for, original owners, Charming home sits on 1.15 acres. *3 car attached garage. *18x12 fully screened 3 seasoned porch great for relaxing and bird watching. Wide plank Pine wood floors thought entire house. *New Quartz kitchen counters and tile

    Lynsie M. White KW Legacy Partners

    Section Image
  • 33 Erdoni Rd, Columbia, CT 06237

    $499,900

    • 3 Beds
    • 2.5 Baths
    • 1,645 Sq Ft
    • 33 Erdoni Rd
    • Columbia, CT

    An absolutely charming home set on Columbia Lake with year-round views. Set on 1.15 acres, this contemporary lake home offers year round living with lots of glorious natural light, open space, large back yard & plenty of parking. Pulling up, you pass the stone wall with irises, and an expansive front yard. Granite steps lead you up to the front deck - overlooking the grounds and a perfect view of

    Margaret Wilcox William Raveis Real Estate

    Section Image
  • 79 Erdoni Rd, Columbia, CT 06237

    $579,900

    • 3 Beds
    • 2 Baths
    • 2,418 Sq Ft
    • 79 Erdoni Rd
    • Columbia, CT

    Just like Mary Poppins-practically perfect in every way! This charming home, with its picture-perfect front porch, is nestled on a beautifully landscaped lot and feels like new. Inside, an open and airy floor plan welcomes you with elegant cream-colored kitchen cabinets, a granite-topped island, double ovens, and sleek stainless steel appliances. The kitchen flows seamlessly into a cozy breakfast

    Margaret Wilcox William Raveis Real Estate

    Section Image

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
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 Change Sq Ft Price
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 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
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