STR Yield
← Back to deals

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

925 Spruce Ln

925 Spruce Ln

Big Bear City, CA 92314

$424,999

3 bd · 2 ba · 1,461 sqft · Listed 5d ago

View on Realtor.com →
Negative cash flow

Year built

2020

Sqft

1,461

Lot sqft

4,504

HOA / mo

None

Furnished

Yes

List date

2026-11-14T04:29:33.000000Z

Revenue

Annual revenue

$20,366

ADR

$232

Occupancy

24%

Cleaning fees (12 mo)

$4,065

Confidence

Low (43.53), 24 comps

Comp revenue range (p25 / median / p75)

$13,776$18,407$30,050

Median revenue of shown comps: $18,407

  • 3BR Starlight Stargaze Haus - EV & Fireplace

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

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

    Revenue $16,518ADR $239Occ ≈ 19%5★ (16)

    AirbnbVrbo

  • Peaceful, 3 BD Modern Cabin & Game Room

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

    Revenue $10,578ADR $264Occ ≈ 11%4.9★ (20)

    Booking

  • 'The Bear's Den' Cabin: 8 Mi to Snow Summit!

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

    Revenue $19,458ADR $338Occ ≈ 16%4.2★ (55)

    Airbnb

  • Whistling Birds ~ EV Charge

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

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

    Revenue $27,314ADR $236Occ ≈ 32%5★ (40)

    Airbnb

  • Mama Bear's Manor - Luxury Spa - No Cleaning Fee

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

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

    Revenue $32,790ADR $503Occ ≈ 18%4.9★ (56)

    Airbnb

  • Home w/ SPA, Fire Pit, Yard near Ski Resort & Lake

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

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

    Revenue $34,622ADR $242Occ ≈ 39%4.9★ (110)

    Airbnb

  • Gorgeous Newly Remodeled Cabin Minutes from slopes

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

    Revenue $14,737ADR $221Occ ≈ 18%5★ (35)

    Airbnb

  • One Hundred Pines Equestrian Ranch at Big Bear Lake

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

    Revenue $10,295ADR $323Occ ≈ 9%—

    Booking

  • One Hundred Pines Equestrian Ranch at Big Bear

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

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

    Revenue $13,917ADR $278Occ ≈ 14%4.5★ (6)

    AirbnbVrboBooking

  • Starlight Hideaway: Big Bear Log Cabin w/ Hot tub!

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

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

    Revenue $24,949ADR $339Occ ≈ 20%5★ (45)

    Airbnb

Show 14 more
  • Cozy Cabin on Sixth - FREE EV Charging!

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

    Revenue $446ADR $205Occ ≈ 1%4.9★ (41)

    Airbnb

  • Lincoln Log Cabin | Renovated | Near Attractions

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

    • Free parking
    • Wifi
    • Kitchen
    • Washer

    Revenue $15,667ADR $296Occ ≈ 15%4.5★ (9)

    AirbnbVrboBooking

  • 3rd Night FREE Blue Snowflake Big Bear Mtn. Resort

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

    • Free parking
    • Wifi
    • Kitchen
    • Fireplace

    Revenue $3,876ADR $343Occ ≈ 3%5★ (1)

    Airbnb

  • A Frame Escape ! Fully fenced!

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

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

    Revenue $21,342ADR $135Occ ≈ 43%4.5★ (165)

    AirbnbVrbo

  • Bluebird Haven

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

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

    Revenue $10,518ADR $272Occ ≈ 11%5★ (19)

    Airbnb

  • Big Bear Getaway!

    Chalet · 3 bd · 2.5 ba · sleeps 8 · 0.4 mi

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

    Revenue $29,136ADR $193Occ ≈ 41%4.7★ (222)

    AirbnbVrbo

  • Cedar Creek

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

    Revenue $13,354ADR $234Occ ≈ 16%4.6★ (62)

    Delisted

  • Warm, modern, rustic cabin, Dog friendly. Bravo.

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

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

    Revenue $14,656ADR $296Occ ≈ 14%5★ (64)

    AirbnbVrbo

  • Beach to Mountains Chalet

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

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

    Revenue $17,356ADR $186Occ ≈ 26%5★ (14)

    AirbnbVrbo

  • Entire Home • 4 Beds • 3 Bedroom Big Bear

    House · 3 bd · 3 ba · sleeps 7 · 0.5 mi

    • Free parking
    • Wifi
    • Kitchen
    • Fireplace

    Revenue $21,545ADR $314Occ ≈ 19%5★ (141)

    Airbnb

  • Hershey Bear Cabin:NEW! Igloo,Hot Tub,Dog Friendly

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

    Revenue $34,023ADR $429Occ ≈ 22%4.9★ (47)

    Delisted

  • StAr wArS Log Cabin, game room, hot tub

    Cabin · 3 bd · 1.5 ba · sleeps 10 · 0.7 mi

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

    Revenue $42,000ADR $337Occ ≈ 34%5★ (232)

    AirbnbVrbo

  • Beary Peaceful Ski & SPA Retreat, Ping Pong

    Cabin · 3 bd · 3 ba · sleeps 8 · 0.7 mi

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

    Revenue $43,706ADR $298Occ ≈ 40%4.8★ (82)

    Airbnb

  • Cozy Fall Cabin-Hot Tub, Arcade, Play Room

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

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

    Revenue $44,141ADR $308Occ ≈ 39%4.8★ (89)

    AirbnbVrbo

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

