NOT LISTED FOR SALE

17 Crestview Dr Madison, CT 06443

Estimated Value: $1,033,000 - $1,272,027

5 Beds
6 Baths
4,460 Sq Ft
$258/Sq Ft Est. Value

Last Sold August 15, 2016

Last sale price $770,000 $173 Per Sq Ft

Est. 50% increase in value since last sale

Current estimated payment $7,344/month

206 Days on Market

Highlights

  • Health Club
  • Wine Cellar
  • Heated In Ground Pool
  • Walter C. Polson Upper Middle School Rated A
  • Medical Services
  • Sub-Zero Refrigerator

About This Home

As of August 2016

Huge price reduction! Amazing new price! This home has all the bells and whistles. Beautiful home, gorgeous setting! Lovely cul-de-sac neighborhood with short walkable trail to two schools.
A new WOW kitchen with custom cabinets, granite countertops, six-burner Viking gas stove, double Viking electric ovens,Sub-zero refrigerator, three-zone 150-bottle Viking wine cooler, Advantium convection microwave oven, and a warming drawer.Level,spacious, private backyard with a heated in ground pool, ideal for touch football games or large parties. Family room with stone fireplace, cathedral ceilings, wet bar, surround sound opens onto a screened-in-porch overlooking the pool. The first floor also includes a mudroom, a living room, an office, and two half baths. The generously master bedroom suite has a huge custom-designed closet/dressing room , full bath and walk-in storage space. The top floor guest bedroom suite includes a new full bath, a cedar closet and storage. The lower level has an additional 900+ square feet of finished space with a gym area, a wine cellar, with custom racks holding in excess of 1200 bottles, a full bath and large amounts of storage space. The house includes a state-of-the-art entertainment center, surround sound in every room, full-yard irrigation system, security system and a whole-house stand-by generator.
This home is only a 5-10 minute drive to Hammonassett Beach State Park and the Madison town beaches.

Last Agent to Sell the Property

Andrea Woolston

Coldwell Banker Realty License #RES.0758669 Listed on: 11/18/2015

Coldwell Banker Realty

Last Buyer's Agent

Jack Hill

Seabury Hill REALTORS License #REB.0795121

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,301

Year Built

  • Built in 1991

Lot Details

  • 1.35 Acre Lot
  • Cul-De-Sac
  • Stone Wall
  • Sprinkler System

Home Design

  • Colonial Architecture
  • Vinyl Siding

Interior Spaces

  • 4,460 Sq Ft Home
  • Ceiling Fan
  • 2 Fireplaces
  • Thermal Windows
  • French Doors
  • Mud Room
  • Wine Cellar
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House
  • Finished Attic
  • Home Security System

Kitchen

  • Built-In Oven
  • Gas Cooktop
  • Microwave
  • Sub-Zero Refrigerator
  • Dishwasher
  • Wine Cooler

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

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

Outdoor Features

  • Heated In Ground Pool
  • Deck
  • Enclosed Patio or Porch

Schools

  • Kathleen H. Ryerson Elementary School
  • Pboe Middle School
  • Daniel Hand High School

Utilities

  • Central Air
  • Heating System Uses Oil
  • Heating System Uses Oil Above Ground
  • Power Generator
  • Private Water Source
  • Oil Water Heater
  • Cable TV Available

Community Details

Overview

  • No Home Owners Association
  • Woodgate Subdivision

Amenities

  • Medical Services

Recreation

  • Health Club
  • Tennis Courts
  • Recreation Facilities
  • Community Playground
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,301

Year Built

Built in 1991

Lot Details

0

