NOT LISTED FOR SALE

18N062 Hidden Hills Trail Dundee, IL 60118

Estimated Value: $773,000 - $1,186,000

4 Beds
4 Baths
3,650 Sq Ft
$260/Sq Ft Est. Value

Last Sold August 29, 2013

Last sale price $640,000 $175 Per Sq Ft

Est. 48% increase in value since last sale

Current estimated payment $6,659/month

18 Days on Market

Highlights

  • Water Views
  • Landscaped Professionally
  • Wooded Lot
  • Gilberts Elementary School Rated A-
  • Pond
  • Whirlpool Bathtub

About This Home

As of August 2013

Owners have $1,491,000+ invested in their dream home makeover: their loss=your gain. 1-of-a-kind w/6,400+finished sq.ft. Warm & inviting, awesome great rm, gourmet kitchen w/custom cabinetry, granite, 2 SS ovens, KitchenAid. Heated floors in MBA+glass tiles; w/o LL 4 in-law/nanny +2nd kitchen roughed in.Spectacular property w/pond,babbling brook,3-season porch w/FP +terraced gardens; 1 of the finest homes in W.Dundee

Last Agent to Sell the Property

Carol Best

Jameson Sotheby's International Realty License #475124464 Listed on: 06/23/2013

Jameson Sotheby's International Realty

Last Buyer's Agent

Betty Shattuck

Berkshire Hathaway HomeServices Starck Real Estate

Berkshire Hathaway HomeServices Starck Real Estate

Property Details

Home Type

  • Other

Est. Annual Taxes

  • $16,851

Year Built

  • 2009

Lot Details

  • Cul-De-Sac
  • Landscaped Professionally
  • Irregular Lot
  • Wooded Lot

HOA Fees

  • $8 per month

Parking

  • Garage
  • Garage Transmitter
  • Garage Door Opener
  • Circular Driveway

Home Design

  • Slab Foundation
  • Asphalt Shingled Roof
  • Stone Siding
  • Cedar

Interior Spaces

  • Formal Dining Room
  • Water Views

Kitchen

  • Microwave
  • High End Refrigerator
  • Dishwasher

Bedrooms and Bathrooms

  • Primary Bathroom is a Full Bathroom
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry
  • Finished Basement Bathroom

Outdoor Features

  • Pond

Schools

  • Gilberts Elementary School
  • Hampshire High School

Utilities

  • Central Air
  • Well
  • Private or Community Septic Tank

Property Details

Home Type

Other

Est. Annual Taxes

$16,851

Year Built

2009

Lot Details

0

HOA Fees

$8 per month

Parking

3

Interior Features

  • Total # Of Rooms: 10
  • Appliances: Microwave, Dishwasher, High End Refrigerator, Washer, Dryer
  • Equipment: Humidifier, Water-Softener Owned, Central Vacuum, Security System, CO Detectors, Ceiling Fan, Sump Pump, Air Exchanger
  • Fireplace Type/Details: Wood Burning, Gas Logs, Gas Starter, Heatilator Type System, Includes Accessories, Portable/Ventless
  • Fireplaces: 4
  • Attic: Unfinished
  • Basement: Full, Walkout
  • Basement: Finished, Exterior Access
  • Basement Bathrooms: Yes
  • Master Bedroom Level: Main Level
  • Master Bedroom Size: 19X17
  • Master Bedroom Flooring: Carpet
  • Primary Bedroom Bath: Full
  • Second Bedroom Level: Main Level
  • Second Bedroom Size: 17X13
  • Second Bedroom Flooring: Carpet
  • Third Bedroom Level: Main Level
  • Third Bedroom Size: 16X13
  • Third Bedroom Flooring: Carpet
  • Fourth Bedroom Level: Walkout Basement
  • Fourth Bedroom Size: 16X15
  • Fourth Bedroom Flooring: Ceramic Tile
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink
  • Dining Room: Separate
  • Dining Room Level: Main Level
  • Dining Room Size: 15X14
  • Dining Room Flooring: Hardwood
  • Family Room Level: Walkout Basement
  • Family Room Size: 26X29
  • Family Room Flooring: Carpet
  • Kitchen Type: Eating Area-Breakfast Bar, Island, Pantry-Walk-in
  • Kitchen Level: Main Level
  • Kitchen Size: 18X17
  • Kitchen Flooring: Hardwood

