Let’s Play “Zillow”

by Kris Berg on July 29, 2006

KrisBerg05 a.jpgUnless you live in a cave, you are no doubt familiar with the Zillow phenomenon. Zillow is an on-line real estate service that allows users to obtain a free valuation of any property, or “Zestimate”. In addition to the on-line valuation feature, they are now rolling out Zillow Moblie, which allows users to get “almost instant” Zestimates via their cell phones. While most of us in the industry whine incessantly about the questionable accuracy of the Zestimate, I do give these guys props for developing a complex algorithm and a fun tool. The question is, is it fun or is it a tool? Well, a little of both, I suppose, if you keep the information they provide in perspective.

Zillow uses public records in arriving at their valuation estimates, so from that standpoint, the data has value. But, Zillow (not being of the human persuasion) is totally objective and, as we all know, subjectivity is a large component of home valuation. So, LET’S PLAY ZILLOW! I chose the four most recent closed sales in my community as a little test of Zillow’s home pricing savvy, figuring they would not have picked up on the recordation price yet. Here is what I found:

Home A: Sale Price $600,000; Zillow Price $702,837 (Ouch)

Home B: Sale Price $650,000; Zillow Price $643,813 (Not bad)

Home C: Sale Price $1,055,000; Zillow Price $1,010,645 (Close)

Home D: Sale Price $1,169,500; Zillow Price $1,389,248 (After four months on the market, I might add. Don’t those buyers know value when they see it? :) )

Now, Home D is an interesting case study in that two weeks prior, an almost identical model match sold one street away. Both homes had nearly identical views and lot sizes and virtually identical floor plan and square footage. Upgrades were comparable as well. We will call this model-match “Home E”. When Home E sold, the principals signed a non-disclosure agreement so that no sale price would show on the tax stamp or in the MLS. (Why that was the case is the subject of another post). Therefore, Zillow’s algorithm has no way of taking advantage of this sale as a comp. Since it is public record, however, we can tell you that Home E sold for $1,085,000. Zillow’s estimate? $1,158,057. Why did Zillow value two identical homes $230,000 apart? Beats the heck out of me.

So, was that fun? Sort of (if you are a real estate junkie like myself). If I had relied on Zillow to price these homes, would it have been a useful tool? Not so much, I’m afraid. What have we learned? What every real estate agent out there already knows; pricing is a combination of art and science. Proper pricing requires experience, market knowledge and human reasoning (which Zillow can not provide). Most importantly, perhaps, Zillow is not the “market”; your buyer is the market, and they will be willing to pay what they perceive the value to be, Zillow be damned. I am not suggesting that you shouldn’t continue to play Zillow, but remember that in the department store of Real Estate, Zillow is the toy department. (P.S. Zillow says that the value of my home dropped $10,000 since yesterday. Bummer. I told Steve it was time to repaint).

{ 7 trackbacks }

The San Diego Home Blog » Blog Archive » Now Accepting Applications
08.03.06 at 8:45 am
The San Diego Home Blog » Blog Archive » Dog Days of August
08.09.06 at 8:05 am
The San Diego Home Blog » Blog Archive » Guilty by Association
09.03.06 at 8:33 am
The San Diego Home Blog » Blog Archive » I Just Made $30K!
09.20.06 at 8:29 am
The San Diego Home Blog » Blog Archive » Stupid People Zue Zillow
11.06.06 at 8:47 am
RealEstateUndressed » Blog Archive » The Magnificent 7 Consumer Real Estate And Mortgage Articles of 2006
02.06.07 at 9:09 am
Contact me for all of your Scripps Ranch (and Kodiak) real estate needs! — The San Diego Home Blog
10.02.08 at 4:13 pm

{ 7 comments… read them below or add one }

1

Steve BergNo Gravatar 07.29.06 at 9:20 am

I have been “playing” Zillow for a while, myself. Clients have even brought it up (interestingly, only when the Zestimate is MORE favorable than the market reality). We actually had a case where our client claimed their home was worth $740,000 based upon a Zillow Zestimate. Based upon our research and experience we believed it was worth between $700,000 and $715,000. It actually sold for $710,000 and ultimately the seller was very happy to get that.

I think it is most important to re-emphasize what Kris said about the “objective” nature of Zillow. Actually it’s worse than that. Because it only uses public records, it cannot, for example, differentiate between two model-match or similar homes, where one has a view and the other does not. As we know in San Diego, a view can add a value premium of $10,000 to $150,000.

Does a “Zestimate” identify the difference in value between two similar homes where one backs to a busy street and the other backs to open space? No! Or how about two similar homes, one with a lot size of 14,000 sq. ft. (but only 7,000 sq. ft. usable due to the steep slope the backyard faces faces) and the other home with a lot of 7,000 sq. ft. , but with a 40 mile view. Nope, it can’t do that, either. :-(

The people at Zillow understand this. They do not suggest that using a Zesitmate should take the place of an experienced agent who has actually seen most, if not all, of the homes for sale and/or sold in a given market area home and are, therefore, able to make these critical adjustments in the home valuation.

Having said that, I’m really upset that Zillow says my home dropped $10,000 since yesterday. Maybe I should have THEM come out and paint it? Unless, of course, tomorrow the Zestimate value goes up $10,000.

2

ShannonNo Gravatar 07.31.06 at 10:58 am

I love “playing” Zillow! However, I never pay any attention to the Zestimate. Once I saw the Zestimate for the house I live in I knew it was bunk. Someone would have to be high to pay so much for this house!! HA HA! Anyway, my favorite part of Zillow is seeing the sales history for the property. It is interesting to learn if the seller is an original ower (ie tons of equity…presumably), or bought on the high end and won’t be clearing much (aside from assumed down payment). I just thought I’d share how I get my kicks!! Pathetic!

3

Kris BergNo Gravatar 07.31.06 at 11:07 am

Hi Shannon! No more pathetic than spending your vacation blogging (a reference to my previous “Summer Vacation” post). My favorite feature is the “comp” feature. They value my home (today, anyway) at $302/sf when all of the alledged comps average $310/sf. Zillow has clearly been in my kitchen this morning. :) The good news is my Zestimate has held steady for three days now. I was starting to worry about my vanishing equity.

By the way, as a point of clarification, I happen to know that you are currently renting, but the readers - all two of them - may not. Didn’t want them to think you were “high”.

4

ShannonNo Gravatar 08.01.06 at 1:16 pm

Kris, thanks for the clarification! You know how much I worry about what people think of me!!

5

Kris BergNo Gravatar 08.01.06 at 1:19 pm

Now, THAT’S funny!

6

DavidNo Gravatar 11.26.06 at 11:29 am

Pretty interesting blog!

Hey, so a question. You describe a buyer and seller who signed a non-disclosure agreement to keep the sales price out of the tax records. What did they do that? To keep their information out of Zillow? Is that to the buyer’s advantage?

7

Kris BergNo Gravatar 11.26.06 at 11:43 am

Thanks, David! To answer your question, I can only speculate the following: The seller did it so as not to have the neighbors storm him, the agent did it so they might live to sell another house in this particular neighborhood some day, and the buyer did it to placate the seller (as perhaps a condition of the sale). All of this, of course, because the sale price was hideously low and what we call a “comp killer”. Just my hunch, of course. :)

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>

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word