Sales Spreadsheets for Lake Villa Township

My office has compiled a detailed list of sales that have occurred in Lake Villa Township during 2008, 2009 and 6 months of 2010.   This list can be used to find other homes that have sold for comparison to your property.

There are three separate Excel spreadsheets.  They are larger files so it may take a longer time to download.  The spreadsheets are sorted by the neighborhood number defined by our office and then by PIN within the neighborhood.  Using the data sort feature in Excel the spreadsheet can be sorted by any column desired.

We have tried to include every sale that has occurred.  However we have excluded some.  A sale would be excluded if it was judicial forced foreclosure, a sale between relatives, or a sale that was not exposed to the open market.  We have include the “short sales”, bank owned sales, and other sales occurring in this unusual market.

There is a column “Qualified sale” – a yes or no entry.  Those few sales that do not meet our standard for a fair market transaction are listed with “no” in this field.  Using those properties as comparables should be avoided if possible

After finding the comparable homes from the spreadsheet, use the Lake County website to prepare the comparison grid to find the best comparable properties.  The are instruction for using the Lake County website found here

Lake Villa Sales Spreadsheet Column and Consrtruction Style Definitions
Column heading	Definitions
PIN	Parcel Identification Number
#	House number
Dir	Street direction (north south east west)
Street	Street name
City	City
NBHD#	The neighborhood number we assign.  Normally this is by geographic area and can also be grouped by model of home or style of construction.
NBHD Name	Descriptive name associated with the neighbor number
Multi PIN Sale	Either a yes or no entry to note the number of parcels included in the purchase price.  “no” equals 1 parcel “yes” means more than 1 parcel.  If “yes” further research should be conducted to find all parcels and the assessed values.  Only the parcel information describing the dwelling is shown.
HT	House Type.  This is a Assessor defined field and it can mean different things in different subdivisions.  Generally try to find the same house type within the same subdivision.  House type can depict the style of construction or it can delineate the model of house.
Style	Style of construction described below
Yr Blt	Year the home was built
AGLA	Above Grade Living Area.  This area exclude the basement.  For tri-level and raise ranches this area does not include the lower level area.
Grade	The quality grade of the home
Qualified sale	A yes or no entry.  We have tried to include every sale on this list yet there are a few sales that do not meet our standard for a fair market transaction.  Those are listed with “no” in this field.
Sale Price	The price paid for the property
Sale Date	Date the transaction was completed
Sale price per AGLA	The sale price divided by the above grade living area.  This provide a basic mode of comparison.
Style Definitions
Style	Description
1C	1 sty no basement
1B	1 sty with basement
1A	1 sty with attic
1.5C	1.5 sty no basement
1.5B	1.5 sty with basement
1&1.5	1 and 1.5 Sty
RR	Raised ranch
RRLOG	Raised ranch with Living over garage
TRI	Tri-Level
Quad	Quad-Level
1&2CG	1 and 2 Sty no basement with Living over garage
1&2BG	1 and 2 Sty with basement and Living over garage
1&2C	1 and 2 Sty no basement
1&2B	1 and 2 Sty with basement
2CG	2 Sty no basement with Living over garage
2BG	2 Sty with basement and Living over garage
2C	2 Sty no basement
2B	2 Sty with basement
Multi	Multi-level structure