STR Yield
← Back to deals

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

225 Collier Dr Unit 1113

225 Collier Dr Unit 1113

Sevierville, TN 37862

$150,000

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

View on Realtor.com →
High HOANegative cash flow

Year built

2004

Sqft

1,064

Lot sqft

4,356

HOA / mo

$957

Furnished

No

List date

2026-11-13T23:21:53.000000Z

Revenue

Annual revenue

$13,147

ADR

$213

Occupancy

17%

Cleaning fees (12 mo)

$3,483

Confidence

Med (54.63), 41 comps

Comp revenue range (p25 / median / p75)

$9,253$10,718$11,370

Median revenue of shown comps: $10,718

  • 2 Waterparks Included - 2 Bedroom Condo!

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 226 ft

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

    Revenue $11,075ADR $314Occ ≈ 10%4.5★ (51)

    AirbnbVrbo

  • Spacious 2BR Smoky Mountain Resort | Sleeps 8

    Apartment · 2 bd · 2 ba · sleeps 8 · 413 ft

    Revenue $6,196ADR $90Occ ≈ 19%—

    Delisted

  • 2BR Apartment at Smoky Mountains Resort

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 413 ft

    • Hot tub
    • Pool
    • A/C
    • Free parking
    • +3

    Revenue $2,344ADR $131Occ ≈ 5%—

    Airbnb

  • Smoky Mountains 2BR · Pool · Sevierville

    Serviced apartment · 2 bd · 2 ba · sleeps 8 · 413 ft

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

    Revenue $4,330ADR $156Occ ≈ 8%—

    Airbnb

  • Wyndham Smoky Mountains 2 BR Condo

    Apartment · 2 bd · 1 ba · sleeps 8 · 413 ft

    • Hot tub
    • Pool
    • A/C
    • Free parking
    • +3

    Revenue $605ADR $121Occ ≈ 1%—

    AirbnbVrbo

  • Wyndham Smoky Mountains Resort 2 Bedroom, 2 Bathroom Condo with Full Kitchen

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

    Revenue $25,389ADR $436Occ ≈ 16%—

    Delisted

  • Club Wyndham Smoky Mountains

    Apartment · 2 bd · 2 ba · sleeps 7 · 0.2 mi

    • Hot tub
    • Pool
    • A/C
    • Free parking
    • +3

    Revenue $16,831ADR $210Occ ≈ 22%—

    Airbnb

  • Beautiful Club Wyndham Smoky Mountains, 2 Bedroom

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,646ADR $224Occ ≈ 14%4.6★ (15)

    Airbnb

  • Smoky Mountains Resort 2 Bedroom

    Apartment · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    • Hot tub
    • Pool
    • A/C
    • Free parking
    • +4

    Revenue $23,254ADR $197Occ ≈ 32%5★ (2)

    Airbnb

  • Wyndham Smoky Mountains 2bedroom 2bath multiple weeks available!

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    • A/C
    • Wifi
    • Washer

    Revenue $1,068ADR $164Occ ≈ 2%5★ (1)

    Vrbo