$20,366

NOI

$3,621

Cash flow /mo

-$2,006

Cash needed

$123,250

Cash-on-cash

-19.5%

ROE (yr 1)

-7.0%

Cap rate

0.9%

DSCR

0.13

Year-1 write-off

$86,962

Year-1 tax shield @ 32%

$27,828

Year-1 return on equity

  • Cash flow (annual)-$24,073
  • Principal paydown$2,738
  • Appreciation at%$12,750
ROE-7.0%

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)$4,073
  • Platform fees (3% of revenue)$611
  • Maintenance / capex (5% of revenue)$1,018
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$5,584
  • Insurance (STR-rated)$2,167

Cash needed to close

  • Down payment (25%)$106,250
  • Closing costs (4.0%)$17,000
  • Furnishing (conveyed with the sale)$0

Tax savings if the STR loophole applies

  • Tax shield @ 32%$27,828

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

$341,000

Short-life (5/15-yr)

$87,000 · 25%

Year-1 deduction

$87,000

Year-1 tax shield @ 32%

$28,000

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

Based on: 1,461 sq ft, built 2020, 3 bd / 2 ba, furnished, listing features (deck, fireplace, stone counters, appliance list).

Try the cost segregation calculator on any property →

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

5-year property$53,700
  • Kitchen cabinetsdefault

    $9,000 new × 76% good × 1.35 allocation

    $9,200
  • Kitchen countertops (stone)listing

    $9,200 new × 76% good × 1.35 allocation

    $9,500
  • Decorative trimdefault

    $2,600 new × 76% good × 1.35 allocation

    $2,600
  • Mirrorsdefault

    $300 new × 50% good × 1.35 allocation

    $200
  • Shelvingdefault

    $1,200 new × 76% good × 1.35 allocation

    $1,200
  • Window coverings (15)default

    $3,800 new × 40% good × 1.35 allocation

    $2,000
  • Carpet, vinyl & laminate (40% of floors)default

    $3,800 new × 50% good × 1.35 allocation

    $2,500
  • Kitchen & laundry equipment plumbingdefault

    $7,000 new × 88% good × 1.35 allocation

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

    $4,200 new × 88% good × 1.35 allocation

    $5,000
  • Appliances (range, microwave, dishwasher, refrigerator, washer, dryer)listing

    $7,700 new × 50% good × 1.35 allocation

    $5,200
  • Furniture conveyed with the sale (used)listing

    $19,500 new × 40% good · out of the price

    $7,800
15-year land improvements$33,000
  • Paving: driveway & walks (paved)default

    $7,900 new × 76% good × 1.35 allocation

    $8,100
  • Landscaping (typical)default

    $7,600 new × 76% good × 1.35 allocation

    $7,800
  • Patiosdefault

    $1,400 new × 76% good × 1.35 allocation

    $1,500
  • Decks & porches (attached)listing

    $16,400 new × 70% good × 1.35 allocation

    $15,500
Building, 39-year$254,700
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $158,100 new × 90% good × 1.35 allocation

    $192,300
  • Building plumbing & fixturesdefault

    $16,400 new × 88% good × 1.35 allocation

    $19,500
  • Building electrical & lightingdefault

    $15,800 new × 88% good × 1.35 allocation

    $18,800
  • HVACdefault

    $16,500 new × 70% good × 1.35 allocation

    $15,600
  • Hardwood & tile floorsdefault

    $5,600 new × 76% good × 1.35 allocation

    $5,800
  • Fireplacelisting

    $2,600 new × 76% good × 1.35 allocation

    $2,700

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$53,700$33,000$300$87,000
2$0$0$6,500$6,500
3$0$0$6,500$6,500
4$0$0$6,500$6,500
5$0$0$6,500$6,500
6+$0$0$228,300$228,300
Total$53,700$33,000$254,700$341,400

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.