The Past Sold Exercise: Does Your San Francisco Home Exist at Your Price?

The short version:

In San Francisco, the list price is a marketing number, so it can’t tell you what you can afford. Before my team and I show buyers a single active listing, we send them every home that has already sold inside their criteria and ask which ones they would have bought. In about an hour, that shows whether the home they want exists at their price, what they actually want and how fast they’ll need to move. Four times out of five it ends with a short list of benchmark homes; the fifth time, it saves someone a year of losing offers.

What happens when you send buyers 105 homes they can’t buy?

They learn more in one evening than most buyers learn in 6 months. Not long ago I sent a husband and wife 105 San Francisco homes. Before they opened a single one, I told them they couldn’t buy any of them. Every one had already sold.

They did the work anyway. They went through all 105 and favorited 33. When we got on a Zoom call to go over it, he said, “Ruth, this is all very depressing.”

He was right. It was depressing. It was also, I think, the most useful hour they spent all year.

This couple had $4 million to spend. The homes they picked averaged $3.17 million, which sounds like plenty of room. It wasn’t.

Their number one favorite out of all 105 was a house the wife told me she had walked straight past on the street and would never have looked at. In the end, they never walked into a single house in San Francisco, not one showing. I would do it exactly the same way again, and I’ll explain why.

Browsing San Francisco listings costs buyers more than time

Most buyers learn San Francisco the slow way. You set up a search on Redfin or Compass, watch the notifications every week, and after 4 to 6 months you build a picture of what homes go for, based on the list price. Watching sold prices works better. Either way, in this market, slow is very expensive.

The cost isn’t only time. During those months you may also be writing offers on homes that were never going to come close to your budget, because the list price was the only number you had. You lose one, then another. Each loss teaches you something real, but you pay for it with your weekends, your hope, and the nerve you’ll need when you finally find the right house.

There’s a second cost: every offer that wins becomes the new comp. Somebody paid that number, so now it’s real, and the next similar house goes up from there. You’re not studying a fixed target. You’re studying one that moves further away every time you take a swing at it.

I’ve talked to a lot of buyers who got priced out of this city during their own education process. Nothing changed about their finances. It took them a year, sometimes 2 years, to learn the market, and by then it wasn’t that market anymore.

Losing offers is actually the smaller problem. The bigger one is that if the list price is the only number you’ve ever had, everything you believe about your budget is built on it: which neighborhoods you can afford, whether you’re buying a house or a condo, and for some people, whether this city works for them at all.

You may not have gotten one offer wrong. You may have been shopping in the wrong market the entire time, and no one told you.

I’d much rather you find that out in an afternoon at your kitchen table, with nothing on the line, than 18 months from now.

Why don’t list prices tell you what San Francisco homes sell for?

Because in San Francisco, the list price is a marketing tool, not a price. Low pricing strategies are everywhere here. An agent prices a home well under where they expect it to trade because a low price drives traffic, traffic drives multiple offers, and multiple offers drive the price up.

Listing agents aren’t doing this to frustrate buyers. They have a fiduciary duty to sell the home for the highest price, and when a home is priced at value, it often doesn’t move. When they see a proven path to the highest price, their job is to explain it to the seller, who chooses the list price.

My team does it too. We recently listed a condo on a very special street in Noe Valley at $995,000. We thought it would trade around $1.3 to $1.4 million, maybe $1.5 million on a good day.

A condo on Jersey Street in Noe Valley, San Francisco

The top offer was $1.825 million. We priced it about 30% low, and the market took it much further. That’s now the comp for Jersey Street, and it moved the whole condo market around it.

A condo on Jersey Street in Noe Valley, San Francisco

Look at 3 homes this couple said yes to, all sold earlier:

  • A house on 10th Avenue in the Inner Richmond closed 30% above asking.
  • A house on 12th Avenue, 2 blocks away, closed 46% above asking.
  • A house on 27th Avenue on the Lake Street corridor closed 21% above asking.

