Below is a chart breaking down the 2010/2009 sales comparisons by MLS Area for the Austin real estate market. This time I’m adding a couple of new things. First, there is color coding on each of the summary rows for each area. A green shade indicates “improvement” in the measured metric. I put “improved” in quotes because it’s debatable what that means, and for whom, so perhaps a better word to use would simply be “increase” toward seller’s market. Note that a decrease in Days on Market is an “improvement”, however, as it means homes are selling faster, so a negative number on DOM is coded green and vice-versa, whereas the other negative numbers are red. Confusing enough? I hope not.
Next, I added a new column called SP/OLP which is the Sold Price divided by the Original List Price. I think this is a useful metric to observe as it informs us of the gap between the original list price a seller was hoping to obtain and the ultimate sold price achieved. This is more useful to know than the more commonly reported metric of SP/LP (Sold Price/List Price) because it doesn’t disguise the price drops that occurred before the home eventually sold.
In other words, a home that started at a list price of $300K, was eventually dropped to $270K, and then sold for the $270K list price, would produce a SP/LP ratio of 100%, but a SP/OLP of 90%. The 90% is a more accurate measure of market strength or weakness in a given area. You’ll see below that some areas are right at 95% (which is pretty good) and some are below 90%, which is a tougher market requiring bigger price drops.
OK then, let’s take a quick look at the new format using the cumulative sold data for all of 2010 compared to 2009.
| All MLS | # Sold | Avg Sold | Med Sold | Avg SQFT | Avg PSF | Avg Days | Med Days | SP/OLP |
| 2010 | 17,709 | $255,049 | $195,000 | 2,214 | $115.20 | 73 | 48 | 93.19 |
| 2009 | 18,636 | $245,765 | $190,000 | 2,177 | $112.89 | 75 | 47 | 95.2 |
| Change | -4.97% | 3.78% | 2.63% | 1.70% | 2.04% | -2.67% | 2.13% | -2.11% |
So, with the color coding, this allows a “quick glance” gleaning of which areas saw increases/decrease in the measered metrics across the board. We can see above, looking at the entire Austin MLS market as a whole, that the average sold price increased 3.78%, median sold also increased, by 2.63%, Sold Price Per Square Foot increase 2.04%, and homes sold faster when looking at Avg Days on Market. But we also see that 5% fewer homes sold (lower demand) and that the median DOM and the SP/OLP ratios worsened. This “mixed” market is in fact what most areas produce.
One last aside, if an MLS Area is mostly red all the way across, such as Area 10S, does that mean buyers should avoid that area? Absolutely not. This is a look in the rear view mirror and doesn’t necessarily predict the future or indicate a trend. Same with areas that did well in 2010. This is just a snap shop of what happened in the given year 2010 compared to the year prior. If you own a home in an area that had a dog year, your particular neighborhood or size/price of home may have perfromed differently, and that won’t be reflected in this type of macro analysis of area-wide stats.
OK, the entire Austin MLS is broken down by MLS Area in the chart below. As usual, questions, comments, observations are welcome.
