STR Yield
← Back to deals

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

336 W Sherwood Blvd

336 W Sherwood Blvd

Big Bear City, CA 92314

$499,999

4 bd · 3 ba · Listed 63d ago

View on Realtor.com →
Negative cash flow

Year built

1961

Sqft

—

Lot sqft

5,000

HOA / mo

None

Furnished

No

List date

2026-09-11T04:20:06.000000Z

Revenue

Annual revenue

$27,531

ADR

$293

Occupancy

26%

Cleaning fees (12 mo)

$5,109

Confidence

Low (45.06), 36 comps

Comp revenue range (p25 / median / p75)

$16,624$24,260$35,079

Median revenue of shown comps: $24,857

  • SuperHost's creation: MiniCastle

    House · 4 bd · 2 ba · sleeps 10 · 0.1 mi

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

    Revenue $36,223ADR $322Occ ≈ 31%5★ (90)

    Airbnb

  • Big Bear Cabana Near Lake W/ Hot Tub, Shuffleboard

    House · 4 bd · 2 ba · sleeps 10 · 0.2 mi

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

    Revenue $972ADR $486Occ ≈ 1%5★ (1)

    AirbnbVrbo

  • Spring Retreat Family Cabin Hot Tub+BBQ+Game Room

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

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

    Revenue $32,911ADR $517Occ ≈ 17%5★ (91)

    AirbnbVrbo

  • 4-Bedroom Jacuzzi, Car, RV Parking & EV charging

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

    Revenue $20,366ADR $612Occ ≈ 9%5★ (2)

    Airbnb

  • Golden Bear - Comfy cabin, short drive to the lake! Ping Pong and Pool Table! Darts and Air Hockey!

    Vacation home · 4 bd · 2 ba · sleeps 10 · 0.2 mi

    Revenue $33,857ADR $344Occ ≈ 27%—

    Booking

  • 5 Mi to Snow Summit: Cabin w/ Deck & Fireplace

    Cabin · 4 bd · 3 ba · sleeps 9 · 0.2 mi

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

    Revenue $12,662ADR $394Occ ≈ 9%4.5★ (23)

    AirbnbVrboBooking

  • Laugh, Play & Chill in Big Bear’s Golden Bear

    Cabin · 4 bd · 2 ba · sleeps 10 · 0.3 mi

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

    Revenue $24,871ADR $262Occ ≈ 26%4.1★ (11)

    AirbnbVrbo

  • "Cabana Del Oso" New Villa, AC, pool tbl.

    Villa · 4 bd · 3 ba · sleeps 10 · 0.3 mi

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

    Revenue $1,942ADR $647Occ ≈ 1%—

    AirbnbVrbo

  • Skylight Chalet - 4 BR/2.5 Bath Home, Sleeps 8

    House · 4 bd · 2.5 ba · sleeps 10 · 0.4 mi

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

    Revenue $10,667ADR $462Occ ≈ 6%5★ (80)

    Airbnb

  • Cozy Bear Lodge- Modern, Clean Cabin w Private spa

    House · 4 bd · 2 ba · sleeps 12 · 0.4 mi

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

    Revenue $3,002ADR $264Occ ≈ 3%5★ (2)

    AirbnbBooking

Show 10 more
  • Fun-Filled Big Bear Retreat for Families & Friends

    House · 4 bd · 2 ba · sleeps 10 · 0.4 mi

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

    Revenue $23,136ADR $306Occ ≈ 21%4.2★ (4)

    AirbnbVrboBooking

  • Spacious Mountain Retreat w/ Game Room

    Cabin · 4 bd · 4 ba · sleeps 10 · 0.5 mi

    • Free parking
    • Wifi
    • Kitchen
    • Fireplace
    • +2

    Revenue $18,176ADR $517Occ ≈ 10%4.7★ (40)

    AirbnbVrboBooking

  • *Bear City Doble Your Pleasure Retreat*Hot Tub*

    Cabin · 4 bd · 2 ba · sleeps 10 · 0.6 mi

    Revenue $45,770ADR $149Occ ≈ 84%4.5★ (20)

    AirbnbBooking

  • Doble your pleasure #2127

    Vacation home · 4 bd · 2 ba · sleeps 10 · 0.6 mi

    Revenue $39,530ADR $554Occ ≈ 20%—

    Booking

  • Pine Forest Cabin (beautiful fenced yard & deck!)

    Cabin · 4 bd · 3 ba · sleeps 10 · 0.6 mi

    Revenue $47,694ADR $461Occ ≈ 28%5★ (116)

    Airbnb

  • Woodland Hideaway - Stylish, Spacious, Hiking, EV

    Cabin · 4 bd · 2 ba · sleeps 9 · 0.6 mi

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

    Revenue $30,196ADR $252Occ ≈ 33%5★ (36)

    AirbnbBooking

  • 4BR Cabin Near Big Bear Lake, Ski, Hike EV Charger

    House · 4 bd · 3 ba · sleeps 10 · 0.6 mi

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

    Revenue $43,691ADR $399Occ ≈ 30%4.8★ (47)

    AirbnbVrboBooking

  • Families love! Close to Slopes, Lake, Trails & All

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

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

    Revenue $16,683ADR $472Occ ≈ 10%4.8★ (98)

    AirbnbVrboBooking

  • Gold Mountain Getaway

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

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

    Revenue $26,300ADR $369Occ ≈ 20%4.8★ (57)

    AirbnbVrbo

  • Mountain Retreat | Firepit/BBQ | Games

    House · 4 bd · 2 ba · sleeps 9 · 0.8 mi

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

    Revenue $24,842ADR $422Occ ≈ 16%5★ (18)

    AirbnbVrboBooking

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% Freddie Mac 30-yr avg (Nov 12) + 0.75% investor premium

