NOT LISTED FOR SALE

Estimated Value: $538,000 - $566,301

3 Beds
2.5 Baths
2,672 Sq Ft
$207/Sq Ft Est. Value

Last Sold March 20, 2023

Last sale price $460,000 $172 Per Sq Ft

Est. 20% increase in value since last sale

Current estimated payment $4,209/month

Highlights

  • Colonial Architecture
  • Community Lake
  • Vaulted Ceiling
  • Hawthorn Elementary School South Rated A
  • Property is near a park
  • Whirlpool Bathtub

About This Home

As of March 2023

Welcome to this exceptional maintenance-free home, nestled in a peaceful quiet cul-de-sac in the Courts of Indian Creek. As you step into the sun-filled two-story foyer, you'll be impressed by the well-designed modern floor plan that awaits you. The spacious living and dining rooms are perfect for entertaining. The cozy family room with a gas fireplace is the perfect place to curl up and relax. The heart of the home is the open concept kitchen, complete with a breakfast area overlooking the mature, professionally landscaped yard. Upstairs, you'll find a a huge master suite with a tray ceiling, a large walk-in closet, a master bath with a shower, jacuzzi tub and double vanity sinks. Two additional bedrooms, a full bath with double sinks and an open loft that could easily be converted into a fourth bedroom complete the upper level. Downstairs, the full basement with rough-in plumbing awaits your finishing touches. You can rest easy knowing that the home is equipped with a security system. This stunning home offers the perfect balance of luxury and comfort, and it's just waiting for you to make it your own.

Last Agent to Sell the Property

Caroline Madej

@properties Christie's International Real Estate License #475197535 Listed on: 02/06/2023

@properties Christie's International Real Estate

Last Buyer's Agent

Jane Lee

RE/MAX Top Performers License #471004433

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,217

Year Built

  • Built in 2004

Lot Details

  • 5,101 Sq Ft Lot
  • Lot Dimensions are 87x53x63x39x13x28x43
  • Cul-De-Sac
  • Paved or Partially Paved Lot

HOA Fees

  • $297 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Parking Space is Owned

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Asphalt Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,672 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Entrance Foyer
  • Family Room with Fireplace
  • Combination Dining and Living Room
  • Loft
  • Unfinished Attic
  • Home Security System
  • Breakfast Bar
  • Laundry Room

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Potential Bedrooms
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Location

  • Property is near a park

Schools

  • Mundelein Cons High School

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Lake Michigan Water
  • Cable TV Available

Community Details

  • Association fees include lawn care, scavenger, snow removal
  • Foster Premier Association, Phone Number (847) 459-1222
  • Courts Of Indian Creek Subdivision, 501K Floorplan
  • Property managed by Courts of Indian Creek
  • Community Lake

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,217

Year Built

Built in 2004

Lot Details

0

HOA Fees

$297 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple w/ HO Assn.
  • ArchitecturalStyle: Colonial
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Subdivision Name: Courts of Indian Creek
  • Year Built: 2004
  • Age: 16-20 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: None
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • New Construction Y/N: No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Basement: Full
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Total Bedrooms: 3
  • Fireplace Features: Gas Log
  • Fireplaces: 1
  • Interior Amenities: Vaulted/Cathedral Ceilings
  • LivingArea: 2672
  • Other Equipment: Humidifier, TV-Cable, Security System, Ceiling Fan(s), Sump Pump
  • Room Type: Eating Area, Foyer, Loft
  • Estimated Total Finished Sq Ft: 0
  • Basement Description: Unfinished
  • Bathroom Amenities: Whirlpool,Separate Shower,Double Sink
  • Basement Bathrooms: No
  • Below Grade Bedrooms: 0
  • Dining Room: Combined w/ LivRm
  • Total Sq Ft: 0
  • Fireplace Location: Family Room
  • Total Sq Ft: 0
  • Attic: Unfinished
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Foundation Details: Concrete Perimeter
  • List Price: 440000
  • Lot Features: Cul-De-Sac
  • Roof: Asphalt
  • Waterfront: No
  • Exterior Building Type: Brick

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Natural Gas, Forced Air
  • Water Source: Lake Michigan

