NOT LISTED FOR SALE

Estimated Value: $775,000 - $816,030

4 Beds
2.5 Baths
3,557 Sq Ft
$225/Sq Ft Est. Value

Last Sold May 23, 2023

Last sale price $739,000 $208 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $5,584/month

9 Days on Market

Highlights

  • Open Floorplan
  • Landscaped Professionally
  • Loft
  • Oliver Julian Kendall Elementary School Rated A+
  • Wood Flooring
  • 3-minute walk to Clow Creek Greenway

About This Home

As of May 2023

This stunning home seamlessly blends contemporary and classic design elements. The fully renovated property boasts a 3-car garage and sits on a lushly landscaped and newly fenced private cul-de-sac lot measuring over 1/3 acre in the highly sought-after area of Neuqua Valley High School. Inside, the welcoming open floor plan connects the gourmet kitchen, complete with popular white custom cabinetry and stunning granite countertops, to the family room featuring a beautiful see-thru fireplace and ample windows that provide the space with plenty of natural light. Kitchen is equipped with premium stainless steel appliances including Electrolux double ovens, a microwave, a Bosch dishwasher, and a 5-burner stove top. A unique feature of this home is the glorious 4-seasons sunroom accessible via French doors from the kitchen, which is sure to attract family and friends alike. From here, one can enjoy views of the expansive lawn and patio, surrounded by mature trees including 4 Pine, 2 White Birch, 2 Bradford Pear, 1 Maple, 2 Crab Apple, and 1 Canadian Cherry tree. The formal dining room features an elegant chandelier, while the formal living room boasts tall windows and ceilings. Upstairs, there are 4 bedrooms, a loft/office with a closet, and an enormous master bedroom with a sitting area and trey ceilings, providing a spa-like retreat after a long day. The master bathroom features new Kohler fixtures and granite shower, while all bathrooms boast new quartz countertops. The full basement features plush grey carpeting, high-end lighting fixtures installed within the past 2 years, and a rough-in available for future customization. Additional upgrades include a newer roof 2020, newer furnace and AC unit, fresh paint, and a newer Bradford 75-gallon hot water heater. This home exudes relaxation, peacefulness, and serenity, with flowering trees such as Purple & White Lilacs, Burning Bushes & Lilies. The full vegetable & herb garden with western exposure will surely delight for summer BBQs. Meticulously maintained, this home is truly worthy of gracing the cover of Architecture Digest, inside and out. Welcome Home!

Last Agent to Sell the Property

Walter Burrell

Coldwell Banker Realty License #475163963 Listed on: 04/01/2023

Coldwell Banker Realty

Co-Listed By

Bridget Salela

Coldwell Banker Realty License #475175515

Last Buyer's Agent

Jan Mackey

Baird & Warner License #475166535

Baird & Warner

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,719

Year Built

  • Built in 1997

Lot Details

  • 0.39 Acre Lot
  • Lot Dimensions are 48x163x50x152x122
  • Cul-De-Sac
  • Landscaped Professionally

HOA Fees

  • $19 Monthly HOA Fees

Parking

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

Home Design

  • Asphalt Roof
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 3,557 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Built-In Features
  • Ceiling Fan
  • Double Sided Fireplace
  • Fireplace With Gas Starter
  • Family Room with Fireplace
  • Sitting Room
  • Living Room
  • Formal Dining Room
  • Loft
  • Heated Sun or Florida Room
  • Home Security System

Kitchen

  • <<doubleOvenToken>>
  • Cooktop<<rangeHoodToken>>
  • <<microwave>>
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Potential Bedrooms
  • Walk-In Closet
  • Dual Sinks
  • Separate Shower

Laundry

  • Laundry Room
  • Laundry on main level

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Patio

Schools

  • Kendall Elementary School
  • Crone Middle School
  • Neuqua Valley High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Lake Michigan Water

Community Details

  • Company Association, Phone Number (630) 253-0101
  • Property managed by management

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,719

Year Built

Built in 1997

Lot Details

0

HOA Fees

$19 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple w/ HO Assn.
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Year Built: 1997
  • Age: 26-30 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Double Oven, Microwave, Dishwasher, Refrigerator, Disposal, Stainless Steel Appliance(s), Cooktop
  • Basement: Full
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: Double Sided, Gas Starter
  • Fireplaces: 1
  • Interior Amenities: Hardwood Floors, First Floor Laundry, Built-in Features, Walk-In Closet(s), Open Floorplan
  • LivingArea: 3557
  • Other Equipment: Security System, Ceiling Fan(s), Sump Pump, Radon Mitigation System, Security Cameras
  • Room Type: Loft, Heated Sun Room, Sitting Room
  • Estimated Total Finished Sq Ft: 3557
  • Basement Description: Unfinished
  • Bathroom Amenities: Separate Shower,Double Sink
  • Basement Bathrooms: No
  • Below Grade Bedrooms: 0
  • Dining Room: Separate
  • Total Sq Ft: 3557
  • Basement Sq Ft: 1635
  • Fireplace Location: Family Room
  • Square Footage Comments: See the appraiser notes on square footage in the additional documents.
  • Total Sq Ft: 5192
  • Unfinished Basement Sq Ft: 1635
  • Upper Level Sq Ft: 1880
  • Main Level Sq Ft: 1677
  • Flooring: Carpet
  • ResoLivingAreaSource: Appraiser

