NOT LISTED FOR SALE

Estimated Value: $381,000 - $1,041,000

4 Beds
7 Baths
8,479 Sq Ft
$82/Sq Ft Est. Value

Last Sold October 01, 2020

Last sale price $1,050,000 $124 Per Sq Ft

Est. 43% decrease in value since last sale

Current estimated payment $3,507/month

155 Days on Market

Highlights

  • Lake Front
  • Beach
  • Home Theater
  • Fremont Intermediate School Rated A-
  • Boat Slip
  • Heated Floors

About This Home

As of October 2020

Can not be duplicated for less than $2.5 million! Why travel to Michigan or Wisconsin to your second home? Vacation year-round at your Spectacular Waterfront Estate with 350' of private Lakefront. Over 5 acres connect to neighborhood beach. Enjoy a cozy fire in the Vaulted Cedar Screened Porch. Open floor plan is ideal for entertaining. Huge Family Room with soaring Limestone Fireplace and gorgeous views of the Lake. Kitchen with large center island, Wolf, SubZero, loads of cabinets, granite counters, travertine floors & access to large Trex Balcony. First Floor Master Suite with Fireplace, balcony, Luxury Bath with Steam Shower, Heated Floors & Turreted Sitting Area. Walnut Library with handsome coffered ceiling, Fireplace & Balcony. Walk-out Lower Level with dynamite custom Bar, Theater, Wine Cellar, Fireplace, Full Bath. New Heavy Cedar Shake Roof with copper flashing 2018! Whole house automatic Generac generator. Four Car Garage & Basement with radiant heated floors. Extensive landscaping, terracing, & inground sprinkler systems. New permanent boat dock with electric. Cool drone video of lake & exterior available. Check out walk through video.

Last Agent to Sell the Property

Elizabeth Bryant

Baird & Warner License #475131493 Listed on: 03/06/2020

Baird & Warner

Co-Listed By

Liz Anderson

@properties Christie's International Real Estate License #475131755

Last Buyer's Agent

Non Member

NON MEMBER

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,100

Year Built

  • 2003

Lot Details

  • Lake Front
  • Landscaped Professionally
  • Wooded Lot

HOA Fees

  • $83 per month

Parking

  • Attached Garage
  • Garage ceiling height seven feet or more
  • Heated Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Garage Is Owned

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Wood Shingle Roof
  • Stone Siding

Interior Spaces

  • Wet Bar
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • See Through Fireplace
  • Gas Log Fireplace
  • Sitting Room
  • Home Theater
  • Library
  • Recreation Room
  • Loft
  • Game Room
  • Screened Porch
  • Storage Room
  • Heated Floors
  • Water Views

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Butlers Pantry
  • Double Oven
  • Range Hood
  • Microwave
  • High End Refrigerator
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • Main Floor Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Bathroom on Main Level
  • Bidet
  • Dual Sinks
  • Whirlpool Bathtub
  • Double Shower
  • Steam Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Partially Finished Basement

  • Walk-Out Basement
  • Exterior Basement Entry
  • Finished Basement Bathroom
  • Rough-In Basement Bathroom

Outdoor Features

  • Boat Slip
  • Balcony
  • Deck
  • Patio
  • Fire Pit

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • Water Rights

Community Details

  • Beach

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,100

Year Built

2003

Lot Details

0

HOA Fees

$83 per month

Parking

4

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service
  • Age: 16-20 Years
  • Full Bathrooms: 6
  • Half Bathrooms: 1
  • Number Interior Fireplaces: 5
  • Ownership: Fee Simple
  • Total Full or Half Bathrooms: 6.1
  • Style Of House: Traditional
  • Type Detached: 2 Stories
  • Estimated Year Built: 2003
  • Tax Exemptions: Homeowner
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2003

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Bar-Wet, Heated Floors, 1st Floor Bedroom, 1st Floor Laundry, 1st Floor Full Bath
  • Number Of Rooms: 14
  • Living Room: Dimensions: 17X15, On Level: Main Level, Flooring: Hardwood
  • Appliances: Oven-Double, Microwave, Dishwasher, Refrigerator, High End Refrigerator, Washer, Dryer, Disposal, All Stainless Steel Kitchen Appliances, Wine Cooler/Refrigerator, Range Hood
  • Equipment: Humidifier, Security System, CO Detectors, Ceiling Fan, Sump Pump, Sprinkler-Lawn, Backup Sump Pump;, Power Generator
  • Fireplace Details: See through/Multi Sided, Wood Burning, Gas Logs, Gas Starter
  • Fireplace Location: Family Room, Master Bedroom, Basement
  • Basement: Walkout
  • Basement: Partially Finished, Exterior Access, Bathroom Rough-In
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 4
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Whirlpool, Steam Shower, Double Sink, Bidet, Double Shower
  • Above Grade Bedrooms: 4
  • Laundry: Dimensions: 12X11, On Level: Main Level, Flooring: Travertine
  • Dining Room: Dimensions: 17X15, On Level: Main Level, Flooring: Hardwood
  • Kitchen Type: Dimensions: 27X19, On Level: Main Level, Flooring: Travertine
  • Kitchen Type: Eating Area-Breakfast Bar, Eating Area-Table Space, Island, Pantry-Butler, Pantry-Closet, Pantry-Walk-in
  • Additional Rooms: Library, Loft, Recreation Room, Game Room, Sitting Room, Theatre Room, Walk In Closet, Screened Porch, Storage
  • Master Bedroom: Dimensions: 38X28, On Level: Main Level, Flooring: Hardwood
  • Additional Room 1 Name: Library, Dimensions: 16X14, On Level: Main Level, Flooring: Hardwood
  • Additional Room 2 Name: Loft, Dimensions: 17X14, On Level: Main Level, Flooring: Hardwood
  • Bedroom 2: Dimensions: 23X15, On Level: 2nd Level, Flooring: Hardwood
  • Additional Room 3 Name: Recreation Rm, Dimensions: 27X20, On Level: Walkout Basement, Flooring: Carpet
  • Bedroom 3: Dimensions: 20X16, On Level: 2nd Level, Flooring: Hardwood
  • Additional Room 4 Name: Game Rm, Dimensions: 22X12, On Level: Walkout Basement, Flooring: Carpet
  • Bedroom 4: Dimensions: 18X15, On Level: 2nd Level, Flooring: Hardwood
  • Additional Room 5 Name: Sitting, Dimensions: 12X12, On Level: Main Level, Flooring: Carpet
  • Additional Room 6 Name: Theater Rm, Dimensions: 22X14, On Level: Walkout Basement, Flooring: Carpet
  • Additional Room 7 Name: Walk in Closet, Dimensions: 19X10, On Level: Main Level, Flooring: Hardwood
  • Additional Room 8 Name: Screened Porch, Dimensions: 20X13, On Level: Main Level, Flooring: Other
  • Additional Room 9 Name: Bar, Dimensions: 21X17, On Level: Walkout Basement
  • Additional Room 10 Name: Storage, Dimensions: 62X15, On Level: Walkout Basement, Flooring: Other
  • Estimated Sq Ft: 8479
  • Dining Room Type: Separate
  • Family Room: Dimensions: 24X18, On Level: Main Level, Flooring: Hardwood

