NOT LISTED FOR SALE

Estimated Value: $898,000 - $923,000

5 Beds
3.5 Baths
3,250 Sq Ft
$280/Sq Ft Est. Value

Last Sold August 16, 2019

Last sale price $517,500 $159 Per Sq Ft

Est. 77% increase in value since last sale

Current estimated payment $6,131/month

40 Days on Market

Highlights

  • Golf Course View
  • Colonial Architecture
  • Fruit Trees
  • Gideon Welles School Rated A
  • ENERGY STAR Certified Homes
  • Deck

About This Home

As of August 2019

LOCATION! LOCATION! LOCATION! TOTALLY REMODELED, like new spacious Colonial in a desirable cul de sac location. This impeccable home has not been lived in since renovated and boasts of a grand entry foyer with a spectacular cascading jeweled light, formal dining room, living room with surround sound, a well appointed cherry dry bar and marble fireplace ready for your entertaining! The all new kitchen is set up with a pantry, new stainless steel appliances, an eat in breakfast nook with great views of your very own orchard with fruit trees, half bath and a second kitchen/butlers pantry! On the upper level you will find 5 generous sized bedrooms including a grand master bedroom with an extensive walk in closet, sliding doors leading out to a balcony and a large master bathroom with Jacuzzi tub, shower and water closet. The second level continues with a Jack & Jill bedroom suite with a full bathroom, laundry room and third full bathroom. The lower level’s full walk out basement steps out to a brick walkway and manicured cleared lot leading to a babbling brook. There is absolutely nothing to do but move in! Everything has been taken care of with all new paint inside and out, new floors throughout, new air conditioning system, new lighting, new paved driveway, new roof and more! This elegant home offers an abundance of light, amazing space, closets and storage. Enjoy the peace, serenity, hiking trails and go for a walk by beautiful Diamond Lake! This property won't last!

Last Agent to Sell the Property

Lisa Mandeville-McGeough

Berkshire Hathaway NE Prop. License #RES.0787964 Listed on: 06/18/2019

Berkshire Hathaway NE Prop.

Last Buyer's Agent

Justin Marino

Marino Realty LLC License #REB.0791818

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,177

Year Built

  • Built in 1995

Lot Details

  • 1.12 Acre Lot
  • Home fronts a stream
  • Cul-De-Sac
  • Sloped Lot
  • Cleared Lot
  • Fruit Trees
  • Partially Wooded Lot
  • Property is zoned PAD

Home Design

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

Interior Spaces

  • 3,250 Sq Ft Home
  • Sound System
  • Wood Burning Stove
  • Self Contained Fireplace Unit Or Insert
  • Mud Room
  • Entrance Foyer
  • Concrete Flooring
  • Golf Course Views
  • Home Security System

Kitchen

  • Built-In Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Ice Maker
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Laundry Room
  • Laundry on upper level
  • Electric Dryer
  • Washer

Attic

  • Attic Floors
  • Storage In Attic
  • Attic or Crawl Hatchway Insulated

Unfinished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • Basement Storage

Parking

  • 2 Car Attached Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Private Driveway

Outdoor Features

  • Walking Distance to Water
  • Balcony
  • Deck
  • Patio
  • Rain Gutters

Schools

  • Smith Middle School
  • Gideon Welles Middle School
  • Glastonbury High School

Utilities

  • Humidifier
  • Humidity Control
  • Zoned Heating and Cooling System
  • Floor Furnace
  • Heating System Uses Oil
  • Heating System Uses Wood
  • Programmable Thermostat
  • Private Company Owned Well
  • Oil Water Heater
  • Fuel Tank Located in Basement
  • Cable TV Available

Additional Features

  • ENERGY STAR Certified Homes
  • Property is near a golf course

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,177

Year Built

Built in 1995

Lot Details

0

Listing Details

  • Neighborhood: East Glastonbury
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 3250
  • Public Record Living Room Sq Ft: 3250
  • Total Sq Ft: 3250
  • Year Built: 1995
  • Nearby Amenities: Golf Course, Medical Facilities, Stables/Riding
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Public Record Gross Sq Ft: 5907
  • Tax Year Updated Dt: 07/29/2019
  • Directions: Hebron Avenue to Marlborough Road to Imperil Drive.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 15
  • Total Bedrooms: 5
  • Total Bathrooms: 4.00
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Attic Description: Access Via Hatch, Floored, Storage Space
  • Basement Description: Full With Walk-Out, Unfinished, Heated, Concrete Floor, Interior Access, Storage
  • Interior Amenities: Audio System, Auto Garage Door Opener, Cable - Available, Humidifier, Security System
  • Appliances: Gas Cooktop, Oven/Range, Wall Oven, Microwave, Range Hood, Refrigerator, Icemaker, Dishwasher, Disposal, Washer, Electric Dryer
  • Additional Rooms: Foyer, Laundry Room, Mud Room
  • Laundry Room Location: Upper Level
  • Laundry Room Info: Upper Level
  • Attic: Yes
  • Street Number Modifier: 80

