A while ago a reader wrote in responding to, and taking issue with, my post about the lack of accuracy of zillow’s zestimates > more on zestimates vs reality. (And I thought it was an important enough comment to post it here rather than let it disappear in the comments section)
And to do so he compares the original Realtor list price of each home, to what the home actually sold for, vs the median of zillow’s value range, making the point that, in fact, zestimates are a useful source of pricing information. And looked at in that light, original Realtor list prices are no better a predictor of the final sale price than the zillow value range. But is that a fair comparison. Comparing the single original list price with the median of the value range. Note that value ranges cover a lot of territory ;
(Value Range: 348k - 498k), (Value Range: $504K – $709K), (Value Range: $535K – $773K)
And there are also a couple of important differences that I can think of between zestimates and Realtor list prices.
Listing agents are in the business of doing all they can to get the highest price for their clients homes. And that’s not necessarily the same as fair market value. That is their mission, highest price/best terms, for the seller. Period. Zestimates, presumably, do not come with those marching orders. 2nd, the final decision about price is made by the seller, not by the Realtor. And, unfortunately, the reality is that in most cases, if you won’t list it for what the client wants, there are plenty of others who will. While zillow is under no such pressure. And, of course, list prices almost always come with a nice juicy fudge factor built in. And more so these days.
And one last point. While it’s true that Realtor original list prices are way off these days vs sale prices, their record is much much better in normal times. And I’ll pull and post data that demonstrates that. And I don’t think the same can be said for zestimates.
None of that is to make light of the poor record of original list prices vs sold prices, but to point out that there are differences between list prices and zestimates.
With that said, for all you math whizzes out there, here’s what Jent had to say.
To those whom are interested in learning more about this great discussion I recommend a book written by Darrell Huff in 1954, surprisingly much hasn’t changed on the subject on which he writes. In this gem Mr. Huff discusses Confidence Intervals.
A confidence interval is “The range around a numeric statistical value obtained from a sample, within which the actual, corresponding value for the population is likely to fall, at a given level of probability” Zillow gives their interval for every property, and it usually tell the rest of the story not seen in the Zestimate regarding … well… their confidence in the algorithmic statistical guess given their underlying data set, and its timeliness to the market at hand.
I thought I would peel back the next layer of the onion on the properties discussed in this latest post and compare listing agents accuracy to zillow’s algorithim, and also provide the confidence intervals “Value Range” not previously shown in Mr. Schneder’s post.
1. 4971 E Avenida Del Cazador Tucson, AZ 85718 Zillow says - $429,000 (Value Range: 348k - 498k) Actual Sold Price - $480,000 Listed for sale by Tierra Antigua Realty 04/15/2010 @ $525k Delta from initial List Price 45k, Delta from Zillow Median 51K, Sale lies within Zillow’s Confidence Interval
3. 2300 E Corte Ingles Tucson, AZ 85718 Zillow says - $622,000 (Value Range: $504K – $709K) Actual Sold Price - $550,000 Listed for sale by Long 7/21/2009 @ 690K, then 669K, then 639K, then 565K then Sold Delta from initial list price 140K, Delta from Zillow Median, 72K, Sale lies within Zillow’s Confidence Interval
5. 3900 N Pontatoc Road Tucson, AZ 85718 Zillow says - $452,000 (Value Range: $375K – $515K) Actual Sold Price - $550,000 Listed for sale by Long 07/10/2009 @ 674K, then, 639K, then 599K, then 574K, then sold Delta from initial list price 124K, Delta from Zillow Median, 98K, Sale NOT within Zillow’s Confidence Interval ( I speculate because this home built in 1978 had been upgraded and remodeled significantly more than those in it’s immediate community)
7. 2430 E Placita Sin Lujuria Tucson, AZ 85718 Zillow says - $499,500 (Value Range: $430K – $579K) Actual Sold Price - $520,000 Listed for sale by Long 11/07/2009 @ 699K, then 649K, then 629K, then 599K, then sold Delta from initial list price 109K, Delta from Zillow Median, 20K, Sale lies within Zillow’s Confidence Interval
9. 5444 N Maguey Place Tucson, AZ 85750 Zillow says - $393,500 (Value Range: $307K – $433K) Actual Sold Price - $547,500 Listed for sale by SWS LLC @ 630K, then sold Delta from initial list price 83K, Delta from Zillow Median, 154K, Sale NOT within Zillow’s Confidence Interval (I speculate because this is the first time that this home, arguably the nicest in the community, was sold since its lot was purchased in 1991)
11. 6500 N Campbell Avenue Tucson, AZ 85718 Zillow says - $746,000 (Value Range: $552K – $798K) Actual Sold Price - $560,000 Listed for sale by Long 09/18/2009 @ 850K, then 799K, then 775K, then 725K, then 650K then sold Delta from initial list price 290K, Delta from Zillow Median, 186K, Sale lies within Zillow’s Confidence Interval
13. 4735 N Camino Antonio Tucson, AZ 85718 Zillow says - $783,500 (Value Range: $572K – $932K) Actual Sold Price - $575,000 Listed for sale by Long 05/02/2009 @ 685K, then sold Delta from initial list price 110K, Delta from Zillow Median, 198K, Sale lies within Zillow’s Confidence Interval (Which is admittedly VERY large in this neighborhood)
15. 4210 E Pontatoc Drive Tucson, AZ 85718 Zillow says - $743,000 (Value Range: $535K – $773K) Actual Sold Price - $645,000 Listed for sale by Foreclosure.com 05/21/2009 @ 645K, then sold AT LIST PRICE !! Delta from initial list price 0K, Delta from Zillow Median, 98K, Sale lies within Zillow’s Confidence Interval
17. 5700 N Williams Drive Tucson Tucson, AZ 85704 Zillow says - $527,500 (Value Range: $422K – $612K) Actual Sold Price - $680,000 Listed for sale by Great Stout 09/07/2009 @ 820K, then sold Delta from initial list price 140K, Delta from Zillow Median, 153K, Sale NOT within Zillow’s Confidence Interval .....
In the end I agree that the Zestimate, and it’s underlying data set, is a great place to start a discussion about home valuation with a local real estate professional.
Let’s hear from you.
sales for the last 30 days)
Recent Comments