STR Yield
← Back to deals
MortgageCash

Rate 7.78% = 7.03% Freddie Mac 30-yr avg (Sep 24) + 0.75% investor premium

42741 LA Cerena Ave

42741 LA Cerena Ave

Big Bear Lake, CA 92315

$375,000

2 bd · 2 ba · 972 sqft · Listed 1d ago

View on Realtor.com →
Rental historyNegative cash flow

Year built

1980

Sqft

972

Lot sqft

2,500

HOA / mo

None

Furnished

Yes

List date

2026-09-29T16:44:58.000000Z

Revenue

Annual revenue

$25,445

ADR

$217

Occupancy

32%

Cleaning fees (12 mo)

$5,027

Confidence

Low (49.21), 50 comps

Comp revenue range (p25 / median / p75)

$14,125$24,959$32,102

  • Remodel/AC/Hot Tub/Firepit/EV Chrg/Walk to Shuttle

    House · 2 bd · 1 ba · sleeps 5 · 108 ft

    Revenue $27,506ADR $274Occ ≈ 28%5★ (183)

    Airbnb

  • Gambrel Boho Cabin Vibes, Hot Tub & Firepit

    Cabin · 2 bd · 2 ba · sleeps 5 · 125 ft

    Revenue $40,282ADR $227Occ ≈ 49%4.8★ (92)

    AirbnbVrboBooking

  • Bristlecone Cottage ~ Ideally Located Cabin Near Skiing & Hiking w/ Wood Stove & Full Kitchen

    Vacation home · 2 bd · 1 ba · sleeps 4 · 164 ft

    Revenue $27,590ADR $563Occ ≈ 13%—

    Booking

  • Summit Happy Mountain Cabin w\ Hot tub\EV Charger.

    Cabin · 2 bd · 2 ba · sleeps 5 · 167 ft

    Revenue $36,581ADR $271Occ ≈ 37%4.5★ (201)

    AirbnbVrboBooking

  • Relax in Pines: Cabin Near Slopes & Lake

    Cabin · 2 bd · 2 ba · sleeps 4 · 197 ft

    Revenue $16,278ADR $286Occ ≈ 16%4.1★ (15)

    AirbnbVrboBooking

  • Mountain Retreat ~ Great Location!

    Cabin · 2 bd · 1 ba · sleeps 4 · 220 ft

    Revenue $19,405ADR $95Occ ≈ 56%4.8★ (251)

    AirbnbVrboBooking

  • Ponderosa walking distance to the Zoo

    Cabin · 2 bd · 1 ba · sleeps 6 · 243 ft

    Revenue $6,254ADR $340Occ ≈ 5%5★ (2)

    Airbnb

  • Moonridge Retreat•Spa•Ski-Trails•Bike•Golf•Zoo

    Cabin · 2 bd · 1 ba · sleeps 4 · 243 ft

    Revenue $24,688ADR $197Occ ≈ 34%5★ (70)

    Airbnb

  • It's Bear Time!

    Cabin · 2 bd · 2.5 ba · sleeps 9 · 256 ft

    Revenue $28,853ADR $284Occ ≈ 28%4.9★ (109)

    AirbnbVrbo

  • Dog Friendly Rustic MoonRidge Flats Cabin Tesla-EV

    Cabin · 2 bd · 1 ba · sleeps 5 · 348 ft

    Revenue $30,715ADR $269Occ ≈ 31%5★ (94)

    Airbnb