Exterior Features

  • Exterior Features: Balcony, Deck, Fruit Trees, Gutters, Patio, Sidewalk
  • Exterior Siding: Wood
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Brook, Walk to Water
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garage Parking Info: Attached Garage
  • Garages Number: 2
  • Driveway Type: Private, Paved

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air, Wood/Coal Stove, Zoned
  • Heat Fuel Type: Oil, Wood
  • Fuel Tank Location: In Basement
  • Hot Water Description: Domestic, Oil
  • Water Source: Private Well
  • Sewer: Septic

Condo/Co-op/Association

  • HOA: No

Schools

  • Elementary School: Per Board of Ed
  • Middle School: Smith
  • High School: Glastonbury
  • Intermediate School: Gideon Welles

Green Features

  • Energy Features: Energy Star Rated, Fireplace Insert, Humidistat, Programmable Thermostat

Lot Info

  • Acres: 1.1200
  • Lot Description: On Cul-De-Sac, In Subdivision, Cleared, Golf Course View, Lightly Wooded, Sloping Lot
  • Elevation Certificate: No
  • Flood Zone: No
  • Zoning: PAD

Tax Info

  • Tax Year: July 2019-June 2020
  • Property Tax: 12177
  • Total Assessed Value: 334900
  • Mil Rate Base: 36.360
  • Mil Rate Total: 36.360
  • Assessor Parcel Number: 570470

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 29, 2024
Sold by
Alt Ret and Pilzek
Bought by
Hanfi Sameer H and Pandit Zuha
Current Estimated Value
$916,867

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$779,313
Outstanding Balance
$768,882
Interest Rate
6.77%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$128,273

Purchase Details

Closed on
May 1, 2020
Sold by
Pilzek Anna
Bought by
Alt Ret and Pilzek

Purchase Details

Closed on
Nov 8, 2013
Sold by
Hoffpauir Joseph K
Bought by
Strong-Jefferson Linda

Purchase Details

Closed on
Feb 26, 1999
Sold by
Singh Ruby and Singh Debi
Bought by
Hoffpassir Joseph K and Jefferson Linda S

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 23, 1996
Sold by
Poliakoff Raymond and Stuart Ann
Bought by
Arciero Matthew and Arciero Susan

Purchase Details

Closed on
Jul 5, 1995
Sold by
Jacques & Son Land Dev
Bought by
Singh Rudy and Singh Devi
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
Hanfi Sameer H $866,000 None Available
Hanfi Sameer H $866,000 None Available
Alt Ret -- None Available
Alt Ret -- None Available
Strong-Jefferson Linda -- --
Hoffpassir Joseph K $389,000 --
Arciero Matthew $160,000 --
Singh Rudy $315,000 --
Strong-Jefferson Linda -- --
Hoffpassir Joseph K $389,000 --
Arciero Matthew $160,000 --
Singh Rudy $315,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hanfi Sameer H $779,313
Closed Hanfi Sameer H $779,313
Previous Owner Singh Rudy $135,000
Previous Owner Singh Rudy $289,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/16/2019 08/16/19 Sold $517,500 -1.3% $159 / Sq Ft
07/26/2019 07/26/19 Pending -- -- --
07/09/2019 07/09/19 Price Changed $524,500 -2.8% $161 / Sq Ft
06/16/2019 06/16/19 For Sale $539,500 -- $166 / 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 $13,624 $415,000 $123,000 $292,000
2024 $13,251 $415,000 $123,000 $292,000
2023 $12,869 $415,000 $123,000 $292,000
2022 $12,656 $339,300 $101,500 $237,800
2021 $12,663 $339,300 $101,500 $237,800
2020 $12,520 $339,300 $101,500 $237,800
2019 $12,177 $334,900 $101,500 $233,400
2018 $12,056 $334,900 $101,500 $233,400
2017 $12,467 $332,900 $101,500 $231,400
2016 $12,118 $332,900 $101,500 $231,400
2015 $12,018 $332,900 $101,500 $231,400
2014 $11,868 $332,900 $101,500 $231,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170205059

SmartMLS

APN: GLAS-000008N-003490-S000005