STR Yield
← Back to deals

Rate 7.78% = 7.03% Freddie Mac 30-yr avg (Sep 24) + 0.75% investor premium

546 Stillhouse Creek Dr

546 Stillhouse Creek Dr

Ellijay, GA 30540

$625,000

3 bd · 3 ba · 2,514 sqft · Listed 16d ago

View on Realtor.com →
Negative cash flow

Year built

2006

Sqft

2,514

Lot sqft

107,593

HOA / mo

None

Furnished

Yes

List date

2026-09-11T12:53:57.000000Z

Revenue

Annual revenue

$32,830

ADR

$172

Occupancy

52%

Cleaning fees (12 mo)

$7,806

Confidence

Low (45.88), 12 comps

Comp revenue range (p25 / median / p75)

$21,121$34,372$47,719
  • Private Oasis, Family & Pet Friendly, Bordering National Forest and Trails.

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

    Revenue $1,265ADR $180Occ ≈ 2%—

    Vrbo

  • Bungalow+RV/10 acres/Stream

    House · 2 bd · 2 ba · sleeps 6 · 0.9 mi

    Revenue $21,259ADR $138Occ ≈ 42%5★ (42)

    AirbnbVrbo

  • Custom-Built Luxury Cabin w/ Tesla Charger!

    Cabin · 4 bd · 3 ba · sleeps 10 · 1.0 mi

    Revenue $48,680ADR $293Occ ≈ 46%4.7★ (73)

    AirbnbVrboBooking

  • Pinhoti Lodge Cabin with hot tub in the mountains

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

    Revenue $47,398ADR $167Occ ≈ 78%4.9★ (78)

    AirbnbVrbo

  • Magical Forest Lodge-HotTub-Pool Table-Creek

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

    Revenue $65,575ADR $235Occ ≈ 76%4.8★ (194)

    AirbnbVrbo

  • A Lure on Bear Creek | Trout Fishing Trail Access

    Cabin · 2 bd · 2 ba · sleeps 4 · 1.4 mi

    Revenue $37,378ADR $258Occ ≈ 40%5★ (10)

    AirbnbVrbo

  • sleeps 8+ Fire Pit -15 min Ellijay

    Cabin · 4 bd · 2 ba · sleeps 8 · 1.7 mi

    Revenue $37,356ADR $201Occ ≈ 51%4.9★ (30)

    AirbnbVrbo

  • Fairytale SQUIRREL'S NEST cabin at Mulberry Gap in Ellijay!

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

    Revenue $23,806ADR $314Occ ≈ 21%3.5★ (2)

    Vrbo

  • C Hike/Ride the Trailsfrom a Mulberry Gap CABIN!

    Nature lodge · 2 bd · 2 ba · sleeps 5 · 1.9 mi

    Revenue $16,486ADR $213Occ ≈ 21%5★ (1)

    Airbnb

  • Charming 2-bedroom POND NOOK cabin at Mulberry Gap with AC, WiFi, & Kitchenette!

    Cabin · 2 bd · 2 ba · sleeps 5 · 2.0 mi

    Revenue $20,707ADR $208Occ ≈ 27%5★ (1)

    Vrbo

Show all 12 comps
  • Secluded 2Bd/2Bth-Fire pit - Dogs Allowed

    Cabin · 2 bd · 2 ba · sleeps 4 · 2.0 mi

    Revenue $31,388ADR $154Occ ≈ 56%4.5★ (21)

    AirbnbVrboBooking

  • Creekside Storie - Waterfalls Hike Bike Hot Tub

    House · 3 bd · 3 ba · sleeps 6 · 2.1 mi

    Revenue $55,397ADR $204Occ ≈ 74%5★ (106)

    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
Term

Rate 7.78% = 7.03% Freddie Mac 30-yr avg (Sep 24) + 0.75% investor premium

Est. revenue

$32,830

NOI

$11,997

Cash flow /mo

-$2,368

Cash needed

$181,250

Cash-on-cash

-15.7%

ROE (yr 1)

-3.1%

Cap rate

1.9%

DSCR

0.30

Year-1 write-off

$114,915

Year-1 tax shield @ 32%

