NOT LISTED FOR SALE

24 Shepherds Trail Madison, CT 06443

Estimated Value: $821,001 - $931,000

4 Beds
2.5 Baths
2,974 Sq Ft
$290/Sq Ft Est. Value

Last Sold December 11, 2020

Last sale price $546,000 $184 Per Sq Ft

Est. 58% increase in value since last sale

Current estimated payment $5,418/month

3 Days on Market

Highlights

  • Colonial Architecture
  • Deck
  • 2 Fireplaces
  • Walter C. Polson Upper Middle School Rated A
  • Attic
  • No HOA

About This Home

As of December 2020

What a charmer! This expansive Madison Colonial is located in a desirable neighborhood of upscale homes. Located just a short drive from downtown & the popular "Robert’s" grocery store, this pretty home has everything you’ve been looking for in a classic 4 bed, 2.5 bath home with so many unexpected bonus features. The kitchen offers granite counters, stainless appliances, sliders to one of two decks, access to the mudroom & powder room and is topped off with an oversized island. The dining room is located off the kitchen and features hardwoods, great light and two sweet pocket doors. The family room offers hardwoods, a wood burning fireplace, a bow window and sliders to a newly redone deck. The living room is oversized, flooded with light, features a second wood burning fireplace and another set of sliders to the deck. Upstairs you’ll find 4 well sized bedrooms and access to 2 attic spaces, one of which could be finished into an office or 3rd full bath. The finished downstairs is an added bonus. This area is HUGE (over 1,000 additional square feet!) and offers a den area, play space and ample storage area. Another unexpected bonus is the workshop over the 2 car garage that could be finished into year round space or offers additional storage. Outside you'll find a terrific backyard with loads of room for sports and entertainment. Imagine biking riding, trick or treating or walks around this great neighborhood. A lovely home in a terrific neighborhood that will not last!

Last Agent to Sell the Property

Phoebe Schreiner

William Pitt Sotheby's Int'l License #RES.0803073 Listed on: 10/09/2020

William Pitt Sotheby's Int'l

Last Buyer's Agent

David Brooke

eXp Realty License #REB.0792877

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,220

Year Built

  • Built in 1990

Lot Details

  • 1.89 Acre Lot
  • Cul-De-Sac
  • Level Lot
  • Cleared Lot
  • Property is zoned RU-1

Home Design

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

Interior Spaces

  • 2,974 Sq Ft Home
  • Ceiling Fan
  • 2 Fireplaces
  • Workshop

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Attic

  • Attic Floors
  • Walkup Attic

Partially Finished Basement

  • Heated Basement
  • Basement Fills Entire Space Under The House

Parking

  • 2 Car Attached Garage
  • Parking Deck
  • Private Driveway

Outdoor Features

  • Deck

Schools

  • Kathleen H. Ryerson Elementary School

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,220

Year Built

Built in 1990

Lot Details

1.89 Acres

Listing Details

  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 2974
  • Public Record Living Room Sq Ft: 2974
  • Total Sq Ft: 2974
  • Year Built: 1990
  • Nearby Amenities: Playground/Tot Lot, Private School(s), Stables/Riding
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Yes
  • Radon Mitigation Water Ynu: Yes
  • Public Record Gross Sq Ft: 7818
  • Directions: Route 80 to Summer Hill. Right onto Summer Hill. Shepherds Trail is on the left. 2nd house on the right.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 10
  • Total Bedrooms: 4
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Attic Description: Walk-up, Floored
  • Basement Description: Full, Partially Finished, Heated
  • Appliances: Oven/Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer
  • Additional Rooms: Workshop
  • Laundry Room Location: Main Floor off Kitchen
  • Laundry Room Info: Main Level
  • Attic: Yes

Exterior Features

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

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

  • HOA: No
  • Special Association Assessment Y: No

Lot Info

  • Acres: 1.8900
  • Lot Description: On Cul-De-Sac, Dry, Cleared, Level Lot, Professionally Landscaped
  • Zoning: RU-1

Tax Info

  • Tax Year: July 2020-June 2021
  • Property Tax: 10220
  • Mil Rate Base: 28.350
  • Assessor Parcel Number: 1160531

MLS Schools

  • Elementary School: Kathleen H. Ryerson
  • High School: Per Board of Ed

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 9, 2020
Closed on
Nov 14, 2020
Sold by
Chen Xian and Meng Yilin
Bought by
Prestileo Scott and Prestileo Victoria
Seller's Agent
Phoebe Schreiner
William Pitt Sotheby's Int'l
Buyer's Agent
David Brooke
eXp Realty
List Price
$535,000
Sold Price
$546,000
Premium/Discount to List
$11,000
2.06%
Current Estimated Value
$862,250

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$316,250
Avg. Annual Appreciation
9.06%

Purchase Details

Listed on
Mar 16, 2017
Closed on
Aug 17, 2017
Sold by
Oconnor James P and Oconnor Linda E
Bought by
Meng Yilin and Chen Xian
Seller's Agent
Suzanne Forte
Coldwell Banker Realty
Buyer's Agent
Genther Brohel Team
William Raveis Real Estate
List Price
$519,900
Sold Price
$490,000
Premium/Discount to List
-$29,900
-5.75%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.31%
Original Mortgage
$392,000
Interest Rate
3.96%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 7, 2009
Sold by
Franceschelli George and Franceschelli Maryann
Bought by
Oconnor James P and Oconnor Linda E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$372,500
Interest Rate
5.14%

Purchase Details

Closed on
Oct 16, 1998
Sold by
Dey Donald H and Dey Holly M
Bought by
Francischelli George and Francischelli Maryann

Purchase Details

Closed on
Nov 28, 1989
Sold by
Madison Assoc
Bought by
Dey Donald H
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
Prestileo Scott $546,000 None Available
Meng Yilin $490,000 --
Oconnor James P $553,000 --
Francischelli George $340,000 --
Dey Donald H $85,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Dey Donald H $392,000
Previous Owner Dey Donald H $350,000
Previous Owner Dey Donald H $372,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/11/2020 12/11/20 Sold $546,000 +2.1% $184 / Sq Ft
10/12/2020 10/12/20 Pending -- -- --
10/09/2020 10/09/20 For Sale $535,000 +9.2% $180 / Sq Ft
08/17/2017 08/17/17 Sold $490,000 -3.9% $163 / Sq Ft View Prior Sale
07/04/2017 07/04/17 Pending -- -- --
06/07/2017 06/07/17 Price Changed $509,900 -1.9% $170 / Sq Ft
03/16/2017 03/16/17 For Sale $519,900 -- $173 / 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 $11,172 $498,100 $149,300 $348,800
2024 $10,958 $498,100 $149,300 $348,800
2023 $10,804 $360,500 $114,800 $245,700
2022 $10,602 $360,500 $114,800 $245,700
2021 $10,400 $360,500 $114,800 $245,700
2020 $10,220 $360,500 $114,800 $245,700
2019 $10,220 $360,500 $114,800 $245,700
2018 $10,798 $385,100 $132,800 $252,300
2017 $10,513 $385,100 $132,800 $252,300
2016 $10,201 $385,100 $132,800 $252,300
2015 $9,920 $385,100 $132,800 $252,300
2014 $11,938 $474,300 $148,000 $326,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170345399

SmartMLS

APN: MADI-000136-000000-000002-000011

Your Personal Tour Guide

Ask me questions while you tour the home.