Exterior Features

  • ExteriorFeatures: Patio
  • Foundation Details: Concrete Perimeter
  • List Price: 739000
  • Lot Features: Cul-De-Sac, Landscaped
  • Roof: Asphalt
  • Waterfront: No
  • Exterior Building Type: Vinyl Siding,Brick

Garage/Parking

  • Garage Spaces: 3
  • Number of Cars: 3
  • Driveway: Asphalt
  • Garage Details: Garage Door Opener(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: 225
  • Association Fee Frequency: Annually
  • Master Association Fee: No
  • Master Association Fee Frequency: Not Required
  • Management Company: management
  • Management Contact Name: company
  • Management Phone: 630-253-0101
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Association Fee Includes: Other

Schools

  • Elementary School: Kendall Elementary School
  • High School: Neuqua Valley High School
  • Middle/Junior School: Crone Middle School
  • Middle/Junior School District: 204

Lot Info

  • Lot Size Acres: 0.39
  • Lot Dimensions: 48X163X50X152X122
  • Lot Size: .25-.49 Acre
  • Special Assessments: N

Rental Info

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

Tax Info

  • Tax Annual Amount: 11719
  • Tax Year: 2021

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 1, 2023
Closed on
May 23, 2023
Sold by
National Residential Nominee Services In
Bought by
Bardhan Debashi and Bhushan Kangana
Seller's Agent
Walter Burrell
Coldwell Banker Realty
Buyer's Agent
Jan Mackey
Baird & Warner
List Price
$739,000
Sold Price
$739,000
Current Estimated Value
$799,508

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$60,508
Avg. Annual Appreciation
4.09%
Original Mortgage
$433,000
Outstanding Balance
$398,148
Interest Rate
5.88%
Mortgage Type
New Conventional
Estimated Equity
$407,725

Purchase Details

Closed on
Feb 15, 2023
Sold by
Still Jared and Still Danae
Bought by
National Residential Nominee Services Inc

Purchase Details

Listed on
May 30, 2021
Closed on
Aug 27, 2021
Sold by
Kuehn David and Kuehn Sophie
Bought by
Still Jared and Still Danae
Seller's Agent
Jill Clark
Compass
Buyer's Agent
Robert Trantham
United Real Estate - Chicago
List Price
$624,900
Sold Price
$605,000
Premium/Discount to List
-$19,900
-3.18%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.49%
Original Mortgage
$484,000
Interest Rate
2.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 9, 1999
Sold by
Palmer William C and Palmer Hathy A
Bought by
Kuehn David and Kuehn Sophie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$330,850
Interest Rate
6.9%

Purchase Details

Closed on
Jun 5, 1998
Sold by
Classic Custom Homes Inc
Bought by
Palmer William C and Palmer Hathy A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$226,800
Interest Rate
7.32%

Purchase Details

Closed on
Feb 24, 1997
Sold by
Maf Developments Inc
Bought by
Classic Custom Homes Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$52,200
Interest Rate
7.65%
Mortgage Type
Construction
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
Bardhan Debashi $739,000 Fidelity National Title
National Residential Nominee Services Inc $739,000 Fidelity National Title
Still Jared $605,000 First American Title
Kuehn David $389,000 --
Palmer William C $322,000 --
Classic Custom Homes Inc $70,000 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bardhan Debashi $433,000
Previous Owner Still Jared $484,000
Previous Owner Kuehn David $560,000
Previous Owner Kuehn David $340,000
Previous Owner Kuehn David $100,000
Previous Owner Kuehn David $340,000
Previous Owner Kuehn David $60,000
Previous Owner Kuehn David $334,000
Previous Owner Kuehn David $50,000
Previous Owner Kuehn David M $42,000
Previous Owner Kuehn David M $18,900
Previous Owner Kuehn David $330,850
Previous Owner Palmer William C $226,800
Previous Owner Classic Custom Homes Inc $52,200
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/23/2023 05/23/23 Sold $739,000 0.0% $208 / Sq Ft
04/10/2023 04/10/23 Pending -- -- --
04/01/2023 04/01/23 For Sale $739,000 +22.1% $208 / Sq Ft
07/30/2021 07/30/21 Sold $605,000 -3.2% $170 / Sq Ft
06/11/2021 06/11/21 Pending -- -- --
05/30/2021 05/30/21 For Sale $624,900 -- $176 / 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
2023 $13,648 $191,143 $38,647 $152,496
2022 $12,261 $175,230 $36,560 $138,670
2021 $12,261 $166,886 $34,819 $132,067
2020 $11,496 $164,241 $34,267 $129,974
2019 $11,299 $159,612 $33,301 $126,311
2018 $10,621 $147,786 $32,568 $115,218
2017 $11,983 $164,089 $31,727 $132,362
2016 $11,962 $160,557 $31,044 $129,513
2015 $12,054 $154,382 $29,850 $124,532
2014 $12,054 $150,138 $29,850 $120,288
2013 $12,054 $150,138 $29,850 $120,288
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 11729856

Midwest Real Estate Data (MRED)

APN: 01-15-307-020