Est. revenue

$27,531

NOI

$7,572

Cash flow /mo

-$2,084

Cash needed

$168,000

Cash-on-cash

-14.9%

ROE (yr 1)

-4.0%

Cap rate

1.5%

DSCR

0.23

Year-1 write-off

$126,459

Year-1 tax shield @ 32%

$40,467

Year-1 return on equity

  • Cash flow (annual)-$25,009
  • Principal paydown$3,221
  • Appreciation at%$15,000
ROE-4.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)$5,506
  • Platform fees (3% of revenue)$826
  • Maintenance / capex (5% of revenue)$1,377
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$6,250
  • Insurance (STR-rated)$2,550

Cash needed to close

  • Down payment (25%)$125,000
  • Closing costs (4.0%)$20,000
  • Furnishing (bought new)$23,000

Tax savings if the STR loophole applies

  • Tax shield @ 32%$40,467

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

$400,000

Short-life (5/15-yr)

$103,000 · 26%

Year-1 deduction

$126,000

Year-1 tax shield @ 32%

$40,000

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

Based on: ~2,400 sq ft (from beds), built 1961, 4 bd / 3 ba, unfurnished, listing features (deck, fireplace).

Try the cost segregation calculator on any property →

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

5-year property$73,700
  • Kitchen cabinetsdefault

    $11,100 new × 40% good × 2.10 allocation

    $9,300
  • Kitchen countertopsdefault

    $9,000 new × 40% good × 2.10 allocation

    $7,600
  • Decorative trimdefault

    $4,200 new × 40% good × 2.10 allocation

    $3,500
  • Mirrorsdefault

    $500 new × 40% good × 2.10 allocation

    $400
  • Shelvingdefault

    $1,500 new × 40% good × 2.10 allocation

    $1,300
  • Window coverings (24)default

    $6,000 new × 40% good × 2.10 allocation

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

    $6,200 new × 40% good × 2.10 allocation

    $5,200
  • Kitchen & laundry equipment plumbingdefault

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

    $7,200
  • Kitchen, laundry & data equipment electricaldefault

    $5,200 new × 40% good × 2.10 allocation

    $4,400
  • Appliances (range, microwave, dishwasher, disposal, refrigerator, washer, dryer)default

    $8,100 new × 40% good × 2.10 allocation

    $6,800
  • Furniture bought newlisting

    $23,000 new × 100% good · bought separately

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

    $10,200 new × 50% good × 2.10 allocation

    $10,700
  • Landscaping (typical)default

    $9,800 new × 50% good × 2.10 allocation

    $10,300
  • Patiosdefault

    $2,400 new × 50% good × 2.10 allocation

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

    $27,000 new × 50% good × 2.10 allocation

    $28,400
Building, 39-year$297,500
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $260,300 new × 40% good × 2.10 allocation

    $218,800
  • Building plumbing & fixturesdefault

    $27,000 new × 40% good × 2.10 allocation

    $22,700
  • Building electrical & lightingdefault

    $27,700 new × 40% good × 2.10 allocation

    $23,300
  • HVACdefault

    $27,000 new × 40% good × 2.10 allocation

    $22,700
  • Hardwood & tile floorsdefault

    $9,300 new × 40% good × 2.10 allocation

    $7,800
  • Fireplacelisting

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

    $2,200

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$73,700$51,800$1,000$126,500
2$0$0$7,600$7,600
3$0$0$7,600$7,600
4$0$0$7,600$7,600
5$0$0$7,600$7,600
6+$0$0$266,000$266,000
Total$73,700$51,800$297,500$423,000

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.