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

719 College St
Madisonville, TN 37354
Tannor Giles with Your Home Sold Guaranteed Realty TN, original listing - (865) 365-1670

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $724,999
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3876 Square Feet
Agency: Your Home Sold Guaranteed Realty TN
Agency Phone: (865) 365-1670

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1925
Notes: Your Home Sold Guaranteed or I'll Buy It! This property comes with $22,000+ in savings, guaranteed! That's no money down ($0) and up to 2 months of no payments for a stress-free move that can happen immediately. Better yet, if you are not satisfied with your investment at 24 months, we'll buy it back or sell it absolutely free-no questions asked. That's a $16,000+ value to our VIP buyers! We can even buy your current home so you can move in right away, so you don't get stuck owning two homes. Contact us today for a complimentary consultation and to get started. -- Stunningly beautiful home with basement apartment, detached recreation/game room with dry bar, custom kitchen, 5 bedrooms with additional bonus room and all this sitting on a double lot with an extra meter at the pole!! All Kitchen appliances convey to buyer as well as shed and beautiful large mirror in living room! This home was completely renovated in 2022 along with landscaping. Additional feature include: Trey Ceilings with lights, marble fire place, custom kitchen with double ovens, quartz counter-tops, gas stove with copper hood, matching copper farm sink, Large Primary Suite with large primary bath, walk in shower, standing tub, marbled walls, blue tooth speaker system, High ceilings throughout, original doorknobs throughout, huge laundry room with shelves, second laundry in basement, Tiles floors, gas stoves, old barn-wood trim, one car garage with wood burning stove, workbench, top of the line HOT TUB, dry bar, and so much more!! When you step outside enjoy the large detached recreation/game room with hot tub, dry bar and games as well as a detached full bathroom and joined together by a large concrete patio for relaxing and entertaining your friends! The basement is a full apartment space equipped with full kitchen, 1 bedroom, 1 full bathroom, extra laundry room and tons of extra storage space! Basement is currently being rented at $900/month (no contract) so buy this house and have a big chunk of your mortgage covered right away! The back side of the property has a second entry way where you could park an RV, add additional parking or whatever you wanted. Homes like this don't come available often....enjoy everything this house has to offer along with city water, city sewer, easy access to town, less then 2 miles from Madisonville Golf Club, Walmart and about 3 miles from Monroe County Airport and Kefauver Park! -- Contact us today to get more information about this exclusive offer! Our properties include a 12-month limited home warranty ($500) value, $500 lender credit, $300 attorney credit, and $100 home inspection credit for VIP buyers. Note: This home qualifies for an additional 1% buy down rate for our VIP buyers, so much sure to sign up today! Your Home Sold Guaranteed Realty is the #1 Real Estate team for people looking to make a move fast while getting the most return. Let us show you why our team is the best in Tennessee and beyond.
MlsNumber: --
ListingId: 11356900


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 = 2488 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 Danielle Belcher
Danielle Belcher
ASCIIRealty Executives
Call Today!: (386) 663-5504

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App