Show 29 more
  • CW Smoky Mountains Resort | King Bed Balcony Suite

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $8,824ADR $231Occ ≈ 10%—

    Airbnb

  • 2 bedroom- Smoky Mountain Resort in TN.

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $7,695ADR $205Occ ≈ 10%5★ (1)

    Airbnb

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,370ADR $260Occ ≈ 12%4.7★ (8)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,015ADR $230Occ ≈ 13%5★ (1)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,085ADR $232Occ ≈ 11%4.4★ (18)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,510ADR $205Occ ≈ 13%4.5★

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,899ADR $215Occ ≈ 13%4.9★ (0)

    Delisted

  • Wyndham Smoky Mountains - 2 bedroom Hearing

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $8,541ADR $212Occ ≈ 11%5★

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $12,536ADR $249Occ ≈ 14%5★ (3)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,982ADR $237Occ ≈ 13%4.3★ (3)

    Delisted

  • Wyndham Smoky Mountains - 2 bedroom Hearing

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,543ADR $220Occ ≈ 13%5★

    Delisted

  • Wyndham Smoky Mountains - 2 bedroom Mobility

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,379ADR $206Occ ≈ 12%4.8★

    Delisted

  • Wyndham Smoky Mountains - 2 bedroom Hearing

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,909ADR $211Occ ≈ 13%5★

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,224ADR $239Occ ≈ 12%4★ (1)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,253ADR $203Occ ≈ 12%—

    Delisted

  • Club Wyndham Smoky Mountains, Tennessee, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,721ADR $247Occ ≈ 13%4.7★ (3)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,015ADR $231Occ ≈ 13%5★ (2)

    Delisted

  • Wyndham Smoky Mountains - 2 Bedroom

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,774ADR $246Occ ≈ 11%—

    Delisted

  • Comfortable Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,537ADR $219Occ ≈ 13%4.7★ (19)

    Delisted

  • Serene Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,998ADR $230Occ ≈ 13%4.7★ (3)

    Delisted

  • Lush Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,817ADR $232Occ ≈ 13%5★ (1)

    Delisted

  • Club Wyndham Smoky Mountains, Tennessee, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,817ADR $232Occ ≈ 13%3★ (1)

    Delisted

  • Lush Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,620ADR $238Occ ≈ 13%3.5★ (2)

    Delisted

  • Club Wyndham Smoky Mountains, Tennessee, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,718ADR $227Occ ≈ 13%5★ (8)

    Delisted

  • Comfortable Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $12,506ADR $251Occ ≈ 14%3.7★ (3)

    Delisted

  • Lush Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $9,877ADR $213Occ ≈ 13%5★ (2)

    Delisted

  • Lush Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $11,075ADR $231Occ ≈ 13%4★ (1)

    Delisted

  • Beautiful Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $12,072ADR $242Occ ≈ 14%4.2★ (10)

    Delisted

  • Comfortable Club Wyndham Smoky Mountains, 2 Bedroom Condo

    Condominium (condo) · 2 bd · 2 ba · sleeps 8 · 0.2 mi

    Revenue $10,810ADR $232Occ ≈ 13%4.4★ (16)

    Delisted

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

$13,147

NOI

-$8,783

Cash flow /mo

-$1,546

Cash needed

$65,500

Cash-on-cash

-28.3%

ROE (yr 1)

-20.0%

Cap rate

-5.9%

DSCR

-0.90

Year-1 write-off

$42,363

Year-1 tax shield @ 32%

$13,556

Year-1 return on equity

  • Cash flow (annual)-$18,558
  • Principal paydown$966
  • Appreciation at%$4,500
ROE-20.0%

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)$2,629
  • Platform fees (3% of revenue)$394
  • Maintenance / capex (5% of revenue)$657
  • Utilities & supplies$4,200
  • HOA$11,484
  • Property tax$1,665
  • Insurance (STR-rated)$900

Cash needed to close

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

Tax savings if the STR loophole applies

  • Tax shield @ 32%$13,556

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

$123,000

Short-life (5/15-yr)

$20,000 · 17%

Year-1 deduction

$42,000

Year-1 tax shield @ 32%

$14,000

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

Based on: 1,064 sq ft, built 2004, 2 bd / 2 ba, unfurnished, listing features (game room, fireplace, flooring types, appliance list, wooded lot).

Try the cost segregation calculator on any property →

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

5-year property$42,300
  • Kitchen cabinetsdefault

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

    $3,600
  • Kitchen countertopsdefault

    $6,700 new × 40% good × 1.10 allocation

    $2,900
  • Decorative trimdefault

    $1,900 new × 40% good × 1.10 allocation

    $800
  • Mirrorsdefault

    $300 new × 40% good × 1.10 allocation

    $100
  • Shelvingdefault

    $900 new × 40% good × 1.10 allocation

    $400
  • Window coverings (11)default

    $2,800 new × 40% good × 1.10 allocation

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

    $3,400 new × 40% good × 1.10 allocation

    $1,500
  • Kitchen & laundry equipment plumbingdefault

    $6,300 new × 56% good × 1.10 allocation

    $3,900
  • Kitchen, laundry & data equipment electricaldefault

    $3,800 new × 56% good × 1.10 allocation

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

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

    $3,400
  • 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
Building, 39-year$102,300
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $115,100 new × 63% good × 1.10 allocation

    $80,300
  • Building plumbing & fixturesdefault

    $11,900 new × 56% good × 1.10 allocation

    $7,400
  • Building electrical & lightingdefault

    $10,800 new × 56% good × 1.10 allocation

    $6,600
  • HVACdefault

    $12,000 new × 40% good × 1.10 allocation

    $5,300
  • Hardwood & tile floorsdefault

    $3,400 new × 40% good × 1.10 allocation

    $1,500
  • Fireplacelisting

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

    $1,200

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$42,300$0$100$42,400
2$0$0$2,600$2,600
3$0$0$2,600$2,600
4$0$0$2,600$2,600
5$0$0$2,600$2,600
6+$0$0$91,700$91,700
Total$42,300$0$102,300$144,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.