STR Yield
← Back to deals

Rate 8.15% = 7.40% Freddie Mac 30-yr avg (Oct 15) + 0.75% investor premium

331 Caney Creek Rd

331 Caney Creek Rd

Pigeon Forge, TN 37863

$549,999

2 bd · 2 ba · 1,664 sqft · Listed 1d ago

View on Realtor.com →
Negative cash flow

Year built

2003

Sqft

1,664

Lot sqft

21,344

HOA / mo

None

Furnished

No

List date

2026-10-19T17:07:49.000000Z

Revenue

Annual revenue

$56,711

ADR

$236

Occupancy

66%

Cleaning fees (12 mo)

$11,408

Confidence

Med (61), 47 comps

Comp revenue range (p25 / median / p75)

$35,776$50,563$61,482

Median revenue of shown comps: $48,579

  • Creekside Cabin

    Cabin · 2 bd · 2 ba · sleeps 7 · 213 ft

    Revenue $47,422ADR $250Occ ≈ 52%4.8★ (326)

    AirbnbVrbo

  • Across the Creek by Beyond Expectations w/ Hot Tub

    Cabin · 2 bd · 2 ba · sleeps 8 · 217 ft

    Revenue $56,974ADR $289Occ ≈ 54%4.3★ (14)

    AirbnbVrboBooking

  • Creekside Getaway, Hot Tub + Fire Pit + Pool Table

    Cabin · 2 bd · 2 ba · sleeps 8 · 256 ft

    Revenue $81,614ADR $273Occ ≈ 82%5★ (71)

    AirbnbVrbo

  • Pigeon Forge Cabin /Game Room/Dog Friendly/Hot Tub

    Cabin · 2 bd · 2 ba · sleeps 8 · 259 ft

    Revenue $48,579ADR $222Occ ≈ 60%4.5★ (246)

    AirbnbVrboBooking

  • "Smokey Max Cabin", 2 bed 2 bath 8 people sleeping

    Cabin · 2 bd · 2 ba · sleeps 8 · 446 ft

    Revenue $54,785ADR $302Occ ≈ 50%4.5★ (211)

    AirbnbVrboBooking

  • Creekside Cabin! Hot Tub, Fire Pit, Pet Friendly

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

    Revenue $41,086ADR $270Occ ≈ 42%5★ (34)

    AirbnbVrboBooking

  • Peaceful Creekside Escape/5min>GBurg-PForge/HotTub

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

    Revenue $64,499ADR $242Occ ≈ 73%4.9★ (585)

    AirbnbVrbo

  • 2/2 with Hot Tub! Near Gatlinburg and Dollywood!

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

    Revenue $50,563ADR $179Occ ≈ 77%4.8★ (474)

    AirbnbVrbo

  • Downtown Creekside Cabin~FirePit~Hot Tub~Game Room

    Cabin · 2 bd · 2 ba · sleeps 8 · 0.3 mi

    Revenue $81,991ADR $303Occ ≈ 74%4.9★ (237)

    AirbnbVrboBooking

  • Woodland Hot Tub Retreat•King Bed• Foosball+Arcade

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

    Revenue $46,206ADR $202Occ ≈ 63%5★ (60)

    AirbnbVrbo

