Comps aren’t easy today. The problem is there aren’t that many sales, so it’s not so simple to figure out value. Lately, I’ve been getting a ton of questions about this, so I wanted to share some things I’m doing on my end. Skim by topic or digest slowly. I’d love to hear your take in the comments.
UPCOMING SPEAKING GIGS:
3/6/25 Yolo Association YPN Event
3/12/25 Windemere Sierra Oaks
3/20/25 HomeSmart iCare Realty (private I think)
4/2/25 SAFE Credit Union (details TBA)
4/10/25 Yuba-Sutter Association (details TBA)
4/15/25 Culbertson and Gray (private I think)
4/24/25 KW EDH (private I think)
5/8/25 Private event (details TBA)
5/13/25 PCAR
6/5/25 Auburn Marketing Meeting
9/26/25 PCAR
11/4/25 SAR Main Meeting
THINGS TO KEEP IN MIND ABOUT COMPS IN 2025
1) SALES TELL US ABOUT THE PAST
Closed sales are like historic artifacts that tell us what the market used to be like. In other words, sales might not reflect what buyers are willing to pay today. No, they really tell us what value used to be like when these properties got into contract a few months ago or whenever. What is the market like right now? Let’s look to the pendings and listings to understand the temperature today. It’s the pendings and listings where we can sometimes get clues as to whether prices are rising, flat, or declining. This doesn’t mean sales aren’t significant. They are. All I’m saying is we need to give way more respect to current data. Just be sure to look for a pattern. You don’t want to hang your perception of value on only one or two listings.
2) TWO OPTIONS TODAY
We have two choices for comps. Go back further in time in the immediate neighborhood, or go out further to competitive areas. Why not do both? I think the knee-jerk response is to search for more recent sales further away, but don’t sleep on using older sales in the immediate neighborhood and figuring out how the market has changed since those properties got into contract. The danger of going too far out is some neighborhoods are really dissimilar and not comparable. And you know, buyers might not be shopping in both areas at the same time, so it gets super awkward to be arbitrarily pulling “comps” two miles away in the same ZIP code. That’s not the move.
3) HOW FAR AWAY CAN YOU GO FOR COMPS?
It’s not how far you can go, but where you should go. Read that again. This is true in any market. And where would buyers go for comps? That’s also a viable question. No matter where you’re getting comps, be sure they are a good substitution. In other words, if a buyer wasn’t going to purchase the subject, would the buyer really consider the comps you’re using? In short, there isn’t a distance parameter. In a rural market, you might be going many miles away, but in an urban market you could be focused on a very tight area. One more thing. Don’t just automatically go out further to find the “comps” that meet the price or value you want.
These days I find myself spending much more time researching nearby neighborhoods. I’ll draw boundaries around the subject neighborhood (polygon MLS tool), and then draw boundaries around other areas too. There simply aren’t many sales, so I’m looking at a wider portion of the market to try to make sense of things. Keep in mind I may not be using nearby neighborhood sales as “comps,” but it could be helpful research to get a sense of where the market is at.
4) HOW OLD CAN THE COMPS BE?
Don’t get stuck on just using sales over the past 90 days. The problem today is we’re missing a huge portion of the market, so we don’t have the luxury of many recent sales. Keep in mind closed sales volume was down 34% last year in the region, and that means there were 34% fewer comps to choose from. No wonder why it hasn’t been easy!!! On that note, you might have a comp that is much older (a year or two), and you may need to use that today after figuring out how the market has changed since that property sold. There is NOTHING wrong with that. We simply need to do our best in the midst of limited data. But you don’t want to cherry-pick a really high sale from the past while glossing over newer sales that are lower. My advice? Use some older comps if necessary, some newer ones, and maybe some comps from competitive neighborhoods too. Keep in mind FHA wants comps within twelve months though. And it is possible lenders might want more recent comps too (hopefully they exist).
5) LOOK AT THE MARKET IN CHUNKS
I tend to look at the market in annual chunks. So, if I’m searching for comps, I might draw boundaries around an area in MLS using the map search and maybe look at 1500-1900 SQ FT sales from 2024 and beyond. Then I’ll look at just 2023. Then 2022. And then 2021. And maybe I’ll keep going back further if needed. I could even draw boundaries around competitive areas to see if the comps were selling at similar prices historically too. I know this sounds crazy and tedious, but this helps me understand how prices have changed over time. Very often I can see a market that went up through mid-2022, dipped, rebounded, and now feels flat. The problem is if we don’t go back far enough, we don’t often glean enough context for how values have changed. And remember, you might not use really old sales as comps, but you can use them for research. If you’re a real estate agent, the huge benefit here is going to a listing presentation well-versed in the neighborhood trend, but also being in tune with properties that sold three years ago that your client thinks sold six months ago.
6) UNDERSTAND THE SHAPE
One helpful thing as we look for comps is to understand the shape of the neighborhood. In other words, how have prices moved over time? This will help us make adjustments or realize there is no adjustment needed since the market is at a similar place today. For me, I like making graphs to see this. If you have a different way to do that, cool. What I’m seeing in many cases in my graphs is a flattening in recent time especially. One thing to keep in mind though is graphs like this are based on closed sales, so it might take a few months for the trend happening in the pendings and listings to show up in the sales.
Secondly, it helps to be in tune with county and regional trends. All I’m saying is the trend I’m seeing in the county is often pretty similar to what I see in neighborhoods. We saw massive price growth through mid-2022, a dip, modest appreciation, and now a pretty flat market. However, the luxury market isn’t always following this pattern as there is more strength there. So, not every portion of the market will rigidly follow the median price in the county, for instance. This is where we have to listen to competitive data. Know what I’m saying?
7) LOOK FOR REPEAT SALES
This might seem random, but one thing I’m doing today more often is looking for repeat sales in MLS. If I can line up a few examples of sales that sold a couple of times in recent years (in the same condition), there are sometimes clues as to where the market is at today. The danger is maybe the property sold too high or low in the past or today, so we have to be super careful here. And this is where we want to line up multiple examples to try to see a pattern. The goal here is to understand the shape of the market because that might help us as we’re pulling comps and sometimes trying to adjust older sales.
TIP: Use the MLS map search and have a few years of data in the parameters. If you see more than one pin on a property, that’s your sign there is a resale situation. You’ll have to look at pictures to understand condition, and there may be some legwork in understanding each transaction. I don’t put all my weight on this method. It’s just one tool in my bag of tricks. It can be really helpful in a declining market though where we see properties selling for less.
Here is an example in the Land Park neighborhood from this week. I’m a bit hesitant to share this since resale examples were a bit all over the place, but I guess this is a good real-life situation where it doesn’t always look perfect like it might in a real estate text book. Remember, we don’t want to pin the trend on just one example either. And sometimes we get conflicting results, so we’re going to have to try to make sense out of it all.
Here’s a different example in the Verdera neighborhood in Lincoln where I was focused on a luxury price point (value was above $2M, but it sold for significantly less a decade ago). What I wanted to do was find out how much prices have changed over many years, so I looked at recent sales and traced back their previous purchase. This ended up being really helpful to justify a hefty change. But some units might have been remodeled, had a pool installed, and I think one even bought the lot next door and then re-sold twice as large. Ultimately, we are in charge and have to decide which examples are reflective of the market trend or outliers. So, you decide if it’s useful or junk.
8) TAKE MORE THAN FIVE MINUTES
In my opinion, there is no such thing as pulling comps in just five minutes. The truth is it could be hours of pouring through data to try to figure out value. My advice? Maybe do some of the stuff above or other methods you find useful. No matter what, we need a multi-layered approach to try to see the market in different ways. Recent sales, older sales, nearby neighborhoods, competitive areas further away, ZIP code trends, county trends, current listings and pendings, make some graphs, word on the street from the real estate community, etc…
I suspect some people are going to be using ChatGPT more to choose comps and such, so maybe you could get results in seconds. But be careful with that.
9) LISTEN TO THE DATA
We have to block out voices when choosing comps. What do the stats tell you? Is the market flat? Are prices going down? Is there a modest spring uptick happening? What do we see in the data? This is where we have to really look to the comps and let them speak to us. The truth is the answer could be different by neighborhood and price point, so we have to resist imposing the same trend on every neighborhood. For instance, the condo market has some struggles right now, but that trend may not be showing up at luxury price points. If you confused too, talk to others about what they’re seeing. Ask for help. Hone your skills.
10) THERE ISN’T JUST ONE WAY
There isn’t just one way to do this, so figure out what works for you. But keep growing and picking up tips. The reality is when the market changes, we often have to add new tricks to our bag. In the past, comps were ample, but that’s not the vibe today, so we need to approach things differently.
Thanks for being here.
NOTE ON COMMENTS: I know the captcha is not working perfectly for everyone. If you open up a new browser and go to my blog, that should solve the issue. I think it’s been a problem for some when clicking over from my weekly email. My apologies. I am getting an absurd amount of spam comments, so I had to put a captcha on here. I hope to have this solved eventually.
Questions: What stands out to you the most above? What else are you doing today to pull comps? What did I miss?
If you liked this post, subscribe by email (or RSS). Thanks for being here.
Love this post, Ryan! Yes, it is a more complex and nuanced landscape, and to do our best to see and understand it clearly does take time and effort. I really appreciate what you do and share; it’s a real service to us realtors and the people we do our best to serve well and effectively.
Thank you so much Peter. I appreciate you.
Love your insight as always. You are Spot-On at so many levels. For me “pulling comps” refers to research on behalf of a Seller to make sure we get an accurate List Price.
I was beginning to think I was just slow as I typically take 3-6 hours, or more. Yikes!
The one thing I didn’t hear mentioned was reviewing Pending and Active listings. I spend a lot of time reviewing Pendings. I see that as a snapshot of what’s happened in the past few weeks. And especially at this time of year, as the market is changing so quickly.
I also look VERY closely at the general price range to see how my listing will compare with others that are already on the market (and how long they’ve been on the market), and those that come on in the days between signing a listing contract, and going live. I think it’s critical to know the competition and how potential buyers will view our listing.
Just my thoughts
Thank you Steve. Love your thoughts. Spot on stuff. I didn’t have a category for just listings and pendings, but I did allude to that throughout the post. I had one agent today tell me he is going to think through his strategy now. Instead of putting all the weight on sales, he will consider what is happening currently (listings and pendings). That’s good stuff. Let’s keep considering both and respect what is happening today. On that note, we’re seeing larger-sized and pricier homes getting into contract right now as a whole in the region, and that’s why we are poised to see an increase in price metrics between January and February. But how does it feel on the neighborhood level? I think that’s where we all have to do exactly what you suggested. And kudos to you for really putting in the time. I suspect some people in real estate are doing a five-minute comp check, and they just might not know what they are missing. We need to invest more time to understand the trend…
Poor Iggy Pop lol
Thanks comps are rough these days!
Haha. And yes, the struggle is real. It seems like everything in real estate takes more time these days. It’s not smooth and easy sailing like it was a few years ago.
This post is speaking loudly to me! At a listing appointment last week I showed two separate sets of comps. One showed homes further out, but each neighborhood is so different. The other was their immediate neighborhood from 1/2024 to date. That, with Altos data by zip, helped us choose a list price, but even then it’s tough to know if you’re getting it right. I feel so validated right now! LOL Thank you, Ryan!
Right on Shannon. I love to hear this. Way to go on looking at comps from so many angles. I think that’s exactly what we have to do. Love Altos Research too. They put out some great stuff.
Retired R.E. Appraiser here ——–
You think you have in bad in the current market?
I have practiced in 4 states – 2 of the four were “NON-Disclosure States.” These are where you could NOT get any data from the Assesor that was meaningful about any sales Transactions!! If the transaction was not in the MLS, you had to go DIG recent sale deeds at the assessor. The deeds say who the seller/buyer was, but then you had to find the principles to the transaction – phone or face to face or Secretary of State for commercial. I was good at tracking down people – Once I got threatened with a lawsuit if I used the data. I got the other side of the transaction – to confirm the sale. I got the full boat of details, concessions, and the property’s condition. The other side of this transaction found out I got the info and did not like it – it was a real estate broker who admitted to me that he paid “too much” for the property, but said he would bring suit if I used the info in court. He did not want it know he was a chump.
I used the data in court, & He never brought suit.
As a professional, you do what you need to do to establish your credibility, get by, & stand by what you believe is the TRUTH.
Thanks Ed. I always appreciate your take. I am SO thankful that California is a non-disclosure state. I am okay with having basically instant access to so much data. And yes, I’ll take missing 30% of the normal of sales today instead of being located elsewhere.
Great post Ryan. I love the twice sold properties part. That could have been a blog by itself. Twice sold properties is what Case-Shiller’s index does, but obviously, that’s not specific to a neighborhood or property type.
Thanks Gary. Yeah, I’d like to explore this a bit more. I think there is something there to figure out how to rely on more.
Great visualization for repeat sales. I may have to steal that. I’ve been whining about this for three years but non-conforming homes are even more difficult to comp out. Agents, please sell more homes.
See you next week.
Thanks Joe. I was excited about the Verdera repeat visual especially. I think that one tells a more compelling story. It would be cool to find a way to automate this a bit more. I know we can sort repeat sales in pivot tables. Still tedious to put it together though.
Ryan, you have provided very good examples of the many ways to study value. I like how you pointed out that you really can’t just go on one of the examples but rather look at the many different approaches to get an all around idea of how the market is reacting. Also, the lack of sales is making it somewhat difficult for appraisers to follow the new mandate of “showing your work” regarding time adjustments. The reduction in sales makes it more difficult to get a large enough sample size to calculate time adjustment if there are any. I know you don’t do any lender work but how would you handle this problem?
Thanks Tom. I always appreciate you and your support. It is very tough to see the trend at times today. This morning I have a condo appraisal I’m finishing up, and I’m finding the same problem here, so in addition to condo volume, I have detached volume plotted in a different series on a scatter graph to help show what the overall market is doing. Granted the condo and detached trend could be different, so I have to be super careful here. All I’m saying is I’m finding myself looking to bigger data sources lately in ZIP codes, cities, adjacent neighborhoods, or bigger areas to get a sense of price movement. If I were doing the Fannie market condition support, I would probably use a scatter graph with a trendline. Keep it simple. The struggle with a trendline is the built-in line we use doesn’t always behave perfectly in my experience, so I might have to manually add a line that better mimics the market. I would also look to see if anyone has a software that helps automate things a bit more. No matter what, there has never been a shortcut for market conditions analysis, and there still isn’t no matter what sort of software comes out. I may be a one-tricky pony, but I really spend time with scatter graphs to help understand the trend. The downfall with any graph based on sales though is it lags the trend if we are only showing closed sales (which tell us more about the market from 30 to 60 days ago probably). So, all of us have to be careful to recognize the trend in pendings and listings could be showing what we need more than just sales. What are you doing with these adjustments? And other appraisers, please share if you’d like. I’d personally probably just try to invent my own thing with a scatter graph in Gnumeric.
For any onlookers, one of my favorite graphs to make is a scatter plot with multiple layers of data. You can find it at this link under “SCATTER GRAPH TEMPLATE.” My goal in creating a template is to have something that I can quickly dump data into rather than trying to re-create the wheel every time I need something. One downfall though is it seems like Gnumeric may not be compatible any longer with some versions of Windows. When I started running Windows 11 on a new computer, I could no longer download Gnuermic (or maybe I’m doing something wrong). Anyway, what I did as a workaround was to buy an external hard drive from Best Buy (pretty cheap) that’s plugged into my computer at all times by USB. I have an older version of Gnumeric on the hard drive. This basically means I can use Gnumeric at any given time on my PC. https://sacramentoappraisalblog.com/graphs/