Diamonds of Real Estate Data

By: Tommy Unger, Data Analyst | December 6, 2007

Recently we released the 2007 Q3 Zillow Home Value Reports. Stan has already pointed out that the markets are cooling in his quarterly report summary. His analysis also shows that it’s “raining” on some markets a bit more than others. The map included in his post gives us a macro view of the metro areas. If you really want to dig into a market, you can open up the Excel files to get market details about the performance of different home types as well as geographies ranging from counties to neighborhoods.

Maybe spreadsheets and pivot tables and thousands of numbers aren’t quite what you’re looking for. It’s always nice to complement the relative dryness of the raw numbers with a more exciting visualization. Last quarter we used a rankbar to compare the performance of the top metropolitan areas. This quarter we’re using Zillow’s data and Microsoft’s Virtual Earth to let you explore and dive into markets throughout the country.

Click the map above or go here to explore the 2007 Q3 quarterly report data. Scroll through and click on the metro areas to view the year over year change for regions within the market. Hover over a diamond for more details. The color of the shape indicates the year over year change. The size of the shape is proportional to the number of homes in the market. Click the “Q” link to download the Excel quarterly report. Click the “Z” to browse this metro area on the Zillow map.

We’re sitting on a mountain of real estate information, and this is just one of the many interesting ways we can slice and dice this data. As always, let us know what you’d like to see more of in the future.

Stumble it!
Categories: Real Estate Analytics, Zestimate

Comments

3 Comments so far

Ryan B From Zillow on December 6, 2007 1:13 pm

Tommy, awesome chart. You’ll often hear that a community is down, but this map highlights that even in an area that has cooled off there are still often times hotspots. The most troubling map for me was Phoenix. Last year that was such a hot market that I’m surprised to see it fall as much as it has. In my mind that was a market similar to Seattle, but I guess that is no longer the case.
Minnesota & Wisconsin Lake Property on January 17, 2008 6:37 pm

This will be really helpful
Adam Blomdahl on February 20, 2008 8:00 pm

I recently made a few postings on the website.
Overall the site is very good compared to other Realestate spec sites, with alot of room for improvement. I think in time it will gradually improve or I will find a better one to replace it.

Examples of improvements are map-data surfing ease of movement. I find it anoying to continue to have to reset my browser everytime I want to check the map to available listings.

Another issue is there is no heat map listed for Kansas City, Kansas but there is one for MO and when I search for listings in that state I am automatically deverted to KC MO.
I know there is more listings there but to have my page automatically show up on most listings is not finding particular speculations. Thank-you