Sacramento Appraisal Blog | Real Estate Appraiser

Real estate appraisals for divorce, estate settlement, loans, property tax appeal, pre-listing and more. We cover Sacramento, Placer and Yolo County. We're professional, courteous and timely.

Zillow

Two things to understand about Zillow’s accuracy rate

By 33 Comments

How does Zillow’s accuracy rate work? Let’s talk about two important points. I’m not writing because I’m angry, but only because the public places enormous trust in this brand, and I see this accuracy rate quoted everywhere. Well, let’s at least know the fine print so we can have informed conversations.

Two quick points on Zillow’s accuracy rate:

1) Median makes all the difference: Zillow says their median error rate is 5% for the United States. That sounds impressive, but we have to realize this is a MEDIAN error rate, which means the Zestimate is within 5% of the purchase price only half the time. So Zillow’s slogan could be, “We’re within 5% half the time.” But that doesn’t sound as polished as “Our median error rate is 5%”.

2) Zillow uses the most recent Zestimate: This is such an important point – even if it feels a little technical. I have an example to help show what I mean too. Zillow states “Zestimate accuracy is computed by comparing the final sale price to the Zestimate on or before the sale date.” Let me show you why this matters.

An example: Imagine a property listed for $380,000 and the Zestimate was also $380,000. But then after a series of price reductions, the home sold for $350,000. That would be 8 percent lower than the original Zestimate. That’s not very good, right? Well, now imagine as the list price was reduced, so was the Zestimate, and the most recent Zestimate was $353,000, which is only 1 percent higher than what the property sold for. Here’s the kicker: The home may have sold for 8 percent below the original Zestimate, but for its accuracy rate Zillow can claim 1 percent because it uses the most recent Zestimate instead of the original one.

In short, the most accurate stat here would be 8%. After all, the home literally sold 8% lower than what Zillow said it was worth. Thus when Zillow uses the most recent Zestimate instead, it’s a clever way to get much sexier stats. 

One more thing.

Chasing the List Price & Fixer Upper TV show: What sort of effect does the list price have on the Zestimate? In other words, does the list price actually change Zillow’s value? This might not happen in all cases, but here’s a glaring example of the “shotgun” house from the TV show Fixer Upper. It’s a one-bedroom that was listed for $950,000 and didn’t end up selling.

In this example the list price was outrageously high, but Zillow’s algorithm looks to have simply matched the Zestimate to the list price. This might not happen in all cases, but it certainly did here.

I hope that was interesting or helpful.

Article I wrote: Here’s a piece I wrote about online valuation sites for Comstock’s Magazine last month.

CLASS I’M TEACHING: I’m doing my favorite class at SAR on May 28th from 9am-12pm called “How to Think Like an Appraiser.” Sign up here.

Questions: What do you think? Anything else to add?

If you liked this post, subscribe by email (or RSS). Thanks for being here.

6 ways buyers have changed since the housing bubble

By 16 Comments

There’s lots of focus on how home prices have changed since the previous “bubble”, but let’s talk about how buyers have changed. Here’s some observations. What else have you noticed?

1) More picky: During the previous housing “bubble” buyers seemed so desperate to purchase that they pulled the trigger on about anything, but they’re much more discerning these days. Of course let’s remember underwriting has changed dramatically though too. In the past many properties flew through the loan process without hardly any scrutiny, but lenders today are incredibly strict, which has certainly propelled a more picky feeling in the market.

2) More patient: Despite a housing shortage buyers aren’t willing to pull the trigger on junk. They’re simply more patient for the right house and they want to make an informed purchase (and even feel like they’re getting a good deal where possible too).

3) More informed: Just as the “bubble” began to pop we had companies like Zillow and Redfin coming to the forefront. Well, now they are household names and buyers are basically obsessed. Seriously, buyers scour these sites day and night, and they know about every single new listing, price reduction, and sale. This doesn’t mean buyers don’t make value mistakes still, but it does mean they are more informed than EVER about prices. At the same time, guess who is not looking at Zillow as much? Sellers. This is a huge issue because it means sellers are not as in tune with the market these days, which means they’re prone to overprice.

4) Financial mistakes: Buyers remember the pain of financial turmoil in the past, so they’re sensitive to repeating mistakes. For instance, I talked with a buyer considering purchasing the highest-priced listing in a neighborhood, but he’s concerned we’re at the top of the market. This buyer asked, “If a buy right now and the market turns, would it be possible I’d have to hold on to the house for 10 years before values come back?”