Exterior Features

  • Foundation: Concrete
  • Lot Size: 5.0-5.99 Acres
  • Exterior Building Type: Brick, Stone
  • Roof Type: Wood Shakes/Shingles
  • Waterfront: Yes
  • Exterior Property Features: Balcony, Deck, Patio, Porch Screened, Boat Slip, Fire Pit
  • Acreage: 5.1785

Garage/Parking

  • Number of Cars: 4
  • Parking: Garage
  • Garage Type: Attached
  • Garage Details: Garage Door Opener(s), Transmitter(s), Heated, 7 Foot or more high garage door
  • Garage On Site: Yes
  • Number Garage Spaces: 4
  • Driveway: Asphalt
  • Garage Ownership: Owned

Utilities

  • Air Conditioner: Central Air, Zoned
  • Water: Public
  • Sewer: Sewer-Public
  • Heating Fuel: Gas, Forced Air, 2+ Sep Heating Systems, Zoned

Condo/Co-op/Association

  • Fee Frequency: Annual
  • Assessment Includes: Security, Lake Rights
  • Assessment Association Fees: 1000

Schools

  • School District: 120
  • Elementary School: Fremont Elementary School
  • Middle School: Fremont Middle School
  • High School: Mundelein Cons High School
  • Junior High Dist: 79

Lot Info

  • Lot Dimensions: 410X1033X342X762
  • Lot Description: Beach, Lake Front, Landscaped Professionally, Water Rights, Water View, Wooded
  • Parcel Identification Number: 10263060020000

Tax Info

  • Taxes: 31731.32

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 6, 2020
Closed on
Sep 25, 2020
Sold by
Arendt Christopher J
Bought by
Teipel Gregory J and Teipel Ashley
Seller's Agent
Elizabeth Bryant
Baird & Warner
Buyer's Agent
Non Member
NON MEMBER
List Price
$1,250,000
Sold Price
$1,050,000
Premium/Discount to List
-$200,000
-16%
Total Days on Market
155
Current Estimated Value
$593,333

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$456,667
Avg. Annual Appreciation
-11.05%
Original Mortgage
$500,000
Interest Rate
2.75%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 25, 2013
Sold by
Arendt Christopher
Bought by
Arendt Christopher J and Christopher J Arendt Revocable Trust

Purchase Details

Closed on
Jun 8, 2011
Sold by
Arendt Gina
Bought by
Arendt Christopher

Purchase Details

Closed on
Feb 15, 2002
Sold by
Kolschowsky Gerald A
Bought by
Arendt Christopher and Arendt Gina
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
Teipel Gregory J $1,050,000 Fidelity National Title
Arendt Christopher J -- None Available
Arendt Christopher -- None Available
Arendt Christopher $575,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Teipel Gregory J $500,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/01/2020 10/01/20 Sold $1,050,000 -10.3% $124 / Sq Ft
08/08/2020 08/08/20 Pending -- -- --
06/25/2020 06/25/20 Price Changed $1,170,000 -6.4% $138 / Sq Ft
03/06/2020 03/06/20 For Sale $1,250,000 -- $147 / 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 $2,100 $29,313 $29,313 --
2023 $3,789 $26,858 $26,858 --
2022 $3,789 $48,196 $48,196 $0
2021 $3,619 $46,508 $46,508 $0
2020 $871 $10,865 $10,865 $0
2019 $2,806 $34,987 $34,987 $0
2018 $1,409 $17,904 $17,904 $0
2017 $1,402 $17,340 $17,340 $0
2016 $1,370 $16,469 $16,469 $0
2015 $1,361 $15,439 $15,439 $0
2014 $3,120 $35,604 $35,604 $0
2012 $3,677 $35,920 $35,920 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD10658661

Midwest Real Estate Data (MRED)

APN: 10-26-306-001