Listing Details

  • Property Type: Single Family For Sale
  • Potential Short Sale: No
  • Style: Colonial
  • Total Sq Ft: 4460
  • Year Built: 1991
  • Nearby Amenities: Health Club, Library, Medical Facilities, Park, Playground/Tot Lot, Private Rec Facilities, Private School(s), Tennis Courts
  • Association Amenities: Health Club, Medical Facilities, Park, Playground/Tot Lot, Private Rec Facilities, Tennis Courts
  • Direct Waterfront: No
  • Radon Mitigation Air Ynu: Unknown
  • Radon Mitigation Water Ynu: Unknown
  • Directions: Durham Rd ( rt79) north, right into Woodgate/ High Hill Circle, left onto Crestview
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 11
  • Total Bedrooms: 5
  • Total Bathrooms: 6.00
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Fireplaces: 2
  • Attic Description: Finished
  • Basement Description: Full With Hatchway, Partially Finished
  • Interior Amenities: Auto Garage Door Opener, Cable - Pre-wired, Security System
  • Appliances: Dishwasher, Dryer, Gas Cooktop, Microwave, Subzero, Wall Oven, Washer, Wine Chiller
  • Additional Rooms: Mud Room, Wine Cellar
  • Laundry Room Location: Upper Level
  • Attic: Yes

Exterior Features

  • Exterior Features: Deck, Porch-Enclosed, French Doors, Porch, Underground Sprinkler, Stone Wall
  • Exterior Siding: Vinyl Siding
  • Swimming Pool: Yes
  • Pool: Heated, In Ground Pool

Garage/Parking

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

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 Water System
  • Sewer: Septic

Condo/Co-op/Association

  • HOA: No

Schools

  • Intermediate School: PBOE

Green Features

  • Energy Features: Generator, Thermopane Windows

Lot Info

  • Acres: 1.3500
  • Lot Description: On Cul-De-Sac, Fence - Partial, Fence - Stone

Rental Info

  • Lease Purchase: No

Tax Info

  • Tax Year: July 2015-June 2016
  • Property Tax: 12301
  • Assessor Parcel Number: 1159495

MLS Schools

  • Elementary School: Kathleen H. Ryerson
  • High School: Daniel Hand

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 18, 2015
Closed on
Aug 17, 2016
Sold by
Ruperto Frank A and Ryperto Stephanie F
Bought by
Erlanger Joshua P and Erlanger Nina R
Seller's Agent
Andrea Woolston
Coldwell Banker Realty
Buyer's Agent
Jack Hill
Seabury Hill REALTORS
List Price
$895,000
Sold Price
$770,000
Premium/Discount to List
-$125,000
-13.97%
Current Estimated Value
$1,152,009

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$382,009
Avg. Annual Appreciation
4.42%
Original Mortgage
$616,000
Outstanding Balance
$490,383
Interest Rate
3.41%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$661,626

Purchase Details

Closed on
Dec 14, 2000
Sold by
Connor Catherine M
Bought by
Ruperto Frank A and Ruperto Stephanie F

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$630,000
Interest Rate
8.25%

Purchase Details

Closed on
Dec 5, 1991
Sold by
Baross Thomas L and Baross Genevieve A
Bought by
Bay Co
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
Erlanger Joshua P $770,000 --
Ruperto Frank A $630,000 --
Bay Co $15,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bay Co $616,000
Previous Owner Bay Co $630,000
Previous Owner Bay Co $365,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/15/2016 08/15/16 Sold $770,000 -14.0% $173 / Sq Ft
06/11/2016 06/11/16 Pending -- -- --
11/18/2015 11/18/15 For Sale $895,000 -- $201 / 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 $15,629 $696,800 $196,400 $500,400
2024 $15,330 $696,800 $196,400 $500,400
2023 $15,333 $511,600 $165,300 $346,300
2022 $15,046 $511,600 $165,300 $346,300
2021 $14,760 $511,600 $165,300 $346,300
2020 $14,504 $511,600 $165,300 $346,300
2019 $14,504 $511,600 $165,300 $346,300
2018 $13,409 $478,200 $123,400 $354,800
2017 $13,055 $478,200 $123,400 $354,800
2016 $12,302 $464,400 $123,400 $341,000
2015 $11,963 $464,400 $123,400 $341,000
2014 $15,613 $620,300 $202,500 $417,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: N10094840

SmartMLS

APN: MADI-000110-000000-000004-000001