STR Yield
← Back to deals

Rate 7.86% = 7.11% FRED 30-yr avg (Nov 12) + 0.75% investor premium

100 W Sherwood Blvd

100 W Sherwood Blvd

Big Bear City, CA 92314

$389,900

3 bd · 1.5 ba · 1,188 sqft · Listed 51d ago

View on Realtor.com →
Low confidenceNegative cash flow

Year built

1948

Sqft

1,188

Lot sqft

6,650

HOA / mo

None

Furnished

No

List date

2026-09-29T16:44:58.000000Z

Revenue

Annual revenue

$27,245

ADR

$301

Occupancy

25%

Cleaning fees (12 mo)

$4,847

Confidence

Low (33.05), 50 comps

Comp revenue range (p25 / median / p75)

$12,783$25,873$40,460

Median revenue of shown comps: $22,885

  • Harrison’s Hangar | Rustic Cabin Retreat

    Cabin · 3 bd · 2 ba · sleeps 6 · 72 ft

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +2

    Revenue $8,073ADR $194Occ ≈ 11%3.8★ (2)

    AirbnbBooking

  • Modern Cabin w/ Large Yard (early & late checkout)

    House · 3 bd · 1.5 ba · sleeps 8 · 75 ft

    • Free parking
    • Wifi
    • Kitchen
    • Washer
    • +1

    Revenue $15,620ADR $232Occ ≈ 18%4.9★ (204)

    Airbnb

  • Treehouse Feeling - Where Nature Sets the Mood

    House · 3 bd · 2 ba · sleeps 6 · 92 ft

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +2

    Revenue $18,223ADR $340Occ ≈ 15%4.2★ (12)

    AirbnbVrbo

  • Tri-Level Cabin w/ Deck Views + Weekly Discount

    Cabin · 3 bd · 2 ba · sleeps 8 · 180 ft

    • A/C
    • Free parking
    • Pets OK
    • Wifi
    • +3

    Revenue $45,019ADR $351Occ ≈ 35%5★ (52)

    AirbnbVrbo

  • Cozy Cabin with hot tub

    Cabin · 3 bd · 2 ba · sleeps 6 · 223 ft

    • Hot tub
    • Free parking
    • Wifi
    • Kitchen
    • +2

    Revenue $5,903ADR $191Occ ≈ 8%4.9★ (60)

    AirbnbVrbo

  • Big Wood Pines - Relaxing home with a large fenced yard for your furry friends to enjoy!

    Vacation home · 3 bd · 2 ba · sleeps 7 · 249 ft

    Revenue $29,309ADR $367Occ ≈ 22%5★ (1)

    Booking

  • LilCozyCabin/Spa/Deck/BBQ/3BR

    Cabin · 3 bd · 1.5 ba · sleeps 8 · 367 ft

    • Hot tub
    • Free parking
    • Wifi
    • Kitchen
    • +1

    Revenue $20,479ADR $362Occ ≈ 15%4.8★ (203)

    AirbnbVrbo

  • The Wilkie Cabin #339

    Vacation home · 3 bd · 1 ba · sleeps 10 · 417 ft

    Revenue $71,412ADR $1,106Occ ≈ 18%—

    Booking

  • The Wilkie Cabin ~ Calming home hideaway in the wo

    Cabin · 3 bd · 1.5 ba · sleeps 10 · 427 ft

    • Free parking
    • Wifi
    • Kitchen
    • Washer
    • +2

    Revenue $30,405ADR $614Occ ≈ 14%3.5★ (3)

    AirbnbVrboBooking

  • Early Check in! Dog & Family Friendly Ski Cabin

    Cabin · 3 bd · 2 ba · sleeps 7 · 495 ft

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +3

    Revenue $47,050ADR $330Occ ≈ 39%4.9★ (71)

    AirbnbVrbo