Exterior Features

  • Foundation: Concrete
  • Lot Size: 3.0-3.99 Acres
  • Exterior Building Type: Cedar, Stone
  • Roof Type: Asphalt/Glass (Shingles)
  • Waterfront: Yes

Garage/Parking

  • Number of Cars: 3
  • Parking Type: Garage
  • Garage Type: Garage Door Opener(s), Transmitter(s), 7 Foot or more high garage door
  • Driveway: Concrete, Circular

Utilities

  • Electricity: Circuit Breakers, 200+ Amp Service
  • Air Conditioner: Central Air
  • Water: Well-Private
  • Heat/Fuel: Gas, Forced Air
  • Sewer: Septic-Private

Condo/Co-op/Association

  • Fee Frequency: Annual
  • Assessment/Association Fees: 90

Schools

  • Elementary School: Gilberts Elementary School
  • High School: Hampshire High School
  • Junior High Dist: 300
  • Junior High: Hampshire Middle School
  • Other Public School: St. Edward Catholic H.S.

Lot Info

  • Lot Dimensions: 420 X253 X230 X329 X182 X9
  • Lot Description: Cul-de-sac, Irregular, Landscaped Professionally, Pond, Water View, Wooded

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 23, 2013
Closed on
Aug 26, 2013
Sold by
Longbottom Donald J and Becker Mary Ann
Bought by
Frei Marcel and Frei Darina
Seller's Agent
Carol Best
Jameson Sotheby's International Realty
Buyer's Agent
Betty Shattuck
Berkshire Hathaway HomeServices Starck Real Estate
List Price
$800,000
Sold Price
$640,000
Premium/Discount to List
-$160,000
-20%
Total Days on Market
18
Current Estimated Value
$950,207

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$310,207
Avg. Annual Appreciation
3.36%
Original Mortgage
$417,000
Interest Rate
4.75%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 10, 2010
Sold by
Becker Mary Ann and Mary Ann Becker Declaration Of
Bought by
Longbottom Donald J and Becker Mary Ann

Purchase Details

Closed on
Jun 25, 2008
Sold by
Albergo Frank and Albergo Cathy
Bought by
Becker Mary Ann and Mary Ann Becker Declaration Of

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
5%
Mortgage Type
Credit Line Revolving
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
Frei Marcel $640,000 Multiple
Longbottom Donald J -- None Available
Becker Mary Ann $739,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Real Bryan $175,000
Open Real Bryan $295,000
Closed Frei Marcel $400,000
Closed Frei Marcel $417,000
Previous Owner Becker Mary Ann $584,000
Previous Owner Becker Mary Ann $250,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/29/2013 08/29/13 Sold $640,000 -14.7% $175 / Sq Ft
07/11/2013 07/11/13 Pending -- -- --
07/11/2013 07/11/13 Price Changed $750,000 -6.3% $205 / Sq Ft
06/23/2013 06/23/13 For Sale $800,000 -- $219 / Sq Ft
Source: Midwest Real Estate Data (MRED)

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
2024 $16,851 $283,368 $67,499 $215,869
2023 $16,167 $256,256 $61,041 $195,215
2022 $16,174 $245,936 $65,948 $179,988
2021 $15,148 $223,256 $62,028 $161,228
2020 $15,265 $217,556 $60,444 $157,112
2019 $14,988 $208,807 $58,013 $150,794
2018 $14,573 $195,971 $54,447 $141,524
2017 $16,420 $214,100 $51,849 $162,251
2016 $16,406 $203,827 $49,361 $154,466
2015 -- $192,508 $46,620 $145,888
2014 -- $181,615 $51,800 $129,815
2013 -- $184,944 $52,749 $132,195
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD08377197

Midwest Real Estate Data (MRED)

APN: 02-12-451-002