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;

314 Washington St N
Calhoun Falls, SC 29628
Lynn Blanton with Keller Williams Greenwood, original listing - (864) 229-6922

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $149,900
Beds: 2
Baths: Full: 1
Status: Active
SqFt: --
Agency: Keller Williams Greenwood
Agency Phone: (864) 229-6922

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: ADORABLE HOUSE IN GREAT NEIGHBORHOOD - As you drive up to this corner lot home, the bright & cheerful front door & shutters welcome you into this darling cottage. The small front porch is perfect for sitting & sipping sweet tea & waving at your neighbors. As you enter the home, you immediately notice the pretty fireplace with ornate mantel. Vinyl plank flooring in living room, hall & bedrooms. As you leave the living room you see the wide hall which is the center of the home. 2 nice size bedrooms & a bathroom tile & vinyl flooring. The eat-in kitchen is off the wide hall & has plenty of counter tops & cabinets. The laundry/mud room leads to the nice backyard. There is a storage building plus a small cabin with heat/air unit. This could be a man-cave, she-shed or anything you would like to use it for. Residents in this neighborhood are long-term & very friendly. If you like water activities such as fishing, boating, swimming, jet skiing, then this home is for you. Lake Russell is only 1 1/2 miles from this property. The beautiful & pristine Lake Russell is a 26,650 acre lake on the Savannah River. Known as one of the best fishing lakes in the area, you can fish for largemouth bass, crappie, bream & catfish. Love to hunt? There is plenty of US Forest Service land nearby to hunt. Only 14 miles to historic Abbeville with cute shops, wonderful restaurants & the Opera House & Belmont Inn. Elberton, GA is only 18 miles. If you've been wanting to slow down & live the small town life, then call today to check out this cute home.
MlsNumber: --
ListingId: 130925


Listing Provided By: Keller Williams Greenwood, original listing
Phone: (864) 391-1687
Office Phone: (864) 229-6922
Agent Name: Lynn Blanton
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