5) Higher expectations about condition: These days buyers have higher expectations about homes being in good condition. In other words they are much more picky about properties that are not in “move-in” shape or upgraded. Wait, there aren’t granite counters? What the? There could be many reasons for this, but I think heightened investor flipping activity played a huge role. In a fairly short period of time investors had a gluttonous real estate feast by purchasing an avalanche of bank-owned homes, rehabbing them, and selling them. This helped quickly upgrade the housing stock, and also widen the price gap in some areas. What I mean is values used to be very tight together as you can see in the graph below, but now the price spectrum is simply wider since buyers are willing to pay more for rehabbed homes in today’s market. I’m not saying this dynamic is in every neighborhood, but I definitely see it in quite a few areas.

6) Less cash-out refinances: Everyone and their Mom had a boat before the “bubble” burst because people were using their house like an ATM to buy toys. Well, today we don’t have that dynamic (image from Leonard Kiefer). Home owners are clearly cashing out less, which makes them sound financially wise, but let’s realize lending guidelines have changed to make it more difficult to ATM your house. Moreover, many owners are sitting on 3% interest rates, so why the heck would they trade pulling out cash for a much higher rate?

NOTE: I updated this post with “more informed” above after Peter left a stellar comment (thanks). This is such a big point. I can’t believe I didn’t mention it while writing this, but it didn’t come to mind at the moment. The irony is I’ve been talking about this in other posts and in person so much lately. Ha. Well, it’s fixed now.

I hope that was interesting or helpful.

MARKET UPDATE VIDEO: A few days back I did a screencast to talk through trends. Lots of people are wondering if the market is tanking or softening, so I wanted to pitch in two cents. Well, the video is actually 20 minutes (there’s lots to say). Anyway, give it a view if you’d like here (or below).

SPEAKING GIGS: If you’re around, I’m doing a blogging class on October 11th at SAR. I’ll be speaking at the AI’s 2018 Fall Conference in San Francisco on October 19th and AppraiserFest in San Antonio on Nov 1-3.

Questions: What else do you think has changed about buyers since the “bubble” burst? Any stories to share? I’d love to hear your take.

If you liked this post, subscribe by email (or RSS). Thanks for being here.

Is the public trusting Zillow too much?

By 54 Comments

I don’t have an axe to grind. I’m not angry. And I’m not worried about Zillow replacing my job. I am concerned about the public trusting Zillow way too much though, so I wanted to share an eye-opening “Zestimate” example to help create conversation. Please give it a read and let’s talk in the comments.

Here’s the Zestimate history of a single family home in Carmichael, CA. I’ve been following this property for the past two months.

1) OVERPRICED: This home was originally overpriced in MLS at $380,000 and the Zestimate happened to be $380,414 when the home listed for sale.

2) PRICE & ZESTIMATE REDUCTION: The price was reduced to $335,000 in MLS and very soon after the Zestimate was changed to $346,364. Seeing this definitely gave me pause and made me wonder how much weight Zillow’s algorithm gives to the list price. Does it usually match the list price when a property is first listed? How much do price changes affect the Zestimate? These are reasonable questions. By the way, I shared about this house on Twitter and Inman News included it in a story.

3) ZILLOW DIDN’T GIVE MUCH WEIGHT TO THE SALES PRICE: The property sold at $350,000 eventually, but then Zillow’s estimate said the property was worth $327,960 after the property recorded at $350,000. So it looks like Zillow’s algorithm did not automatically give strong weight to the actual sales price.

4) ZESTIMATE DECLINES 8% IN 30 DAYS: Despite selling at $350,000 one month ago, Zillow now says this property is worth $301,972, which is a whopping 14% less than it actually sold for last month. Moreover, in just 30 days Zillow states the value of this home has gone from $327,960 to $301,972, which is an 8% loss in value. Did the market really decline by 8% this past month?

ZILLOW’S TRENDS ARE OUT OF SYNC: I can’t speak for every property listed on Zillow, but the Zestimate history in this case is definitely out of sync with the market in Carmichael. Values are certainly softening for the season like I talked about last week, but a decline of 8% in 30 days is simply not accurate. Look at the trend line in my graph that shows the market balancing out, and then look at the Zestimate connected by dots. That’s a huge difference in direction, right? Obviously Zillow hasn’t been inside this house, so we can give grace to an algorithm not knowing the full picture of value for an individual property, but to say the market has dropped by 8% is just inaccurate (and you don’t need to go inside a house to know that).

QUICK STUFF ON MY MIND:

1) It’s not just a “ballpark” for consumers: Despite Zillow touting itself as a “ballpark” valuation or starting point for consumers, many people treat it like a definitive value. Bottom line.

