Ran the numbers on three West Sedona STRs: the cute one & one with the best view lost

Ran the numbers on three West Sedona STRs: the cute one & one with the best view lost

Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes

This summer my wife and I were looking to buy an Airbnb/STR investment property in West Sedona. I'm a local real estate agent and we already own and run a successful short-term rental in the Village of Oak Creek, so I figured I knew what I was looking for. But, when I ran the actual numbers properly, the house both my wife and I loved the most actually came in last.

What follows is an under the hood look at my whole analysis, including the parts that don't usually make it into the glossy pro forma you might get from a property management company. If you're weighing an investment in the Sedona STR market, the reasoning applied here is probably more important to you than my particular set of houses.

Our constraints were simple and modest: a price tag of under one million, at least 1,200 sqft, and 2 or more bedrooms and baths.

The three candidates

We ended up with three West Sedona listings. (I've left the addresses out since the process here is what's potentially useful, not the specifics). Prices and sizes are rounded.

  • House A, "the view": $775k, 3 bed / 2 bath, 1,275 sq ft, full red rock view, move-in ready, no STR restrictions

  • House B, "the cute one": $700k, 2 bed / 2 bath, 1,050 sq ft, peekaboo view from the back yard only, move-in ready, no STR restrictions

  • House C, "the fixer": $800k, 2 bed / 2 bath, 1,625 sq ft, red rock and mountain views, needs about $50k of work, HOA 30-day minimum

A and B sat on streets with a mix of stick-built and manufactured homes. C was among $1M+ neighbors.

First cut: the HOA trap

House C had the best views, the best street and was in the best neighborhood, but it was out in five minutes. Its HOA requires 30-day minimum stays, which rules out nightly and weekly bookings entirely.

That doesn't make it a bad property, but through the Sedona STR investment lens it meant that it was really a mid-term rental: furnished and rented by the month to traveling nurses, snowbirds, remote workers and the like. Modeling it as such, the conservative case put rents at approximately $3,300 a month, in line with furnished two-bedroom listings around Sedona today. The optimistic case could go as high as $5,500, which is my gut read on what a 30-day Airbnb stay could fetch for this house. Both ends assume 10 rented months a year, $50k of remodeling and $25k of furniture.

House C as a monthly rental (conservative at $3,300/mo vs. optimistic at $5,500/mo):

  • Cap rate: 2.5% vs. 5.0%

  • Return on cash invested (cash, self-managed): 2.3% vs. 4.5%

  • Monthly cash flow, financed at 25% down and 7.5% (approximated): -$2,500 vs. -$900

Without the boost from nightly rental rates, the best views on the best street ended up producing the worst rental returns of the three. While it could make a lovely home, as a rental investment, the listing price was paying for the neighborhood, not the income potential.

Even at an optimistic view of the potential rent income, House C still trails House A's optimistic case by a wide margin and still loses money every month once you factor in the need to finance the purchase.

The lesson here is to check the HOA documents before you do anything else. There are actually very few neighborhoods in the city of Sedona that don't have some kind of rental restrictions. It's the cheapest, clearest and easiest "no go" signal you'll ever get.

Charm vs. view: why the cute one loses

House A won on every metric I ran. The red rock view and the third bedroom projected almost 40% more revenue for only 11% more purchase price.

Bought with cash, self-managed (House A, the view, vs. House B, the cute one):

  • Return on cash invested, conservative: 5.5% vs. 3.7%

  • Return on cash invested, optimistic: 8.7% vs. 6.6%

  • Cap rate, conservative: 5.8% vs. 4.0%

House B really is charming, and charm counts for something. Great photos convert browsers into bookings and let you push your rate. But charm can only move you up within the pricing tier you live at. A cute no-view house competes with all the other no-view houses; it never gets to charge red rock view prices. And here in Sedona, the red rock view is what folks pay a premium for.

