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 ('cihud','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 = 'cihud', 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 ('cihud','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 = 'cihud', 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 ('cihud','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 = 'cihud', 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 22 Properties (0 foreclosures)
Keller Williams Realty Charleston West Ashley
$2,150,000
--
bd /
0
ba /
--
sqft
937 Tiger Loop
Saint Stephen
,
South Carolina
29479
Keller Williams Realty Charleston West Ashley
$1,200,000
16
bd /
0
ba /
--
sqft
935 Tiger Loop
Saint Stephen
,
South Carolina
29479
RE/MAX Cornerstone Realty
$575,000
3
bd /
2
ba /
--
sqft
1758 Mendel Rivers Road
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
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
Realty ONE Group Coastal
$415,000
4
bd /
3
ba /
--
sqft
240 Pole Cat Way
Saint Stephen
,
South Carolina
29479
Beycome
$390,000
4
bd /
2
ba /
--
sqft
1090 Peru Road
Saint Stephen
,
South Carolina
29479
Hunter Quinn Homes
$349,325
3
bd /
3
ba /
--
sqft
1102 Graham Street
Saint Stephen
,
South Carolina
29479
Hunter Quinn Homes
$339,555
4
bd /
3
ba /
--
sqft
1114 Graham Street
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 ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Gino Lucarelli
ASCII
The Real Estate Firm
work
Call Today!
:
(843) 478-7282
I'm interested in properties in BERKELEY, SC
1842783
1842783
0
Contact Me
USHUD.com on the Go!