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] => 2321 [1] => BERKELEY [2] => SC [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2321 LocID: BERKELEY Region: SC State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2321 Igate: njhud LocID: 2321 Region: BERKELEY 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 = 2321 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] => 2321 [1] => BERKELEY [2] => SC [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2321 LocID: BERKELEY Region: SC State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2321 Igate: njhud LocID: 2321 Region: BERKELEY 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 = 2321 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] => 2321 [1] => BERKELEY [2] => SC [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2321 LocID: BERKELEY Region: SC State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2321 Igate: njhud LocID: 2321 Region: BERKELEY 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 = 2321 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
|
Berkeley
| Saint Stephen, South Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Saint Stephen, Berkeley, South Carolina
Displaying 1 to 10 of 37 Properties (0 foreclosures)
Coldwell Banker North Charleston
$97,500
--
bd /
0
ba /
--
sqft
Lot 0 Chauncey Lane
Saint Stephen
,
South Carolina
29479
Harbins Two, Inc
$69,500
--
bd /
0
ba /
--
sqft
00 Fishermans Drive
Saint Stephen
,
South Carolina
29479
Johnson & Wilson Real Estate Co LLC
$65,000
--
bd /
0
ba /
--
sqft
0 Madrid Lane
Saint Stephen
,
South Carolina
29479
Keller Williams Preferred
$60,000
--
bd /
0
ba /
--
sqft
Thompson Oak Trail
Saint Stephen
,
South Carolina
29479
Coldwell Banker North Charleston
$525,000
4
bd /
3
ba /
3,420
sqft
3112 Santee River Rd
Saint Stephen
,
South Carolina
29479
Coldwell Banker North Charleston
$50,000
--
bd /
0
ba /
--
sqft
Tract 2 Chauncey Lane
Saint Stephen
,
South Carolina
29479
AgentOwned Realty
$495,000
9
bd /
0
ba /
--
sqft
1359 Schurlknight Road
Saint Stephen
,
South Carolina
29479
RE/MAX Cornerstone Realty
$490,000
3
bd /
2
ba /
--
sqft
264 Shiver Farms Lane
Saint Stephen
,
South Carolina
29479
Olde Towne Realty, LLC
$47,500
--
bd /
0
ba /
--
sqft
0 Buckles
Saint Stephen
,
South Carolina
29479
RE/MAX Cornerstone Realty
$45,000
--
bd /
0
ba /
--
sqft
0 Wisteria Falls Trail
Saint Stephen
,
South Carolina
29479
«
‹
1
2
3
›
»
Cities In BERKELEY, SC
Bethera
Bonneau
Charleston
Cordesville
Cross
Goose Creek
Hanahan
Huger
Jamestown
Ladson
Moncks Corner
Pineville
Pinopolis
Russellville
Saint Stephen
saint stephen
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => berkeley [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: berkeley State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: berkeley 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 = 2321 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;
Jim Mills
ASCII
Next Home The Agency Group
work
Call Today!
:
(843) 830-3800
I'm interested in properties in BERKELEY, SC
1842634
1842634
0
Contact Me
USHUD.com on the Go!