2) Blind trust: I find many consumers trust Zillow without thinking too much about accuracy. I don’t say this to be insulting, but there is a deep trust with this brand right now without many questions being asked. My advice? Think critically about examples like I showed above before you trust with all your heart.

3) Pricing according to Zillow: Many sellers are growing disconnected from the real market lately and they’re prone to overprice. Having sensational real estate headlines for six years is definitely one of the reasons why this is happening, but I think some of it comes down to consumers having more information than ever about prices and value. The struggle is when sellers feel so strongly that a Zestimate is legitimate that they aren’t willing to price below it or hear pricing suggestions from others. My advice? Listen to the market around you as well as real estate professionals. Don’t get so caught up in a Zestimate that you cannot see anything else.

4) Feeling stressed: I had a friend who used to get stressed out when his Zestimate would dip. He has since passed away, but I can only imagine how he’d feel about an 8% price decline in 30 days if that’s what Zillow said about his home. He’d be freaking out, and the truth is he wouldn’t be alone because there are lots of people who think of Zillow as way more than just a “ballpark”. In short, I recommend being careful about letting a website’s value claim affect your mood or even your real estate decisions. By the way, the New York Time’s wrote a piece last week called Why Zillow Addicts Can’t Look Away.

I hope that was interesting or helpful.

SPEAKING GIGS: By the way, if you’re around, I’ll be speaking at the Appraisal Institute’s 2018 Fall Conference in San Francisco on October 19th and AppraiserFest in San Antonio on Nov 1-3. I’m also doing a real estate blogging class locally on October 11th at SAR. Just a heads-up.

Questions: What do you think of Zillow? Is the public trusting this website and brand too much? Any stories to share?

If you liked this post, subscribe by email (or RSS). Thanks for being here.

The problem of overpricing in real estate

By 15 Comments

Overpricing is a problem. You’d think in such a “hot” market that it wouldn’t be an issue, but it is. I’m not trying to dog sellers, but let’s talk about some of the most common pricing mistakes right now. I hope this helps.

1) Getting married to the list price: Sometimes it’s like sellers get married to a lofty list price and become unwilling to budge – even when buyers are refusing to pay that much. It’s as if sellers get paralyzed and cannot move beyond a clearly unrealistic price. My advice? Listen to the market and budge on price as needed.

2) I need this amount to move: I’ve encountered a few sellers recently who priced based on how much money they needed to move. But the market doesn’t care about personal finances or plans. The market only cares about paying a reasonable price for the property.

3) Headlines: At times sellers hear sensational headlines like, “Values are increasing more rapidly than ever,” so they price according to a headline rather than similar sales in the neighborhood market.

4) Out of touch with picky buyers: Buyers these days tend to be more picky than ever about what they purchase, but I’m not sure sellers are really in tune with how finicky buyers are about price, location, and condition. You’d think buyers would be so desperate to get into contract and pay anything because of a housing shortage, but they’re actually quite patient in many cases because they want to wait for the right property and feel like they’re paying a fair price. My advice? Price for real buyers in the neighborhood market rather than that one mythical “unicorn” buyer who is going to pay more for some reason.

5) Sales instead of comps: The most common pricing mistake I see is pricing according to a sale down the street that really isn’t comparable. So a seller says, “I know that house is totally remodeled with a pool, but someone’s going to pay the same amount for my house.” My advice? Price according to similar homes that are actually getting into contract rather than dissimilar properties. Be careful about hijacking price per sq ft figures too.

6) The fallacy of summer: We hear that summer is the hottest real estate season, but the spring season is actually the hottest in many markets throughout the country. By the time summer rolls around the market is actually beginning to cool because it’s been hot for almost two quarters already. During summer listing volume is just about to peak for the year, and that means it starts to take longer to sell, prices often begin to soften for the season, and buyers gain more power to negotiate. My advice? Be realistic about prices today.

7) Zillow: I can’t tell you how often I’ve heard, “But Zillow says my house is worth X amount.” I know, Zillow says stuff like, “We’re only a starting point and a ballpark figure.” Yet in my experience sellers rely heavily on the Zestimate and very often treat it like a definitive ending point rather than a ballpark. Remember, Zillow doesn’t know anything about condition, upgrades, smell, etc… Sometimes Zillow nails the value, but other times it’s off by a substantial amount – even in a tract neighborhood. My advice? Take “The Big Z” with a grain of salt.

8) Other: What else are you seeing out there?

I hope this was interesting or helpful. In light of the market beginning to cool for the season, I thought scratching out these thoughts might be helpful and even save sellers some money (and heartache).

Questions: Which mistake do you see most often? Any stories or insight to share? I’d love to hear your take.

If you liked this post, subscribe by email (or RSS). Thanks for being here.