STR Yield
← Back to deals

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

351 Hansels Lea

351 Hansels Lea

Sevierville, TN 37876

$385,000

3 bd · 2 ba · 1,426 sqft · Listed 3d ago

View on Realtor.com →
Negative cash flow

Year built

2002

Sqft

1,426

Lot sqft

37,026

HOA / mo

None

Furnished

No

List date

2026-11-16T16:09:09.000000Z

Revenue

Annual revenue

$39,302

ADR

$173

Occupancy

62%

Cleaning fees (12 mo)

$8,262

Confidence

Med (53.78), 15 comps

Comp revenue range (p25 / median / p75)

$26,921$42,550$47,447

Median revenue of shown comps: $33,922

  • Historic Farmhouse near Dollywood |Pet-Friendly

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

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

    Revenue $27,458ADR $219Occ ≈ 34%4.7★ (53)

    Airbnb

  • Pet-friendly Log Cabin with Hot Tub + Fire Pit

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

    Revenue $42,550ADR $200Occ ≈ 58%4.7★ (52)

    Airbnb

  • Little Mountain Cabin w/ Hot Tub, Fire Pit, Games

    Cabin · 3 bd · 2 ba · sleeps 6 · 1.1 mi

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

    Revenue $48,793ADR $202Occ ≈ 66%4.5★ (32)

    AirbnbVrboBooking

  • Log Cabin Hot Tub & Fire Pit Near Pigeon Forge TN

    Cabin · 3 bd · 2 ba · sleeps 6 · 1.2 mi

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

    Revenue $9,758ADR $250Occ ≈ 11%5★ (2)

    AirbnbVrboBooking

  • Lazy Bear Meadow | Dog-Friendly Cabin, Fenced Yard

    House · 3 bd · 2 ba · sleeps 7 · 1.2 mi

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

    Revenue $33,651ADR $206Occ ≈ 45%4.8★ (20)

    AirbnbVrboBooking

  • La Maison Rouge - Your 3 BR Getaway in the Smokies

    House · 3 bd · 2 ba · sleeps 10 · 1.3 mi

    Revenue $13,579ADR $186Occ ≈ 20%4.8★ (64)

    Airbnb

  • Southern Charm, beautiful cabin close to Pigeon Forge and Gatlinburg

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

    • Hot tub
    • A/C
    • Free parking
    • Kitchen
    • +2

    Revenue $26,384ADR $156Occ ≈ 46%4.9★ (114)

    Vrbo

  • 3 BR cabin with hot tub & fully equipped kitchen

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

    Revenue $44,572ADR $0Occ ≈ —4.7★ (6)

    AirbnbBooking

  • This is Perfect - Free Breakfast

    House · 3 bd · 2 ba · sleeps 6 · 1.8 mi

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

    Revenue $34,192ADR $237Occ ≈ 40%4.9★ (68)

    AirbnbVrboBooking

  • Modern Ranch | Hot Tub, Views & Game Room

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

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

    Revenue $45,668ADR $238Occ ≈ 53%5★ (15)

    AirbnbVrboBooking

Show 2 more
  • Mountain Oasis: Luxe Views, Hot Tub, Fire Pit

    House · 3 bd · 2.5 ba · sleeps 8 · 2.0 mi

    Revenue $15,605ADR $272Occ ≈ 16%4.9★ (128)

    AirbnbBooking

  • Hopp On Inn Secluded 3BR Home

    Vacation home · 3 bd · 2 ba · sleeps 7 · 2.1 mi

    Revenue $62,417ADR $419Occ ≈ 41%3.1★ (3)

    Booking

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

$39,302

NOI

$21,124

Cash flow /mo

-$330

Cash needed

$131,150

Cash-on-cash

-3.0%

ROE (yr 1)

7.7%

Cap rate

5.5%

DSCR

0.84

Year-1 write-off

$82,050

Year-1 tax shield @ 32%

$26,256

Year-1 return on equity

  • Cash flow (annual)-$3,963
  • Principal paydown$2,480
  • Appreciation at%$11,550
ROE7.7%

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)$7,860
  • Platform fees (3% of revenue)$1,179
  • Maintenance / capex (5% of revenue)$1,965
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$663
  • Insurance (STR-rated)$2,310

Cash needed to close

  • Down payment (25%)$96,250
  • Closing costs (4.0%)$15,400
  • Furnishing (bought new)$19,500

Tax savings if the STR loophole applies

  • Tax shield @ 32%$26,256

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

$321,000

Short-life (5/15-yr)

$62,000 · 19%

Year-1 deduction

$82,000

Year-1 tax shield @ 32%

$26,000

Land 17% (county tax record, market value split) · building $258,000 over 39 years · new furniture $20,000

Based on: 1,426 sq ft, built 2002, 3 bd / 2 ba, unfurnished, listing features (patio, fireplace, flooring types, appliance list, septic).

Try the cost segregation calculator on any property →

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

5-year property$57,800
  • Kitchen cabinetsdefault

    $8,900 new × 40% good × 2.07 allocation

    $7,400
  • Kitchen countertopsdefault

    $7,300 new × 40% good × 2.07 allocation

    $6,000
  • Decorative trimdefault

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

    $2,100
  • Mirrorsdefault

    $300 new × 40% good × 2.07 allocation

    $200
  • Shelvingdefault

    $1,200 new × 40% good × 2.07 allocation

    $1,000
  • Window coverings (14)default

    $3,500 new × 40% good × 2.07 allocation

    $2,900
  • Carpet, vinyl & laminate (33% of floors)listing

    $3,100 new × 40% good × 2.07 allocation

    $2,500
  • Kitchen & laundry equipment plumbingdefault

    $6,900 new × 52% good × 2.07 allocation

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

    $4,200 new × 52% good × 2.07 allocation

    $4,500
  • Appliances (range, dishwasher, refrigerator)listing

    $5,000 new × 40% good × 2.07 allocation

    $4,100
  • Furniture bought newlisting

    $19,500 new × 100% good · bought separately

    $19,500
15-year land improvements$24,000
  • Paving: driveway & walks (paved)default

    $7,800 new × 50% good × 2.07 allocation

    $8,100
  • Landscaping (typical)default

    $7,500 new × 50% good × 2.07 allocation

    $7,800
  • Patioslisting

    $6,400 new × 50% good × 2.07 allocation

    $6,600
  • Decks & porches (attached)default

    $1,400 new × 50% good × 2.07 allocation

    $1,500
Building, 39-year$258,200
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $154,300 new × 60% good × 2.07 allocation

    $191,600
  • Building plumbing & fixturesdefault

    $16,000 new × 52% good × 2.07 allocation

    $17,200
  • Building electrical & lightingdefault

    $15,300 new × 52% good × 2.07 allocation

    $16,500
  • HVACdefault

    $16,100 new × 40% good × 2.07 allocation

    $13,300
  • Hardwood & tile floorsdefault

    $6,100 new × 40% good × 2.07 allocation

    $5,100
  • Fireplacelisting

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

    $2,200
  • Septic systemlisting

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

    $12,400

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$57,800$24,000$300$82,000
2$0$0$6,600$6,600
3$0$0$6,600$6,600
4$0$0$6,600$6,600
5$0$0$6,600$6,600
6+$0$0$231,500$231,500
Total$57,800$24,000$258,200$340,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

STR allowed in most of Sevier County; inside Gatlinburg city limits only in overnight-rental zones.