If they had used the asking price to decide whether those homes fit inside $4 million, they would have been wrong on all 3. On the 12th Avenue house, they would have been off by more than a third.

It wasn’t a fluke: 7 of the 10 homes at the top of their list sold for a lot more than list price. That was early spring, and sale-to-list prices have gotten much more intense since.

San Francisco home the buyers favorited Neighborhood Sold above asking price (%)
House on 12th Avenue Inner Richmond 46%
House on 10th Avenue Inner Richmond 30%
House on 27th Avenue Lake Street corridor 21%

Three houses could be outliers, so widen it out. So far this year, 144 San Francisco homes have sold for $1 million or more over their asking price. Some sold $2 million over, some $4 million over. Before 2026, we’d see a few of those a year.

So when someone uses a list price to work out what you can afford, understand what they’re asking you to do: plan the largest purchase of your life around a number that, 144 times this year alone, was off by 7 figures. You see a house listed at $3.5 million, you drive across the city, you fall in love with it, and it sells for $5.2 million. You’re not an idiot. You were reading a number that was never meant to be information.

What is the past sold exercise?

It’s how my team and I compress 6 months of watching the market into about an hour. Before we look at anything active together, we take everything you’ve told us and pull every property that has actually sold inside those parameters: not what’s listed or active, but what has sold.

Here’s how it works:

  1. We pull the solds. Usually the last 6 months, or a year for bigger budgets (around $10 million) where there’s less inventory. A good search comes back with around 45 to 50 homes. The higher the price, the fewer homes.
  2. You do the homework. We send the collection in the Compass app. Go over it at dinner. Look at the photos and what each home closed for.
  3. You favorite the homes you would have bought. Not the ones you liked. The ones where you think, “If that came on today, I would have bought it.”
  4. We read it together. We go through your favorites and your notes and talk about what they show.

The part that makes people relax, and I say it up front every time, is that every home is sold. You can’t buy any of them even if you wanted to. So there’s no pressure, and you get to be completely honest about what you want, what you can’t live without, and what you don’t like.

Honesty is the whole point, and you get out of it what you put in. Some couples send me pages of notes from both partners. Others send very little, and it becomes more of a conversation starter.

A home on Grove Street in San Francisco

The exercise answers 2 questions:

  • Is your search viable? Does what you want exist at the price you want to pay? We answer that by counting.
  • Would you actually buy it? Of the homes that sold, how many would you have bought? I’ve had plenty of buyers with a very viable search on paper who would not have bought a single home in it.

Many clients also use it as a safe space to explore budgets. If you want to spend $4 million but could stretch to $6 million, you can look up to $6 million and see exactly what the difference buys before you firm up your budget.

And if you want to take this whole exercise and do it on your own, or with another agent, go for it.

A $4 million San Francisco home search, open to almost anything

This couple was very firm about $4 million. They wanted at least 3 bedrooms, around 2,500 square feet, and parking for at least 1 car, ideally 2. They were open to a house or a condo.

They were coming from the North Bay and found us through our YouTube channel. Even after watching our videos, they didn’t feel they had a sense of the neighborhoods, so they wanted to start wide. They were open to almost the entire north and west side of the city, roughly Cow Hollow out to the Central Richmond, but not the Marina (they didn’t want liquefaction) and not east of the park.

What they had decided was why they were moving. After a full life out in the country, they wanted to be in the city, in a walkable, urban neighborhood. They wanted a new life, not a quieter version of the one they already had.

Remember that. It ended up deciding everything, not the bedroom count.

The wide search brought back 105 homes. That alone answered the first question. Somewhere in the city, the thing they wanted, at their size, with their parking, at their budget, had sold.

Calibrating with your partner: 33 favorite homes became 15 or 16

When the homework comes back, I first look at how many homes a buyer favorited, not which ones. This couple favorited 33. That sounds great, but the number wasn’t real, and I told them so.

There were 2 reasons. The first happens with almost every couple: 2 people go through the collection separately, and the lists disagree. She favorited a house with a wide open floor plan, which he had already told me was an absolute no. Part of this exercise is getting calibrated with your partner.

