• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

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.

  • About
  • Appraisals
  • Order
  • Ask Ryan
  • Areas
  • Classes
  • Press
  • Trends
  • Share
  • Contact

pulling comps

How do you know how much the market has gone up?

July 24, 2019 By Ryan Lundquist 19 Comments

I’ve been getting this question quite a bit lately. How much has the market gone up? How do you figure that out exactly? This is something we consider all the time when pulling comps, which is why it’s so important. Let’s talk about it. 

NOTE: This post is longer because there’s lots to say. You can still skim the bold headings though if you wish.

Here are a few simple things I do to gauge value changes:

1) Look for comps: The best thing we can do is look to the comps for the answers. More specifically, look for the price difference between sales in the past compared with properties that are currently getting into contract.

To gauge a change in value I recommend comparing similar properties from the past to similar properties now. This is often done with sales from last year vs this year, but here’s an example of several years ago with this year. If you’re in a tract neighborhood you might consider comparing a few different similar-sized models from the past with those same models today. If you’re not in a tract area, just compare competitive sales from the past with competitive sales today.

In this example above I looked up a 2,734 sq ft model in South Sacramento and in 2015 this model was selling for about $330,000 while today the most recent sales have been $400,000 (backs highway) and $412,000. There is a pending at $419,126. Ultimately we could say the market has gone up by $80,000 to $90,000 or about 24% to 27%. It might seem odd that I’m looking up 2015 sales, but in this case the subject property sold in 2015, so I was attempting to figure out how much the market changed since then.

When lining up all data from 2018 through 2019 it’s really clear we’ve seen price increases, right?

2) Sales last year & this year: We can also try to find some sales that sold last year and then re-sold this year. I realize if we’re lucky we might find only one or two examples at best. I’m not talking about flips where remodeling has occurred, but an example like the one below where it sold in the exact same condition.

In this example we see the market has shown about a 2% uptick in value over the past year. Of course we have to understand whether these sales sold at reasonable levels. After all, if either sold too high or too low, then it’s probably meaningless data. Ultimately sales like this can be clues into the market (more on this below too).

3) Stats programs: Some people might use fancy excel spreadsheet programs where competitive neighborhood data can be exported to show price changes over time. I don’t personally use something like this, but it’s not a bad idea if it helps you get a good picture of a neighborhood market. If you use something like this, please comment below.

4) Create visuals: I’m a visual guy and it helps me see the market by creating visuals. I find myself spending a good chunk of time on #1 and #2 above as I’m pulling comps, but I also use this step to compliment those steps. If you want to learn to make graphs, here’s a tutorial. If you’ve been thinking about this, why not go for it? Creating images has been revolutionary for the way I see the market and explain it.

CLOSING TIPS:

1) Be careful about zip code data: If you’re pulling data from a zip code or county, just remember trends shown in a larger area may or may not apply equally to every neighborhood or price range (or property type). This is why I don’t look at my recent big market update, see price metrics are up 3-4% this year in the region, and then use that number for every neighborhood. Nope. I advise knowing the larger trend very well, but don’t impose that trend on a smaller area without doing research.

2) Not just one example: It’s dangerous to base a value conclusion on only one example. This is why I wouldn’t look at my example in number two above and definitely state the market has increased by 2%. One example is best considered a piece of the puzzle, and it’s important to find other pieces before understanding the puzzle.

3) The stock market & competitive data: In the stock market you can have different stocks going up, down, and sideways all at once. The same thing happens in real estate. This is exactly why I strongly recommend you look at competitive data in neighborhoods. For example, if you are valuing a 1,200 sq ft house, make sure you are looking at examples of similar-sized homes to understand that market segment instead of 4,000 sq ft homes in the same neighborhood. Otherwise if I only look at larger homes that might be a little more stagnant, I could miss the fact that the bottom of the market is increasing much more rapidly than the top end.

4) Declining market: It’s been years since we’ve had a declining market, but this same methodology above can help you measure the market when prices are declining too.

5) Seasons: When looking at older sales let’s remember the seasons in which they sold. Thus last year I might give a 2% adjustment in a neighborhood for a property that sold in June, but I could give a 5% adjustment for something that closed in December because it sold when the market was down further during a dull fall season.

