2251 Upper Middle Creek Rd Unit 24
Sevierville, TN 37876
$639,000
4 bd · 3 ba · 2,176 sqft · Listed 1d ago
View on Realtor.com →Year built
2007
Sqft
2,176
Lot sqft
—
HOA / mo
$300
Furnished
No
List date
2026-11-01T20:48:54.000000Z
Revenue
Annual revenue
$64,658
ADR
$338
Occupancy
52%
Cleaning fees (12 mo)
$11,486
Confidence
Low (45.96), 46 comps
Comp revenue range (p25 / median / p75)
Median revenue of shown comps: $50,378
Amazing Views & 5 miles from Dollywood / Parkway 4 bedroom + game room + WiFi
Cabin · 4 bd · 3 ba · sleeps 12 · 3 ft
- Hot tub
- Pool
- A/C
- Free parking
- +7
Revenue $67,164ADR $388Occ ≈ 47%4.8★ (211)
Million Dollar Views | Dog Friendly Escape
Cabin · 4 bd · 3 ba · sleeps 12 · 305 ft
Revenue $75,778ADR $354Occ ≈ 59%5★ (163)
Dad's Cabin: Mountain Views+pets+Dollywood+Hot Tub
Cabin · 4 bd · 3 ba · sleeps 9 · 312 ft
Revenue $44,309ADR $296Occ ≈ 41%4.8★ (135)
Game Room + Arcade • Hot-Tub • MTN Views
Cabin · 4 bd · 3 ba · sleeps 10 · 322 ft
- Hot tub
- A/C
- Free parking
- Wifi
- +5
Revenue $14,007ADR $305Occ ≈ 13%4.8★ (10)
Beartastic Mountain View by Avada Properties
Vacation home · 4 bd · 4 ba · sleeps 10 · 325 ft
Revenue $51,817ADR $213Occ ≈ 67%—
| Listing | Size | Revenue (12 mo) | ADR | Occ ≈ | Rating | Distance | Links |
|---|---|---|---|---|---|---|---|
Amazing Views & 5 miles from Dollywood / Parkway 4 bedroom + game room + WiFi Cabin
| 4 bd · 3 ba · sleeps 12 | $67,164 | $388 | 47% | 4.8★ (211) | 3 ft | Vrbo |
Fall Getaway• Mountain Views• Hot Tub• Dollywood Cabin
| 4 bd · 3 ba · sleeps 12 | $44,954 | $347 | 35% | 4.7★ (24) | 16 ft | AirbnbVrboBooking |
Panoramic MtnVws-EVChgr-PoolTbl-HotTub-NearDlywood Cabin
| 4 bd · 3 ba · sleeps 12 | $48,758 | $328 | 41% | 5★ (30) | 302 ft | AirbnbVrboBooking |
All About The View-great views, close to Dollywood Cabin
| 4 bd · 3 ba · sleeps 10 | $64,072 | $346 | 51% | 3.9★ (45) | 305 ft | AirbnbVrboBooking |
Million Dollar Views | Dog Friendly Escape Cabin | 4 bd · 3 ba · sleeps 12 | $75,778 | $354 | 59% | 5★ (163) | 305 ft | Airbnb |
Moonlight Getaway- great view, near pigeon forge Cabin
| 4 bd · 3 ba · sleeps 10 | $64,297 | $359 | 49% | 4.2★ (20) | 305 ft | AirbnbVrboBooking |
Dad's Cabin: Mountain Views+pets+Dollywood+Hot Tub Cabin | 4 bd · 3 ba · sleeps 9 | $44,309 | $296 | 41% | 4.8★ (135) | 312 ft | Airbnb |
Game Room + Arcade • Hot-Tub • MTN Views Cabin
| 4 bd · 3 ba · sleeps 10 | $14,007 | $305 | 13% | 4.8★ (10) | 322 ft | Airbnb |
Eagle's Perch | MTN views | Hot Tub | Game Room! Cabin
| 4 bd · 3 ba · sleeps 9 | $22,178 | $319 | 19% | 4.5★ (10) | 325 ft | AirbnbVrbo |
Beartastic Mountain View by Avada Properties Vacation home | 4 bd · 4 ba · sleeps 10 | $51,817 | $213 | 67% | — | 325 ft | Booking |
Show 26 more
10% OFF! Just Renovated | Mountain Views| Location
Cabin · 4 bd · 3 ba · sleeps 12 · 430 ft
Revenue $14,572ADR $373Occ ≈ 11%4.9★ (227)
3 decks w/ Amazing Mtn Views, Game Rm, Hot Tub!
Cabin · 4 bd · 3 ba · sleeps 9 · 0.1 mi
Revenue $38,428ADR $378Occ ≈ 28%4.8★ (132)
Majestic Views | Prime Location | Game Room | 4BR
Cabin · 4 bd · 3 ba · sleeps 12 · 0.1 mi
- Hot tub
- A/C
- Free parking
- Pets OK
- +6
Revenue $44,364ADR $280Occ ≈ 43%5★ (31)
Mtn VIEWS! Close to Dollywood +Hot tub, Pool table
Cabin · 4 bd · 3 ba · sleeps 12 · 0.1 mi
Revenue $57,048ADR $366Occ ≈ 43%4.9★ (214)
Cozy 4BD w/ Breathtaking VIEWS! Arcade + HOT TUB!
Cabin · 4 bd · 3 ba · sleeps 10 · 0.1 mi
Revenue $64,207ADR $290Occ ≈ 61%4.7★ (125)
NEW! Modern, Cozy & Fun Fam Gem Game Room HotTub
Cabin · 4 bd · 3 ba · sleeps 12 · 0.2 mi
- Hot tub
- A/C
- Free parking
- Wifi
- +5
Revenue $124,460ADR $528Occ ≈ 65%4.8★ (216)
Secluded 4BRMountain Retreat:Stunning Views, Pool Table, Arcade, HotTub, FirePit
Cabin · 4 bd · 4 ba · sleeps 12 · 0.3 mi
- A/C
- Free parking
- Wifi
- Kitchen
- +4
Revenue $112,260ADR $446Occ ≈ 69%5★ (209)
Peaceful Stay Hot Tub, Views, Near Pigeon Forge
Vacation home · 4 bd · 3 ba · sleeps 9 · 0.4 mi
Revenue $77,340ADR $375Occ ≈ 57%5★ (2)
Peaceful Stay | Hot Tub, Views, Near Pigeon Forge
House · 4 bd · 3.5 ba · sleeps 12 · 0.4 mi
Revenue $17,035ADR $421Occ ≈ 11%4.5★ (8)
Delisted
Tanasi Retreat Game Room Corn Hole Gas Grill
House · 4 bd · 2 ba · sleeps 10 · 0.7 mi
- A/C
- Free parking
- Wifi
- Kitchen
- +2
Revenue $896ADR $224Occ ≈ 1%4.7★ (3)
| Listing | Size | Revenue (12 mo) | ADR | Occ ≈ | Rating | Distance | Links |
|---|---|---|---|---|---|---|---|
Mtn Range View-Pet OK-Hot Tub-Close to Attractions Cabin | 4 bd · 3 ba · sleeps 10 | $57,759 | $313 | 51% | 4.8★ (274) | 374 ft | AirbnbBooking |
Summit Creek Lodge/Mtn Views/Hot Tub/Sleeps 12 Cabin
| 4 bd · 3 ba · sleeps 12 | $5,351 | $278 | 5% | 5★ (1) | 407 ft | AirbnbVrboBooking |
10% OFF! Just Renovated | Mountain Views| Location Cabin | 4 bd · 3 ba · sleeps 12 | $14,572 | $373 | 11% | 4.9★ (227) | 430 ft | Airbnb |
3 decks w/ Amazing Mtn Views, Game Rm, Hot Tub! Cabin | 4 bd · 3 ba · sleeps 9 | $38,428 | $378 | 28% | 4.8★ (132) | 0.1 mi | Airbnb |
Majestic Views | Prime Location | Game Room | 4BR Cabin
| 4 bd · 3 ba · sleeps 12 | $44,364 | $280 | 43% | 5★ (31) | 0.1 mi | Airbnb |
Superior MTN Views| HotTub | GameRoom | Sleeps 12 Cabin
| 4 bd · 3 ba · sleeps 12 | $33,744 | $336 | 28% | 4.7★ (43) | 0.1 mi | AirbnbVrbo |
Bear Watch | Views + Hot Tub + Games | Sleeps 12 House
| 4 bd · 3 ba · sleeps 12 | $31,160 | $395 | 22% | 5★ (17) | 0.1 mi | AirbnbVrbo |
Mountain View • Hot Tub • Dogs OK • Sleeps 12 Cabin
| 4 bd · 3 ba · sleeps 12 | $44,670 | $361 | 34% | 4.8★ (11) | 0.1 mi | AirbnbVrboBooking |
Mtn Views • Hot Tub • Game Room • 10 min Dollywood Cabin
| 4 bd · 3 ba · sleeps 12 | $38,355 | $343 | 31% | 5★ (30) | 0.1 mi | AirbnbVrbo |
4BR w/Mountain Views! Hot Tub*Sauna*Near Dollywood Cabin
| 4 bd · 3 ba · sleeps 10 | $49,061 | $421 | 32% | 5★ (15) | 0.1 mi | AirbnbVrbo |
Million-Dollar Views • 3 Kings • Near Dollywood Cabin
| 4 bd · 3 ba · sleeps 12 | $58,478 | $360 | 45% | 5★ (43) | 0.1 mi | AirbnbVrbo |
Mtn VIEWS! Close to Dollywood +Hot tub, Pool table Cabin | 4 bd · 3 ba · sleeps 12 | $57,048 | $366 | 43% | 4.9★ (214) | 0.1 mi | Airbnb |
Grand Mountain View Lodge By Ghosal Lodging Cabin
| 4 bd · 3 ba · sleeps 10 | $59,409 | $386 | 42% | 4.8★ (45) | 0.1 mi | AirbnbVrboBooking |
Cozy 4BD w/ Breathtaking VIEWS! Arcade + HOT TUB! Cabin | 4 bd · 3 ba · sleeps 10 | $64,207 | $290 | 61% | 4.7★ (125) | 0.1 mi | Airbnb |
NEW! Modern, Cozy & Fun Fam Gem Game Room HotTub Cabin
| 4 bd · 3 ba · sleeps 12 | $124,460 | $528 | 65% | 4.8★ (216) | 0.2 mi | Airbnb |
Secluded 4BRMountain Retreat:Stunning Views, Pool Table, Arcade, HotTub, FirePit Cabin
| 4 bd · 4 ba · sleeps 12 | $112,260 | $446 | 69% | 5★ (209) | 0.3 mi | Vrbo |
Smoky Mtn Views | Hot Tub · Pool Table Cabin
| 4 bd · 4 ba · sleeps 12 | $134,333 | $539 | 68% | 4.9★ (223) | 0.3 mi | AirbnbVrboBooking |
4 king beds, hot tub, mountain view! Cabin | 4 bd · 4 ba · sleeps 12 | $71,891 | $397 | 50% | 4.7★ (24) | 0.3 mi | AirbnbBooking |
Knotty But Nice | 4 King Suites & Hot Tub Cabin
| 4 bd · 4 ba · sleeps 12 | $51,694 | $377 | 38% | 4.8★ (6) | 0.3 mi | AirbnbVrboBooking |
Game & Movie Room • Hot Tub • Fire Pit • WiFi House
| 4 bd · 2 ba · sleeps 12 | $45,115 | $258 | 48% | 5★ (58) | 0.4 mi | AirbnbVrbo |
Peaceful Stay Hot Tub, Views, Near Pigeon Forge Vacation home | 4 bd · 3 ba · sleeps 9 | $77,340 | $375 | 57% | 5★ (2) | 0.4 mi | Booking |
Peaceful Stay | Hot Tub, Views, Near Pigeon Forge House | 4 bd · 3.5 ba · sleeps 12 | $17,035 | $421 | 11% | 4.5★ (8) | 0.4 mi | Delisted |
Spectacular Views | Hot Tub, Firepit & Theater Cabin
| 4 bd · 3.5 ba · sleeps 12 | $71,124 | $388 | 50% | 4.9★ (29) | 0.4 mi | AirbnbVrboBooking |
25%OFF~4BR~Views~Hot Tub~10 Min to the Parkway Cabin
| 4 bd · 3 ba · sleeps 12 | $77,246 | $378 | 56% | 4.9★ (173) | 0.7 mi | AirbnbVrbo |
Tanasi Retreat Game Room Corn Hole Gas Grill House
| 4 bd · 2 ba · sleeps 10 | $896 | $224 | 1% | 4.7★ (3) | 0.7 mi | Airbnb |
Rustic Mountain Cabin w/ Hot Tub & Fireplaces Cabin
| 4 bd · 3 ba · sleeps 10 | $46,472 | $373 | 34% | 3★ (3) | 0.7 mi | 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
Rate 7.99% = 7.24% Freddie Mac 30-yr avg (Oct 29) + 0.75% investor premium
Est. revenue
$64,658
NOI
$32,341
Cash flow /mo
-$818
Cash needed
$214,310
Cash-on-cash
-4.6%
ROE (yr 1)
6.2%
Cap rate
5.1%
DSCR
0.77
Year-1 write-off
$138,594
Year-1 tax shield @ 32%
$44,350
Year-1 return on equity
- Cash flow (annual)-$9,818
- Principal paydown$4,011
- Appreciation at%$19,170
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)$12,932
- Platform fees (3% of revenue)$1,940
- Maintenance / capex (5% of revenue)$3,233
- Utilities & supplies$4,200
- HOA$3,600
- Property tax$2,579
- Insurance (STR-rated)$3,834
Cash needed to close
- Down payment (25%)$159,750
- Closing costs (4.0%)$25,560
- Furnishing (bought new)$29,000
Tax savings if the STR loophole applies
- Tax shield @ 32%$44,350
No county tax record split for property tax, insurance rate and the land/building split, so those use market defaults — edit the price above; 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
$543,000
Short-life (5/15-yr)
$109,000 · 20%
Year-1 deduction
$139,000
Year-1 tax shield @ 32%
$44,000
Land 15% (market default, no usable tax-record split) · building $434,000 over 39 years · new furniture $29,000
Based on: 2,176 sq ft, built 2007, 4 bd / 3 ba, unfurnished, listing features (hot tub, deck, game room, fireplace, flooring types, appliance list).
Try the cost segregation calculator on any property →
IRS-guide safe-harbor floor: $92,000 in year 1 (11% short-life, $29,000 tax shield), the conservative amount following the IRS audit guide's residential classification table.
- $8,900
Kitchen cabinetsdefault
$10,600 new × 40% good × 2.10 allocation
- $7,300
Kitchen countertopsdefault
$8,600 new × 40% good × 2.10 allocation
- $3,200
Decorative trimdefault
$3,800 new × 40% good × 2.10 allocation
- $400
Mirrorsdefault
$500 new × 40% good × 2.10 allocation
- $1,300
Shelvingdefault
$1,500 new × 40% good × 2.10 allocation
- $4,600
Window coverings (22)default
$5,500 new × 40% good × 2.10 allocation
- $3,900
Carpet, vinyl & laminate (33% of floors)listing
$4,700 new × 40% good × 2.10 allocation
- $10,700
Kitchen & laundry equipment plumbingdefault
$8,200 new × 62% good × 2.10 allocation
- $6,500
Kitchen, laundry & data equipment electricaldefault
$5,000 new × 62% good × 2.10 allocation
- $6,800
Appliances (range, microwave, dishwasher, disposal, refrigerator, washer, dryer)listing
$8,100 new × 40% good × 2.10 allocation
- $7,600
Hot tub (freestanding)listing
$9,000 new × 40% good × 2.10 allocation
- $23,000
Furniture bought newlisting
$23,000 new × 100% good · bought separately
- $6,000
Game-room equipment bought newlisting
$6,000 new × 100% good · bought separately
- $10,200
Paving: driveway & walks (paved)listing
$9,700 new × 50% good × 2.10 allocation
- $9,800
Landscaping (typical)default
$9,300 new × 50% good × 2.10 allocation
- $2,300
Patiosdefault
$2,100 new × 50% good × 2.10 allocation
- $25,700
Decks & porches (attached)listing
$24,500 new × 50% good × 2.10 allocation
- $339,000
Structure: foundation, framing, walls, windows, doors, roof, interior finishesdefault
$235,800 new × 68% good × 2.10 allocation
- $32,000
Building plumbing & fixturesdefault
$24,500 new × 62% good × 2.10 allocation
- $32,400
Building electrical & lightingdefault
$24,900 new × 62% good × 2.10 allocation
- $20,600
HVACdefault
$24,500 new × 40% good × 2.10 allocation
- $7,900
Hardwood & tile floorsdefault
$9,300 new × 40% good × 2.10 allocation
- $2,200
Fireplacelisting
$2,600 new × 40% good × 2.10 allocation
About the property
Depreciation schedule: typical cost seg study
| Year | 5-yr | 15-yr | Building | Total |
|---|---|---|---|---|
| 1 | $90,200 | $48,000 | $500 | $138,600 |
| 2 | $0 | $0 | $11,100 | $11,100 |
| 3 | $0 | $0 | $11,100 | $11,100 |
| 4 | $0 | $0 | $11,100 | $11,100 |
| 5 | $0 | $0 | $11,100 | $11,100 |
| 6+ | $0 | $0 | $389,000 | $389,000 |
| Total | $90,200 | $48,000 | $434,000 | $572,100 |
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.