NOT LISTED FOR SALE

3227 Mayes Loop Rd Pigeon Forge, TN 37863

Estimated Value: $1,743,570

12 Beds
12.5 Baths
6,865 Sq Ft
$254/Sq Ft Est. Value

Last Sold December 20, 2024

Last sale price $1,750,000 $255 Per Sq Ft

Current estimated payment $11,361/month

37 Days on Market

Highlights

  • Pool and Spa
  • No HOA
  • Laundry Room
  • Gatlinburg Pittman High School Rated A-
  • Double Oven
  • Kitchen Island

About This Home

As of December 2024

Check out this fantastic investment property opportunity! Your chance to own ''Creekside Mansion'', a 6,800 sq foot cabin. An absolute PRIME location only about 1 mile from Pigeon Forge's main Parkway, this 12 bedroom, 12 bathroom home overlooks Waldens Creek and features 2 hot tubs, a home theater, a massive kitchen, and a variety of arcade games and other amenities! The home sleeps 48 people and is being sold fully furnished and ready to rent.Can't beat its location, just down from beautiful Wear City Park. This cabin is served by City water and sewer and is a guest favorite due to its layout and location.

Last Listed By

Lisa Gibson

Great Mountain Realty LLC License #347999 Listed on: 10/13/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,065

Year Built

  • Built in 2020

Lot Details

  • 0.42 Acre Lot
  • Property is zoned C-2

Home Design

  • Cabin

Interior Spaces

  • 2-Story Property
  • Electric Fireplace

Kitchen

  • Double Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island

Bedrooms and Bathrooms

  • 12 Bedrooms | 5 Main Level Bedrooms
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on upper level
  • Dryer
  • Washer

Additional Features

  • Pool and Spa
  • Central Air

Community Details

  • No Home Owners Association
  • Twin Mountain Subdivision

Listing and Financial Details

  • Tax Lot 9R
  • Assessor Parcel Number 078093D C 00900

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,065

Year Built

Built in 2020

Lot Details

0

Listing Details

  • Property Type: Residential
  • Year Built: 2020
  • Zoning: C-2
  • Current Use: Investment
  • CoListOfficeEmail: billy@greatmountainrealty.com
  • Reso Property Sub Type: Cabin
  • ResoLaundryFeatures: Laundry Room, Upper Level
  • ResoPoolFeatures: Hot Tub
  • Co List Office Mls Id: 576
  • Co List Office Phone: 865-436-8600
  • Co List Office Mls Id: 576
  • Subdivision Name: Twin Mountain
  • Above Grade Finished Sq Ft: 3495.0
  • Fireplace: Yes
  • Garage Yn: No
  • Unit Levels: Two
  • New Construction: No
  • Location Tax and Legal New Construction YN: No
  • Location Tax and Legal Parcel Number2: 078093D C 00900
  • Location Tax and Legal Tax Lot2: 9R
  • Location Tax and Legal:Tax Annual Amount: 7065.0
  • Location Tax and Legal Tax Year2: 2021
  • General Property Information Lot Size Acres: 0.42
  • General Property Information Above Grade Finished Area: 3495.0
  • General Property Information Below Grade Finished Area: 3370.0
  • General Property Information:Bathrooms Half: 1
  • General Property Information Bonus Room YN2: No
  • Appliances Dryer: Yes
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Cooling:Central Air: Yes
  • Sewer:Public Sewer: Yes
  • Water Source:Public: Yes
  • Levels:Two: Yes
  • Pool Features Hot Tub: Yes
  • General Property Information:Stories Total: 2
  • General Property Information Fireplace YN: Yes
  • Interior Features Walk-In Shower(s): Yes
  • Laundry Features Laundry Room: Yes
  • Main Room Levels Main Level Bathrooms: 5
  • Main Room Levels Main Level Bedrooms: 5
  • Laundry Features:Upper Level: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Basement: None
  • Appliances: Dishwasher, Double Oven, Dryer, Electric Cooktop, Microwave, Refrigerator, Washer
  • Interior Amenities: Kitchen Island, Walk-In Shower(s)
  • Street Number Modifier: 3227
  • Full Bathrooms: 12
  • Half Bathrooms: 1
  • Total Bedrooms: 12
  • Below Grade Sq Ft: 3370.0
  • Fireplace Features: Electric
  • Fireplaces: 1
  • Main Level Bathrooms: 5
  • Main Level Bedrooms: 5
  • Stories: 2
  • Appliances Dishwasher: Yes
  • Basement:None3: Yes
  • Fireplace Features:Electric2: Yes
  • Appliances:Double Oven: Yes
  • Appliances:Electric Cooktop: Yes
  • Fireplace Features:Fireplaces Total: 1
  • Interior Features:Kitchen Island: Yes

Exterior Features

  • Acres: 0.42

Garage/Parking

  • General Property Information:Garage YN: No

Utilities

  • Cooling: Central Air
  • Sewer: Public Sewer
  • Cooling Y N: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Lot Info

  • Lot Size Sq Ft: 18295.2
  • ResoLotSizeUnits: Acres
  • Parcel #: 078093D C 00900
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 7065.0
  • Tax Lot: 9R

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 13, 2024
Closed on
Dec 23, 2024
Sold by
Dabuxstra Llc
Bought by
Warner David
Seller's Agent
Lisa Gibson
Great Mountain Realty LLC
Buyer's Agent
Patricia Burris
Avada Properties
List Price
$1,795,000
Sold Price
$1,750,000
Premium/Discount to List
-$45,000
-2.51%
Total Days on Market
37
Views
21
Current Estimated Value
$1,743,570

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$6,430
Avg. Annual Appreciation
-0.99%
Original Mortgage
$1,312,500
Outstanding Balance
$1,309,117
Interest Rate
6.79%
Mortgage Type
New Conventional
Estimated Equity
$434,453

Purchase Details

Closed on
Mar 7, 2019
Sold by
Buxton Properties Llc
Bought by
Dabuxstra Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,100,000
Interest Rate
4.5%
Mortgage Type
Construction

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Warner David $1,750,000 Smoky Mountain Title
Dabuxstra Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Warner David $1,312,500
Previous Owner Dabuxstra Llc $672,250
Previous Owner Dabuxstra Llc $1,100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/20/2024 12/20/24 Sold $1,750,000 -2.5% $255 / Sq Ft
11/19/2024 11/19/24 Pending -- -- --
10/13/2024 10/13/24 For Sale $1,795,000 -- $261 / Sq Ft
Source: Great Smoky Mountains Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $20,338 $687,120 $11,000 $676,120
2023 $20,338 $687,120 $0 $0
2022 $7,065 $429,450 $6,875 $422,575
2021 $7,065 $429,450 $6,875 $422,575
2020 $5,542 $429,450 $6,875 $422,575
2019 $429 $20,800 $11,000 $9,800
2018 $429 $20,800 $11,000 $9,800
2017 $429 $20,800 $11,000 $9,800
2016 $429 $20,800 $11,000 $9,800
2015 -- $19,400 $0 $0
2014 $355 $19,400 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Great Smoky Mountains Association of REALTORS®

MLS Number: 303381

Great Smoky Mountains Association of REALTORS®

APN: 093D-C-009.00