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.

You carried me & a spreadsheet for Christmas

By 36 Comments

This will be my last post of the year and I wanted to say thank you for all of your support. I’m so grateful for the conversations and all the business of course, but there’s so much more. 

This year was not easy as I spent six nights in the hospital and took three months off work to heal from a really bad ulcerative colitis flare. I’m thankfully doing very well now and I’m happy. But I couldn’t have done this alone.

Thank you for the kind words, advice, flowers, meals, cards, prayer, and all the ways you showed support. I’m especially grateful to those who donated to the GoFundMe because it sustained my family and helped us pay off medical bills. 

It might sound cheesy, but you carried me this year. And I will never forget that.

Merry Christmas. May you know profound joy and a deep-seated peace regardless of your circumstances or the craziness of 2020.

Much love,

Ryan Lundquist

——————- now a spreadsheet if that’s your thing ——————-

A SPREADSHEET FOR CHRISTMAS?

It’s not the new PlayStation, a leg lamp, or a Bob Ross chia pet, but it’s pretty cool even if it sounds lame. This spreadsheet will help you make quick neighborhood graphs and it can work anywhere as long as you can export data from your MLS.

What does it do? This spreadsheet makes ten or so visuals as I shared about last week. This is a tool to quickly understand a few neighborhood dynamics. This isn’t a template to find out exactly what prices are doing. It’s more about the relationship things like bedroom count or lot size has with price.

STEPS TO USE THE TEMPLATE:

1) Download the spreadsheet here.

2) Decide what data you want to show. It’s up to you.

3) Create a custom export in MLS (see how to video).

4) Paste data from MLS into the template (see how to video).

5) Share graphs on social media, newsletters, etc…

IMPORTANT NOTE: Metrolist updated all of their terminology since I made the video, so when you make the template for the spreadsheet as I show you in the video you’re going to have to figure out what the new terms are. For instance, instead of “Selling Price” it’s now “Buyer Price.” This template should work just as I show in the video, but you must tell MLS to export the correct categories.

HOW TO VIDEO:

I talk for ten minutes or so about how to use this template. If you have questions, let me know. Please call your MLS if you cannot figure out how to export though because that’s not something I can help you with. Watch below (or here).

NOTE ON DATA: It’s important to think about the data you use. It could be a neighborhood, zip code, or MLS area. You might use all neighborhood sales or maybe just a sliver such as 1400-1700 sq ft homes. I suggest showing maybe the past 90 days or 180 days of sales so we capture a recent trend (or maybe it’s useful to see one year of sales?). Remember, if there is too much data it’s going to look like chaos. In short, experiment and figure out what works.

FEEDBACK: I have lots of graph tutorials here, but I’ve never made a template like this before for the public, so let me know which visuals you like best and/or what might work better in the future. I’m open to doing more of these if there is interest and it’s useful. Just remember this template isn’t meant to do everything or dissect prices in depth, so please see it in context. Thanks.

I hope this is helpful. Thanks for being here.

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

Real estate drama (and a market update)

By 50 Comments

I’m not into The Bachelorette or The Real Housewives. It’s just not my thing. But I love me some real estate drama. I’m not talking about HGTV, but the housing market. I know that elevates my nerd status, but I’m hyper focused on fresh stats, ups and downs, and things that make the market move.

(scroll down for a big market update instead)

AN EXCEL FILE FOR CHRISTMAS? Today I want to share some new neighborhood visuals and I’d like to give you an Excel template so you can quickly make these images for neighborhoods in your area. Does that interest you? If I have consensus I’ll post a template with instructions next week.

DRAMA IN THE NEIGHBORHOOD: What can you tell me about this neighborhood (East Sac)? What stands out to you about the relationship between price and square footage, lot size, and bedroom count? I made these images in a couple of minutes with the template I mentioned.

What do you think? Do you like any of these images? Any ideas for something else to show in a quick template like this? Let me know.

UNCLE RYAN’S LAME GIFT: I know it’s odd to wrap an Excel file for Christmas, but let me know if this would be relevant. You can use it for studying neighborhoods, explaining the market to clients, or for newsletters / social media. If there’s enough interest I’ll make a video tutorial. You don’t need to be an Excel guru either. This is something anyone can do with a little effort.

FOX 40 INTERVIEW: By the way, I did a 15-minute live segment last week on Fox 40. We talked about Sacramento being poised to have the strongest market in the country next year according to Realtor.com. Watch here if you wish.

Thanks so much for being here.

Any thoughts?

