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 = 2314 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 2314 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 2314 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

165 Tugaloo St S
Calhoun Falls, SC 29628
Tina Lensch with eXp Realty LLC (Greenville), original listing - (888) 440-2798

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $129,900
Beds: 3
Baths: Full: 1
Status: Active
SqFt: --
Agency: eXp Realty LLC (Greenville)
Agency Phone: (888) 440-2798

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1975
Notes: Welcome to your dream home, nestled close to the enchanting Blue Hole area! Imagine living just a stone's throw away from some of the best spots for camping, picnicking, fishing, boating, and swimming. With Calhoun State Park and Blue Hole just a few miles up the road, outdoor adventures are practically at your doorstep. This charming single brick home offers a perfect blend of comfort and convenience. Step inside to discover three generously sized bedrooms, ideal for comfortable living or hosting guests. The living room flows seamlessly into an open kitchen and dining area, making it perfect for entertaining or enjoying cozy family dinners. One of the standout features of this home is the wonderful covered deck, accessible through patio doors from the dining area. Equipped with two fans, it's the perfect spot to unwind with a book, enjoy a morning coffee, or host a summer BBQ. The home boasts brand-new floors throughout, giving it a fresh and modern feel. With a new HVAC system, freshly painted walls, a new stove, and updated lights and fans, this home is truly move-in ready. When you're not enjoying the comforts of your new home, take a short ride to the quaint town of Abbeville. Spend an evening at the opera house, dine at local restaurants, and explore charming boutiques and eateries. This home is more than just a place to live—and the price is right. Ready to make it yours? Come see it today!
MlsNumber: --
ListingId: 131483


Listing Provided By: eXp Realty LLC (Greenville), original listing
Phone: (864) 993-9621
Office Phone: (888) 440-2798
Agent Name: Tina Lensch
Disclaimer: Copyright © 2024 Greenwood Association of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App