The second reason: they got tired. I could see it in the data. Near the top, the favorites had long, thoughtful notes. By the bottom, they were just clicking.

Once we reconciled the list honestly, they had 15 or 16 homes, which is a good number. Then I took the strongest 10 and did the real work.

Are 6-month-old San Francisco comps still accurate?

Not this year. Those 10 homes sold for an average of $3.17 million against a $4 million budget, so on paper they were drawn to homes roughly $800,000 below what they could spend. That looks very viable.

Pricing San Francisco comps forward

But 9 of the 10 had closed in 2025. The average was a photograph of a market that had already stopped existing by the time they sat down to look at it, even though we were only looking back about 6 months. So I priced every one of them forward, finding a recent sale for each that showed what it would trade for today. When I ran those numbers, only 3 of the 10 were still under $4 million.

Take their number one favorite, the 10th Avenue house. It sold the previous September for $3.375 million, about $1,085 a foot for 3,100 square feet. Good houses in the Inner Richmond and the Lake Street corridor were trading around $1,700 to $1,800 a foot, which puts it between $5.3 and $5.6 million.

I came down from there, since the bathrooms had never been touched and the lower level didn’t quite work. Call it $5 million, still not $4 million. Nobody renovated that house. The neighborhood moved underneath it.

Why the past sold exercise has a shelf life

What I hand you is accurate the week I hand it to you, and in a market like this one it starts drifting immediately. It doesn’t drift evenly, either. Before 2026 I used to say the Richmond and the Inner Sunset were among the best values in the city, and that’s no longer true.

Other neighborhoods are barely moving, which is why you want someone pricing out your specific list rather than applying one number to the whole city. In 17 years, I don’t remember having to extrapolate comps for this exercise until this year. It’s hard to keep up with a market moving this fast on your own, which is why it matters to work with someone doing multiple sales every week.

Your ratio of favorites shows whether your search is viable

The ratio of homes you’d buy to homes that sold does 2 jobs. The raw ratio shows how well your taste lines up with what San Francisco produces. The adjusted ratio, priced forward, tells me whether the search is viable.

If 100 homes sold in 6 months and you would have bought 2 or 3, nothing is wrong with your taste. But your search may take much longer than most, or may not be viable at all, because once you see those homes and read their disclosures, some will drop out. I’d rather we both know that in week 1 than in month 5 or month 18.

The past sold exercise shows buyers what they actually want

Half of the past sold is a test of the market. The other half is a test of what you believe about yourself.

Here’s what she wrote about her number one favorite out of 105 homes: “I would have never looked at this house from the outside, but it’s my favorite by far.” She had walked or driven past a version of that house 100 times and written it off. It took stripping away the facade, just the rooms and a sold price in a list of 105 homes, for her to see it.

A San Francisco home at twilight

The exercise also surfaced things neither of them had told me:

  • Turnkey, not a project. They had said they were open to doing some work. They didn’t favorite a single house that needed any.
  • No open kitchen. For him, it wasn’t a preference. It was a hard no. Every time one showed up, I lost him, even on houses his wife loved.
  • Period detail, finished properly. They wanted an Edwardian or Victorian with original woodwork, not charm as an excuse for a house nobody had maintained.
  • No busy streets. A busy street ended it, no matter how good the house was.

None of those were on the list they gave me when we sat down. Every buyer compromises. A good house is an 8 out of 10, but 2 partners often have 2 different ideas of what that 80% has to include.

The exercise calibrates that into 1 list, and it tells me the next questions to ask. Does outdoor space have to be a yard, or would a patio work? Does the view need to be big, or is it a nice-to-have? Getting that list right can be the difference between needing to see 4 houses and needing to see 40.

The San Francisco homes buyers want most sell fastest

Eight of their top 10 homes sold very quickly. Across all 33 favorites, 27 closed very quickly. They weren’t picking overlooked houses. Like most buyers, they were picking the houses everybody wants.