Show all 50 comps

  • Modern Moonridge Cabin w Deck by Lake, Slopes

    House · 2 bd · 1 ba · sleeps 6 · 358 ft

    Revenue $3,157ADR $190Occ ≈ 5%5★ (4)

    AirbnbVrbo

  • Relaxing Modern Cabin •2mi to Lake•Hot tub

    Cabin · 2 bd · 1 ba · sleeps 4 · 364 ft

    Revenue $36,772ADR $339Occ ≈ 30%5★ (86)

    AirbnbVrbo

  • Moonridge Cabin+AC+Hot Tub + Pet Friendly+Fire Pit

    Cabin · 2 bd · 1 ba · sleeps 4 · 367 ft

    Revenue $36,900ADR $286Occ ≈ 35%5★ (55)

    AirbnbVrbo

  • Walk to Bear Mtn • 2BR • New Spa • Pet Friendly

    Cabin · 2 bd · 1 ba · sleeps 4 · 410 ft

    Revenue $13,913ADR $267Occ ≈ 14%4.8★ (240)

    Airbnb

  • Storybook Cottage with Hot Tub-

    Cabin · 2 bd · 1 ba · sleeps 5 · 420 ft

    Revenue $24,271ADR $587Occ ≈ 11%4.7★ (49)

    AirbnbVrboBooking

  • Forest Valley

    Cabin · 2 bd · 1.5 ba · sleeps 5 · 430 ft

    Revenue $27,587ADR $349Occ ≈ 22%5★ (11)

    Airbnb

  • The Twisted Twig hosted by Big Bear Cool Cabins

    Cabin · 2 bd · 2 ba · sleeps 4 · 453 ft

    Revenue $32,564ADR $357Occ ≈ 25%4.8★ (27)

    AirbnbVrboBooking

  • Hiking Paradise: Back to National Forest

    Cabin · 2 bd · 1.5 ba · sleeps 7 · 466 ft

    Revenue $36,052ADR $175Occ ≈ 56%4.8★ (473)

    AirbnbVrbo

  • Sunflower Chalet~Pets ok

    Cabin · 2 bd · 1.5 ba · sleeps 5 · 476 ft

    Revenue $12,875ADR $260Occ ≈ 14%5★ (13)

    Airbnb

  • Bearadise Lodge- Hot Tub, Arcade, next to ski runs

    Cabin · 2 bd · 1 ba · sleeps 4 · 486 ft

    Revenue $22,528ADR $279Occ ≈ 22%4.8★ (258)

    AirbnbVrbo

  • Grizzly Hollow - Close to Bear Mtn, & Alpine Zoo

    Cabin · 2 bd · 1 ba · sleeps 5 · 486 ft

    Revenue $23,173ADR $140Occ ≈ 45%4.8★ (15)

    AirbnbVrbo

  • Heavenly Hideaway ~ Pets OK

    Cabin · 2 bd · 2 ba · sleeps 5 · 495 ft

    Revenue $9,329ADR $296Occ ≈ 9%5★ (26)

    AirbnbVrbo

  • Mins to Ski Resorts!+Center of Moonridge+PetsOK!

    House · 2 bd · 1.5 ba · sleeps 5 · 499 ft

    Revenue $11,339ADR $174Occ ≈ 18%4.9★ (8)

    Airbnb

  • Starway to Heaven: BBQ! Internet! Open Space!

    House · 2 bd · 2 ba · sleeps 6 · 505 ft

    Revenue $28,965ADR $241Occ ≈ 33%4.7★ (139)

    AirbnbVrbo

  • Snowbound Escape | <1mi Zoo • Trails • Bear Mtn

    Cabin · 2 bd · 1.5 ba · sleeps 4 · 512 ft

    Revenue $25,230ADR $300Occ ≈ 23%5★ (29)

    AirbnbVrbo

  • 3 Mi to Big Bear Lake & Village: Home w/ Balcony

    House · 2 bd · 2 ba · sleeps 8 · 515 ft

    Revenue $4,467ADR $0Occ ≈ —4.7★ (36)

    AirbnbVrboBooking

  • Dreamy Retreat – Walk to Mountain, Zoo & Golf

    House · 2 bd · 2 ba · sleeps 8 · 518 ft

    Revenue $25,754ADR $262Occ ≈ 27%5★ (22)

    AirbnbBooking

  • Little Cedar~With Spa; Pets Ok

    Cabin · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $24,058ADR $238Occ ≈ 28%5★ (25)

    Airbnb

  • Cozy Cabin w/ Hot Tub Near Slopes & Lake

    Cabin · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $11,775ADR $311Occ ≈ 10%4.5★ (16)

    AirbnbVrboBooking

  • < 3 Mi to Lake: Pet-Friendly Big Bear Cabin

    Cabin · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $22,331ADR $181Occ ≈ 34%4.2★ (62)

    AirbnbVrboBooking

  • Relax in Elevation - hike, ski, zoo + ev charger

    House · 2 bd · 2 ba · sleeps 6 · 0.1 mi

    Revenue $29,292ADR $177Occ ≈ 45%5★ (6)

    Airbnb

  • COZY Vibe - Hot Tub - Karaoke - We Love Dogs

    Vacation home · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $57,893ADR $321Occ ≈ 49%—

    Booking

  • Dog-Friendly Moonridge Cabin | Near Lake, Slopes

    Cabin · 2 bd · 1 ba · sleeps 5 · 0.1 mi

    Revenue $29,896ADR $277Occ ≈ 30%5★ (239)

    Airbnb

  • Large, centrally cabin, 10 min walk to ski & lake

    House · 2 bd · 2 ba · sleeps 5 · 0.1 mi

    Revenue $26,753ADR $170Occ ≈ 43%5★ (80)

    AirbnbVrboBooking

  • Little Bear Cubs Lodge

    Cabin · 2 bd · 2 ba · sleeps 5 · 0.1 mi

    Revenue $14,759ADR $226Occ ≈ 18%4.6★ (90)

    Airbnb

  • Cozy 2br Cabin Walk to Zoo Golf - Near Bear Mtn

    Cabin · 2 bd · 1 ba · sleeps 6 · 0.1 mi

    Revenue $11,432ADR $190Occ ≈ 16%4.7★ (147)

    AirbnbVrbo

  • New Mid-Century Cabin, Near Lake, Pet- Friendly

    Cabin · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $12,686ADR $310Occ ≈ 11%5★ (34)

    AirbnbVrbo

  • Modern 2 Bedroom with jacuzzi near forest/slopes

    Cabin · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $25,976ADR $178Occ ≈ 40%4.8★ (344)

    Airbnb

  • Walk to Bear Mountain~Putting Green~Cozy Cabin

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

    Revenue $17,960ADR $235Occ ≈ 21%4.9★ (208)

    AirbnbVrbo

  • Moonridge Hideaway - Fireplace, Deck, Fenced Yard, Pet Friendly

    Vacation home · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $39,606ADR $234Occ ≈ 46%3.1★ (3)

    Booking

  • Modern Moonridge Retreat w/ Hot Tub, Fire Pit +A/C

    Cabin · 2 bd · 2 ba · sleeps 5 · 0.1 mi

    Revenue $39,731ADR $331Occ ≈ 33%5★ (89)

    Airbnb

  • Boho Bearadise-Spa-Near Ski Resort-EV Charger

    Cabin · 2 bd · 2 ba · sleeps 5 · 0.1 mi

    Revenue $39,144ADR $283Occ ≈ 38%5★ (236)

    AirbnbVrbo

  • Nicoles Happy Place hosted by Big Bear Cool Cabins

    Cabin · 2 bd · 1 ba · sleeps 4 · 0.1 mi

    Revenue $10,435ADR $143Occ ≈ 20%4.3★ (32)

    AirbnbBooking

  • Retreat To The Mountains/Modern/2Bed/2Bath

    Cabin · 2 bd · 2 ba · sleeps 6 · 0.1 mi

    Revenue $37,832ADR $212Occ ≈ 49%4.9★ (188)

    AirbnbVrbo

  • 4Bed Loft Style - Great location-Walk to the Zoo

    Cabin · 2 bd · 1 ba · sleeps 6 · 0.1 mi

    Revenue $18,032ADR $140Occ ≈ 35%5★ (3)

    Airbnb

  • Tres Osos Family Cabin

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

    Revenue $14,762ADR $185Occ ≈ 22%4.7★ (221)

    AirbnbVrbo

  • Bear Paw Cottage~ Hot Tub~ Resort Base Camp Cottage~

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

    Revenue $51,940ADR $511Occ ≈ 28%2.6★ (3)

    Booking

  • Just The Two of Us Couples Cabin/ Walk to Zoo/Ski/Hiking

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

    Revenue $35,756ADR $272Occ ≈ 36%4.5★ (1)

    Booking

  • Sleepy Hollow-Walk to CoffeeShop/Mountain Shuttle

    Cabin · 2 bd · 2 ba · sleeps 5 · 0.1 mi

    Revenue $6,516ADR $151Occ ≈ 12%—

    Vrbo

  • Walk to local shops, Smart TV, Fireplace, Deck

    Cabin · 2 bd · 1.5 ba · sleeps 4 · 0.1 mi

    Revenue $5,374ADR $252Occ ≈ 6%4.7★ (4)

    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.78% = 7.03% Freddie Mac 30-yr avg (Sep 24) + 0.75% investor premium