Condo/Co-op/Association

  • Association Fee: 297
  • Association Fee Frequency: Monthly
  • Community Features: Park, Lake, Curbs, Sidewalks, Street Lights, Street Paved
  • Master Association Fee: No
  • Master Association Fee Frequency: Not Required
  • Management Company: Courts of Indian Creek
  • Management Contact Name: Foster Premier
  • Management Phone: 847-459-1222
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Association Fee Includes: Lawn Care, Scavenger, Snow Removal

Schools

  • High School: Mundelein Cons High School
  • Middle/Junior School District: 73

Lot Info

  • Additional Parcels: No
  • Lot Size Acres: 0.1171
  • Lot Dimensions: 87X53X63X39X13X28X43
  • Lot Size: Less Than .25 Acre
  • Special Assessments: N

Rental Info

  • Board Number: 8

Tax Info

  • Tax Annual Amount: 10217
  • Tax Year: 2021
  • Tax Exemptions: Homeowner

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 6, 2023
Closed on
Mar 15, 2023
Sold by
Aiyer Aparna and Aiyer Naresh
Bought by
Giacomo Gustave Silva and Bueno Carolina Cerqueira
Seller's Agent
Caroline Madej
@properties Christie's International Real Estate
Buyer's Agent
Jane Lee
RE/MAX Top Performers
List Price
$440,000
Sold Price
$460,000
Premium/Discount to List
$20,000
4.55%
Views
56
Current Estimated Value
$552,075

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$92,075
Avg. Annual Appreciation
6.51%
Original Mortgage
$368,000
Outstanding Balance
$356,905
Interest Rate
5.5%
Mortgage Type
New Conventional
Estimated Equity
$178,272

Purchase Details

Closed on
Nov 22, 2006
Sold by
Huang Culling and Moy Anna
Bought by
Aiyer Aparna and Avasarala Naresh

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$356,800
Interest Rate
5.87%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 1, 2004
Sold by
The Courts Of Indian Creek Llc
Bought by
Huang Cuiling and Moy Anna

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$240,000
Interest Rate
5.99%
Mortgage Type
Purchase Money Mortgage
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
Giacomo Gustave Silva $460,000 Proper Title
Aiyer Aparna $446,000 Stewart Title Company
Huang Cuiling $407,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Giacomo Gustave Silva $368,000
Previous Owner Avasarala Naresh $317,300
Previous Owner Aiyer Aparna $364,000
Previous Owner Aiyer Aparna $45,500
Previous Owner Aiyer Aparna $356,800
Previous Owner Huang Cuiling $240,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/20/2023 03/20/23 Sold $460,000 +4.5% $172 / Sq Ft
02/07/2023 02/07/23 Pending -- -- --
02/06/2023 02/06/23 For Sale $440,000 0.0% $165 / Sq Ft
02/23/2017 02/23/17 Rented $2,450 -2.0% --
02/18/2017 02/18/17 Under Contract -- -- --
02/01/2017 02/01/17 For Rent $2,500 -- --
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,679 $143,113 $32,517 $110,596
2023 $10,508 $132,390 $30,080 $102,310
2022 $10,508 $128,035 $29,090 $98,945
2021 $10,217 $126,654 $28,776 $97,878
2020 $10,449 $130,299 $28,874 $101,425
2019 $10,333 $129,819 $28,768 $101,051
2018 $10,515 $132,544 $28,433 $104,111
2017 $10,386 $129,450 $27,769 $101,681
2016 $10,103 $123,959 $26,591 $97,368
2015 $9,879 $115,926 $24,868 $91,058
2014 $8,992 $107,691 $26,707 $80,984
2012 $8,620 $107,907 $26,761 $81,146
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 11711708

Midwest Real Estate Data (MRED)

APN: 15-05-309-088