That’s not a criticism. Good taste is good taste. But it changes the strategy completely.

If your taste runs toward homes that go in a week, you can’t be the buyer who takes a weekend to think about it. You need financing lined up, disclosures read fast, and sometimes a decision in a day. You’ll never learn that by browsing listings.

If you’re fairly sure you already know exactly what you’re looking for, I’d gently suggest that 2 or 3 things on your list may drop off the moment you and your partner see 100 homes in a row. We can find out in about an hour.

What do you do when your home doesn’t exist at your budget?

You pull 1 of 4 levers. When the numbers say the home you’re picturing isn’t there at your price, these are the options:

  1. Price. Some people can raise their budget. Not everyone can.
  2. Neighborhood. Everyone can change neighborhoods, but not everyone is willing to. Different neighborhoods are priced differently.
  3. The home itself. A condo instead of a house, or a different size.
  4. Timing. Some people wait and look for a way to stretch later. I don’t know what the market will look like in 2 years. Right now it feels like it will keep going up for a while. At some point it will come down, and I can’t tell you by how much.

Why this couple chose not to buy in San Francisco

By the end of our call, this couple knew, with the numbers behind it, that $4 million and their current criteria didn’t meet. Between the past sold and the conversations that came out of it, we narrowed a very wide search down to a handful of neighborhoods where they’d actually be happy, in and around Pacific Heights.

This is the part almost nobody explains: your budget doesn’t just set a ceiling on price, it quietly decides what kind of home you end up in. In those neighborhoods, 2,500 square feet with parking at $4 million is a condo. The houses that fit their criteria there were $5, $6 and $7 million.

They could absolutely have had a house. Many San Francisco houses trade below $4 million, and below $3 million, but to get one, you go further out, to quieter streets, where less of your life happens on foot.

A home on Yerba Buena Avenue, on a quieter street further out in San Francisco

The whole reason they were moving was to walk to restaurants. Buying a house at their number wouldn’t have just cost them a neighborhood. It would have cost them the reason they were coming to San Francisco.

To their credit, they understood immediately: “Okay, fine. We’ll do a condo. Less to maintain anyway.” We set them up on a condo search, and there were some really good ones. You can get a great 3-bedroom condo in Pacific Heights or Cow Hollow for under $4 million.

They didn’t like any of them. It wasn’t the feel they had in mind, and $4 million is an enormous amount of money almost anywhere on earth. They decided not to buy in San Francisco at all.

Why I’d do it exactly the same way again

I did a lot of work for that couple, and I didn’t sell them a house. That’s the job. Sometimes doing it properly means talking yourself out of a commission. If I’m not willing to do that, nothing else in this post is worth anything.

Look at what they didn’t spend. They never gave up a Sunday, never wrote an offer and never got outbid. They never got a call from me saying someone else came in higher, and they never fell in love with something they couldn’t afford.

That outcome is the exception, about 1 in 5 by my gut feel. Most of the time, this exercise ends with someone getting focused fast on what they can actually have.

That matters more than it sounds, because of who tends to walk through our door. Many people come to us after looking for years with an agent. When we run their past sold, we find the same thing over and over: they spent 2 years chasing something their budget was never going to reach, and no one told them.

Why San Francisco buyers rarely get current pricing

Most buyers never get current San Francisco pricing because the most useful information is the hardest to get, and because delivering it honestly is uncomfortable. Neither means their agents were careless.

Accurate pricing takes standing in the houses

Knowing where a house will land isn’t an average price per square foot across a neighborhood. A real comp analysis accounts for the layout, whether the backyard walks out flat or drops away, what the light does at 2:00 in the afternoon, whether the bedrooms sit on 1 floor or across 3, and the exact street.

None of that is in a photo set. You only know it by standing in those houses. And you shouldn’t buy the most expensive thing you’ll ever own on the strength of anybody’s gut, including mine.

Pending prices aren’t published anywhere