Show 31 more
  • Welcome to “Bear Necessities ”

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

    Revenue $28,074ADR $303Occ ≈ 25%4.9★ (34)

    AirbnbVrbo

  • Beary Comfy, Sleeps 6・Hot Tub・Pool Table・Deck

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

    Revenue $8,092ADR $299Occ ≈ 7%4★ (3)

    AirbnbVrbo

  • Cozy 2BR Cabin Between Gatlinburg & Pigeon Forge

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

    Revenue $35,830ADR $190Occ ≈ 52%4.9★ (243)

    AirbnbVrbo

  • Hot Tub, Pool Table | 5 Mi to Island & Gatlinburg

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

    Revenue $30,055ADR $223Occ ≈ 37%4.2★ (16)

    AirbnbVrbo

  • Our Happy Place

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

    Revenue $34,010ADR $230Occ ≈ 41%4.9★ (221)

    AirbnbVrbo

  • Black Bear Quarters | Near Smokies & Gatlinburg

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

    Revenue $50,150ADR $223Occ ≈ 62%5★ (79)

    AirbnbBooking

  • Perfect location Between Pigeon Forge and G'burg

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

    Revenue $55,494ADR $239Occ ≈ 64%5★ (329)

    AirbnbVrbo

  • Family Cabin w/Hot Tub & Arcade Near Dollywood

    Cabin · 2 bd · 2 ba · sleeps 7 · 0.5 mi

    Revenue $61,020ADR $231Occ ≈ 72%4.8★ (200)

    AirbnbVrboBooking

  • Afternoon Delight: Semi-Secluded Cabin, Hot Tub

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

    Revenue $45,263ADR $267Occ ≈ 46%4.6★ (24)

    AirbnbVrbo

  • Mountain View Cabin w/ Free Attraction Tickets

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

    Revenue $27,635ADR $400Occ ≈ 19%4.5★ (175)

    AirbnbVrboBooking

  • Rustic Retreat — Easy Access, Close to Everything!

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

    Revenue $34,287ADR $177Occ ≈ 53%4.8★ (18)

    AirbnbVrboBooking

  • Dave & Barb's Place - Private ~ Quiet ~ Serene

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

    Revenue $8,284ADR $165Occ ≈ 14%4.8★ (193)

    Airbnb

  • Hot Tub + Game Loft | Free Dollywood Tickets

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

    Revenue $55,501ADR $219Occ ≈ 69%4.8★ (230)

    AirbnbVrbo

  • Charming Mountain Cabin with Hot Tub & Game Loft near Pigeon Forge, Tennessee

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

    Revenue $24,455ADR $373Occ ≈ 18%5★

    Vrbo

  • Luxe Cabin Retreat,Elevated Views,Mountain Charm

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

    Revenue $67,739ADR $321Occ ≈ 58%5★ (35)

    AirbnbVrboBooking

  • Pet friendly 2 BR in convenient location!

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

    Revenue $59,893ADR $282Occ ≈ 58%4.8★ (20)

    AirbnbVrbo

  • Eagle’s Nest | Epic Smoky Mtn Views • Hot Tub

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

    Revenue $30,384ADR $218Occ ≈ 38%3.2★ (5)

    AirbnbVrbo

  • The ONE ! Cozy Private Cabin W/ Prime Location !

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

    Revenue $75,673ADR $247Occ ≈ 84%5★ (308)

    Airbnb

  • Bear Point by Bear Camp

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

    Revenue $60,113ADR $238Occ ≈ 69%4.8★ (53)

    AirbnbVrboBooking

  • Dual Suite Cabin with Hot Tub and Fishing Pond

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

    Revenue $50,983ADR $219Occ ≈ 64%4.8★ (139)

    AirbnbVrbo

  • Secluded Cabin w/ Hot Tub & Views

    Cabin · 2 bd · 2.5 ba · sleeps 6 · 0.6 mi

    Revenue $44,481ADR $293Occ ≈ 42%4.5★ (16)

    AirbnbVrbo

  • Romantic - Hot tub - Cozy - Pet Friendly

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

    Revenue $45,921ADR $222Occ ≈ 57%5★ (28)

    AirbnbVrboBooking

  • Bird's Eye View*Great Location just off the Spur

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

    Revenue $47,282ADR $214Occ ≈ 61%4.7★ (10)

    AirbnbVrbo

  • Family Cabin w/ Theater, PS3, Hot Tub, & Game Room

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

    Revenue $47,893ADR $260Occ ≈ 50%4.8★ (221)

    AirbnbVrbo

  • Charming Bear Pause is close to everything and offers unlimited parking

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

    Revenue $35,721ADR $180Occ ≈ 54%4.7★ (114)

    Vrbo

  • Mountain Views & Hot Tub | 6 Mi to Dollywood

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

    Revenue $33,047ADR $264Occ ≈ 34%5★ (15)

    AirbnbVrbo

  • Mountain Views Between Gatlinburg and Pigeon Forge – Dollywood Retreat

    Cabin · 2 bd · 2 ba · sleeps 8 · 0.7 mi

    Revenue $61,943ADR $360Occ ≈ 47%5★ (2)

    Vrbo

  • Smoky Mountain Log Cabin POOL VIEWS WIFI LOCATION

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

    Revenue $68,062ADR $277Occ ≈ 67%4.9★ (290)

    AirbnbVrbo

  • Family Cabin, Hot Tub + Game Room Near Gatlinburg

    Cabin · 2 bd · 2.5 ba · sleeps 6 · 0.7 mi

    Revenue $63,108ADR $259Occ ≈ 67%4.8★ (66)

    AirbnbVrbo

  • Brink of Paradise - Secluded, Hot Tub & Pool Table

    Cabin · 2 bd · 2 ba · sleeps 8 · 0.7 mi

    Revenue $53,062ADR $255Occ ≈ 57%3.6★ (62)

    AirbnbVrboBooking

  • 2BD/2Bath Cabin - Pool Table, Hot Tub, Fireplace

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

    Revenue $64,925ADR $242Occ ≈ 74%4.9★ (304)

    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 8.15% = 7.40% Freddie Mac 30-yr avg (Oct 15) + 0.75% investor premium

