Home : Blogs : David Gibbons : David 's Blog

Zillow releases raw data behind Q4 Housing Reports

Hi All,

Zillow has released its quarterly reports on house value trends in the US in Q4 2006.

More details about the reports can be found in this blog post in which Zillow's Director of Analytics explains that "For these 2006 fourth quarter results, we’re taking a slightly different approach than in the past when we released detailed reports and analysis for five specific markets and an overall national summary. Instead, this quarter, we’re releasing all the underlying data on which we based the earlier reports and we’re providing this data for a total of 75 different metropolitan regions around the country."

I'd love to hear your opinion on the trends we measured in your neck of the woods -- below this you'll see links to the raw data (in excel) for the 75 regions we analyzed.

The big news in the aggregate data is that in Q4, we saw negative (Y-O-Y) appreciation for the first time in the US data set.

House value trend and appreciation - USA

Looking at performance in the Top 25 Metro areas however drives home again the local nature of our business -- multiple regions are still measuring double-digit appreciation in Q4. This graphic isn't very clear (better version here - any tips on posting photo's?) -- but it illustrates very well the variance in appreciation in the top 25 Metro areas.

Regional appreciation and value trends - Q4 2006

Some more interesting factoids from this data:

Five highest-appreciating metropolitan areas (year-over-year appreciation):

Lakeland-Winter Haven, FL (25.88%)
Yuma, AZ (25.66%)
Myrtle Beach, SC (21.24%)
Flagstaff, AZ (19.02%)
Ocala, FL (17.56%)

Five most expensive metropolitan areas (measured by Zindex):

San Francisco-Oakland-San Jose, CA ($684,459)
Salinas, CA ($654,503)
Santa Barbara-Santa Maria-Lompoc, CA ($627,323)
Honolulu, HI ($626,452)
Los Angeles-Riverside-Orange County, CA ($545,409)

Five least expensive metropolitan areas (measured by Zindex):

Davenport-Moline-Rock Island, IA-IL ($86,201)
Peoria-Pekin, IL ($91,984)
Greenville-Spartanburg-Anderson, SC ($96,508)
Tulsa, OK ($97,186)
Dayton-Springfield, OH ($103,729)

Local Reports

Posted by David Gibbons on 02/10/2007 03:41 AM

Comments (19)

trends, analytics, house value, zillow, metrics, appreciation

19 Comments on Zillow releases raw data behind Q4 Housing Reports

FEB

2007

David, where is metro Detroit? You have much smaller cities than this on here.

M & D --

Sorry that Detroit didn't make the cut. We excluded about 25 metro's where we have insufficient raw data to draw conclusions about housing trends. Collecting raw data is MI is still a challenge for us -- only 32% of MI homes are on Zillow today but we are working on it.

Well, I guess that explains why the zestimates are so far off here too.

Maureen

FEB

2007

Thanks for the data. When do you expect to have more complete information on New Jersey in Zillow? Currently many towns have only assessed values listed.

David thanks for the data. But tell me how come you did not update your profile? I alway like to read something about the author of the post.

Thanks for posting this David. I've got to make the time to look at it thoroughly. So far my experience with Zillow has been that the home values come in way lower than true market value in my area.

The reports are interesting but are they really accurate overall?.

I am rather surprise that there is nothing on Kansas City.

Are you using average price or median price?

New York County = Manhattan

NYC is made up of 5 counties:

New York County, Queens County, Kings County(Brooklyn) Bronx County, Richmond County (Staten Island)

I think when you are referring to New York County and New York City you are referring to Manhattan, the numbers seem to reflect that.

Check out CyberHomes.com a new company competing with Zillow.

It's interesting to see how much the prices have risen over the past ten years in North Port. I know it's not precisely accurate but it's interesting to look at!

I'm actually quite happy that Austin didn't make the list. I want to see appreciation, but just at a slow and steady pace.

Very interesting. I am hearing from some large lenders that they are seeing "declining" markets - I wonder how these figures correspond to the lenders' opinions. Very interesting.

MAR

2007

Good information

MAR

2007

David good post and good data!! Thanks.

Good Day!! have a cup of java and a smile on me :)

APR

2007

why have I yet to hear from Zillow?

MAY

2007

Thanks for the info - The San Luis Obispo - Atascadero - Paso one is a broken link. This is the region which I am from.

JUN

2007

Good to meet you this weekend David (tried to find a good place to put the comment so this will have to do)O and chatting about the online real estate market. The AR bbq allowed me to rub shoulders with the big wigs :) take care and enjoy the week!

FEB

Regarding the graph Zindex and Appreciation... the red line... who dropped the rock off the cliff?

Yikes- many of us saw it coming... but not quite to that extent.

Leave a response…

Name:

Email:
(optional)

Comment:

What does the graphic say?