
40217 Dream St
Big Bear Lake, CA 92315
$599,000
3 bd · 2 ba · Listed 15d ago
View on Realtor.com →Year built
2017
Sqft
—
Lot sqft
5,000
HOA / mo
None
Furnished
Yes
List date
2026-09-14T07:49:56.000000Z
Revenue
Annual revenue
$31,384
ADR
$245
Occupancy
35%
Cleaning fees (12 mo)
$6,528
Confidence
Low (38.82), 50 comps
Comp revenue range (p25 / median / p75)


Home From Home in Big Bear Lake
Cabin · 3 bd · 3 ba · sleeps 6 · 115 ft
Revenue $12,936ADR $242Occ ≈ 15%5★ (18)

Bear Hug Cabin- Arcade Game! Centrally Located!
Cabin · 3 bd · 2 ba · sleeps 8 · 180 ft
Revenue $26,688ADR $286Occ ≈ 26%5★ (38)

Family Fun close to hiking trails and lake
House · 3 bd · 2 ba · sleeps 6 · 285 ft
Revenue $22,402ADR $221Occ ≈ 28%5★ (67)






Village chic chalet #2113
Vacation home · 3 bd · 2 ba · sleeps 7 · 371 ft
Revenue $4,247ADR $252Occ ≈ 5%—
| Listing | Size | Revenue (12 mo) | ADR | Occ ≈ | Rating | Distance | Links |
|---|---|---|---|---|---|---|---|
![]() Hearthmoon Haven ~ AC & SPA, Near Village House | 3 bd · 2 ba · sleeps 5 | $12,239 | $217 | 15% | 4.8★ (7) | 98 ft | AirbnbVrbo |
![]() Home From Home in Big Bear Lake Cabin | 3 bd · 3 ba · sleeps 6 | $12,936 | $242 | 15% | 5★ (18) | 115 ft | Airbnb |
![]() Bear Hug Cabin- Arcade Game! Centrally Located! Cabin | 3 bd · 2 ba · sleeps 8 | $26,688 | $286 | 26% | 5★ (38) | 180 ft | Airbnb |
![]() Family Fun close to hiking trails and lake House | 3 bd · 2 ba · sleeps 6 | $22,402 | $221 | 28% | 5★ (67) | 285 ft | Airbnb |
![]() Escape to Big Bear Lake before Summer Ends Cabin | 3 bd · 2 ba · sleeps 7 | $29,020 | $380 | 21% | 5★ (16) | 292 ft | AirbnbVrboBooking |
![]() Family Cabin, Playroom w/ Slide, Walkable, Dog Run House | 3 bd · 2 ba · sleeps 7 | $18,858 | $303 | 17% | 5★ (17) | 325 ft | AirbnbVrboBooking |
![]() Hot Tub and Kids Play Set - Take a Break House | 3 bd · 2 ba · sleeps 7 | $27,382 | $276 | 27% | 4.3★ (39) | 338 ft | AirbnbVrboBooking |
![]() Fully fenced Playground Hot Tub Near Lake&Town Cabin | 3 bd · 1 ba · sleeps 5 | $26,981 | $336 | 22% | 4.8★ (120) | 348 ft | AirbnbVrbo |
![]() Bearadise ~ Enchanted Dream ~ Mountain Escape Cabin | 3 bd · 2 ba · sleeps 8 | $60,377 | $249 | 66% | 5★ (83) | 354 ft | AirbnbVrbo |
![]() Village chic chalet #2113 Vacation home | 3 bd · 2 ba · sleeps 7 | $4,247 | $252 | 5% | — | 371 ft | Booking |
Show all 50 comps

La Petite château, easy walk to lake and Village
Cabin · 3 bd · 2 ba · sleeps 6 · 377 ft
Revenue $11,064ADR $224Occ ≈ 14%4.8★ (77)

The Dream Catcher| Modern Rustic w/ Hot Tub & EV
Cabin · 3 bd · 3 ba · sleeps 8 · 384 ft
Revenue $31,165ADR $444Occ ≈ 19%4.8★ (15)

Upscale Cabin by Village, Lake, Slopes+ EV Charger
Cabin · 3 bd · 2 ba · sleeps 5 · 397 ft
Revenue $66,683ADR $248Occ ≈ 74%5★ (217)