$36,773

Year-1 return on equity

  • Cash flow (annual)-$28,418
  • Principal paydown$4,090
  • Appreciation at%$18,750
ROE-3.1%
ROE incl. year-1 tax savings (32% bracket, STR loophole)17.2%
Opex, cash-needed & tax-savings breakdown

Annual operating expenses

  • Management (20% of revenue)$6,566
  • Platform fees (3% of revenue)$985
  • Maintenance / capex (5% of revenue)$1,642
  • Utilities & supplies$4,200
  • HOA$0
  • Property tax$691
  • Insurance (STR-rated)$6,750

Cash needed to close

  • Down payment (25%)$156,250
  • Closing costs (4.0%)$25,000
  • Furnishing (conveyed with the sale)$0

Tax savings if the STR loophole applies

  • Tax shield @ 32%$36,773

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

$575,000

Short-life (5/15-yr)

$113,000 · 20%

Year-1 deduction

$115,000

Year-1 tax shield @ 32%

$37,000

Land 8% (county tax record, market value split) · building $461,000 over 39 years

Based on: 2,514 sq ft, built 2006, 3 bd / 3 ba, furnished, listing features (deck, fence, fireplace, flooring types, appliance list, septic).

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

5-year property$58,400
  • Kitchen cabinetsdefault

    $11,300 new × 40% good × 1.92 allocation

    $8,700
  • Kitchen countertopsdefault

    $9,300 new × 40% good × 1.92 allocation

    $7,100
  • Decorative trimdefault

    $4,400 new × 40% good × 1.92 allocation

    $3,400
  • Mirrorsdefault

    $500 new × 40% good × 1.92 allocation

    $300
  • Shelvingdefault

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

    $900
  • Window coverings (25)default

    $6,300 new × 40% good × 1.92 allocation

    $4,800
  • Carpet, vinyl & laminate (25% of floors)listing

    $4,000 new × 40% good × 1.92 allocation

    $3,100
  • Kitchen & laundry equipment plumbingdefault

    $8,800 new × 60% good × 1.92 allocation

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

    $5,300 new × 60% good × 1.92 allocation

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

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

    $5,900
  • Furniture conveyed with the sale (used)listing

    $19,500 new × 40% good · out of the price

    $7,800
15-year land improvements$55,000
  • Paving: driveway & walks (paved)default

    $10,400 new × 50% good × 1.92 allocation

    $10,000
  • Landscaping (typical)default

    $10,000 new × 50% good × 1.92 allocation

    $9,600
  • Patiosdefault

    $2,500 new × 50% good × 1.92 allocation

    $2,400
  • Decks & porches (attached)listing

    $28,300 new × 50% good × 1.92 allocation

    $27,200
  • Fencinglisting

    $6,000 new × 50% good × 1.92 allocation

    $5,800
Building, 39-year$461,300
  • Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault

    $273,000 new × 67% good × 1.92 allocation

    $350,300
  • Building plumbing & fixturesdefault

    $28,300 new × 60% good × 1.92 allocation

    $32,700
  • Building electrical & lightingdefault

    $29,100 new × 60% good × 1.92 allocation

    $33,600
  • HVACdefault

    $28,300 new × 40% good × 1.92 allocation

    $21,800
  • Hardwood & tile floorsdefault

    $12,100 new × 40% good × 1.92 allocation

    $9,300
  • Fireplacelisting

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

    $2,000
  • Septic systemlisting

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

    $11,500

About the property

Depreciation schedule: typical cost seg study

Year5-yr15-yrBuildingTotal
1$58,400$55,000$1,500$114,900
2$0$0$11,800$11,800
3$0$0$11,800$11,800
4$0$0$11,800$11,800
5$0$0$11,800$11,800
6+$0$0$412,500$412,500
Total$58,400$55,000$461,300$574,800

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: Georgia disallows bonus depreciation, Ohio adds back 5/6 of it, and Tennessee has no personal income tax. Not tax advice.

Market note

Fannin and Gilmer counties require STR registration and lodging tax; no cap found. Blue Ridge and Ellijay city limits have their own rules; most cabins are in unincorporated county.