6) Being quick & reconciliation: There’s not just one way to do this, and there aren’t quick answers. We have to dig in. Most of all, we might choose a few different ways to study the market and then reconcile our findings. What I mean is I might do all of the steps above, get slightly different answers for each step, and then piece them all together (reconcile them) when I use a comp in a report and make a specific adjustment to that comp. In other words, if I adjust a comp up by 2% or 4% or whatever the number is, I’m coming to the table with some sort of rationale or support for why that adjustment makes sense.

I hope this was helpful.

MARKET UPDATE VIDEO: Here’s a video to walk through the growing and slowing market in Sacramento. Enjoy if you wish.

Questions: What do you think of the steps above? Anything else you’d add? What do you do?

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

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff Tagged With: comp selection, House Appraiser, how much has the market gone down, how much has the market gone up, how to make scatter graphs in excel or gnumeric, making graphs, market update in sacramento, pulling comps, pulling data in real estate, Sacramento Home Appraiser, steps in appraisal process, tips for comps

Can you use comps from a different neighborhood?

March 1, 2018 By Ryan Lundquist 6 Comments

One of the questions I get asked the most is, “Can I use comps from a different neighborhood?” Maybe. But then again, maybe not. Let’s talk about it, and I’ll show you what I do when making this decision. Of course there isn’t just one right way to go about this. Anything to add? 

1) Compare sales over time: One of the most important steps is to compare similar properties in each neighborhood over time. If there aren’t many recent sales I have no problem going back year by year to compare older sales. That’s okay. Is there a price difference? Sometimes it’s very clear there is, so it’s probably not a good idea to use “comps” from a different neighborhood (unless I’m making a location adjustment). When looking at two areas I try to find a percentage price difference too where possible so I can say something like, “It looks like prices are 10-15% higher there.” This sounds time-consuming, but there’s no such thing as a 5-minute “comp check”, right? Nothing replaces putting in the time.

2) Let’s get visual: Here are a few visuals I made to compare two areas. Does it look like there might be a value difference? I know, you don’t know how to graph. Why not learn though? It’s an incredible skill to add to your bag of tricks. Here’s a video tutorial.

Truth: It’s easy to “cherry pick” sales from Elmhurst when in Tahoe Park or North Oak Park. Maybe it works out okay sometimes, but in other cases it could be a really bad move.

3) Word on the street: Talking with other real estate professionals about what they think can be insightful. Where are values higher? If you had a property in both areas, where would it sell for more? Of course someone’s perception might be off, but insight from other agents and appraisers can still be useful.

4) Crunch numbers: Why not run stats for both areas? Running the numbers might give us clues into how value works. If you don’t know how to pull stats, here’s a tutorial.

The numbers clearly show one neighborhood has higher prices, so I might need to give a location adjustment if I’m using a “comp” from a different area. For me I like to give location adjustments based on lining up neighborhood sales instead of stats like this, but I might still use these stats to help reinforce an adjustment I give. Let’s remember the market isn’t so mechanical to always apply the same adjustment either. Sometimes there are special properties that seem to buck the trend and ignore price differences (this is what makes value complicated). But in most cases I would be foolish to ignore stats like this and arbitrarily choose “comps” from an area with higher prices without consideration that there might be a location adjustment needed.

BIG CAUTION: If one area has smaller homes, heavy fixers, not enough data, more foreclosures, or more remodeled properties, we might draw the wrong conclusions when looking at stats if we’re not careful. In other words, we need to know how to think through the numbers rather than taking them at face value. For instance, in North Oak Park there are more fixers and some streets simply do not sell as high as others, so that might actually soften the stats a bit. I might also recommend pulling stats for the entire neighborhood as well as competitively-sized properties. This way we at least have two data sets and hopefully a little more balance. And of course do steps 1-3 above too.

I hope that was interesting or helpful.

Questions: What step do you think is most important? Did I miss anything? What else do you do or recommend? I’d love to hear your take.

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

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Resources Tagged With: choosing the right comps, comparing two neighborhoods, Elmhurst, Greater Sacramento Region, Home Appraiser, House Appraiser, how to make a graph, making a loction adjustment, MedCenter, North Oak Park, pulling comps, pulling stats for Sacramento, tips for pulling comps

When value is higher on one street than another

March 1, 2017 By Ryan Lundquist 29 Comments

The cookie cutter tract homes are the easy ones, but sometimes value can change dramatically from one street to another – especially in older eclectic areas. Maybe you’ve seen this before after pulling comps and finding a huge disparity in prices. Today let’s look at an example of this happening to me recently. Any thoughts? I’d love to hear your take.