Big B's Den
Vacation home · 3 bd · 2 ba · sleeps 5 · 404 ft
Revenue $15,221ADR $210Occ ≈ 20%4.8★ (5)

Big Bear Lake Family Cabin, located 5 mins from Snow Play
Cabin · 3 bd · 3 ba · sleeps 7 · 407 ft
Revenue $18,731ADR $260Occ ≈ 20%5★ (2)




Ursa Major Lodge Walk to Lake & Village Hot tub firepit
Vacation home · 3 bd · 3 ba · sleeps 6 · 433 ft
Revenue $13,509ADR $279Occ ≈ 13%5★ (1)







Kelley's Kabin-290 by Big Bear Vacations
Vacation home · 3 bd · 2 ba · sleeps 6 · 525 ft
Revenue $32,919ADR $492Occ ≈ 18%—



Attitude Adjustment
House · 3 bd · 2 ba · sleeps 8 · 0.1 mi
Revenue $43,395ADR $238Occ ≈ 50%4.8★ (81)


Lakeview Cabin , Game Room , Parking , Hot Tub
House · 3 bd · 2.5 ba · sleeps 10 · 0.1 mi
Revenue $16,290ADR $603Occ ≈ 7%—

Green Squirrel Chateau by Big Bear Vacations
Vacation home · 3 bd · 2 ba · sleeps 7 · 0.1 mi
Revenue $37,166ADR $711Occ ≈ 14%2.8★ (2)





Bear 'n Tree - Cozy cabin near the Village
Vacation home · 3 bd · 2 ba · sleeps 5 · 0.1 mi
Revenue $8,342ADR $276Occ ≈ 8%0.5★ (1)





Lazy Bear Cabin ~ Dog-friendly home with private hot tub, ping-pong, basketball & firepit
Vacation home · 3 bd · 2 ba · sleeps 4 · 0.1 mi
Revenue $43,627ADR $479Occ ≈ 25%—

Vintage A-Frame Cabin, Near Village, Lake, Trails
Cabin · 3 bd · 1.5 ba · sleeps 6 · 0.1 mi
Revenue $16,651ADR $275Occ ≈ 17%5★ (195)




Peaceful Pines #1, with Hot Tub, Dogs Welcome
House · 3 bd · 2.5 ba · sleeps 6 · 0.1 mi
Revenue $16,885ADR $231Occ ≈ 20%4.6★ (131)

Cabin 30 stand alone 3 bedrooms cabin
Cabin · 3 bd · 2 ba · sleeps 8 · 0.1 mi
Revenue $23,228ADR $356Occ ≈ 18%4★ (4)