Show 36 more
  • Champagne Wishes & Cabin Dreams | Hot Tub, Decks

    House · 3 bd · 2.5 ba · sleeps 8 · 0.1 mi

    • Hot tub
    • Free parking
    • Wifi
    • Kitchen
    • +2

    Revenue $6,290ADR $285Occ ≈ 6%5★ (2)

    AirbnbVrboBooking

  • Yogi Bears Den - Close to Lake and Slopes

    Vacation home · 3 bd · 2 ba · sleeps 8 · 0.1 mi

    Revenue $46,421ADR $703Occ ≈ 18%—

    Booking

  • Spacious cabin | hot tub | central AC | near lake

    House · 3 bd · 2.5 ba · sleeps 8 · 0.1 mi

    • Hot tub
    • A/C
    • Free parking
    • Wifi
    • +4

    Revenue $16,185ADR $354Occ ≈ 13%5★ (13)

    Airbnb

  • Foosball Table, Pet Friendly, Fenced Yard

    Cabin · 3 bd · 2 ba · sleeps 7 · 0.1 mi

    • Hot tub
    • Free parking
    • Pets OK
    • Wifi
    • +4

    Revenue $19,038ADR $314Occ ≈ 17%4.7★ (24)

    AirbnbVrbo

  • HotTub/Speakeasy/FirePitTable/BBQ/Hammock/3bd/2ba

    Cabin · 3 bd · 2 ba · sleeps 8 · 0.1 mi

    Revenue $13,321ADR $264Occ ≈ 14%4.9★ (43)

    Delisted

  • Maltby Modern 1936 Cabin w/ Hot Tub + Games

    Chalet · 3 bd · 2 ba · sleeps 6 · 0.1 mi

    Revenue $35,461ADR $463Occ ≈ 21%—

    Booking

  • Maltby Modern 1936 Cabin w/ Hot Tub + Games

    Cabin · 3 bd · 1.5 ba · sleeps 6 · 0.1 mi

    Revenue $56,216ADR $426Occ ≈ 36%4.5★ (34)

    AirbnbBooking

  • Cozy 3BR | Steps to Hiking | Pool Table & BBQ

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.2 mi

    • Free parking
    • Wifi
    • Kitchen
    • Washer
    • +2

    Revenue $11,161ADR $491Occ ≈ 6%5★ (11)

    Airbnb

  • Carrera Cozy Cabin | FencedBackyard+FirePit+HotTub

    Cabin · 3 bd · 2 ba · sleeps 8 · 0.2 mi

    • Hot tub
    • Free parking
    • Pets OK
    • Wifi
    • +4

    Revenue $21,003ADR $602Occ ≈ 10%5★ (27)

    AirbnbVrboBooking

  • Charming cabin by the forrest

    Cabin · 3 bd · 2 ba · sleeps 8 · 0.2 mi

    • Free parking
    • Wifi
    • Kitchen
    • Fireplace

    Revenue $24,766ADR $306Occ ≈ 22%4.8★ (221)

    AirbnbVrbo

  • Baby Bears Cabin -3BD, Kid+Dog Friendly w/ Jacuzzi

    House · 3 bd · 1.5 ba · sleeps 8 · 0.2 mi

    • Hot tub
    • Free parking
    • Pets OK
    • Wifi
    • +3

    Revenue $35,424ADR $222Occ ≈ 44%4.8★ (6)

    AirbnbVrbo

  • Gingerbread House in the Woods

    Cabin · 3 bd · 2.5 ba · sleeps 6 · 0.2 mi

    • Free parking
    • Wifi
    • Kitchen
    • Fireplace

    Revenue $15,307ADR $291Occ ≈ 14%5★ (62)

    AirbnbVrbo

  • Cozy Family Cabin-Fireplace & Near Ski Lifts/Hikes

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +3

    Revenue $29,628ADR $114Occ ≈ 71%4.8★ (35)

    Airbnb

  • Chic Big Bear Cabin - Summer Oasis

    Cabin · 3 bd · 1 ba · sleeps 8 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +3

    Revenue $26,979ADR $286Occ ≈ 26%4.8★ (69)

    AirbnbVrbo

  • Rustic Private Cabin w/ Fireplace, BBQ & Fire Pit

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.2 mi

    • A/C
    • Free parking
    • Pets OK
    • Wifi
    • +4

    Revenue $38,232ADR $270Occ ≈ 39%5★ (193)

    AirbnbVrbo

  • BearsRUs

    Cabin · 3 bd · 2 ba · sleeps 8 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +3

    Revenue $7,219ADR $414Occ ≈ 5%4.8★ (58)

    Airbnb

  • *Cozy Cabin nestled in the woods of Big Bear City

    Cabin · 3 bd · 2 ba · sleeps 10 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +2

    Revenue $12,354ADR $295Occ ≈ 11%4.7★ (187)

    AirbnbVrbo

  • The Heartfelt Cabin: Best Views, Large Backyard!

    Cabin · 3 bd · 1.5 ba · sleeps 8 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +1

    Revenue $10,219ADR $379Occ ≈ 7%4.9★ (9)

    AirbnbBooking

  • Rustic A-Frame: Pool Table and Forest Views

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +4

    Revenue $64,092ADR $257Occ ≈ 68%4.8★ (107)

    Airbnb

  • Modern Hideaway in Big Bear

    Vacation home · 3 bd · 2 ba · sleeps 7 · 0.2 mi

    Revenue $39,087ADR $305Occ ≈ 35%—

    Booking

  • Modern Hideaway • Earthy & Chic 3BR, Game Room, AC

    Cabin · 3 bd · 2 ba · sleeps 7 · 0.2 mi

    • A/C
    • Free parking
    • Wifi
    • Kitchen
    • +3

    Revenue $40,917ADR $327Occ ≈ 34%4.9★ (47)

    AirbnbVrbo

  • Atlas Ridge Cabin | Cozy, HotTub, Arcade, Firepit

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.2 mi

    • Hot tub
    • Free parking
    • Wifi
    • Kitchen
    • +2

    Revenue $1,780ADR $286Occ ≈ 2%5★ (3)

    Airbnb

  • The GoldenForest: AC+Spa+Arcades+PetsOK+FencedYard

    Cabin · 3 bd · 2.5 ba · sleeps 8 · 0.2 mi

    • Hot tub
    • Free parking
    • Pets OK
    • Wifi
    • +4

    Revenue $44,404ADR $340Occ ≈ 36%5★ (50)

    Airbnb

  • FOUR SEASON CABIN

    Cabin · 3 bd · 2 ba · sleeps 10 · 0.2 mi

    • Free parking
    • Pets OK
    • Wifi
    • Kitchen
    • +2

    Revenue $28,977ADR $525Occ ≈ 15%4.7★ (102)

    AirbnbVrbo

  • Reality Escape Central Retreat at Big Bear Lake

    Vacation home · 3 bd · 1 ba · sleeps 6 · 0.3 mi

    Revenue $58,098ADR $701Occ ≈ 23%—

    Booking

  • Game Room! Close to Slopes, Village & LAKE PC

    Cabin · 3 bd · 2 ba · sleeps 8 · 0.3 mi

    Revenue $47,937ADR $560Occ ≈ 23%4.8★ (17)

    AirbnbBooking

  • Serene Big Bear Retreat w/ Hot Tub + Game Room!

    Cabin · 3 bd · 2.5 ba · sleeps 10 · 0.3 mi

    • Hot tub
    • Free parking
    • Pets OK
    • Wifi
    • +3

    Revenue $67,261ADR $337Occ ≈ 55%4.9★ (49)

    AirbnbVrboBooking

  • Hot Tub • Fenced Spacious Yard • Peaceful Cabin

    Cabin · 3 bd · 1.5 ba · sleeps 6 · 0.3 mi

    • Hot tub
    • A/C
    • Free parking
    • Pets OK
    • +5

    Revenue $17,900ADR $254Occ ≈ 19%4.9★ (18)

    Airbnb

  • 1930's Rustic Cabin King of Kings !!Jacuzzi, Pet Friendly!!

    Vacation home · 3 bd · 1 ba · sleeps 6 · 0.3 mi

    Revenue $1,822ADR $250Occ ≈ 2%—

    Booking

  • Cozy Mountain Retreat w/ Jacuzzi & Fireplace

    Cabin · 3 bd · 1 ba · sleeps 6 · 0.3 mi

    • Hot tub
    • Free parking
    • Pets OK
    • Wifi
    • +4

    Revenue $38,415ADR $315Occ ≈ 33%4.8★ (382)

    AirbnbVrbo

  • Foosball/Central Heat/Dogs OK -Rainbow Connection

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.3 mi

    Revenue $28,808ADR $240Occ ≈ 33%4.7★ (40)

    AirbnbBooking

  • Atlas Ridge Cabin | NEW! Cozy, Hot Tub, Fireplace

    House · 3 bd · 2 ba · sleeps 6 · 0.3 mi

    Revenue $5,198ADR $337Occ ≈ 4%5★ (6)

    Delisted

  • Lookout Lodge Mountain Retreat

    House · 3 bd · 2 ba · sleeps 6 · 0.3 mi

    • Free parking
    • Wifi
    • Kitchen
    • Washer
    • +2

    Revenue $14,978ADR $534Occ ≈ 8%5★ (65)

    AirbnbVrbo

  • “The Pilot's Chalet”

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.3 mi

    • Hot tub
    • Free parking
    • Wifi
    • Kitchen
    • +2

    Revenue $5,324ADR $102Occ ≈ 14%4.7★ (3)

    Airbnb

  • Single Level Home w/Entry Ramp In Big Bear

    Cabin · 3 bd · 2 ba · sleeps 6 · 0.3 mi

    • Free parking
    • Wifi
    • Kitchen
    • Fireplace

    Revenue $12,604ADR $349Occ ≈ 10%5★ (14)

    AirbnbVrboBooking

  • Sierra Family Getaway Spa/AC/Boat Parking/Wi-Fi

    House · 3 bd · 2 ba · sleeps 8 · 0.3 mi

    • Hot tub
    • Free parking
    • Wifi
    • Kitchen
    • +2

    Revenue $18,399ADR $288Occ ≈ 18%5★ (31)

    AirbnbBooking

