NOT LISTED FOR SALE

Estimated Value: $2,321,066 - $3,044,000

5 Beds
6 Baths
10,383 Sq Ft
$261/Sq Ft Est. Value

Last Sold January 03, 2013

Last sale price $1,775,000 $171 Per Sq Ft

Est. 53% increase in value since last sale

Current estimated payment $19,173/month

46 Days on Market

Highlights

  • Water Views
  • Second Kitchen
  • In Ground Pool
  • Ferson Creek Elementary School Rated A
  • Home Theater
  • Rooftop Deck

About This Home

As of January 2013

Renowned as "The Castle" & "Ultimate Dream Home", this estate is incredible! Amazing, remarkable, opulent, grand, lavish & magnificent, not to mention eco-friendly (green), too! Experience the ultimate in architecture w/handcrafted cabinetry, extensive millwork, elaborate staircases, detailed ceilings, lavishly appointed mini master suites, waterfalls, designer's kitchen & in-law suite! Pool, spa, balconies & views!

Last Agent to Sell the Property

Debora McKay

Coldwell Banker Realty License #475103636 Listed on: 11/02/2012

Coldwell Banker Realty

Last Buyer's Agent

Debora McKay

Coldwell Banker Realty License #475103636 Listed on: 11/02/2012

Coldwell Banker Realty

Property Details

Home Type

  • Other

Est. Annual Taxes

  • $54,042

Year Built

  • 2008

Lot Details

  • Cul-De-Sac
  • Landscaped Professionally
  • Wooded Lot

Parking

  • Attached Garage
  • Carport
  • Heated Garage
  • Garage Transmitter
  • Tandem Garage
  • Garage Door Opener
  • Side Driveway

Home Design

  • Brick Exterior Construction
  • Slab Foundation
  • Stone Siding

Interior Spaces

  • Wet Bar
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • See Through Fireplace
  • Gas Log Fireplace
  • Mud Room
  • Entrance Foyer
  • Formal Dining Room
  • Home Theater
  • Heated Sun or Florida Room
  • First Floor Utility Room
  • Utility Room with Study Area
  • Gallery
  • Water Views

Kitchen

  • Second Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Butlers Pantry
  • Kitchen Island

Bedrooms and Bathrooms

  • Main Floor Bedroom
  • Primary Bathroom is a Full Bathroom
  • Maid or Guest Quarters
  • In-Law or Guest Suite
  • Bathroom on Main Level
  • Dual Sinks
  • Whirlpool Bathtub
  • Garden Bath
  • Shower Body Spray
  • Separate Shower

Unfinished Basement

  • English Basement
  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • Balcony
  • Rooftop Deck
  • Patio
  • Storage Shed

Utilities

  • Zoned Heating
  • Well
  • Private or Community Septic Tank

Property Details

Home Type

Other

Est. Annual Taxes

$54,042

Year Built

2008

Lot Details

0

Parking

6

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service
  • Architectural Style: French Provincial
  • Type Detached: 2 Stories
  • Special Features: None
  • Year Built: 2008

Interior Features

  • Appliances: Oven/Range, Microwave, Dishwasher, Refrigerator
  • Fireplaces: 6
  • Interior Property Features: Vaulted/Cathedral Ceilings, Hot Tub, Bar-Wet, 1st Floor Bedroom, In-Law Arrangement, 1st Floor Full Bath
  • Number Of Rooms: 13
  • Equipment: Central Vacuum, Security System, Intercom, Fire Sprinklers, CO Detectors, Ceiling Fan, Sump Pump
  • Fireplace Details: See through/Multi Sided, Wood Burning, Gas Logs, Gas Starter
  • Fireplace Location: Family Room, Master Bedroom, Basement
  • Basement: Full, English
  • Basement: Unfinished, Exterior Access
  • Bedrooms All Levels: 5
  • Master Bedroom Level: Main Level
  • Master Bedroom Size: 23X16
  • Master Bedroom Flooring: Hardwood
  • Primary Bedroom Bath: Full
  • Second Bedroom Level: 2nd Level
  • Second Bedroom Size: 26X16
  • Second Bedroom Flooring: Carpet
  • Third Bedroom Level: 2nd Level
  • Third Bedroom Size: 18X15
  • Third Bedroom Flooring: Carpet
  • Fourth Bedroom Level: 2nd Level
  • Fourth Bedroom Size: 20X15
  • Fourth Bedroom Flooring: Carpet
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink, Garden Tub, Full Body Spray Shower
  • Dining Room: Separate
  • Dining Room Level: Main Level
  • Dining Room Size: 18X15
  • Dining Room Flooring: Hardwood
  • Family Room Level: Main Level
  • Family Room Size: 25X20
  • Family Room Flooring: Carpet
  • Kitchen Type: Eating Area-Breakfast Bar, Island, Pantry-Butler, Pantry-Closet, Pantry-Walk-in
  • Kitchen Level: Main Level
  • Kitchen Size: 28X23
  • Kitchen Flooring: Travertine
  • Laundry Level: Main Level
  • Laundry Size: 12X12
  • Laundry Flooring: Slate
  • Additional Rooms: 2nd Kitchen, 5th Bedroom, Foyer, Gallery, Maid Room, Mud Room, Study, Sun/Florida Room Heated, Theatre Room, Utility Room-1st Floor
  • Additional Room 1 Name: 5th Bdrm
  • Additional Room 1 Level: 2nd Level
  • Additional Room 1 Size: 15X15
  • Additional Room 1 Flooring: Hardwood
  • Additional Room 2 Name: Theater Rm
  • Additional Room 2 Level: 2nd Level
  • Additional Room 2 Size: 26X20
  • Additional Room 2 Flooring: Carpet
  • Additional Room 3 Name: Sun/Florida Room Heated
  • Additional Room 3 Level: Main Level
  • Additional Room 3 Size: 20X19
  • Additional Room 3 Flooring: Travertine
  • Additional Room 4 Name: Maid
  • Additional Room 4 Level: 2nd Level
  • Additional Room 4 Size: 42X31
  • Additional Room 4 Flooring: Carpet
  • Additional Room 5 Name: Utility Room-1st Floor
  • Additional Room 5 Level: Main Level
  • Additional Room 5 Size: 13X12
  • Additional Room 5 Flooring: Slate
  • Additional Room 6 Name: 2nd Kitchen
  • Additional Room 6 Level: 2nd Level
  • Additional Room 6 Size: 12X10
  • Additional Room 6 Flooring: Hardwood
  • Additional Room 7 Name: Foyer
  • Additional Room 7 Level: Main Level
  • Additional Room 7 Size: 40X12
  • Additional Room 7 Flooring: Hardwood
  • Additional Room 8 Name: Gallery
  • Additional Room 8 Level: 2nd Level
  • Additional Room 8 Size: 22X12
  • Additional Room 8 Flooring: Hardwood
  • Additional Room 9 Name: Study
  • Additional Room 9 Level: Main Level
  • Additional Room 9 Size: 17X15
  • Additional Room 9 Flooring: Hardwood
  • Additional Room 10 Name: Mud
  • Additional Room 10 Level: Main Level
  • Additional Room 10 Size: 16X12

