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 ('vahud','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 = 'vahud', 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 ('vahud','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 = 'vahud', 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 ('vahud','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 = 'vahud', 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 21 to 30 of 38 Properties (0 foreclosures)
AgentOwned Realty
$165,000
--
bd /
0
ba /
--
sqft
0 Roosevelt Drive
Saint Stephen
,
South Carolina
29479
The Boulevard Company, LLC
$164,990
--
bd /
0
ba /
--
sqft
1405 Mendel Rivers Road
Saint Stephen
,
South Carolina
29479
National Land Realty, Charleston, SC
$159,900
--
bd /
0
ba /
--
sqft
0 Cottage Ln
Saint Stephen
,
South Carolina
29479
Olde Towne Realty, LLC
$79,900
--
bd /
0
ba /
--
sqft
0 Cottage Lane
Saint Stephen
,
South Carolina
29479
RE/MAX Cornerstone Realty
$75,000
--
bd /
0
ba /
--
sqft
0 W Campbellridge 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
AgentOwned Realty
$60,000
--
bd /
0
ba /
--
sqft
520 Kimrey Lane
Saint Stephen
,
South Carolina
29479
Keller Williams Preferred
$60,000
--
bd /
0
ba /
--
sqft
Thompson Oak Trail
Saint Stephen
,
South Carolina
29479
AgentOwned Realty
$49,999
--
bd /
0
ba /
--
sqft
000 Unity Road
Saint Stephen
,
South Carolina
29479
«
‹
1
2
3
4
›
»
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 ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Deeanna Enfinger
ASCII
Better Homes and Gardens Palmetto
work
Call Today!
:
(843) 494-2294
I'm interested in properties in BERKELEY, SC
1843547
1843547
0
Contact Me
USHUD.com on the Go!