value higher on one street - sacramento appraisal blog

Values are sometimes all over the place, and that’s exactly what I saw when appraising a house in Carmichael. Take a look below at the graph. How do you think the subject street fits into the market?

Subject street in Carmichael - Sacramento Appraisal Blog

Value Conclusion: When we look at the graph with over 17 years of neighborhood sales, it’s clear properties on the subject street tend to compete toward the mid-to-higher end of the market range (even when they aren’t all that updated). Keep in mind every sale on the graph is between 1600-2100 sq ft, so we are looking at a tight range over a long period of time. You can also see there is a range where most properties have been selling between $350,000 to $500,000 lately.

Some tips for seeing the market in eclectic neighborhoods:

1) Pay close attention to subject street sales: There were 7 available sales for me to look at on the subject street over the past two decades. This might seem limiting, but it’s much better than zero, and ultimately it means I have seven data points that might help me see the context for how the subject street fits into the market. Of course we always have to use good professional judgment and not get caught up in giving too much weight to very little data. 

2) Look through years of data: In an eclectic area where values seem to be all over the place it’s a good idea to study the market by looking at years of sales. The goal is to know how value works and be able to see which streets or types of properties are fetching price premiums. When looking at areas like Fair Oaks, Carmichael, and East Sacramento, this is very key. In this case I appraised the subject property around $450,000, but there were sales within blocks that were coming in between $350,000 to $375,000 with seemingly superior upgrades too (probably why Zillow had this one at $378,000). After studying the market and carefully comparing previous sales on the subject street it was clear the subject street sales were competing at a higher price tier compared to other streets. It would have been a shame if I hastily pulled up three “comps” and brought this one in at $350,000 when the market was clearly willing to pay more.

3) The feel of the street: On paper it might look like we are pulling good “comps”, but then after driving by other streets we might see a lower quality of construction, or unkempt homes, or maybe a negative influence from commercial property.

4) Real estate community: It’s helpful to talk with other real estate professionals who know the neighborhood. I find most real estate agents and appraisers are actually pretty helpful when you call to say, “Hey, I have a question. May I bend your ear for a minute?” I realize not everyone is receptive to talking (lame), but that doesn’t take away the importance of building good relationships in the real estate community so we can exchange information. My advice? When people call you, be the type of person you wish everyone else was. Bottom line. All things considered, it is worth noting we still have to be careful not to impose someone’s perception of the market on our value. So let’s seek insight from others, but let’s also not forget to look at actual data and support the value we say exists.

5) Learn to graph so you can see the market: The graph above was part of my research and it helped me visualize the market. I know, here I am mentioning graphing again, but I only do that because it’s revolutionized the way I see the market. Anyway, here is a tutorial I made for learning to make a basic scatter graph in Excel. If you didn’t know, there are a couple of programs you can use to quickly export neighborhood data from MLS to make graphs. I might suggest looking at Don’s 1004MC program (for locals and some other states (right now his site is down)) and Trendsheet (covers many states). These programs are built for appraisers, but I tell Realtor friends all the time to consider using them and just skip the appraiser stuff. 

UPDATE: I was asked by several people in the comments and by email how to make a graph like the one above, so I made a video tutorial. Check it out here or below.

I hope that was useful or interesting.

Questions: What is #6? Did I miss anything? How do you figure out if there is a value premium for a certain street? How do you avoid choosing the wrong comps? I’d love to hear your take.

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

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff, Resources Tagged With: appraiser methodlogy, Carmichael, choosing comps, complex appraisal, ecelctic neighborhood, learn to make real estate graphs, pulling comps, values are all over the place

How to pull comps like an appraiser

October 30, 2014 By Ryan Lundquist 28 Comments

The right comps make all the difference. How do appraisers pull comps? I scraped the surface of this topic a few days ago in a class I taught, and I wanted to unpack it a bit further today. There is sometimes a striking difference between how appraisers and agents approach this topic, so being on the same page a bit more will probably be an advantage. I hope this helps. I’d love to hear your thoughts below.

choosing comps like an appraiser - by sacramento appraisal blog

These following steps sound very detailed, but applying them is really a matter of making quick decisions during an MLS search.