———————- (skim or digest slowly) ———————–

BIG MARKET UPDATE

For those interested, here’s a big Sacramento market update:

MARKET SUMMARY: In short, we’ve been seeing the drama of a spring real estate season during the fall months. The housing market has been on steroids and the slower fall season we normally have just didn’t happen. Well, technically we are seeing some stats start to slow down as prices have gone sideways lately and we’re seeing fewer sales like we normally do in November and December. But here’s the thing. The “slower” stats are still so elevated from where they should be that it just doesn’t feel slow at all.

HIGHLIGHT REEL:

  • Half of all sales sold in seven days or fewer last month
  • For six months in a row sales volume has outpaced last year
  • We only have three weeks of supply (that’s crazy low)
  • We have the lowest monthly inventory in 15-20 years (at least)
  • Buyers made twice as many offers last month compared to last year
  • The number of listings has been chopped in half
  • Price metrics are up about 12-14% from last year
  • November 2020 regional volume is up 25% from November 2019
  • 63% of all sales had multiple offers last month
  • There were 53.6% more multiple offers compared to last year
  • Each sale last month had an average of 3.22 offers
  • Sales volume is up about 2% over the past 12 months
  • There were 106% more million dollar sales from July to November

WAY TOO MANY VISUALS:

You are welcome to use these in newsletters and social media with proper attribution. Scroll quickly or digest slowly.

SACRAMENTO REGION:

  

 

 

SACRAMENTO COUNTY:

PLACER COUNTY:

EL DORADO COUNTY:

Other visuals: I have lots of other graphs. Check out my social media in coming days and weeks. I am posting daily stuff on Facebook, Twitter, and LinkedIn. Oh, and sometimes Instagram.

Thanks for being here.

Questions: What are you seeing in the market right now? Any stories to share? Are you interested in my Excel template? I’d love to hear your take.

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

Goodbye California. Is everyone leaving?

By 52 Comments

Everyone is leaving California. Well, it feels like it. But what do the stats actually say? Let’s talk about it. This is so important for real estate professionals in particular to understand because it helps us talk about the market and plan for the future. Any stories to share? Please comment below. 

1) Where are California residents moving?

Last year 653,551 residents left the state according to the American Community Survey. Here are the top destinations of where California residents are moving. Keep in mind 2020 data is not out yet. I included the top states below. If I had all fifty states on one graph it would be too big. Does anything surprise you?

2) Who is coming to California?

There is so much news about people leaving California, but we have quite a few people coming to the state too. Last year in 2019 there were 480,204 people who moved to California. It’s interesting that many residents moving here are from some of the top destination states.

3) Where are Californians MOVING THE LEAST?

This visual shows the locations where California residents moved the least in 2019. Does anything surprise you?

4) How can the population still be growing with so many leaving?

Last year we saw more people leave than come to California and that’s been the trend for at least ten years according to the American Community Survey (without considering international migration). So how is our population still growing? Well, in short we’ve had more births to offset the numbers. This is really important because we often hear things like, “Dude, our population keeps growing, so clearly we don’t have more people leaving. That’s just a made-up narrative.” Look, it’s both. We actually do have more residents leaving than coming, but births are helping our population continue to grow. On a side note, I wonder if we’ll see the birth rate go up in light of the pandemic. You know, will sheltering in place lead to more babies?

5) Aren’t more residents moving to Idaho?

It seems like Idaho is all the rage as a destination, so it might be surprising to see only 17,722 California residents moved to Idaho last year. But keep in mind these are 2019 stats and we could see the numbers increase in 2020. Let’s remember Idaho only has a total population of about 1.75 million people though, so having nearly eighteen thousand California residents move last year is huge because it essentially boosted the population by 1%. That’s enormous growth for Idaho, but it’s really just a drop in the bucket for California since we have over thirty nine million residents.

Thanks Meghan for letting me use the photo.

6) Less than 2% of the population moved last year

It seems like everyone and their Mom is leaving the state, but it’s really not true when considering the numbers from the U.S. Census Bureau. I’m not trying to minimize over 650,000 residents leaving last year, but that’s less than 2% of the state. It’s worth noting that over 98% of residents did not move last year.

7) Will the pandemic cause more people to move?

The stats above DO NOT reflect the pandemic because 2020 stats aren’t out yet. I’m anxious to see what new stats bring in light of so many residents being able to work from home now. By the way, here are three ways the pandemic has affected buyers.

8) Migration resources:

