NOT LISTED FOR SALE

15 Hop Brook Rd Simsbury, CT 06070

Estimated Value: $1,024,017 - $1,267,000

4 Beds
6 Baths
4,800 Sq Ft
$235/Sq Ft Est. Value

Last Sold June 30, 2017

Last sale price $760,000 $158 Per Sq Ft

Est. 48% increase in value since last sale

Current estimated payment $7,921/month

39 Days on Market

Highlights

  • Health Club
  • Barn
  • 2.8 Acre Lot
  • Squadron Line School Rated A
  • Medical Services
  • Open Floorplan

About This Home

As of June 2017

One of Simsbury's most admired homes, Kemper designed and custom built, this stunning Nantucket Cape style residence is set in an idyllic woodland landscape with views of lower Whitman Pond. The professionally landscaped yard features a historic barn, various streams and old foot bridges that can be enjoyed from the lovely 3 season porch. A first floor master bedroom with fireplace and French doors to a private deck boasts marble bath and his & hers closets. Beautifully detailed rooms with bookcases, soaring ceilings, granite kitchen with sitting area, French doors to a quiet study! 3 additional bedrooms up are spacious! Lower level renovation is awesome with raised paneled media area, French doors, fireplace, surround sound (incl in sq ft). Newer furnace, auto transfer generator, newer a/c, garage doors. Enjoy the private Whitman Pond Association for pond side picnics!

Last Agent to Sell the Property

Katie French

Coldwell Banker Realty License #RES.0639139 Listed on: 03/25/2017

Coldwell Banker Realty

Last Buyer's Agent

Suzanne Walsh

William Raveis Real Estate License #RES.0710652

William Raveis Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $20,030

Year Built

  • Built in 1996

Lot Details

  • 2.8 Acre Lot
  • Partially Wooded Lot
  • Garden

HOA Fees

  • $34 Monthly HOA Fees

Home Design

  • Cape Cod Architecture
  • Wood Siding

Interior Spaces

  • 4,800 Sq Ft Home
  • Open Floorplan
  • Ceiling Fan
  • 3 Fireplaces
  • Mud Room
  • Storage In Attic
  • Home Security System

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry Room
  • Dryer

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Parking

  • 3 Car Attached Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Driveway

Outdoor Features

  • Deck
  • Enclosed Patio or Porch

Location

  • Flood Zone Lot
  • Property is near public transit
  • Property is near a golf course

Schools

  • Squadron Line Elementary School
  • Simsbury High School

Farming

  • Barn

Utilities

  • Central Air
  • Heating System Uses Oil
  • Heating System Uses Oil Above Ground
  • Power Generator
  • Private Company Owned Well
  • Oil Water Heater

Community Details

Overview

  • Association fees include lake/beach access

Amenities

  • Medical Services

Recreation

  • Health Club
  • Putting Green

Home Details

Home Type

Single Family

Est. Annual Taxes

$20,030

Year Built

Built in 1996

Lot Details

0

HOA Fees

$34 per month

Listing Details

  • Property Type: Single Family For Sale
  • Potential Short Sale: No
  • Style: Cape Cod
  • Total Sq Ft: 4800
  • Year Built: 1996
  • Nearby Amenities: Commuter Bus, Golf Course, Health Club, Library, Medical Facilities
  • Association Amenities: Putting Green, Health Club, Medical Facilities
  • Easements Right Of Way: of record
  • Direct Waterfront: No
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Directions: Great Pond to Hop Brook.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 9
  • Total Bedrooms: 4
  • Total Bathrooms: 6.00
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Fireplaces: 3
  • Attic Description: Storage Space
  • Basement Description: Full With Walk-Out, Partially Finished
  • Interior Amenities: Auto Garage Door Opener, Open Floor Plan, Security System
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven/Range, Refrigerator
  • Additional Rooms: Laundry Room, Mud Room
  • Laundry Room Location: First Floor
  • Attic: Yes
  • Street Number Modifier: 15

Exterior Features

  • Exterior Features: Barn, Deck, Porch-Enclosed, Garden Area
  • Exterior Siding: Wood
  • Swimming Pool: No

Garage/Parking

  • Garage Parking Info: Attached Garage
  • Garages Number: 3
  • Driveway Type: Asphalt

Utilities

  • Cooling System: Ceiling Fans, Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: Above Ground
  • Hot Water Description: Oil
  • Water Source: Private Well
  • Sewer: Septic

Condo/Co-op/Association

  • Association Fee Includes: Lake/Beach Access
  • HOA Fees: 34
  • HOA Fee Frequency: Monthly
  • HOA: Yes

Schools

  • Elementary School: Squadron Line
  • High School: Simsbury

Green Features

  • Energy Features: Generator

Lot Info

  • Acres: 2.8000
  • Lot Description: Lightly Wooded, Fence - Partial, Professionally Landscaped
  • Flood Zone: Yes

Rental Info

  • Lease Purchase: No

Tax Info

  • Tax Year: July 2016-June 2017
  • Property Tax: 20030
  • Total Assessed Value: 522300
  • Mil Rate Total: 38.350
  • Assessor Parcel Number: 702731

MLS Schools

  • Elementary School: Squadron Line
  • High School: Simsbury

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 25, 2017
Closed on
Jul 6, 2017
Sold by
Hackendorn John and Weaverling Gail
Bought by
Berkowitz Sheila
Seller's Agent
Katie French
Coldwell Banker Realty
Buyer's Agent
Suzanne Walsh
William Raveis Real Estate
List Price
$829,900
Sold Price
$760,000
Premium/Discount to List
-$69,900
-8.42%
Current Estimated Value
$1,125,672

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$365,672
Avg. Annual Appreciation
4.85%

Purchase Details

Closed on
Nov 14, 2005
Sold by
Tranter Ernest J and Tranter Vivienne L
Bought by
Hackendorn John and Weaverling Gail

Purchase Details

Closed on
Mar 29, 1996
Sold by
Whitman Pond Inc
Bought by
Tranter Ernest and Tranter Vivienne
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
Berkowitz Sheila $760,000 --
Hackendorn John $900,000 --
Tranter Ernest $120,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Tranter Ernest $520,000
Previous Owner Tranter Ernest $73,500
Previous Owner Tranter Ernest $640,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/30/2017 06/30/17 Sold $760,000 0.0% $158 / Sq Ft
05/03/2017 05/03/17 Pending -- -- --
04/30/2017 04/30/17 Off Market $760,000 -- --
03/25/2017 03/25/17 For Sale $829,900 -- $173 / 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 $23,027 $674,100 $110,880 $563,220
2024 $22,454 $674,100 $110,880 $563,220
2023 $18,819 $591,430 $110,880 $480,550
2022 $19,918 $515,620 $129,330 $386,290
2021 $19,918 $515,620 $129,330 $386,290
2020 $19,124 $515,620 $129,330 $386,290
2019 $19,243 $515,620 $129,330 $386,290
2018 $19,382 $515,620 $129,330 $386,290
2017 $20,244 $522,300 $141,340 $380,960
2016 $19,388 $522,300 $141,340 $380,960
2015 $19,388 $522,300 $141,340 $380,960
2014 $19,398 $522,300 $141,340 $380,960
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: G10194841

SmartMLS

APN: SIMS-000007E-000303-000001