Est. revenue

$25,445

NOI

$8,083

Cash flow /mo

-$1,347

Cash needed

$108,750

Cash-on-cash

-14.9%

ROE (yr 1)

-2.3%

Cap rate

2.2%

DSCR

0.33

Year-1 write-off

$119,423

Year-1 tax shield @ 32%

$38,215

Year-1 return on equity

  • Cash flow (annual)-$16,166
  • Principal paydown$2,454
  • Appreciation at%$11,250
ROE-2.3%

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,089
  • Platform fees (3% of revenue)$763
  • Maintenance / capex (5% of revenue)$1,272
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$5,881
  • Insurance (STR-rated)$1,913

Cash needed to close

  • Down payment (25%)$93,750
  • Closing costs (4.0%)$15,000
  • Furnishing (conveyed with the sale)$0

Tax savings if the STR loophole applies

  • Tax shield @ 32%$38,215

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

$301,000

Short-life (5/15-yr)

$119,000 · 39%

Year-1 deduction

$119,000

Year-1 tax shield @ 32%

$38,000

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

Based on: 972 sq ft, built 1980, 2 bd / 2 ba, furnished, listing features (hot tub, deck, fence, fireplace, flooring types, appliance list).

Try the cost segregation calculator on any property →

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

5-year property$68,700

  • Kitchen cabinetsdefault

    $7,900 new × 40% good × 3.28 allocation

    $10,400

  • Kitchen countertopsdefault

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

    $8,500

  • Decorative trimdefault

    $1,700 new × 40% good × 3.28 allocation

    $2,200

  • Mirrorsdefault

    $300 new × 40% good × 3.28 allocation

    $400

  • Shelvingdefault

    $900 new × 40% good × 3.28 allocation

    $1,200

  • Window coverings (10)default

    $2,500 new × 40% good × 3.28 allocation

    $3,300

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

    $6,300 new × 40% good × 3.28 allocation

    $8,200

  • Kitchen & laundry equipment plumbingdefault

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

    $8,100

  • Kitchen, laundry & data equipment electricaldefault

    $3,700 new × 40% good × 3.28 allocation

    $4,900

  • Appliances (range, microwave)listing

    $2,500 new × 40% good × 3.28 allocation

    $3,300

  • Hot tub (freestanding)listing

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

    $11,800

  • Furniture conveyed with the sale (used)listing

    $16,000 new × 40% good · out of the price

    $6,400
