0S277 Kellar Square Geneva, IL 60134
Mill Creek NeighborhoodEstimated Value: $981,000 - $1,143,698
5
Beds
5
Baths
6,284
Sq Ft
$170/Sq Ft
Est. Value
Highlights
- Water Views
- On Golf Course
- Landscaped Professionally
- Fabyan Elementary School Rated A
- Home Theater
- 5-minute walk to Hathaway park
About This Home
As of October 2020LIVE THE GOOD LIFE! ALL THIS CAN BE YOURS IN THIS PHENOMENAL FAMILY HOME... This custom Havlicek-built home offers an impressive 6284 sq feet of stunning luxury. There is unbelievable detail throughout this home including extensive moldings/trim, built-in high-end cabinetry, architectural features & much more. Hickory hardwood floors flow throughout the open floor plan on the main level and you will find easy-care plantation shutters on the windows. The kitchen is amazing with refined and sophisticated detail. High-end appliances, walk-in pantry, fireplace and lots of entertaining space. Enjoy your meals in the bright sun room area or attached private screened porch. The main traffic area will always be organized with the mudroom w/built-ins (including lockers) and attached is the enviable one of two laundry areas. The exemplary detail in the family room is remarkable with the stone fireplace, ceiling beams and bay windows. The home office with built-in desks even has a "Zoom" room. Upstairs the master suite is the ultimate retreat with fireplace, tray ceiling, spa bath, walk-in closet w/built-ins and laundry area. There is an en-suite bedroom along with two bedrooms that share a Jack/Jill bath. The lower level will definitely be your "family zone". There is a 5th bedroom w/full bath for guests, theater w/viewing equipment, exercise area & wonderful recreation area. There is absolutely nothing missing plus plenty of great storage. The fenced yard has a paver patio w/fire pit, large deck and luscious landscaping (lawn care has been paid for the remainder of 2020). This ideal location can't be beat w/gorgeous views, quiet location, golf & walking paths. Great location, breathtaking home ~ the time is now!
Last Agent to Sell the Property
Berkshire Hathaway HomeServices Starck Real Estate License #471018013 Listed on: 07/09/2020
Last Buyer's Agent
Berkshire Hathaway HomeServices Starck Real Estate License #471018013 Listed on: 07/09/2020
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $21,168
Year Built
- 2005
Lot Details
- On Golf Course
- Fenced Yard
- Landscaped Professionally
- Corner Lot
Parking
- Attached Garage
- Garage Transmitter
- Garage Door Opener
- Driveway
- Parking Included in Price
- Garage Is Owned
Home Design
- Traditional Architecture
- Slab Foundation
- Asphalt Shingled Roof
- Wood Siding
Interior Spaces
- Built-In Features
- Bar Fridge
- Vaulted Ceiling
- See Through Fireplace
- Gas Log Fireplace
- Mud Room
- Home Theater
- Home Office
- Recreation Room
- Heated Sun or Florida Room
- Screened Porch
- Home Gym
- Wood Flooring
- Water Views
- Storm Screens
Kitchen
- Breakfast Bar
- Walk-In Pantry
- Butlers Pantry
- Built-In Double Oven
- Range Hood
- Microwave
- High End Refrigerator
- Bar Refrigerator
- Dishwasher
- Stainless Steel Appliances
- Kitchen Island
- Disposal
Bedrooms and Bathrooms
- Walk-In Closet
- Primary Bathroom is a Full Bathroom
- Dual Sinks
- Whirlpool Bathtub
- Separate Shower
Laundry
- Laundry on main level
- Dryer
- Washer
Finished Basement
- Exterior Basement Entry
- Finished Basement Bathroom
Outdoor Features
- Pond
- Deck
- Fire Pit
Utilities
- Forced Air Zoned Cooling and Heating System
- Heating System Uses Gas
- Community Well
Listing and Financial Details
- Homeowner Tax Exemptions
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 9, 2020
Closed on
Sep 18, 2020
Sold by
Lannert Bret C and Lannert Emily E
Bought by
Fuhrman Robert Paul and Fuhrman Jennifer
Seller's Agent
Ginny Sylvester
Berkshire Hathaway HomeServices Starck Real Estate
Buyer's Agent
Ginny Sylvester
Berkshire Hathaway HomeServices Starck Real Estate
List Price
$915,000
Sold Price
$900,000
Premium/Discount to List
-$15,000
-1.64%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$166,899
Avg. Annual Appreciation
3.89%
Original Mortgage
$455,000
Outstanding Balance
$338,591
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$739,279
Purchase Details
Listed on
Jan 26, 2013
Closed on
May 30, 2013
Sold by
Old Second National Bank
Bought by
Lannert Bret C and Lannert Emily E
Seller's Agent
Matt Kombrink
One Source Realty
Buyer's Agent
Bret Lannert
BE Realty Group
List Price
$949,900
Sold Price
$850,000
Premium/Discount to List
-$99,900
-10.52%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.78%
Original Mortgage
$680,000
Interest Rate
3.34%
Mortgage Type
New Conventional
Purchase Details
Closed on
Nov 26, 2005
Sold by
Brady David P and Brady Megan S
Bought by
The Old Second National Bank Of Aurora and Trust #9628
Purchase Details
Closed on
Jan 31, 2005
Sold by
Havlicek Builders Inc
Bought by
Brady David P and Brady Megan S
Purchase Details
Closed on
Nov 10, 2004
Sold by
Sho Deen Inc
Bought by
Havlicek Builders Inc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,600,000
Interest Rate
5.8%
Mortgage Type
Credit Line Revolving
Similar Homes in Geneva, IL
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Fuhrman Robert Paul | $900,000 | Attorney | |
| Lannert Bret C | $850,000 | None Available | |
| The Old Second National Bank Of Aurora | -- | -- | |
| Brady David P | $180,000 | Chicago Title Insurance Comp | |
| Havlicek Builders Inc | -- | Chicago Title Insurance Comp |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Fuhrman Robert Paul | $455,000 | |
| Previous Owner | Lannert Bret C | $680,000 | |
| Previous Owner | Havlicek Builders Inc | $1,600,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 10/01/2020 10/01/20 | Sold | $900,000 | -1.6% | $143 / Sq Ft |
| 08/04/2020 08/04/20 | Pending | -- | -- | -- |
| 07/09/2020 07/09/20 | For Sale | $915,000 | +7.6% | $146 / Sq Ft |
| 05/31/2013 05/31/13 | Sold | $850,000 | -3.3% | $194 / Sq Ft |
| 03/31/2013 03/31/13 | Pending | -- | -- | -- |
| 03/15/2013 03/15/13 | Price Changed | $879,000 | -7.5% | $201 / Sq Ft |
| 03/05/2013 03/05/13 | For Sale | $949,900 | 0.0% | $217 / Sq Ft |
| 02/19/2013 02/19/13 | Pending | -- | -- | -- |
| 01/26/2013 01/26/13 | For Sale | $949,900 | -- | $217 / Sq Ft |
Source: Midwest Real Estate Data (MRED)
Tax History Compared to Growth
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 | $21,168 | $244,934 | $37,908 | $207,026 |
| 2022 | $21,565 | $242,849 | $34,791 | $208,058 |
| 2021 | $20,776 | $231,462 | $33,299 | $198,163 |
| 2020 | $20,198 | $226,038 | $32,519 | $193,519 |
| 2019 | $20,132 | $222,720 | $32,042 | $190,678 |
| 2018 | $20,756 | $229,977 | $32,042 | $197,935 |
| 2017 | $20,745 | $227,363 | $31,678 | $195,685 |
| 2016 | $21,080 | $229,188 | $30,842 | $198,346 |
| 2015 | -- | $232,200 | $29,639 | $202,561 |
| 2014 | -- | $240,751 | $32,979 | $207,772 |
| 2013 | -- | $237,751 | $32,979 | $204,772 |
Source: Public Records
Agents Affiliated with this Home
-
Ginny Sylvester
Seller's Agent in 2020
Ginny Sylvester
Berkshire Hathaway HomeServices Starck Real Estate
(630) 715-1887
24 in this area
169 Total Sales
-
Matt Kombrink
Seller's Agent in 2013
Matt Kombrink
One Source Realty
(630) 803-8444
11 in this area
960 Total Sales
-
B
Buyer's Agent in 2013
Bret Lannert
BE Realty Group
Map
Source: Midwest Real Estate Data (MRED)
MLS Number: MRD10777394
APN: 11-13-130-021
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked.
Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.
The DMCA requires that your notice of alleged copyright infringement include the following information:
(1) description of the copyrighted work that is the subject of claimed infringement;
(2) description of the alleged infringing content and information sufficient to permit us to locate the content;
(3) contact information for you, including your address, telephone number and email address;
(4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law;
(5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and
(6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Nearby Homes
- 39W915 Catlin Square
- 39W729 N Hathaway Ln
- 39W465 S Mathewson Ln
- 39W445 S Mathewson Ln
- 39W188 Pauley Square
- S970 Newton Square
- 0N296 N Mill Creek Dr W
- 39W382 W Mallory Dr
- 39W326 W Mallory Dr
- 0S587 Grengs Ln
- 0N523 Bowdish Dr
- 0S400 Crego Place
- 0N611 W Weaver Cir
- 0S630 Hubbard Place
- 0N745 Bartelt Rd
- 1S215 S Hyde Park
- 38W542 Mcquire Place
- 38W424 Berquist Dr
- 38W277 Monterey Dr
- 948 Bluestem Dr
- 0S277 Kellar Square
- 0S257 Kellar Square
- 39W786 S Hathaway Ln
- 39W789 Kellar Square
- 0S237 Kellar Square
- 39W866 S Hathaway Ln
- 39W921 S Hathaway Ln
- 39W806 S Hathaway Ln
- 0S320 Kellar Ct
- 0S341 Kellar Ct
- 39W809 Kellar Square
- 0S371 Kellar (I4) Ct
- 39W780 Kellar Square
- 0S340 Kellar Ct
- 39W821 S Hathaway Ln
- 39W821 S Hathaway (I 8)
- 39W826 S Hathaway Ln
- 39W814 Kellar Square
- 39W829 Kellar Square
- 0S361 Kellar Ct