Exterior Features

  • Roof: Asphalt/Glass (Shingles)
  • Foundation: Concrete
  • Lot Size: 1.0-1.99 Acres
  • Exterior Building Type: Brick, Stone
  • Exterior Property Features: Balcony, Patio, Hot Tub, Roof Deck, Storage Shed, Pool In-Ground

Garage/Parking

  • Number of Cars: 6
  • Parking: Garage
  • Garage Type: Attached
  • Garage Details: Garage Door Opener(s), Transmitter(s), Carport, Heated, Tandem
  • Garage On Site: Yes
  • Number Garage Spaces: 6
  • Driveway: Side Drive

Utilities

  • Cooling: Central Air, Zoned
  • Electricity: Circuit Breakers, 200+ Amp Service
  • Water: Well-Private
  • Sewer: Septic-Private
  • Heating Fuel: 2+ Sep Heating Systems, Zoned

Schools

  • Elementary School: FERSON CREEK ELEMENTARY SCHOOL
  • Middle School: HAINES MIDDLE SCHOOL
  • High School: ST CHARLES NORTH HIGH SCHOOL
  • Junior High Dist: 303

Lot Info

  • Lot Dimensions: 175X329X170X379
  • Lot Description: Cul-de-sac, Landscaped Professionally, Water View, Wooded

Green Features

  • HERS Index Score: 62

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 2, 2012
Closed on
Dec 27, 2012
Sold by
Royal Savings Bank
Bought by
Khan Farhan A and Khan Nida
Seller's Agent
Debora McKay
Coldwell Banker Realty
Buyer's Agent
Debora McKay
Coldwell Banker Realty
List Price
$1,995,000
Sold Price
$1,775,000
Premium/Discount to List
-$220,000
-11.03%
Current Estimated Value
$2,713,022

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$938,022
Avg. Annual Appreciation
3.41%
Original Mortgage
$1,596,600
Interest Rate
3.3%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Jan 4, 2011
Sold by
Robert Lord Builders
Bought by
Royal Savings Bank

Purchase Details

Closed on
Nov 29, 2007
Sold by
Lord Robert and Lord Stacia C
Bought by
Robert Lord 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
$2,355,000
Interest Rate
7.5%
Mortgage Type
Construction

Purchase Details

Closed on
May 1, 2006
Sold by
Stoneleat Properties Inc
Bought by
Lord Robert and Lord Stacia C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$500,000
Interest Rate
6.54%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
May 12, 2005
Sold by
J & B Builders Inc
Bought by
Stoneleat Properties Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$850,000
Interest Rate
6%
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
Khan Farhan A $1,774,000 Fidelity National Title
Royal Savings Bank -- None Available
Robert Lord Builders Inc -- Chicago Title Insurance Co
Lord Robert $450,000 Chicago Title Insurance Comp
Stoneleat Properties Inc $1,500,000 Chicago Title Insurance Comp
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed Khan Farhan A $1,596,600
Closed Khan Farhan A $1,685,300
Previous Owner Robert Lord Builders Inc $2,355,000
Previous Owner Lord Robert $500,000
Previous Owner Lord Robert $999,999
Previous Owner Stoneleat Properties Inc $850,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/03/2013 01/03/13 Sold $1,775,000 -11.0% $171 / Sq Ft
12/18/2012 12/18/12 Pending -- -- --
11/02/2012 11/02/12 For Sale $1,995,000 -- $192 / 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 $54,042 $825,621 $118,643 $706,978
2023 $53,047 $738,150 $106,073 $632,077
2022 $49,996 $672,574 $96,650 $575,924
2021 $47,069 $635,043 $91,257 $543,786
2020 $47,019 $625,905 $89,944 $535,961
2019 $46,455 $616,716 $88,624 $528,092
2018 $46,388 $616,716 $88,624 $528,092
2017 $46,002 $607,662 $87,323 $520,339
2016 $50,234 $607,662 $85,118 $522,544
2015 -- $637,266 $82,767 $554,499
2014 -- $599,940 $84,036 $515,904
2013 -- $633,270 $85,446 $547,824
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD08213011

Midwest Real Estate Data (MRED)

APN: 08-12-179-005