Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2456 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2456 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2456 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

6499 Warrensburg Rd
Mosheim, TN 37818
Tannor Giles with Your Home Sold Guaranteed Realty TN, original listing - (865) 365-1670

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: --
Agency: Your Home Sold Guaranteed Realty TN
Agency Phone: (865) 365-1670

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: BUY THIS HOME AND GET $22,000+ in savings GUARANTEED! Buy this awesome home with $0 Down and up to 2 mo. No Payments. Buy this home if YOU Are Not Satisfied in 24 Months I'LL Buy It back or SELL IT FOR FREE NO Gimmicks! For information on this exclusive Buyer Protection Plan, call the listing office directly see info below **Bonus 1** Love it or Leave it Guaranteed! Buy this home if YOU Are Not Satisfied in 24 Months I'LL Buy It back or SELL IT FOR FREE NO Gimmicks! A $16,000+ value to our VIP buyers! **Bonus 2** Don't get stuck owning two homes. BUY THIS HOME, I WILL BUY YOURS! If you are looking to buy a home but have one to sell, you are finding yourself in the same dilemma that most homeowners find themselves in. We can help! To discuss the details of this incredible option, call the listing agent or for a free report on this exclusive offer and how it works visit my website see below for info **Bonus 3** This home comes with a 12 Month Limited Home Warranty ($500 VALUE), a $500 lender credit, $300 attorney credit, $100 home inspection credit for our VIP buyers. Call to become a VIP Buyer! **Bonus 4** This home qualifies for a 1% buy down rate for our VIP buyers ********************************************************************************** IMMACULATE custom-built home on 11.17 acres of PRIME Greene County LAND studded with a 3-car attached garage and 4-car detached garage- plus a plethora of "extras"! From the long, private drive into the wooded property to the many detailed touches- both inside and out- you won't be disappointed! The property also includes a 24' x 36' PAVILLION, a 12' x 12' PERGOLA, a 12' x 14' CUSTOM OUTDOOR BAR, and a fire pit that are perfect for outdoor entertainment! The covered porch welcomes you to step inside the home to custom oak hardwood flooring, central kitchen with ALL of the extras, brick accents, full walk-in pantry, double wall oven, wood burning stove, and beautiful FULL-LENGTH windows to enhance the backyard views! A spacious MAIN ensuite and a BONUS ensuite are also included in this unique floorplan. A 4th space at the front of the home can be used as an office space or an extra bedroom. And- a SPACIOUS laundry room with extra storage and a BONUS sink space completes the design. CENTRALLY located and less than an hour to Knoxville, Sevierville, or Johnson City! Don't wait! Schedule to see this enchanting property today! ********************************************************************************** Schedule your private showing today. If you would like to get the CURRENT price of this home, or for the most up-to-date information on this home, call the actual listing office see details below. $4,596.56 Per Month @ 5.84% APR. *0% Down 30-Year to those who qualify. *Taxes insurance not included. *Rates As of August 2024*. Includes the 1% buy-down rate for 12 months to those who qualify call the listing office for more info or visit my website see below for info. All products and values are subject to the buyer becoming a VIP buyer to qualify for benefits and products. 1% buy-down value of $4,000 based on $400,000 sale price. $16,813.84 buy-back value based on average listing side commission for Your Home Sold Guaranteed Realty 2023 ********************************************************************************** "Seller will entertain any and all requests. Please include any requests in the purchase and sale agreement special stipulations."
MlsNumber: --
ListingId: 11338331


Listing Provided By: Your Home Sold Guaranteed Realty TN, original listing
Phone: (865) 505-8215
Office Phone: (865) 365-1670
Agent Name: Tannor Giles
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2456 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Alicia Duncan
Alicia Duncan
ASCIIGreater Impact Realty
Call Today!: (334) 360-6042

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App