You can make your own visuals like mine by checking out the U.S. Census Bureau. But there is also a fun tool called the Census Flow Mapper that helps us see county to county migration (the only downfall is data only goes through 2018 so far). We can also look at migration reports from moving companies. Here’s a sampling of migration reports from Atlas Van Lines, United Van Lines, and North American Moving Services. We can also consider search queries to get clues for places people are thinking about, but I tend to put more weight on stats that show where people actually moved.

9) Why are people moving?

This is a huge question. It’s a dissertation and I won’t pretend to be qualified to answer it. But the usual suspects such as retirement, lifestyle, job change, politics, etc… are surely factors. I’d love to hear your take in the comments.

QUESTIONS FOR REAL ESTATE PROFESSIONALS
Who are your clients going to be over the next few years?
Who is coming to the market?
Who is leaving the market?
Who is going to be participating in the future market?
What steps do you need to take to position yourself for the future?
Where can you meet future clients?

I hope this was helpful.

Questions: Does anything surprise you about the stats above? Why are people leaving? Did I miss anything?

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

How much are buyers paying above the list price?

By 14 Comments

It’s exhausting being a buyer because it’s so easy to get outbid. It seems like finding a house is a bit like trying to buy the new PlayStation 5. Let’s talk about that today. How much are buyers actually paying above the list price? And if you’re not local, what are you seeing in your area?

A spring market in the fall: First, here is a big market update I did for SAFE Credit Union (40 minutes). Enjoy below (or here).

QUICK SUMMARY:

  • There isn’t just one amount buyers pay above the list price
  • The market isn’t the same in every price range.
  • We’ve seen huge growth this year between $10-20K
  • About 80% of sales are somewhere between below list and $20K
  • Not everything is getting bid up
  • About 40% of sales sold at list price or below last month
  • 2/3 of the million dollar market sells at list or below
  • Higher prices tend to pay more above list (when above list happens)
  • Only 3.5% of sales went $50K+ above the list price last month
  • Look to the comps. Don’t just blindly offer above the list price.

SKIM OR READ IN DEPTH:

How much are buyers paying above the list price? Here are some brand new visuals to show how much buyers are paying above the list price. These might take a minute to digest. This image basically shows the total percentage of sales in the market. For instance, in the visual below 31.4% of homes last month sold below the list price, 9.9% of sales sold at the list price, etc…

Under $400K:

Between $500-750K:

Million dollar market:

This visual compares last year with this year.

Here’s the same information but with numbers. Do you like this better?

HOW MUCH ARE BUYERS PAYING ABOVE LIST PRICE?

1) Mixed results: There isn’t just one answer that applies to every price range and escrow. 

2) The biggest change: In many cases buyers are tending to pay ten to twenty thousand over the original list price to secure a contract. About one in five buyers paid $10-20K over the list price last month. In some cases prices get bid up even more, but close to eight out of ten sales are somewhere between below the list price and twenty thousand above the list price. Keep in mind many buyers are getting a loan for the full contract price, so paying above the list price doesn’t always mean buyers are bringing that much cash to the table.

3) Not everything gets bid up: It might be surprising, but this month we saw about one in three sales sell below the list price. It just goes to show sellers have to price it right – even in this wonky market. We also have to be careful about saying “EVERYTHING IS GETTING BID UP” when that’s not true.

4) Million dollar market: The highest prices basically show if buyers are paying above the list price it tends to be more significant. But two thirds of all million dollar sales last month sold at either the list price or below the list price, so the bulk of homes in this range aren’t getting bid up like the rest of the market. Like I’ve said before, this is the most overpriced segment of the market.

5) Not sensational: Only 3.5% of all sales went fifty thousand over the list price last month, so let’s be careful about shining a spotlight on this tiny sliver and saying, “Everything is getting bid up $50-100K.” Nope.

6) Don’t offer above without looking at comps: Buyers, be prepared to offer above the list price, but don’t blindly offer $10-20K above without really considering the comps and advice from your agent. Remember, the market isn’t the same at every price range either.

7) Appraisers: These days appraisers are getting huge flack for “coming in low.” Look, sometimes appraisers are legitimately missing the mark, but other times properties are getting into contract way beyond what is reasonable, so the appraisal should come in “low”. Sellers, sometimes the highest offer isn’t always the best one if there is going to be an appraisal involved. And to my appraiser colleagues, our role is never to “hit the number”, but let’s be sure to account for the true temperature of the market in our reports.

Anyway, I hope that was helpful.

Questions: What stands out to you most above? What is it like right now in the trenches for buyers? Anything stories to share? Did I miss something?

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