The price you measure against has to be current, and what closed 2 months ago is history. What homes are going into contract for right now isn’t published anywhere. You get it by calling the agent on the other side, and whether they tell you depends on whether they know you and trust you.

The other way we get it is simpler: a lot of the time, we were in that negotiation. One of our buyers wrote on the house, looked hard and passed, or won it. That includes the ones we lose. Losing an offer is expensive for a client, and we hate it, but the number that beats us is still a real number.

Telling buyers the truth is uncomfortable

Doing this properly means sitting across from someone and telling them that what they described doesn’t exist at their number. That’s uncomfortable, and you risk losing a client that afternoon.

The easier path is to stay encouraging, sign people up on a portal, and let them work it out over 18 months of open houses. I understand the pull of that. I think it costs the client more than anyone realizes at the time.

Cash matters at higher price points

Sometimes the hard truth is about how you’ll compete. On a condo we recently negotiated, just under $2 million, there were 11 offers, and 4 were cash. What mattered most to the seller in the end was cash, because of appraisal risk.

Over $5 or $6 million, we tell buyers that if there’s any way to leverage stock or a portfolio to offer cash, it’s worth looking at, so you’re not the offer that gets shopped around and beaten by a little. Not all of our buyers are cash, and I’m happy to work with you either way. I just want you to know what you’re up against before your house finally comes up, not after.

If you’ve been looking for more than 6 months and nothing lands, it isn’t a mystery. It’s a math problem, and we can show you the math.

Benchmark homes make buying decisions faster

Getting focused looks like benchmarks. As you go through the sold homes, some hit you differently: “If that came on today, I’d want it.” That house becomes a benchmark. Most buyers come out of the exercise with 2, 3 or 4 of them, and they go on our active buyer sheet so we all know exactly what we’re looking for.

Benchmarks change what we can do in the market. A big part of our job is finding inventory, and a good amount of what we sell never reaches the public market, especially at higher price points. When an agent tells us a house is coming next month, we need to know instantly whether it’s yours. With benchmarks, we can.

A home on Yerba Buena Avenue in San Francisco

They also answer the hardest question in this market. It isn’t “Is this a good house?” It’s “Is this a rare house?” When something comes on and you’re unsure, we go back to your list and ask 1 question: if this house had been in your collection, where would you have ranked it?

  • Top 3: we’re not finding you another one in 2 weeks. We looked at 6 months of inventory, sometimes a year, so act like it.
  • Middle of the pack: we’ll find you another one. You can let it go without agonizing.

We’ve had buyers win a house and walk away feeling stretched, wondering if they overpaid. Two weeks later another house nearby closes, a second goes into contract right behind it, and both confirm our clients got what now looks like a deal. Two weeks from anxious to certain.

That process is why our buyers get into contract in less than 1.4 offers. It’s not a small group: my team has sold more homes than any other agent in San Francisco for the last 2 years running (per MLS), and 104 homes so far this year, buyers and sellers. That’s not luck. By the time we’re writing, our clients know exactly what they’re looking for and what it’s worth, so they don’t spend offers on education.

Is your San Francisco home search viable?

You can find out in about an hour. Here’s the whole exercise in one place:

  • We only look at solds, because the list price is a marketing number and the sold price is the only one that’s true.
  • We count to find out whether your search is viable at all.
  • Your favorites give us a ratio that shows how long the search will realistically take, and they tell you things about your taste you’d never have put into words.
  • If the market is moving, I price your favorites forward, because last year’s comps would get you beaten this year.

What’s left is either a set of benchmarks that make every decision faster for months, or a clear-eyed answer that the home you’re picturing isn’t there. Four times out of five, it’s the first one. Both are worth an hour.

Everything here starts with knowing what homes actually sell for, by neighborhood. On our website you can search the whole city by map and get data you won’t find on a national portal, because nobody outside the city tracks San Francisco street by street. You can also sign up for our newsletter.

Reach out to us if you want to know whether your search is viable. Call, text or email my team. The call is short and it’s free.

Share
October 9, 2026
Buying a Home
previous next