NOT LISTED FOR SALE

17N520 Hidden Hills Trail Dundee, IL 60118

Estimated Value: $578,261 - $638,000

4 Beds
3.5 Baths
3,400 Sq Ft
$177/Sq Ft Est. Value

Last Sold April 05, 2022

Last sale price $473,000 $139 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $4,036/month

5 Days on Market

Highlights

  • Waterfront
  • 1.43 Acre Lot
  • Landscaped Professionally
  • Gilberts Elementary School Rated A-
  • Open Floorplan
  • Mature Trees

About This Home

As of April 2022

The one you have been waiting for!!! Updated ranch with large yard and 2 ponds. 3 car gar & large deck also patio. Full finished walkout bsmt w/full bath and tons of storage. Newer furnace & air. Newer refrigerator & washer/dryer. Open floor plan with volume ceilings and formal dining rm. Updated kitchen with newer cabinets & quartz counters. Master suite has remodeled bath with oversized shower and dual vanities. Walk-in closet & tray ceiling. Minutes to shopping, hospital,expressway, golf, forest preserve & metra train. Quick close possible.

Last Agent to Sell the Property

Tanya Callaway

Baird & Warner License #475166149 Listed on: 02/22/2022

Baird & Warner

Last Buyer's Agent

Tim Sheahan

Compass License #475145058

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,223

Year Built

  • Built in 1990

Lot Details

  • 1.43 Acre Lot
  • Lot Dimensions are 42x88
  • Waterfront
  • Landscaped Professionally
  • Paved or Partially Paved Lot
  • Mature Trees
  • Wooded Lot
  • Backs to Trees or Woods

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Parking Included in Price

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Asphalt Roof

Interior Spaces

  • 3,400 Sq Ft Home
  • Open Floorplan
  • Vaulted Ceiling
  • Skylights
  • Double Sided Fireplace
  • Wood Burning Fireplace
  • Fireplace With Gas Starter
  • Blinds
  • Living Room
  • Formal Dining Room
  • Den
  • Game Room
  • Finished Basement
  • Walk-Out Basement
  • Granite Countertops

Flooring

  • Wood
  • Partially Carpeted

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Potential Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • Bathroom on Main Level
  • Dual Sinks
  • No Tub in Bathroom
  • Shower Body Spray

Laundry

  • Laundry Room
  • Laundry on main level
  • Sink Near Laundry
  • Gas Dryer Hookup

Outdoor Features

  • Pond

Schools

  • Gilberts Elementary School
  • Hampshire Middle School
  • Hampshire High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Well
  • Private or Community Septic Tank

Community Details

  • Community Lake

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,223

Year Built

Built in 1990

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 1 Story
  • Ownership: Fee Simple
  • ArchitecturalStyle: Ranch
  • New Construction: No
  • Property Sub-Type: 1 Story
  • Year Built: 1990
  • Age: 31-40 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service,Commuter Train,Interstate Access
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Basement: Walkout
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Total Bedrooms: 4
  • Fireplace Features: Double Sided, Wood Burning, Gas Starter
  • Fireplaces: 1
  • Interior Amenities: Vaulted/Cathedral Ceilings, Skylight(s), Hardwood Floors, First Floor Bedroom, In-Law Arrangement, First Floor Laundry, First Floor Full Bath, Walk-In Closet(s), Open Floorplan, Some Carpeting, Dining Combo, Drapes/Blinds, Granite Counters, Separate Dining Room
  • LivingArea: 3400
  • Room Type: Den, Game Room
  • Estimated Total Finished Sq Ft: 3468
  • Assessed Sq Ft: 2368
  • Basement Description: Finished
  • Bathroom Amenities: Double Sink,Full Body Spray Shower,No Tub
  • Basement Bathrooms: No
  • Below Grade Bedrooms: 0
  • Total Sq Ft: 3468
  • Fireplace Location: Other
  • Square Footage Comments: assessor doesn't include walk out basement
  • Total Sq Ft: 3968
  • Upper Level Sq Ft: 2368
  • Lower Level Sq Ft: 1100
  • Unfinished Lower Sq Ft: 500

