Top Graphs

Master Merge - Lots of Data...just 1 Click!  < UPDATED 01/15/2012

HOW MUCH IS SELLING?
		Updated
Chart 1	Monthly sold volume for Ada & Canyon County.  (SHOWN 4 WAYS) Single Family, SF w/ Acreage, Townhouse, Condo 2009 - 2011.	1/13/2012
Chart 2	Monthly sold volume for Ada & Canyon County. Single Family Only 2009 - 2011	1/13/2012
AT WHAT PRICE?
Chart 3	Average Monthly Sold Price Single Family, SF w/ Acreage, Townhouse, Condo Ada & Canyon County 2009 - 2011	1/13/2012
Chart 4	Average Monthly Sold Price  (SHOWN 3 WAYS) Single Family Only Ada & Canyon County 2009 - 2011	1/13/2012
Chart 5	Average Monthly Sold Price Single Family Only Ada, Canyon, Gem , Elmore, Payette, Washington 2009 - 2011	1/13/2012
Chart 6	9 Counties Single Family & Single Family w/ Acreage Ada, Boise, Canyon, Elmore, Gem, Owyhee, Payette, Valley, Washington 2011 Average Sold Price	1/13/2012
How much down from list price?
Chart 7	Average Monthly Sales Ratio Single Family Ada & Canyon County 2009 - 2011 List Price / Sold Price = Sales Ratio	1/13/2012
Other Counties
Chart 9	Gem County Single Family & Single Family w/ Acreage Sales Ratio, Avg Sold Price, Amount Sold 2008  - 2011	12/13/2011
Chart 10	Elmore County Single Family & Single Family w/ Acreage Sales Ratio, Avg Sold Price, Amount Sold 2009 - 2011	12/13/2011
Compared to Previous Years?
Chart 11	Data Table- Sold Price by Type of Home Single Family, SF w/ Acreage, Condo, Townhouse Ada County 2005 - 2011	1/13/2012
Chart 12	Graph -Average Monthly Sold Price Single Family, SF w/ Acreage, Condo, Townhouse Ada County 2009 - 2011	1/13/2012
Chart 13	Data Table- Sold Price by Type of Home Single Family, SF w/ Acreage, Condo, Townhouse Canyon County 2005 - 2011	1/13/2012
Chart 14	Graph- Average Monthly Sold Price Single Family, SF w/ Acreage, Condo, Townhouse Canyon County 2009 - 2011	1/13/2012
What County are the Sales in?
Chart 15	Last 12 Month Sales Pie Graph for 9 Counties Ada, Boise, Canyon, Elmore, Gem, Owyhee, Payette, Valley, Washington	1/13/2012
Chart 16	Sold Price Distribution Last 12 Months Sales Below $500,000 Ada & Canyon	1/13/2012
Chart 17	Average Quarterly Sold Price Ada & Canyon County Single Family Only 2001 - 2011 - BIG PICTURE	1/13/2012
Chart 18	Average Quarterly Sales Ratio Ada & Canyon County Single Family Only 2001 - 2011- BIG PICTURE	1/13/2012
Summary Data Tables
Chart 19	Average Monthly Sold Price Single Family Ada & Canyon County By MLS Area 2008 - 2011	1/13/2012
Chart 20	Average Monthly Sold Price Single Family with Acreage Ada & Canyon County By MLS Area 2008 - 2011	1/13/2012

TIME ADJUSTMENTS - SUPPORTING DATA                Updated 7/10/201

(For all you local appraisers, I did the math for you)

Method 1    Time Adjustments based on 3 Month Rolling Average Sold Price  (click to open)

   Pros: Most people like average and understand it.

   Cons: When working with smaller data sets (just one MLS Area, like Eagle) and when you
            have a $3,000,000 sale (10 times the average sold price) it will skew the figures.  
          
            This is is why you must also consider the Meidan Sold Price.

 Green = Good, 0% or better

 Red = Bad. Less than 0%.

 ROLLING 3 MONTH AVERAGE

