Zillow home value estimates SALES PRICES for Phoenix are OFTEN dangerously misleading

by John Wake on October 5, 2008

Tom Ruff of The Information Market is the most knowledgeable guy I know about foreclosures in Maricopa County.

Zillow uses Trustee Deed values

Tom says Zillow currently displays Trustee Deeds as the most recent sale!

Trustee Deeds come from foreclosure auctions (Trustee Sales) and they are certainly not open market transactions. You get a Trustee Deed when you buy a home at a foreclosure auction (Trustee Sale). Banks get a Trustee Deed if no one successfully bids at a foreclosure auction and the bank takes ownership.

Currently, about 95% of these foreclosure auctions end up with the bank taking ownership. That means that about 95% of the time the value shown on Trustee Deeds is the opening bid amount of a FAILED foreclosure auction (Trustee Sale) and does not reflect an open market transaction.

The value given on a Trustee Deed has little to do with the market value of the home. The banks can make the opening bid whatever they want, for example, the banks often make the opening bid the outstanding mortgage amount.

The values shown on Trustee Deeds should not be used in any home price valuation model such as Zillow’s “zestimates” because they are not open market transactions.

Tom says Zillow’s model is “not only naive, it’s dangerous.”

[CORRECTION: Read the comments. Zillow does not include repossessions in calculating the Zestimate but they do at this time display repossessed homes as being sales on their maps of home sales in metropolitan Phoenix. Hopefully, Zillow will correct this soon.]

In the data I use here at Arizona Real Estate Notebook and in my weekly newsletters, Home Sale News, I do not include Trustees Deeds because they are not open market transactions.

In fact, it was the inclusion of Trustee Deeds that caused a brouhaha with the Greater Phoenix home sales data published by Dr. Butler at Arizona State University.

{ 18 comments… read them below or add one }

1

Sam Chapman 10.06.08 at 12:20 pm

That is pretty poor. I come across people all the time who want to believe what they see at a tax appraisal district or Zillow as being an accurate reflection of market value. There is much more than meets the eye and I wish someone could get the word out about what is real and what isn’t.

2

Real Estate Agent 10.06.08 at 2:49 pm

A lot of people are misled by Zillow, unfortunately. Zillow is aware that their information is not the most accurate due to the fact that they have never actually stepped foot inside a home, but people too often take their algorithim’s value as the word instead of their starting point. Check out Zillow, then contact a professional.

3

david wilson 10.07.08 at 8:10 am

The fact that no one bid on them means that the price is too high, not the other way!

4

Michael 10.07.08 at 2:03 pm

In my neighborhood, these trustee sales are usually a low value and Zillow does not count them as towards valuation.

5

John Wake 10.07.08 at 2:13 pm

Michael, Good to know. I wonder why Tom says otherwise. I didn’t look into it myself. I’m confused now.

6

Jay Thompson 10.07.08 at 6:59 pm

I’d be interested in hearing from Zillow on this. Hope you don’t mind that I took the liberty of emailing David G….

7

Miami Real Estate Attorney 10.07.08 at 8:35 pm

Zillow is just one data point. People should do their own research, as well as contact a couple of different Realtors in the area.

8

John Wake 10.07.08 at 10:42 pm

Jay,

Thanks!

9

David G from Zillow.com 10.08.08 at 9:35 am

Hi John, it’s David G from Zillow,

On this topic, Tom is not a knowledgeable guy. Michael is correct. Zillow excludes foreclosure transactions from Zestimate calculations just like a Realtor will typically exclude foreclosures from their CMA.

Excluded transactions are clearly marked on the site. Take this home for example: http://tinyurl.com/4×2esl - there’s an asterisk next to the trustee sale that happened on 8/25/08 that says “* Transaction not included in Zestimate.”

Please correct your post.

10

David G from Zillow.com 10.08.08 at 10:30 am

Sorry that’s the wrong link. Here’s the home I mentioned: http://www.zillow.com/homedetails/2347-W-Laurel-Ln-Phoenix-AZ-85029/7749475_zpid

11

John Wake 10.08.08 at 11:54 am

David,

Thanks!

So Zillow doesn’t use foreclosure sales in Zestimate calculations.

I wonder why he was confused?

Does Zillow show the value given on Trustee Deeds as the sale price? If so, perhaps he saw that and assumed they were also used in the Zestimate calculations.

12

David G from Zillow.com 10.08.08 at 12:56 pm

John -