The reality is the "cuteness" is often easier and cheaper to obtain with a little creativity than one might initially appreciate. So, while it's sometimes hard to step outside the emotional response that a well thought out cute space produces, the numbers speak for themselves.

To match House A's conservative cap rate, House B would have needed to sell for roughly $470,000. That's $225,000 under its asking price, even in a bad market that wasn't likely to happen.

One quick caveat: This was a quick go/no-go assessment. These revenue figures I'm sharing here were modeled estimates based on generalized data, not pulled from individual STR offerings. Before making any final decision, tighter, more specific revenue comps are where the real truth lives, so before you trust any pro forma, mine included, compare it against real nightly-rate and occupancy data for the specific street in question.

The financing gut punch

Paying cash, both A and B houses looked like respectable prospects. Financed at 25% down and 7.5% interest (optimistic rates at the investment property level), neither one paid for itself in the conservative case.

Financed, 25% down at 7.5% (House A vs. House B):

  • Cash-on-cash return, conservative, self-managed: about -1.5% vs. about -7%

  • Same, plus a manager taking 25% of gross: negative vs. negative

  • Optimistic case, plus a manager taking 25%: about breakeven vs. negative

This analysis reveals two important lessons. First, at Sedona prices and even the most optimistic of today's rates, how much you have to borrow matters more than the actual house you end up going with. Second, if you then hand 25% of gross to a full-service manager, the financed numbers go negative almost everywhere. For smaller STR investors, managing it yourself is the single biggest lever in the model you can pull after the purchase price.

This is the reality I most often find missing from the pro formas buyers show me from various property management companies around town.

The question nobody asks: would an index fund do better?

An STR is an investment, and so before pulling the trigger on anything it's never a bad idea to look at what else the money could be invested in. For us the alternative was putting the same cash into an S&P 500 index fund. And the numbers here were really helpful. House A only came out ahead if we held it seven years or more and Sedona prices rose at least 4% a year. At 2% a year, the result depended entirely on how well we ran the rental.

Before COVID, Sedona prices rose roughly 4 to 5% a year on their own. Then things went crazy during the pandemic, so starting from today's still-elevated prices, my read is that the next couple of years will be a disappointing 1 to 2% until the market catches up with itself.

That doesn't mean don't buy a home in Sedona right now. It just means you need to be honest about why you're buying. A house you'll love using, or one near friends, is a perfectly valid reason to make an offer. But, go in knowing it's a lifestyle choice, not a valid investment one.

Why we bought neither

For my wife and me, we decided to wait six months and then check in again. The Sedona market was still clearly in flux based on four key market signals: Supply, Median days on market, Sale-to-list price and Home values, year over year. With math making a purchase profitable unlikely and the indicators suggesting that prices were still settling, I am confident we made the right call. Here's how these key signals have shifted since we made our decision to wait (based on data from Sedona single-family home sales pulled from my MLS):

  • Months of supply: ~4.7 then, ~4.9 now. Buyers still have plenty of choice.

  • Median days on market: 55 then, 46 now. Homes are selling faster.

  • Sale-to-list price: 98.2% then, 98.3% now. Holding steady.

  • Home values, year over year (Zillow): -5.7% then, +0.1% now. Prices have stopped falling.

(Then = May to Jul 2026. Now = Aug to Nov. 2026.)

Where we are currently at: prices have stopped falling and homes are moving a little faster, but buyers still have room to negotiate, which to me looks like the end of a bottoming process, not a rebound yet. So for now, we are still holding back. Meanwhile House A has gone under contract with another buyer, but that is okay. Timing is the key to our plan. I will continue to check the signals monthly, and when the rebound is clear, we will take advantage of the market.

Sources: ARMLS, Sedona single-family closings May to Nov 2026 (the summer months-of-supply figure is from my notes at the time); Zillow Home Value Index through Aug 2026. ARMLS doesn't carry every Sedona listing, so treat these as a strong sample rather than a full count.