15-year land improvements$50,100

  • Paving: driveway & walks (paved)default

    $6,500 new × 50% good × 3.28 allocation

    $10,600

  • Landscaping (typical)default

    $6,200 new × 50% good × 3.28 allocation

    $10,200

  • Patiosdefault

    $1,000 new × 50% good × 3.28 allocation

    $1,600

  • Decks & porches (attached)listing

    $10,900 new × 50% good × 3.28 allocation

    $17,900

  • Fencinglisting

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

    $9,800
Building, 39-year$182,400

  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $105,000 new × 40% good × 3.28 allocation

    $137,800

  • Building plumbing & fixturesdefault

    $10,900 new × 40% good × 3.28 allocation

    $14,300

  • Building electrical & lightingdefault

    $9,600 new × 40% good × 3.28 allocation

    $12,600

  • HVACdefault

    $11,000 new × 40% good × 3.28 allocation

    $14,400

  • Fireplacelisting

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

    $3,500

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$68,700$50,100$600$119,400
2$0$0$4,700$4,700
3$0$0$4,700$4,700
4$0$0$4,700$4,700
5$0$0$4,700$4,700
6+$0$0$163,100$163,100
Total$68,700$50,100$182,400$301,300

The building's share of the price ($295,000) is 3.3x our depreciated replacement cost of the home ($90,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 and Georgia 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.