My pleasure. Please also correct your post and its title.

If Tom has an example he’d like me to review, please send him my e-mail.

Thanks

13

John Wake 10.08.08 at 1:29 pm

David,

So I finally broke down and checked it for myself.

The very first home I looked at in the MLS that was bank owed in my zip code had a trustee deed dated 7/24/08 with a value of $119,600. The new owner was Aurora Loan Services LLC.
http://armls.imapp.com/ilinks/viewer/2f839ff5f6425c51e0276409381b739e

Zillow shows that same home sold on 7/24/08 for $119,600. So Zillow is presenting this Trustee Deed as a sale.

http://www.zillow.com/homedetails/9460-E-Mission-Ln-UNIT-123-Scottsdale-AZ-85258/8061468_zpid

Now, don’t miss the asterisk by the price which states the sale was not used in the calculation of the zestimate.

So I think Tom was indeed correct. Zillow is listing Trustee Sales as open market sales (with an asterisk) which is misleading and in his opinion, dangerously so.

Now, the website says (follow the asterisk) that that sale is not used in the calculation of the zestimate.

So it seems you are both right.

14

John Wake - Real Estate 10.08.08 at 1:50 pm

I think Zillow should not only not use Trustee Deed information in calculating the Zestimate, Zillow should not present Trustee Deed information as home sales either because they are not open market transactions, that is, no money changes hands with most Trustee Deeds. Usually, the foreclosure auction fails and the lender takes back the property via a Trustee Deed.

15

David G from Zillow.com 10.08.08 at 1:54 pm

John,

With all due respect, your conclusion is incorrect.

Nowhere on the site does Zillow either claim or suggest that the trustee sale is a market sale. It is however a sale - I hope that you understand that.

Zillow is not guilty of either of the criticisms that you and Tom are trying to attach to the site. We don’t suggest that trustee sales are market sales and we don’t use trustee sales in Zestimate calculations. I can obviously understand where Tom’s confusion comes from but the bottom line is that he is jumping to false conclusions and not reading the details on Zillow.

I must respectfully insist that you correct your post.

16

John Wake - Real Estate 10.08.08 at 2:10 pm

David,

Zillow obviously knows that Trustee Deeds sale prices are funky because you don’t use them in your Zestimate calculation.

My position is that Trustee Deeds where the lender takes back the property are not sales at all despite the description on Zillow because no money changed hands.

There was a change of ownership but there was definitely not a sale.

17

Mark in Rio Verde 10.10.08 at 8:48 pm

I know that the prices on Zillow for Phoenix are always skewed and usually to the very high side vs being lower than actual… and now, thanks to your research I know why. Seems to me Zillow would be served quite well buy spending less on their legal team writing disclaimers to cover EVERYTHING KNOWN TO MAN and SEVERAL THAT AREN’T and spending more to insure the validity and accuracy of their data. If you “guess” that there is a 6 to 9 month time lag between a foreclosure deed being foreclosed and a subsequent sale of the foreclosed property to a buyer being recorded - there are thousands of properties on Zillow that at best show what the bank took them back for and NOTHING even close to their current asking or sale price until a subsequent-to-foreclosure sale takes place!! And even then Zillow does not break their necks getting data updated so it seems to me. It can take another three or four months for a sale to show up on Zillow after it records. In short, Zillow is virtually useless in these days of multiple foreclosures in various neighborhoods. You may be seeing housing prices reported on Zillow that are more indicative of the all time PEAK prices than they are of current reality. Pity. But there is no law against being sloppy and lazy. Just becomes illegal if you do it intentionally in a scheme to profit from so doing. Otherwise they’re off the hook, legally. And that’s too bad!

18

John Wake - Real Estate 10.10.08 at 9:28 pm

“… writing disclaimers to cover EVERYTHING KNOWN TO MAN and SEVERAL THAT AREN’T”

I haven’t read their disclaimers but I know that expression is hilarious.

Yes, if you just peruse Zillow solds in your neighborhood and you live in a neighborhood with a good deal of foreclosures, then you could easily greatly overestimate the value of your home. That over-estimation could be very expensive to you if you were using it to help set your selling price. No wonder the home didn’t sell.

I think showing repossessions as sales is an unforced error by Zillow. I can’t figure out any possible advantage to it.

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Older post: Detailing the Wall Street Bailout Christmas tree bill

Newer post: Warren Buffett on the Wall Street Bailout Financial Rescue Bill