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 = 2444 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 = 2444 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 = 2444 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;

3835 Renegade Mountain Pkwy #5001
Crab Orchard, TN 37723
Michael Albin with Better Homes and Gardens Real Estate Gwin Realty, original listing - (931) 484-0077

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $198,900
Beds: 2
Baths: Full: 2
Status: Active
SqFt: --
Agency: Better Homes and Gardens Real Estate Gwin Realty
Agency Phone: (931) 484-0077

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Other
Year Built: 1984
Notes: Are you searching for the perfect getaway? Peace and quiet on top of a Tennessee mountain with mild seasons year round. Escape the Florida, Texas heat in the summers or harsh winters and snow up north. Average lows in winter: Dec: 30, Jan: 27, Feb: 30. Average highs in Summer: Jun: 81, Jul: 84, Aug: 84. Low property taxes, no state income tax, 7 golf courses nearby, hiking, boating, a brand new Flatrock motorsports park to be completed soon and outdoor activities all around! Step outside at night and you can see a vast expanse of stars that is truly awe-inspiring. The air is also much cleaner, making it easier to take in the beauty of the night sky above and the city lights from below. Check out this newly remodeled, main level 2 bed, 2 bath, 1718 sq ft condo perfect for a seasonal retreat or large enough for a year round residence. Features include updated kitchen, new appliances in 2021, new HVAC system 2021,new water heater 2022, freshly painted interior, formal dining area with new 18 inch ceramic tile and wet bar. Large master bedroom has lots of closet space, 9 ft ceiling, bathroom with lg vanity, tub/shower combo, heated fan. Living room has 9 ft ceilings, gas log fireplace, door to balcony, lots of natural light. Sunroom also could be an office, art studio, workout room or study, has hardwood floors and lots of natural light. Spend your days soaking in the sunshine, taking in the fresh mountain air, golfing, hiking to waterfalls and more. Come enjoy friendly neighbors that are here to help, peace and quiet, a gentle breeze and amazing sunsets await you here on your Renegade mountain retreat. Experience the peace and serenity that can only be found in nature. There is no HOA fee for each building maintenance. When work is required owners share expenses to make repairs. Wood siding and paint have already been purchased, waiting for contractor to install. Master bedroom window has been ordered, waiting for it to come in to be installed. Buyer to verify all measurements before making an informed offer. Monthly expenses: $57.00 fixed amount for water, $7.00 for outdoor lights, $35.00 a month May-October for lawn service. Average electric bill is around $90.00 a month, depending on usage.
MlsNumber: --
ListingId: 1224916


Listing Provided By: Better Homes and Gardens Real Estate Gwin Realty, original listing
Phone: (931) 287-3539
Office Phone: (931) 484-0077
Agent Name: Michael Albin
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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 = 2444 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;
Cindy Nipper
ASCIIRe/Max Finest
Call Today!: (423) 762-6370

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App