Revenue and nightly rate (ADR) are trailing-12-month figures per listing. Occupancy is estimated as revenue ÷ ADR ÷ 365 and can read high when revenue includes cleaning fees.

Cash flow calculator

Financing
Management
Term

Rate 7.86% = 7.11% FRED 30-yr avg (Nov 12) + 0.75% investor premium

Est. revenue

$27,245

NOI

$9,139

Cash flow /mo

-$1,356

Cash needed

$132,571

Cash-on-cash

-12.3%

ROE (yr 1)

-1.6%

Cap rate

2.3%

DSCR

0.36

Year-1 write-off

$116,996

Year-1 tax shield @ 32%

$37,439

Year-1 return on equity

  • Cash flow (annual)-$16,268
  • Principal paydown$2,511
  • Appreciation at%$11,697
ROE-1.6%

Tax savings aren't counted. Turn on “Count tax savings in returns” above if you can use the losses.

Opex, cash-needed & tax-savings breakdown

Annual operating expenses

  • Management (20% of revenue)$5,449
  • Platform fees (3% of revenue)$817
  • Maintenance / capex (5% of revenue)$1,362
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$4,874
  • Insurance (STR-rated)$1,988

Cash needed to close

  • Down payment (25%)$97,475
  • Closing costs (4.0%)$15,596
  • Furnishing (bought new)$19,500

