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] => 1925 [1] => GUILFORD [2] => NC [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1925 LocID: GUILFORD Region: NC State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1925 Igate: njhud LocID: 1925 Region: GUILFORD State: NC 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 = 1925 AND i.igate IN ('cihud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1925 [1] => GUILFORD [2] => NC [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1925 LocID: GUILFORD Region: NC State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1925 Igate: njhud LocID: 1925 Region: GUILFORD State: NC 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 = 1925 AND i.igate IN ('cihud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1925 [1] => GUILFORD [2] => NC [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1925 LocID: GUILFORD Region: NC State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1925 Igate: njhud LocID: 1925 Region: GUILFORD State: NC 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 = 1925 AND i.igate IN ('cihud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
North Carolina (NC) Foreclosure Listings
|
Guilford
| Greensboro, North Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Greensboro, Guilford, North Carolina
Displaying 1 to 10 of 503 Properties (0 foreclosures)
Keller Williams One
$997,500
--
bd /
0
ba /
--
sqft
1908 Hackamore Road
Greensboro
,
North Carolina
27410
eXp Realty, LLC
$997,000
3
bd /
4
ba /
4,485
sqft
4300 Ravenstone Drive
Greensboro
,
North Carolina
27407
The Headley Group Realty
$995,000
5
bd /
4
ba /
3,142
sqft
1700 W Market Street
Greensboro
,
North Carolina
27403
Keller Williams One
$99,500
--
bd /
0
ba /
--
sqft
110 Greenbriar Road
Greensboro
,
North Carolina
27405
People 1st Realty
$995
2
bd /
1
ba /
--
sqft
3838 West Avenue
Greensboro
,
North Carolina
27407
eXp Realty, LLC
$985,000
--
bd /
0
ba /
--
sqft
4600 Hicone Road
Greensboro
,
North Carolina
27405
My Favorite Realty, Inc
$980,000
3
bd /
3
ba /
3,938
sqft
1301 Burnetts Chapel Road
Greensboro
,
North Carolina
27406
Keller Williams Central
$980,000
4
bd /
4
ba /
5,526
sqft
6002 Still Run Drive
Greensboro
,
North Carolina
27455
Keller Williams One
$97,500
3
bd /
1
ba /
778
sqft
1306 Avalon Road
Greensboro
,
North Carolina
27401
Hall Realty Results
$975
2
bd /
1
ba /
--
sqft
2605 Spring Garden Street
Greensboro
,
North Carolina
27403
«
‹
1
2
3
›
»
Cities In GUILFORD, NC
Browns Summit
Climax
Colfax
Gibsonville
Greensboro
High Point
Jamestown
Julian
Mc Leansville
Oak Ridge
Pleasant Garden
Sedalia
Stokesdale
Summerfield
Whitsett
greensboro
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => guilford [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: guilford State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: guilford State: NC 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 = 1925 AND i.igate IN ('cihud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Tori Foy
ASCII
Keller Williams Kernersville
work
Call Today!
:
(336) 324-5054
I'm interested in properties in GUILFORD, NC
1841855
1841855
0
Contact Me
USHUD.com on the Go!