If you're looking at a Sedona STR

  1. Read the HOA documents first. A 30-day minimum turns an Airbnb into a different business.

  2. Pay for the view and the bedrooms, not the charm. Charm moves you up within your tier; it doesn't change tiers. And it is easier to create than you think.

  3. Run the numbers financed and with a manager, even if you plan to pay cash and do it yourself. That's where your margin disappears.

  4. Compare it to an index fund over the number of years you'll actually hold it. And be honest with yourself about the difference in effort required between the two.

  5. Watch the market signals before you rush. In this market, patience pays.

I'm curious what others are seeing. If you run STRs in view-driven markets (Sedona, Moab, the Smokies, anywhere the scenery is the product), does the view premium hold up in your actual booking data? And has anyone else been caught out by an HOA rental restriction they found late in the process?

3Reply
375 views

14 Replies

Jump to latestLatest
  • Lender · Peoria, AZ · Member since 2026 · 85 posts · 18 votes
    1d

    Hey Benjamin,

    Really solid breakdown, and the HOA point alone is going to save somebody a headache. One thing I'd add on the financing side for when you circle back: price the House A type deals as a DSCR loan too, not just a standard investment loan. Those qualify off the property's rental income instead of your personal income, and how a lender treats projected STR income can move the down payment and cash flow math quite a bit.

    I'm a mortgage broker licensed in Arizona, California, Colorado, Kansas, Texas, and Arkansas, and I like helping investors. Happy to be a resource. No pressure at all!

    When the rebound shows up, are you leaning toward financing the next one or paying cash?

    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      1d

      Thanks, Joe! Good call on DSCR. I modeled a conventional investment loan, but you're right that it changes the picture, especially the down payment. For now we're holding off while the Sedona market settles, but when we buy, we'll most likely finance.

      Question for you: how do lenders treat projected STR income on a DSCR loan for a property with no rental history? Do you see them use AirDNA-type projections, a 1007 rent schedule, or something else? And what DSCR ratio do they usually want to see for an STR?

  • Ashish AcharyaBusiness Member
    CPA, CFP®, PFS · Sarasota, FL · Member since 2017 · 5k+ posts · 3k+ votes
    20h

    This is one of the most honest STR breakdowns I've seen here, especially the index fund comparison most people skip. The one thing I'd add to that comparison is taxes, because they can shift the result more than a point or two of appreciation. An index fund's gains and dividends are taxed with nothing to offset them. An STR you materially participate in, with a cost seg on House A's purchase price, can generate a large first-year loss that offsets your other income. As an agent, that's your commission income, which is active, ordinary income, and the right entity structure (LLC vs. S-corp) helps you save taxes on active, non-passive ordinary income. That's often what tips a borderline financed STR ahead of a passive investment.

    Taxes also give you one more reason House C lost. With a 30-day minimum, the average stay is well over 7 days, so it's treated as a regular rental, and its losses are passive no matter how hands-on you are. The STR tax benefit only applies to the nightly and weekly properties.

    Feel free to DM me, I’d be happy to share a few resources that might help.

    INVESTOR FRIENDLY CPA®4.9244 Reviews
    TaxMD® | Tax Planning Software
    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      13h

      Great point, Ashish. I left taxes out of the headline numbers on purpose to keep the comparison simple, but the cost seg plus material participation angle is a real advantage the index fund can’t match, and it’s one more reason House C’s 30-day minimum hurts. I’d welcome any resources you could share.

  • Las Vegas, NV · Member since 2018 · 31 posts · 8 votes
    20h

    Benjamin, this is the kind of breakdown more people should do before falling for a listing. Putting the HOA check first is spot on.

    A few things I'd add to the model for anyone running the same numbers in Sedona:

    Turnover costs go up with bedrooms. A 3-bed draws bigger groups, so cleaning, laundry and supplies per stay are higher. I'd run House A's revenue bump against a higher per-turn cost so the gap doesn't look bigger than it is.

    Sort out the city and state paperwork before closing, not after. Confirm what Sedona currently requires for a short-term rental permit and what Arizona requires for tax licensing, and budget for any safety or inspection items that come with it.

    Model the slow months on their own. Pull the matched view comps' calendars for the weakest months and see whether they hold rate or cut it, instead of leaning on the annual average.

    On the mixed street, think about the exit too. If you ever sell, the pool of buyers for a $775k house next to older manufactured homes may be smaller than the view suggests.

    (Drafted with AI help.)

    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      13h

      Good additions, Kent. Seasonality is a big one here: summer and January run much slower than fall and spring, so modeling the slow months separately is smart. And you're right on the exit: a mixed street will narrow the resale buyer pool.

  • Tbilisi, Georgia (country) · Member since 2026 · 36 posts · 8 votes
    19h

    @Benjamin Wilkins This is a really good write-up, especially the index fund part (almost nobody makes that comparison). When you ran it, did you count the loan paydown and depreciation on the house side, or only cash flow and price growth? Those two can move a 7-year result quite a bit. I also agree on the HOA - a 30-day minimum makes it a different business, not a worse version of the same one.

    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      13h

      Good question, Rati. It included cash flow, appreciation and loan paydown (equity at the end of each period), net of furnishing costs and about 7% to sell. Depreciation and other tax benefits weren't included, so as Ashish pointed out, the STR's real advantage is probably a bit better than what I showed, especially with a cost seg study. Even so, it took 7+ years and roughly 4% annual appreciation to clearly beat the index, which says a lot about entry prices in Sedona right now.

  • Andrew SteffensBusiness Member
    Tampa, FL · Member since 2022 · 4k+ posts · 3k+ votes
    18h

    Great analysis! I know nothing about the Sedona market but in FL more bedrooms is just about always better. Did that help in Property A's case? Do 4-6 bedrooms do particularly well there as they do here in the Tampa market?

    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      13h

      It did. The third bedroom plus the view is most of why House A projected almost 40% more revenue than House B. In Sedona, bigger homes do well with groups and families, especially for holidays, but the view usually matters more than an extra bedroom.

  • Lender · Peoria, AZ · Member since 2026 · 85 posts · 18 votes
    16h

    Hey Benjamin,

    Happy to share what I'm seeing. Honestly, it changes a lot from lender to lender. Here's how a few of the DSCR lenders I work with handle a purchase with no rental history. Just know guidelines change often.

    Some will use an AirDNA projection on its own, as long as the area makes sense for STRs and the report shows decent occupancy and a solid market score. One of those wants a 1.15 DSCR once you go above 65% LTV.

    Another takes the higher of the appraiser's market rent or 80% of the AirDNA number, with a cap so the two can't be too far apart.

    A few cut gross STR rents by 20% for the extra expenses and then go with the lowest of the appraiser's STR analysis and AirDNA.

    Others still lean on a regular long-term rent schedule, which usually hurts in a place like Sedona.

    So the same house can show a pretty different DSCR depending on who's looking at it. When you find one you like, send me the listing and I'm happy to run it through a few of these. Good luck with the Sedona search!

    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      13h

      This is incredibly helpful, Joe, thank you. The 80% of AirDNA / 20% haircut method is good to know about, and you’re absolutely right that a long-term rent schedule would sink most Sedona deals. I’d love to take you up on running a listing through your lenders. I’ll DM you one.

  • Member since 2020 · 7 posts · 3 votes
    11h

    hey Benjamin, love that you let the numbers pick the house and not the view. thats hard to do when you both love one. learned a lot, thank you

    • Real Estate Agent · Sedona, AZ · Member since 2026 · 9 posts · 3 votes
      4h

      Thanks, Cameron! It definitely wasn't easy. The cute one won our hearts first. But that's exactly why I run the numbers this way. Real estate is emotional, especially when it's a place you'd love to stay yourself. I've watched people buy a Sedona STR because it felt right, only to sell a year or two later when the income never showed up. A few hours with a spreadsheet up front is a lot cheaper than learning that lesson after closing.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.