7 steps when pulling comps in a neighborhood

  1. Start with Tight Boundaries: Pull sales and listings from the very immediate neighborhood first. It’s better to start out smaller rather than begin with a wide area such as a one-mile radius or an entire MLS area. I recommend using the Polygon tool in Sacramento MLS so you can actually draw exact neighborhood boundaries to be sure you are only getting data from those boundaries. After all, if you search by radius, you’ll inevitably pull in data that doesn’t really reflect the immediate neighborhood. Practically speaking, if you don’t know where to draw boundaries, just start searching as close as possible to the subject street, try not to cross major streets or school district lines, and keep an eye out for big age pulling comps 2 - image bought and used with permission by sacramento appraisal blogdifferences in the neighborhood since values might change for newer homes. Sometimes an aerial view on Google Maps can be helpful because you can see a clear difference where one tract starts and another begins because the roof colors are different.
  2. View all Recent Sales & Listings: Look at all sales over the past 3-6 months as well as current listings. This will help give you a quick understanding of the neighborhood price spectrum and which types of houses have sold at the top and bottom of the market. If there are few recent sales, be sure to go back one year or so for reference just so you are sure about what the market has done over time. For instance, if there are only fives sales over the past 90 days, it’s easy to miss the market if you only look at these sales. What if the these five properties sold too low? Or what if the most recent sales were lower in light of the cyclical real estate market (softer sales in the Fall). Remember that current listings might tell us if the market is different from previous sales. If the listings are higher, maybe the market increased. If the listings are lower, maybe the market has softened. Or if the listings are the same, but they aren’t selling, the market has probably softened. You can also look at expired listings also to get a sense of the temperature of the market.
  3. Use an “Apples to Apples” Approach to Search for Similar Homes: Now it’s time to dig into similar-sized homes. I recommend searching by square footage since that is what tends to guide most buyers. You can add and remove about 10% on each side of the square footage. This means if your house is 1800 sq ft, a good range is probably 1600-2000 sq ft. Of course sometimes data is sparse, so you simply need to work with what you have. But comparing something that is significantly different in size really isn’t a good methodology. In cases like that it’s probably better to use an older similar-sized sale rather than a newer and much different property. The key is to use an “apples to apples” approach, meaning you are trying to find the most similar properties to the subject property. If the subject property was not available, what properties would a buyer realistically consider purchasing? (that’s what a good comp is). If your house has three bathrooms, try to pull some sales with three bathrooms and a similar square footage. If you have a pool or converted garage, find other homes with the same feature. When the comps are very similar to your property, you don’t have to guess at how the market responds to upgrades or certain amenities because the proof is already there in the sales. Of course sometimes there aren’t any recent truly similar sales, so it’s important to go back in time to find something similar, or even search a different size of property in the neighborhood to understand how the market has responded to a certain feature. Once you find other sales of any size in the neighborhood with a pool, converted garage, or whatever you are looking for, you can then compare these sales to other similar-sized sales at the time. How much more or less did the house with the pool or converted garage sell for? This can help you glean some context for how much a particular feature might be worth.
  4. Search Older Similar Sales: Be sure to look back over the past year or so in the neighborhood so you can see what similar-sized sales have sold for. This will only take a minute in MLS, and it will help create a deeper context for you to understand the market. It can sometimes reinforce the strength of your list price or value to be sure your current price/value makes sense in light of historic trends in the neighborhood. If you are dealing with a custom home or unique location, you might need to consider sales over multiple years.
  5. tight and expanded search in tahoe park - sacramento appraisal blogSearch the Expanded Neighborhood: If you started with very tight boundaries in your initial search, you can expand it a bit more. I’m not saying to go outside of what buyers would consider the neighborhood market, but only to maybe include more area if you didn’t already. If a buyer would typically search throughout the entire larger neighborhood, then look for comps in this larger area now. The benefit of starting out small is that you are sure to research value very close to the subject property, which helps you not pull in data from further away that might not reflect the immediate neighborhood.
  6. Pull from Outside the Neighborhood (if needed): If sales are really sparse in the immediate neighborhood, you may need to find comps in competitive areas. Don’t do this step first though because it’s important to understand values in the immediate neighborhood first (even by using older sales, current listings, and expired listings). Of course the problem is it can be easy to “cherry pick” higher sales from other subdivisions. This can happen on purpose or by accident. A different tract might sell for more or less than the subject tract, so exercise caution to study whether the other tract really does have similar prices or not. Would a buyer shopping on the subject street also be shopping in the other tract? Better yet, would a buyer pay the same price in both areas?
  7. Avoid Using the Wrong Price per Sq Ft: There is always a price per sq ft range in a neighborhood, so it’s important to not simply choose one random price per sq ft figure and use it to come up with a value or list price. For instance, imagine a 2500 sq ft house that sold at $500,000, which would make the price per sq ft $200 (500,000 / 2500 = 200). At times it’s easy to see the metric of $200 and begin applying it to other homes right away. Yet what if the other homes aren’t similar in size, upgrades, appeal, condition, or location? The reality is if I was pulling comps for a 2000 sq ft home, I might find out that similar-sized sales really have a price per sq ft range of $210-225K instead of the $200 figure that was only good for the 2500 sq ft home. This is an easy mistake to make, and it underscores how important it is to be aware of price per sq ft ranges in a neighborhood. Rather than impose a price per sq ft on a property, search similar sales to discover what the price per sq ft range is for that size of property.

