NOT LISTED FOR SALE

218 Farmington Ave Berlin, CT 06037

Estimated Value: $476,406 - $522,000

4 Beds
2 Baths
3,164 Sq Ft
$157/Sq Ft Est. Value

Last Sold June 17, 2024

Last sale price $465,000 $147 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $3,244/month

7 Days on Market

Highlights

  • Colonial Architecture
  • Attic
  • Porch
  • Berlin High School Rated A-
  • 1 Fireplace
  • Covered Deck

About This Home

As of June 2024

Live with comfort. Centrally located 4 bedroom, 2.5 bathroom Colonial with hardwood flooring throughout. Spacious first-floor master suite with en-suite bathroom. Adjacent to the master suite, you'll find a convenient first-floor laundry room, adding ease to your daily routine. This home boasts classic charm and modern convenience. Meticulously maintained residence, offers newer Roof (2016), Windows (2017), Vinyl siding (2019), Hot water heater (2018) and Furnace (2010). Enjoy the outdoors! Flat yard surrounded by beautiful mature trees & perennials. Enjoy the ambiance by relaxing on the covered porch or lounging on the bluestone patio. Unique features around every corner. The sunroom can be used to finish your newest book or be used for a sun-drenched office/playroom-whatever your lifestyle calls for! Upstairs boasts 3 large bedrooms, updated full bathroom and a walk-up attic! The walk-out basement presents an opportunity for a recreation area or home gym, there is even a wet bar! The oversized garage provides plenty of space for parking, storage and workable space. Situated on a flat lot with light tree line, this property offers privacy and tranquility, making it the perfect oasis. Located across the street is Hungerford Nature Center, enjoy walking trails, playground and farm animals! Schedule your private viewing today and experience the timeless allure of this colonial gem. Outdoor audio/visual surveillance. Multiple offers, best & final by 5/14 by 6pm. Thank you!

Last Agent to Sell the Property

Stephanie Rizzo

William Raveis Real Estate License #RES.0805907 Listed on: 05/09/2024

William Raveis Real Estate

Last Buyer's Agent

Joe Finnegan

Finnegan Realtors LLC License #REB.0225107

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,657

Year Built

  • Built in 1925

Lot Details

  • 25,700 Sq Ft Lot
  • Property is zoned R-15

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Stone Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Vinyl Siding

Interior Spaces

  • Whole House Fan
  • Ceiling Fan
  • 1 Fireplace
  • Walkup Attic
  • Laundry on main level

Kitchen

  • Gas Cooktop
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 2 Full Bathrooms

Basement

  • Basement Fills Entire Space Under The House
  • Partial Basement

Parking

  • 2 Car Garage
  • Automatic Garage Door Opener

Outdoor Features

  • Covered Deck
  • Patio
  • Rain Gutters
  • Porch

Location

  • Property is near golf course

Schools

  • Berlin High School

Utilities

  • Window Unit Cooling System
  • Hot Water Heating System
  • Heating System Uses Natural Gas
  • Hot Water Circulator
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Washer & Dryer
  • Assessor Parcel Number 448795

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,657

Year Built

Built in 1925

Lot Details

0.59 Acres

Listing Details

  • Neighborhood: Kensington
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 2206
  • Sq Ft Est Heated Below Grade: 958
  • Total Sq Ft: 3164
  • Year Built: 1925
  • New Construction: No/Resale
  • Nearby Amenities: Golf Course, Library, Park, Playground/Tot Lot
  • Exclusions: Washer & Dryer
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Directions: High Street to Farmington ave/ Porters Pass to Farmington Ave
  • Financing Used: Conventional Fixed
  • Street Type: Avenue
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 4
  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Fireplaces: 1
  • Attic Description: Walk-up
  • Basement Description: Partial, Full
  • Interior Amenities: Auto Garage Door Opener, Cable - Available
  • Appliances: Gas Cooktop, Convection Range, Gas Range, Refrigerator, Freezer, Disposal
  • Laundry Room Location: First Floor
  • Laundry Room Info: Main Level
  • Attic: Yes

Exterior Features

  • Exterior Features: Porch, Gutters, Covered Deck, Patio
  • Exterior Siding: Vinyl Siding
  • Foundation Type: Concrete, Stone
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 2
  • Garage And Parking: Detached Garage

Utilities

  • Cooling System: Ceiling Fans, Whole House Fan, Window Unit
  • Heat Type: Hot Water
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Domestic, 40 Gallon Tank
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected
  • Sewer Assess Description: Kensington Fire district- water & sewer combo. Average $150 quarterly.

Lot Info

  • Acres: 0.59
  • Lot Description: Lightly Wooded Treed Level Lot
  • Flood Zone: No
  • Zoning: R-15
  • Parcel #: 448795

Tax Info

  • Tax Year: July 2023-June 2024
  • Property Tax: 6657

MLS Schools

  • Elementary School: Per Board of Ed
  • High School: Berlin

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 9, 2024
Closed on
Jun 17, 2024
Sold by
Hartshorn Kevin and Hartshorn Stephanie
Bought by
Walsh Amanda R
Seller's Agent
Stephanie Rizzo
William Raveis Real Estate
Buyer's Agent
Joe Finnegan
Finnegan Realtors LLC
List Price
$409,900
Sold Price
$465,000
Premium/Discount to List
$55,100
13.44%
Views
97
Current Estimated Value
$495,602

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$30,602
Avg. Annual Appreciation
3.67%
Original Mortgage
$372,000
Outstanding Balance
$366,142
Interest Rate
7.22%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$129,460

Purchase Details

Closed on
Jul 18, 2019
Sold by
Hartshorn Kevin
Bought by
Hartshorn Kevin and Hartshorn Stephanie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$154,500
Interest Rate
3.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 20, 2009
Sold by
Hewins Dwight M and Hewins Evelyn N
Bought by
Hartshorn Kevin

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$188,400
Interest Rate
4.86%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Feb 3, 1992
Sold by
Holmquist Albin Est
Bought by
Hewins Dwight and Hewins Evelyn
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
Walsh Amanda R $465,000 None Available
Walsh Amanda R $465,000 None Available
Hartshorn Kevin -- --
Hartshorn Kevin -- --
Hartshorn Kevin -- --
Hartshorn Kevin $170,000 --
Hartshorn Kevin $170,000 --
Hewins Dwight $150,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Walsh Amanda R $372,000
Closed Walsh Amanda R $372,000
Previous Owner Hartshorn Kevin $154,500
Previous Owner Hewins Dwight $171,800
Previous Owner Hewins Dwight $188,400
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/17/2024 06/17/24 Sold $465,000 +13.4% $147 / Sq Ft
05/16/2024 05/16/24 Pending -- -- --
05/09/2024 05/09/24 For Sale $409,900 -- $130 / 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 $7,157 $233,500 $88,100 $145,400
2024 $7,054 $233,500 $88,100 $145,400
2023 $6,657 $225,200 $88,100 $137,100
2022 $6,286 $183,200 $78,500 $104,700
2021 $6,216 $183,200 $78,500 $104,700
2020 $6,216 $183,200 $78,500 $104,700
2019 $6,216 $183,200 $78,500 $104,700
2018 $5,857 $180,200 $78,500 $101,700
2017 $5,408 $171,100 $77,800 $93,300
2016 $5,265 $170,900 $77,800 $93,100
2015 $5,187 $170,900 $77,800 $93,100
2014 $4,942 $170,900 $77,800 $93,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24016655

SmartMLS

APN: BERL-000024-000029E-000006

Your Personal Tour Guide

Ask me questions while you tour the home.