Bear Bungalow, 3B/2Ba, SPA,AC, Views, Walk to Lake
Cabin · 3 bd · 1.5 ba · sleeps 5 · 0.2 mi
Revenue $85,252ADR $401Occ ≈ 58%4.8★ (261)
| Listing | Size | Revenue (12 mo) | ADR | Occ ≈ | Rating | Distance | Links |
|---|---|---|---|---|---|---|---|
![]() La Petite château, easy walk to lake and Village Cabin | 3 bd · 2 ba · sleeps 6 | $11,064 | $224 | 14% | 4.8★ (77) | 377 ft | Airbnb |
![]() The Dream Catcher| Modern Rustic w/ Hot Tub & EV Cabin | 3 bd · 3 ba · sleeps 8 | $31,165 | $444 | 19% | 4.8★ (15) | 384 ft | Airbnb |
![]() Upscale Cabin by Village, Lake, Slopes+ EV Charger Cabin | 3 bd · 2 ba · sleeps 5 | $66,683 | $248 | 74% | 5★ (217) | 397 ft | Airbnb |
![]() Big B's Den Vacation home | 3 bd · 2 ba · sleeps 5 | $15,221 | $210 | 20% | 4.8★ (5) | 404 ft | Booking |
![]() Big Bear Lake Family Cabin, located 5 mins from Snow Play Cabin | 3 bd · 3 ba · sleeps 7 | $18,731 | $260 | 20% | 5★ (2) | 407 ft | Vrbo |
![]() Sleep11 | Game Cabin + Hot Tub | Near Lake/Village House | 3 bd · 3 ba · sleeps 11 | $22,532 | $430 | 14% | 4.9★ (11) | 420 ft | AirbnbVrbo |
![]() Modern 3bdr, Spa, Playroom, Dog Friendly House | 3 bd · 2 ba · sleeps 7 | $37,780 | $272 | 38% | 4.9★ (332) | 423 ft | AirbnbVrbo |
![]() *Village Chic Chalet*Walk to Lake*Hot Tub*Modern* Cabin | 3 bd · 2.5 ba · sleeps 7 | $549 | $0 | — | 4.3★ (14) | 433 ft | AirbnbBooking |
![]() Ursa Major Lodge Walk to Lake & Village Hot tub firepit Vacation home | 3 bd · 3 ba · sleeps 6 | $13,509 | $279 | 13% | 5★ (1) | 433 ft | Booking |
![]() Dream Catcher - Massive Deck & Hot Tub Cabin | 3 bd · 2 ba · sleeps 8 | $42,621 | $405 | 29% | 4.7★ (3) | 433 ft | AirbnbVrboBooking |
![]() Accessible Cabin, Hot Tub, Dog Park & EV Charger Cabin | 3 bd · 3 ba · sleeps 8 | $79,283 | $468 | 46% | 5★ (348) | 433 ft | AirbnbVrbo |
![]() Village Chic Chalet- Walk to Lake- Hot Tub Cabin | 3 bd · 2.5 ba · sleeps 7 | $37,177 | $275 | 37% | 4★ (16) | 440 ft | AirbnbVrbo |
![]() Dream Street Retreat - lake, village, trails, more Cabin | 3 bd · 2 ba · sleeps 6 | $36,346 | $189 | 53% | 4.9★ (148) | 453 ft | AirbnbVrbo |
![]() Amazing Dream Cabin in Big Bear Lake Cabin | 3 bd · 2 ba · sleeps 7 | $46,676 | $274 | 47% | 5★ (200) | 463 ft | AirbnbVrbo |
![]() Central Heat AC • Walk2Lake • 4 min 2 Village • EV Cabin | 3 bd · 1 ba · sleeps 5 | $35,895 | $264 | 37% | 5★ (94) | 472 ft | AirbnbVrbo |
![]() Kelley's Kabin-290 by Big Bear Vacations Vacation home | 3 bd · 2 ba · sleeps 6 | $32,919 | $492 | 18% | — | 525 ft | Booking |
![]() Kelley's Kabin Downtown Retreat w/ Hot Tub Cabin | 3 bd · 1.5 ba · sleeps 6 | $19,503 | $457 | 12% | 3.3★ (10) | 525 ft | AirbnbVrboBooking |
![]() NEW HotTub • Near Big Bear Lake & Village • Family Cabin | 3 bd · 1 ba · sleeps 5 | $49,828 | $365 | 37% | 5★ (119) | 0.1 mi | AirbnbVrbo |
![]() Attitude Adjustment House | 3 bd · 2 ba · sleeps 8 | $43,395 | $238 | 50% | 4.8★ (81) | 0.1 mi | Airbnb |
![]() Sparkling Chalet: AC • Spa • EV • Games • Village Chalet | 3 bd · 2 ba · sleeps 8 | $43,326 | $285 | 42% | 4.8★ (414) | 0.1 mi | AirbnbVrbo |
![]() Lakeview Cabin , Game Room , Parking , Hot Tub House | 3 bd · 2.5 ba · sleeps 10 | $16,290 | $603 | 7% | — | 0.1 mi | Vrbo |
![]() Green Squirrel Chateau by Big Bear Vacations Vacation home | 3 bd · 2 ba · sleeps 7 | $37,166 | $711 | 14% | 2.8★ (2) | 0.1 mi | Booking |
![]() Green Squirrel Chateau w/ Pool Table + Games Cabin | 3 bd · 2 ba · sleeps 7 | $30,521 | $689 | 12% | 4.2★ (7) | 0.1 mi | AirbnbVrboBooking |
![]() Chateau Wonderland-0.9 mi-Village♦️walk to lake✨SPA Cabin | 3 bd · 2 ba · sleeps 8 | $34,290 | $415 | 23% | 5★ (198) | 0.1 mi | AirbnbVrbo |
![]() New! Cute w/Spa, Dogs OK-The Wilderness Haven House | 3 bd · 1 ba · sleeps 8 | $36,213 | $357 | 28% | 4.2★ (27) | 0.1 mi | AirbnbVrboBooking |
![]() Modern Cozy with AC, Hot Tub, Close to Downtown Cabin | 3 bd · 3 ba · sleeps 7 | $22,622 | $355 | 17% | 5★ (96) | 0.1 mi | AirbnbVrbo |
![]() Bear 'n Tree - Cozy cabin near the Village Vacation home | 3 bd · 2 ba · sleeps 5 | $8,342 | $276 | 8% | 0.5★ (1) | 0.1 mi | Booking |
![]() Lake View Retreat:Lake Views! Pool Table! Hot Tub! House | 3 bd · 2.5 ba · sleeps 10 | $13,373 | $242 | 15% | 4.3★ (41) | 0.1 mi | AirbnbVrbo |
![]() Lakeviews! Pet Friendly! Great Yard! Master Suite! House | 3 bd · 2.5 ba · sleeps 12 | $65,296 | $476 | 38% | 4.8★ (105) | 0.1 mi | AirbnbVrbo |
![]() Luxury Family Close to Lake & Village A/C Cabin | 3 bd · 2.5 ba · sleeps 8 | $16,286 | $319 | 14% | 4.7★ (19) | 0.1 mi | AirbnbVrboBooking |
![]() Vista Cottage • Hot Tub • Walk to Lake | Pups OK! House | 3 bd · 1 ba · sleeps 5 | $43,447 | $232 | 51% | 4.6★ (260) | 0.1 mi | AirbnbVrbo |
![]() Lazy Bear Cabin ~ Dog-friendly home with private hot tub, ping-pong, basketball & firepit Vacation home | 3 bd · 2 ba · sleeps 4 | $43,627 | $479 | 25% | — | 0.1 mi | Booking |
![]() Vintage A-Frame Cabin, Near Village, Lake, Trails Cabin | 3 bd · 1.5 ba · sleeps 6 | $16,651 | $275 | 17% | 5★ (195) | 0.1 mi | Airbnb |
![]() Walk to Lake & Village, Foosball, Firepit, Deck Cabin | 3 bd · 2.5 ba · sleeps 6 | $41,596 | $0 | — | 5★ (7) | 0.1 mi | AirbnbBooking |
![]() Cozy Mountain Luxury Cabin Cabin | 3 bd · 1 ba · sleeps 6 | $14,880 | $283 | 14% | 4.9★ (156) | 0.1 mi | AirbnbVrbo |
![]() The Great Getaway-Modern | Clean | Games | Office House | 3 bd · 2 ba · sleeps 6 | $711 | $237 | 1% | 4.9★ (18) | 0.1 mi | AirbnbVrboBooking |
![]() Peaceful Pines #1, with Hot Tub, Dogs Welcome House | 3 bd · 2.5 ba · sleeps 6 | $16,885 | $231 | 20% | 4.6★ (131) | 0.1 mi | Airbnb |
![]() Cabin 30 stand alone 3 bedrooms cabin Cabin | 3 bd · 2 ba · sleeps 8 | $23,228 | $356 | 18% | 4★ (4) | 0.1 mi | Airbnb |
![]() Hot Tub, Grill & Fire Pit: Cabin in Big Bear Lake Cabin | 3 bd · 1.5 ba · sleeps 6 | $44,061 | $298 | 41% | 4.7★ (22) | 0.2 mi | AirbnbVrboBooking |
![]() Bear Bungalow, 3B/2Ba, SPA,AC, Views, Walk to Lake Cabin | 3 bd · 1.5 ba · sleeps 5 | $85,252 | $401 | 58% | 4.8★ (261) | 0.2 mi | Airbnb |
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
Rate 7.78% = 7.03% Freddie Mac 30-yr avg (Sep 24) + 0.75% investor premium
Est. revenue
$31,384
NOI
$8,753
Cash flow /mo
-$2,498
Cash needed
$173,710
Cash-on-cash
-17.3%
ROE (yr 1)
-4.7%
Cap rate
1.5%
DSCR
0.23
Year-1 write-off
$116,448
Year-1 tax shield @ 32%
$37,263
Year-1 return on equity
- Cash flow (annual)-$29,981
- Principal paydown$3,920
- Appreciation at%$17,970
Opex, cash-needed & tax-savings breakdown
Annual operating expenses
- Management (20% of revenue)$6,277
- Platform fees (3% of revenue)$942
- Maintenance / capex (5% of revenue)$1,569
- Utilities & supplies$4,200
- HOA$0
- Property tax$7,488
- Insurance (STR-rated)$3,055
Cash needed to close
- Down payment (25%)$149,750
- Closing costs (4.0%)$23,960
- Furnishing (conveyed with the sale)$0
Tax savings if the STR loophole applies
- Tax shield @ 32%$37,263
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
$512,000
Short-life (5/15-yr)
$115,000 · 22%
Year-1 deduction
$116,000
Year-1 tax shield @ 32%
$37,000
Land 15% (county tax record, assessed value split) · building $397,000 over 39 years
Based on: ~1,900 sq ft (from beds), built 2017, 3 bd / 2 ba, furnished, listing features (deck, fireplace, stone counters, flooring types, appliance list).
IRS-guide safe-harbor floor: $67,000 in year 1 (13% short-life, $22,000 tax shield), the conservative amount following the IRS audit guide's residential classification table.
- $11,300
Kitchen cabinetsdefault
$10,000 new × 64% good × 1.78 allocation
- $11,600
Kitchen countertops (stone)listing
$10,200 new × 64% good × 1.78 allocation
- $3,800
Decorative trimdefault
$3,300 new × 64% good × 1.78 allocation
- $200
Mirrorsdefault
$300 new × 40% good × 1.78 allocation
- $1,400
Shelvingdefault
$1,200 new × 64% good × 1.78 allocation
- $3,400
Window coverings (19)default
$4,800 new × 40% good × 1.78 allocation
- $8,700
Carpet, vinyl & laminate (100% of floors)listing
$12,200 new × 40% good × 1.78 allocation
- $11,300
Kitchen & laundry equipment plumbingdefault
$7,800 new × 82% good × 1.78 allocation
- $6,800
Kitchen, laundry & data equipment electricaldefault
$4,700 new × 82% good × 1.78 allocation
- $5,800
Appliances (range, microwave, dishwasher, disposal, refrigerator, washer, dryer)listing
$8,100 new × 40% good × 1.78 allocation
- $7,800
Furniture conveyed with the sale (used)listing
$19,500 new × 40% good · out of the price
- $10,300
Paving: driveway & walks (paved)listing
$9,000 new × 64% good × 1.78 allocation
- $9,900
Landscaping (typical)default
$8,700 new × 64% good × 1.78 allocation
- $2,100
Patiosdefault
$1,900 new × 64% good × 1.78 allocation
- $20,900
Decks & porches (attached)listing
$21,400 new × 55% good × 1.78 allocation
- $311,200
Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault
$206,100 new × 85% good × 1.78 allocation
- $31,100
Building plumbing & fixturesdefault
$21,400 new × 82% good × 1.78 allocation
- $31,100
Building electrical & lightingdefault
$21,400 new × 82% good × 1.78 allocation
- $20,900
HVACdefault
$21,400 new × 55% good × 1.78 allocation
- $3,000
Fireplacelisting
$2,600 new × 64% good × 1.78 allocation
About the property
Depreciation schedule: typical cost seg study
| Year | 5-yr | 15-yr | Building | Total |
|---|---|---|---|---|
| 1 | $72,000 | $43,200 | $1,300 | $116,400 |
| 2 | $0 | $0 | $10,200 | $10,200 |
| 3 | $0 | $0 | $10,200 | $10,200 |
| 4 | $0 | $0 | $10,200 | $10,200 |
| 5 | $0 | $0 | $10,200 | $10,200 |
| 6+ | $0 | $0 | $355,300 | $355,300 |
| Total | $72,000 | $43,200 | $397,300 | $512,500 |
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.