NOTE: Obviously some appraisers might not pull comps exactly like this. After all, there isn’t a standard set of steps appraisers must follow. Do what works best for you, and if something here resonates with you, that’s great.

Question: Any other tips, insight, or stories to share? I’d love to hear what you do, whether you are an appraiser or real estate agent.

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

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff, Resources Tagged With: appraisal methodology, choosing comps, comparable sales, competitive sales, Home Appraiser, Price per sq ft, pulling comps, real estate appraisals sacramento, sacramento appraisers, the right comps, tips for choosing comps

Primary Sidebar

Connect with Ryan

 Facebook Twitter LinkedIn YouTube Instagram

Subscribe to Weekly Post

* indicates required

Search this site

Blog Categories

  • Appraisal Stuff (407)
  • Bankruptcy (3)
  • Divorce (4)
  • Estate Settlement (6)
  • FHA Appraisal Articles (56)
  • Internet (53)
  • Market Trends (481)
  • Photos from the Field (126)
  • Property Taxes (70)
  • Random Stuff (231)
  • Resources (566)
  • Videos (161)

Blog Archives: 2009 – 2021

Lundquist Appraisal Links

  • Appraisal Order Form
  • Appraisal Website
  • Rancho Cordova Appraiser Website
  • Sacramento Appraisal Blog Sitemap
  • Sacramento Real Estate Appraiser Facebook Page
  • Twitter: Sacramento Appraiser (@SacAppraiser)
  • YouTube: Sacramento Appraiser Channel

Most Recent Posts

  • How long can this market keep going?
  • What is your housing persona?
  • Rapid price growth & the Gilmore Girls next door
  • Are first-time buyers targeting 2-4 unit properties?
  • Stale real estate headlines & buyers flocking to El Dorado County
  • My new sewer line adds huge value, right?
  • The housing market nobody predicted
  • Real estate trends to watch in 2021
  • You carried me & a spreadsheet for Christmas
  • Real estate drama (and a market update)

Disclaimer

First off, thank you for being here. Now let's get into the fine print. The material and information contained on this website is the copyrighted property of Ryan Lundquist and Lundquist Appraisal Company. Content on this website may not be reproduced or republished without prior written permission from Ryan Lundquist.

Please see my Sharing Policy on the navigation bar if you are interested in sharing portions of any content on this blog.

The information on this website is meant entirely for educational purposes and is not intended in any way to support an opinion of value for your appraisal needs or any sort of value conclusion for a loan, litigation, tax appeal or any other potential real estate or non-real estate purpose. The material found on this website is meant for casual reading only and is not intended for use in a court of law or any other legal use. Ryan will not appear in court in any capacity based on any information posted here. For more detailed market analysis to be used for an appraisal report or any appraisal-related purpose or valuation consulting, please contact Ryan at 916-595-3735 for more information.

There are no affiliate links on this blog, but there are three advertisements. Please do your homework before doing business with any advertisers as advertisements are not affiliated with this blog in any way. Two ads are located on the sidebar and one is at the bottom of each post. The ads earn a minor amount of revenue and are a simple reward for providing consistent original content to readers. If you think the ads interfere with your blog experience or the integrity of the blog somehow, let me know. I'm always open to feedback. Thank you again for being here.

Copyright © 2021 Sacramento Appraisal Blog