Exterior Features

  • List Price: 465000
  • Lot Features: Landscaped, Pond(s), Wooded, Mature Trees, Backs to Trees/Woods
  • Roof: Asphalt
  • Waterfront: Yes
  • Exterior Building Type: Brick

Garage/Parking

  • Garage Spaces: 3
  • Number of Cars: 3
  • Driveway: Concrete
  • Garage Details: Garage Door Opener(s),Transmitter(s),Heated
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached
  • Parking: Garage

Utilities

  • Sewer: Septic-Private
  • Cooling: Central Air
  • Electric: Circuit Breakers
  • Heating: Natural Gas
  • Laundry Features: Gas Dryer Hookup, In Unit, Sink
  • Water Source: Private Well

Condo/Co-op/Association

  • Association Fee Frequency: Not Applicable
  • Community Features: Lake, Street Paved
  • Master Association Fee Frequency: Not Required

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: Gilberts Elementary School
  • High School: Hampshire High School
  • Middle/Junior School: Hampshire Middle School
  • Middle/Junior School District: 300

Lot Info

  • Additional Parcels: No
  • Lot Size Acres: 1.43
  • Lot Dimensions: 42X88
  • Lot Size: 1.0-1.99 Acres
  • Special Assessments: N

Rental Info

  • Board Number: 2
  • Is Parking Included in Price: Yes

Tax Info

  • Tax Annual Amount: 9222.72
  • Tax Year: 2020

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 22, 2022
Closed on
Apr 5, 2022
Sold by
Paul D Callaway Trust
Bought by
Hammel Joseph and Hammel Lindy
Seller's Agent
Tanya Callaway
Baird & Warner
Buyer's Agent
Tim Sheahan
Compass
List Price
$465,000
Sold Price
$473,000
Premium/Discount to List
$8,000
1.72%
Current Estimated Value
$603,065

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$130,065
Avg. Annual Appreciation
7.23%
Original Mortgage
$449,350
Outstanding Balance
$422,433
Interest Rate
4%
Mortgage Type
New Conventional
Estimated Equity
$180,632

Purchase Details

Closed on
Jan 20, 2018
Sold by
Callaway Paul D and Callaway Victoria A
Bought by
Callaway Paul D and Callaway Victoria A

Purchase Details

Closed on
Nov 25, 1998
Sold by
Koppie Theodore A and Koppie Susan R
Bought by
Callaway Paul D and Callaway Victoria A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
6.93%
Mortgage Type
Balloon
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
Hammel Joseph $473,000 Burnet Title
Callaway Paul D -- Attorney
Callaway Paul D $315,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hammel Joseph $449,350
Previous Owner Callaway Paul D $225,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/05/2022 04/05/22 Sold $473,000 +1.7% $139 / Sq Ft
02/28/2022 02/28/22 Pending -- -- --
02/22/2022 02/22/22 For Sale $465,000 -- $137 / 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 $10,215 $170,078 $41,037 $129,041
2023 $9,811 $153,806 $37,111 $116,695
2022 $9,669 $151,455 $34,216 $117,239
2021 $9,122 $142,452 $32,182 $110,270
2020 $9,223 $138,815 $31,360 $107,455
2019 $9,033 $133,233 $30,099 $103,134
2018 $8,748 $125,043 $28,249 $96,794
2017 $8,528 $119,077 $26,901 $92,176
2016 $8,489 $113,363 $25,610 $87,753
2015 -- $107,068 $24,188 $82,880
2014 -- $105,138 $24,188 $80,950
2013 -- $107,065 $24,631 $82,434
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 11330221

Midwest Real Estate Data (MRED)

APN: 02-13-201-014