STR Yield
← Back to deals
MortgageCash

Rate 7.93% = 7.18% Freddie Mac 30-yr avg (Nov 5) + 0.75% investor premium

17825 Stella Solaris Ln

17825 Stella Solaris Ln

Lakehead, CA 96051

$410,000

2 bd · 2 ba · 1,320 sqft · Listed 6d ago

View on Realtor.com →
Negative cash flow

Year built

1980

Sqft

1,320

Lot sqft

276,170

HOA / mo

$0

Furnished

No

List date

2026-11-06T19:47:58.000000Z

Revenue

Annual revenue

$23,443

ADR

$192

Occupancy

33%

Cleaning fees (12 mo)

$3,920

Confidence

Med (67.75), 8 comps

Comp revenue range (p25 / median / p75)

$17,865$20,168$27,920

Median revenue of shown comps: $20,168

  • Cozy cabin close to lake & I5/ 2 car garage

    House · 2 bd · 1 ba · sleeps 4 · 1.0 mi

    Revenue $16,764ADR $186Occ ≈ 25%4.7★ (27)

    Delisted

  • Mountain Oaks Chalet

    House · 2 bd · 1 ba · sleeps 4 · 1.0 mi

    • Free parking
    • Wifi
    • Kitchen
    • Washer

    Revenue $18,232ADR $182Occ ≈ 27%5★ (26)

    Airbnb

  • Lakehead Bungalow

    House · 2 bd · 1 ba · sleeps 6 · 1.1 mi

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

    Revenue $19,753ADR $152Occ ≈ 36%4.7★ (13)

    AirbnbVrboBooking

  • Private Lakeview Retreat, Kayaks, Easy Lake Access

    House · 2 bd · 2 ba · sleeps 8 · 1.3 mi

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

    Revenue $37,861ADR $488Occ ≈ 21%5★ (21)

    AirbnbVrbo

  • Cute Lake Home, 2 Bedroom, 1 Bath, 50 & 30 AMP EV

    House · 2 bd · 1 ba · sleeps 6 · 1.3 mi

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

    Revenue $27,616ADR $353Occ ≈ 21%5★ (18)

    AirbnbVrbo

  • Charming Lake Cottage • Relaxed, Cozy Stay

    Cottage · 2 bd · 2 ba · sleeps 4 · 1.9 mi

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

    Revenue $28,831ADR $206Occ ≈ 38%4.8★ (82)

    AirbnbVrboBooking

  • The perfect pit stop.

    Tiny house · 2 bd · 2 ba · sleeps 4 · 1.9 mi

    Revenue $16,599ADR $127Occ ≈ 36%—

    Delisted

  • 5min to Sugarloaf boat ramp/25 min to Mt Shasta

    House · 2 bd · 1 ba · sleeps 6 · 2.1 mi

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

    Revenue $20,582ADR $205Occ ≈ 28%4.8★ (45)

    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.93% = 7.18% Freddie Mac 30-yr avg (Nov 5) + 0.75% investor premium

Est. revenue

$23,443

NOI

$5,770

Cash flow /mo

-$1,760

Cash needed

$134,900

Cash-on-cash

-15.7%

ROE (yr 1)

-4.6%

Cap rate

1.4%

DSCR

0.21

Year-1 write-off

$109,259

Year-1 tax shield @ 32%

$34,963

Year-1 return on equity

  • Cash flow (annual)-$21,126
  • Principal paydown$2,605
  • Appreciation at%$12,300
ROE-4.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)$4,689
  • Platform fees (3% of revenue)$703
  • Maintenance / capex (5% of revenue)$1,172
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$5,125
  • Insurance (STR-rated)$2,399

Cash needed to close

  • Down payment (25%)$102,500
  • Closing costs (4.0%)$16,400
  • Furnishing (bought new)$16,000

Tax savings if the STR loophole applies

  • Tax shield @ 32%$34,963

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

$329,000

Short-life (5/15-yr)

$93,000 · 28%

Year-1 deduction

$109,000

Year-1 tax shield @ 32%

$35,000

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

Based on: 1,320 sq ft, built 1980, 2 bd / 2 ba, unfurnished, listing features (deck, fireplace, flooring types, septic, wooded lot).

Try the cost segregation calculator on any property →

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

5-year property$67,700

  • Kitchen cabinetsdefault

    $8,700 new × 40% good × 2.83 allocation

    $9,800

  • Kitchen countertopsdefault

    $7,100 new × 40% good × 2.83 allocation

    $8,000

  • Decorative trimdefault

    $2,300 new × 40% good × 2.83 allocation

    $2,600

  • Mirrorsdefault

    $300 new × 40% good × 2.83 allocation

    $300

  • Shelvingdefault

    $900 new × 40% good × 2.83 allocation

    $1,000

  • Window coverings (13)default

    $3,300 new × 40% good × 2.83 allocation

    $3,700

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

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

    $4,800

  • Kitchen & laundry equipment plumbingdefault

    $6,800 new × 40% good × 2.83 allocation

    $7,600

  • Kitchen, laundry & data equipment electricaldefault

    $4,100 new × 40% good × 2.83 allocation

    $4,600

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

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

    $9,200

  • Furniture bought newlisting

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

    $16,000
15-year land improvements$41,300

  • Paving: driveway & walks (paved)default

    $9,400 new × 50% good × 2.83 allocation

    $13,300

  • Landscaping (minimal)listing

    $3,600 new × 50% good × 2.83 allocation

    $5,100

  • Patiosdefault

    $1,300 new × 50% good × 2.83 allocation

    $1,800

  • Decks & porches (attached)listing

    $14,900 new × 50% good × 2.83 allocation

    $21,000
Building, 39-year$235,900

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

    $143,000 new × 40% good × 2.83 allocation

    $161,700

  • Building plumbing & fixturesdefault

    $14,800 new × 40% good × 2.83 allocation

    $16,700

  • Building electrical & lightingdefault

    $14,000 new × 40% good × 2.83 allocation

    $15,800

  • HVACdefault

    $14,900 new × 40% good × 2.83 allocation

    $16,800

  • Hardwood & tile floorsdefault

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

    $4,800

  • Fireplacelisting

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

    $3,000

  • Septic systemlisting

    $12,000 new × 50% good × 2.83 allocation

    $17,000

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$67,700$41,300$300$109,300
2$0$0$6,000$6,000
3$0$0$6,000$6,000
4$0$0$6,000$6,000
5$0$0$6,000$6,000
6+$0$0$211,400$211,400
Total$67,700$41,300$235,900$344,900

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

Rules differ by jurisdiction. City of Redding caps whole-home vacation rentals at 400 with a 600 ft spacing rule (300 ft with a physical buffer), and its permit is NOT transferable to a new owner. Shasta Lake city and unincorporated Shasta County allow permitted rentals with no cap found, but permits also do not transfer on sale. Lodging tax ~10% plus a 2% tourism assessment in Redding. Verify parcel eligibility with the city or county before you buy.