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] => 140 [1] => IZARD [2] => AR [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 140 LocID: IZARD Region: AR State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 140 Igate: njhud LocID: 140 Region: IZARD State: AR 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 = 140 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 140 [1] => IZARD [2] => AR [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 140 LocID: IZARD Region: AR State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 140 Igate: njhud LocID: 140 Region: IZARD State: AR 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 = 140 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 140 [1] => IZARD [2] => AR [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 140 LocID: IZARD Region: AR State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 140 Igate: njhud LocID: 140 Region: IZARD State: AR 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 = 140 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Arkansas (AR) Foreclosure Listings
|
Izard
| Guion, Arkansas
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Guion, Izard, Arkansas
Displaying 1 to 9 of 9 Properties (0 foreclosures)
Living The Dream Outdoor Properties - Leasburg
$42,500
--
bd /
0
ba /
--
sqft
White River Run Ii
Guion
,
Arkansas
72540
United Country Ozark Realty-Calico Rock
$40,000
--
bd /
0
ba /
--
sqft
43 White River Run
Guion
,
Arkansas
72540
United Country Ozark Realty-Calico Rock
$40,000
--
bd /
0
ba /
--
sqft
50 White River Run
Guion
,
Arkansas
72540
United Country Real Estate Natural State Home & Land
$29,000
--
bd /
0
ba /
--
sqft
000 River Ridge Road
Guion
,
Arkansas
72540
Dustin White Realty
$270,000
1
bd /
1
ba /
576
sqft
4221 Sandmine Rd
Guion
,
Arkansas
72540
United Country Ozark Realty-Calico Rock
$25,000
--
bd /
0
ba /
--
sqft
59 White River Run
Guion
,
Arkansas
72540
United Country Ozark Realty-Calico Rock
$25,000
--
bd /
0
ba /
--
sqft
60 White River Run
Guion
,
Arkansas
72540
United Country Ozark Realty-Calico Rock
$25,000
--
bd /
0
ba /
--
sqft
64 White River Run
Guion
,
Arkansas
72540
United Country Ozark Realty-Calico Rock
$25,000
--
bd /
0
ba /
--
sqft
65 White River Run
Guion
,
Arkansas
72540
Cities In IZARD, AR
Brockwell
Calico Rock
Dolph
Franklin
Guion
Horseshoe Bend
Melbourne
Mount Pleasant
Oxford
Pineville
Sage
Violet Hill
Wideman
Wiseman
guion
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => izard [3] => AR [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: izard State: AR Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: izard State: AR 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 = 140 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith
ASCII
Generic Real Estate
work
Cell
:
(241) 555-1812
work
Office
:
(241) 555-1776
I'm interested in properties in IZARD, AR
18234
18234
0
Contact Me
USHUD.com on the Go!