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] => 2360 [1] => YORK [2] => SC [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2360 LocID: YORK Region: SC State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2360 Igate: njhud LocID: 2360 Region: YORK 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 = 2360 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2360 [1] => YORK [2] => SC [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2360 LocID: YORK Region: SC State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2360 Igate: njhud LocID: 2360 Region: YORK 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 = 2360 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2360 [1] => YORK [2] => SC [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2360 LocID: YORK Region: SC State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2360 Igate: njhud LocID: 2360 Region: YORK 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 = 2360 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
South Carolina (SC) Foreclosure Listings
|
York
| Fort Mill, South Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Fort Mill, York, South Carolina
Displaying 1 to 10 of 218 Properties (0 foreclosures)
Classica Homes - Charlotte
$997,900
4
bd /
3
ba /
3,690
sqft
2026 Thatcher Way
Fort Mill
,
South Carolina
29715
Keller Williams Fort Mill
$995,000
5
bd /
4
ba /
4,912
sqft
306 Corner Lake Court
Fort Mill
,
South Carolina
29715
Helen Adams Realty
$985,000
5
bd /
4
ba /
5,249
sqft
2161 Hanging Rock Road
Fort Mill
,
South Carolina
29715
Compass North Carolina LLC Mocking Bird Lane
$979,000
5
bd /
4
ba /
3,272
sqft
5818 Savona Terrace
Fort Mill
,
South Carolina
29708
EXP Realty
$970,000
5
bd /
4
ba /
4,512
sqft
2192 Hanging Rock Road
Fort Mill
,
South Carolina
29715
Better Homes and Gardens Real Estate Paracle
$938,000
5
bd /
3
ba /
3,352
sqft
1906 Manor Court
Fort Mill
,
South Carolina
29715
Compass North Carolina LLC Mocking Bird Lane
$900,000
3
bd /
3
ba /
3,243
sqft
828 Savile Lane
Fort Mill
,
South Carolina
29715
NorthGroup Real Estate, Inc.
$899,900
4
bd /
4
ba /
4,323
sqft
1491 Hwy 160 Road E
Fort Mill
,
South Carolina
29715
Savvy + Co Real Estate
$899,900
--
bd /
0
ba /
--
sqft
792 Lost Rabbit Run
Fort Mill
,
South Carolina
29715
Keller Williams Fort Mill
$899,000
6
bd /
6
ba /
5,447
sqft
421 Kimbrell Crossing Drive
Fort Mill
,
South Carolina
29715
«
‹
1
2
3
›
»
Cities In YORK, SC
Bowling Green
Catawba
Fort Mill
Hickory Grove
Lake Wylie
Mc Connells
Rock Hill
Sharon
Smyrna
Tega Cay
York
fort mill
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => york [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: york State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: york 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 = 2360 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jennifer Huffman
ASCII
CONNECTION REALTY, LLC
cell
Mobile
:
(336) 830-4855
I'm interested in properties in YORK, SC
1837259
1837259
0
Contact Me
USHUD.com on the Go!