Est. revenue

$56,711

NOI

$31,916

Cash flow /mo

-$410

Cash needed

$181,500

Cash-on-cash

-2.7%

ROE (yr 1)

8.2%

Cap rate

5.8%

DSCR

0.87

Year-1 write-off

$111,342

Year-1 tax shield @ 32%

$35,630

Year-1 return on equity

  • Cash flow (annual)-$4,924
  • Principal paydown$3,345
  • Appreciation at%$16,500
ROE8.2%

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)$11,342
  • Platform fees (3% of revenue)$1,701
  • Maintenance / capex (5% of revenue)$2,836
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$1,416
  • Insurance (STR-rated)$3,300

Cash needed to close

  • Down payment (25%)$137,500
  • Closing costs (4.0%)$22,000
  • Furnishing (bought new)$22,000

Tax savings if the STR loophole applies

  • Tax shield @ 32%$35,630

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

$470,000

Short-life (5/15-yr)

$89,000 · 19%

Year-1 deduction

$111,000

Year-1 tax shield @ 32%

$36,000

Land 15% (county tax record, market value split) · building $381,000 over 39 years · new furniture $22,000

Based on: 1,664 sq ft, built 2003, 2 bd / 2 ba, unfurnished, listing features (hot tub, game room, fireplace, stone counters, flooring types, appliance list, wooded lot).

Try the cost segregation calculator on any property →

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

5-year property$89,900
  • Kitchen cabinetsdefault

    $9,400 new × 40% good × 2.67 allocation

    $10,100
  • Kitchen countertops (stone)listing

    $9,700 new × 40% good × 2.67 allocation

    $10,300
  • Decorative trimdefault

    $2,900 new × 40% good × 2.67 allocation

    $3,100
  • Mirrorsdefault

    $300 new × 40% good × 2.67 allocation

    $300
  • Shelvingdefault

    $900 new × 40% good × 2.67 allocation

    $1,000
  • Window coverings (17)default

    $4,300 new × 40% good × 2.67 allocation

    $4,500
  • Carpet, vinyl & laminate (33% of floors)listing

    $3,600 new × 40% good × 2.67 allocation

    $3,800
  • Kitchen & laundry equipment plumbingdefault

    $7,400 new × 54% good × 2.67 allocation

    $10,600
  • Kitchen, laundry & data equipment electricaldefault

    $4,400 new × 54% good × 2.67 allocation

    $6,400
  • Appliances (range, microwave, dishwasher, refrigerator, washer, dryer)listing

    $7,700 new × 40% good × 2.67 allocation

    $8,200
  • Hot tub (freestanding)listing

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

    $9,600
  • Furniture bought newlisting

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

    $16,000
  • Game-room equipment bought newlisting

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

    $6,000
15-year land improvements$21,100
  • Paving: driveway & walks (paved)default

    $8,500 new × 50% good × 2.67 allocation

    $11,300
  • Landscaping (minimal)listing

    $4,100 new × 50% good × 2.67 allocation

    $5,400
  • Patiosdefault

    $1,600 new × 50% good × 2.67 allocation

    $2,200
  • Decks & porches (attached)default

    $1,600 new × 50% good × 2.67 allocation

    $2,200
Building, 39-year$380,600
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $180,600 new × 62% good × 2.67 allocation

    $296,800
  • Building plumbing & fixturesdefault

    $18,700 new × 54% good × 2.67 allocation

    $26,900
  • Building electrical & lightingdefault

    $18,400 new × 54% good × 2.67 allocation

    $26,400
  • HVACdefault

    $18,700 new × 40% good × 2.67 allocation

    $20,000
  • Hardwood & tile floorsdefault

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

    $7,600
  • Fireplacelisting

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

    $2,800

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$89,900$21,100$400$111,300
2$0$0$9,800$9,800
3$0$0$9,800$9,800
4$0$0$9,800$9,800
5$0$0$9,800$9,800
6+$0$0$341,100$341,100
Total$89,900$21,100$380,600$491,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, 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.