2011	2011	2011	2011	2011	2011	2011	2011	2011	MLS Defined Area
Jan	Feb	Mar	Apr	May	Jun	July	Aug	Sept
0.24%	-0.08%	-0.72%	-0.86%	-1.62%	-1.04%	-0.51%	0.30%	0.04%	North Boise - 0100
-0.67%	-0.88%	-1.89%	-0.21%	0.28%	0.50%	-0.56%	0.03%	0.38%	NE Boise - 0200
-0.07%	-0.28%	-0.84%	-1.08%	-1.72%	-1.00%	-0.73%	-0.32%	-0.15%	SE Boise - 0300
-1.42%	-2.18%	-2.04%	-1.20%	-0.30%	-0.58%	-0.68%	-1.25%	-0.30%	Boise Bench - 0400
-0.77%	-0.16%	-0.90%	-0.80%	-0.31%	-0.50%	-0.40%	-0.06%	-0.57%	South Boise - 0500
-1.01%	-0.69%	-0.92%	-1.18%	-1.44%	-1.30%	-0.48%	0.08%	0.42%	SW Boise-Meridian - 0550
-0.72%	-0.83%	-1.43%	-1.16%	-0.95%	-0.48%	-0.50%	-0.42%	-0.24%	W Boise-Garden City - 0650
-1.31%	-1.92%	-1.98%	-1.80%	-1.22%	-0.59%	-0.25%	-0.30%	-0.64%	West Boise - 0600
-0.02%	0.11%	-0.28%	-0.86%	-1.06%	-0.74%	0.22%	0.37%	-0.75%	NW Boise - 0800
0.48%	0.30%	0.58%	-0.80%	-0.30%	-0.80%	-0.08%	-0.38%	-0.07%	Eagle - 0900
-1.66%	-1.62%	-0.74%	-1.21%	-1.39%	-1.91%	-0.80%	0.25%	-0.02%	Star - 0950
-0.25%	-0.16%	-0.69%	-0.94%	-1.04%	-0.85%	-0.17%	0.43%	1.44%	SE Meridian - 1000
-0.89%	0.66%	1.09%	0.07%	-0.53%	-1.30%	0.14%	1.05%	1.11%	SW Meridian - 1010
-0.52%	-0.35%	-0.71%	-1.13%	-1.14%	-0.27%	0.06%	0.64%	0.45%	NE Meridian - 1020
-0.54%	-0.58%	-0.56%	-0.79%	-0.81%	-0.49%	-0.10%	-0.04%	0.15%	NW Meridian - 1030
-1.10%	-0.94%	-1.41%	-1.45%	-1.58%	-1.81%	-2.21%	-1.15%	-0.65%	Kuna - 1100
-1.02%	-1.18%	-1.29%	-1.35%	-1.06%	-0.52%	-0.39%	0.03%	0.65%	NE Nampa (87) - 1250
-1.27%	-1.24%	-1.08%	-1.18%	-1.01%	-0.94%	-1.38%	-0.88%	-0.76%	South Nampa (86) - 1260
-1.81%	-2.36%	-2.47%	-1.64%	-0.97%	-0.55%	-0.78%	-0.68%	-0.26%	NW Nampa (51) - 1270
-1.46%	-1.44%	-1.46%	-0.18%	-0.63%	0.30%	-0.47%	-0.24%	-1.25%	Middleton - 1285
-0.10%	-1.23%	-2.45%	-1.76%	-1.47%	-0.62%	-0.44%	-0.91%	-1.98%	NW Caldwell - 1275
-1.74%	-1.46%	-1.55%	-0.95%	-0.55%	-0.07%	-0.34%	-0.50%	-0.73%	SW Caldwell - 1280

Keep in mind, June-11  figure (MLS 0100 -1.04%) is based on the average sold price of;
 (((July-10 + Aug-10 + Sept-10)/3) / ((March-11 + May-11 + June-11)/3) -1 ) / 12

The formula is taking a rolling yearly quarterly average of the change in average sold price.

Method 1A  Time Adjustement Summary based on 3 Monthly Rolling MEDIAN Sold Price

   Pros: Removes the high and low swing.  Is very close to Average Sold Price with large data sets. 
           A more reliable method to show trend direction change with small data sets.

   Cons: Will not show when you have a handful of high price sales, such as over $1,500,000
            when banks  liquidate REO inventory.

(Same Home Selling Twice over Time)

                   BOISE     EAGLE        MERIDIAN

Pros: Your comparing apples to apples.  Same address sold at two different times.  

Cons: Homes typically have over 1 year hold time, therefore it will lag in showing the trend, esp 
         in a steep downward market.    

         Hard to get information.

        This is why the above Boise graph does not go "negative" until 2008.      

Method 3    Use Government Published Data

  Pros:  Easy to get.  No real work involved.

  Cons: Semi-generic. Not specific to an area, subdivision, MLS Area, type of home.

The data will SLIGHTLY change due to MLS "closed" date is not input into MLS sometimes 4 - 5 days after month end. I ususally pull the data 2 -3 days after month end, missing about 30 - 50 sales. Therefore months are updated mid-month. It will typically just change the "count", not the average sales price.

*This website contains raw data taken from IMLS. The information is edited and reviewed for format and context by Hennessey Appraisals.