Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 2324 [1] => CHARLESTON [2] => SC [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2324 LocID: CHARLESTON Region: SC State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2324 Igate: njhud LocID: 2324 Region: CHARLESTON State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 = 2324 AND i.igate IN ('inhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2324 [1] => CHARLESTON [2] => SC [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2324 LocID: CHARLESTON Region: SC State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2324 Igate: njhud LocID: 2324 Region: CHARLESTON State: SC Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 = 2324 AND i.igate IN ('inhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2324 [1] => CHARLESTON [2] => SC [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2324 LocID: CHARLESTON Region: SC State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2324 Igate: njhud LocID: 2324 Region: CHARLESTON State: SC Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 = 2324 AND i.igate IN ('inhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
South Carolina (SC) Foreclosure Listings
|
Charleston
| Charleston, South Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Charleston, Charleston, South Carolina
Displaying 1 to 10 of 367 Properties (0 foreclosures)
Compass North Carolina LLC Mocking Bird Lane
$999,999
--
bd /
0
ba /
--
sqft
2165 Rosebush Lane
Charleston
,
South Carolina
29412
The Boulevard Company, LLC
$999,000
3
bd /
3
ba /
--
sqft
86 Fishburne Street
Charleston
,
South Carolina
29403
The Cassina Group
$998,000
3
bd /
2
ba /
--
sqft
152 Spring Street
Charleston
,
South Carolina
29403
Carriage Properties LLC
$985,000
1
bd /
1
ba /
--
sqft
175 Concord Street
Charleston
,
South Carolina
29401
John Poston & Company, Inc.
$985,000
2
bd /
2
ba /
--
sqft
210 Coming Street
Charleston
,
South Carolina
29403
Brand Name Real Estate of SC Inc
$982,900
3
bd /
3
ba /
--
sqft
685 Windward Court
Charleston
,
South Carolina
29412
Realty ONE Group Coastal
$962,000
4
bd /
2
ba /
--
sqft
1693 Seignious Drive
Charleston
,
South Carolina
29407
Brand Name Real Estate
$950,000
3
bd /
1
ba /
--
sqft
1447 Fort Lamar Road
Charleston
,
South Carolina
29412
William Means Real Estate, LLC
$950,000
4
bd /
0
ba /
--
sqft
728 Rutledge Avenue
Charleston
,
South Carolina
29403
William Means Real Estate, LLC
$945,000
3
bd /
2
ba /
--
sqft
15 Horlbeck Alley
Charleston
,
South Carolina
29401
«
‹
1
2
3
›
»
Cities In CHARLESTON, SC
Adams Run
Awendaw
Charleston
Charleston Afb
Folly Beach
Hollywood
Isle Of Palms
Johns Island
Mc Clellanville
Mount Pleasant
North Charleston
Ravenel
Sullivans Island
Wadmalaw Island
charleston
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => charleston [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: charleston State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: charleston State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1
QUERY: 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 = 2324 AND i.igate IN ('inhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Donna Urban
ASCII
The Agent Owned Realty Co.
work
Call Today!
:
(843) 830-2913
I'm interested in properties in CHARLESTON, SC
1825983
1825983
0
Contact Me
USHUD.com on the Go!