Tax savings if the STR loophole applies

  • Tax shield @ 32%$37,439

Property tax, insurance rate and the land/building split come from this listing's county tax record; other assumptions match the daily feed (see tasks/plan.md).

The write-off comes from the cost segregation estimate below. Not tax advice.

Cost segregation estimate

An estimate from the listing: every part of the home is priced from national construction costs, less wear for age, and the price (less land) is spread over the parts in proportion. The headline is what a typical cost seg study would claim for this property. The answers below are optional refinements.

Depreciable basis

$312,000

Short-life (5/15-yr)

$97,000 · 31%

Year-1 deduction

$117,000

Year-1 tax shield @ 32%

$37,000

Land 20% (county tax record, assessed value split) · building $215,000 over 39 years · new furniture $20,000

Based on: 1,188 sq ft, built 1948, 3 bd / 1.5 ba, unfurnished, listing features (patio, fence, fireplace, stone counters, flooring types, appliance list).

Try the cost segregation calculator on any property →

IRS-guide safe-harbor floor: $89,000 in year 1 (22% short-life, $29,000 tax shield), the conservative amount following the IRS audit guide's residential classification table.

5-year property$74,300
  • Kitchen cabinetsdefault

    $8,400 new × 40% good × 3.16 allocation

    $10,600
  • Kitchen countertops (stone)listing

    $8,600 new × 40% good × 3.16 allocation

    $10,900
  • Decorative trimdefault

    $2,100 new × 40% good × 3.16 allocation

    $2,600
  • Mirrorsdefault

    $200 new × 40% good × 3.16 allocation

    $200
  • Shelvingdefault

    $1,200 new × 40% good × 3.16 allocation

    $1,500
  • Window coverings (12)default

    $3,000 new × 40% good × 3.16 allocation

    $3,800
  • Carpet, vinyl & laminate (100% of floors)listing

    $7,600 new × 40% good × 3.16 allocation

    $9,700
  • Kitchen & laundry equipment plumbingdefault

    $6,500 new × 40% good × 3.16 allocation

    $8,300
  • Kitchen, laundry & data equipment electricaldefault

    $4,000 new × 40% good × 3.16 allocation

    $5,000
  • Appliances (range)listing

    $1,800 new × 40% good × 3.16 allocation

    $2,300
  • Furniture bought newlisting

    $19,500 new × 100% good · bought separately

    $19,500
15-year land improvements$42,000
  • Paving: driveway & walks (paved)default

    $7,100 new × 50% good × 3.16 allocation

    $11,300
  • Landscaping (typical)default

    $6,900 new × 50% good × 3.16 allocation

    $10,900
  • Patioslisting

    $5,300 new × 50% good × 3.16 allocation

    $8,500
  • Decks & porches (attached)default

    $1,200 new × 50% good × 3.16 allocation

    $1,900
  • Fencinglisting

    $6,000 new × 50% good × 3.16 allocation

    $9,500
Building, 39-year$215,200
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $128,500 new × 40% good × 3.16 allocation

    $162,500
  • Building plumbing & fixturesdefault

    $13,300 new × 40% good × 3.16 allocation

    $16,800
  • Building electrical & lightingdefault

    $12,300 new × 40% good × 3.16 allocation

    $15,600
  • HVACdefault

    $13,400 new × 40% good × 3.16 allocation

    $16,900
  • Fireplacelisting

    $2,600 new × 40% good × 3.16 allocation

    $3,300

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$74,300$42,000$700$117,000
2$0$0$5,500$5,500
3$0$0$5,500$5,500
4$0$0$5,500$5,500
5$0$0$5,500$5,500
6+$0$0$192,400$192,400
Total$74,300$42,000$215,200$331,500

The building's share of the price ($312,000) is 3.2x our depreciated replacement cost of the home ($99,000). The IRS guide treats a gap this size as a reason to review the land share: if land is worth more than the county ratio says, the basis and the write-off are smaller.

Model-based estimate, not an engineered cost segregation study. The IRS doesn’t approve studies; get a professional study before filing. Using these losses against W-2 income needs the short-term rental exception (average stay ≤7 days + material participation). The 39-year building life applies because stays average under 30 days, a separate test (27.5 years for a long-term rental). Federal only: California, Georgia and Wisconsin disallow bonus depreciation, Ohio adds back 5/6 of it, and Tennessee has no personal income tax. Not tax advice.

Market note

Big Bear Lake (city) and unincorporated county areas both allow permitted short-term rentals, and we found no numeric permit cap in either. Permits/licenses generally do NOT transfer on sale — a buyer must apply for their own, so confirm permit status with the city or San Bernardino County before closing. City: vacation rental license, up to 3 per owner. County: 1 permit per parcel under 2 acres, 2 max per owner. Lodging tax ~13% in the city, ~7% county. Rules change; verify before you buy.