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 ('cahud','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 = 'cahud', 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 ('cahud','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 = 'cahud', 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 ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Arkansas (AR) Foreclosure Listings
|
Izard
| Mount Pleasant, Arkansas
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Mount Pleasant, Izard, Arkansas
Displaying 1 to 8 of 8 Properties (0 foreclosures)
United Country Ozark Realty
$850,000
3
bd /
2
ba /
1,276
sqft
1168 Love Hollow
Mount Pleasant
,
Arkansas
72561
Re/Max Edge Realty Melbourne
$399,900
3
bd /
2
ba /
1,135
sqft
60 Hilltop Lane
Mount Pleasant
,
Arkansas
72561
Re/Max Edge Realty
$35,000
--
bd /
0
ba /
--
sqft
67-68 River Road
Mount Pleasant
,
Arkansas
72561
United Country Ozark Realty
$1,999,999
3
bd /
2
ba /
1,276
sqft
0 Love Hollow
Mount Pleasant
,
Arkansas
72561
Choice Realty
$179,900
3
bd /
1
ba /
1,708
sqft
2212 West Road
Mount Pleasant
,
Arkansas
72561
United Country Ozark Realty
$1,692,544
--
bd /
0
ba /
--
sqft
Love Hollow
Mount Pleasant
,
Arkansas
72556
Re/Max Edge Realty Melbourne
$149,900
--
bd /
0
ba /
--
sqft
000 West Road
Mount Pleasant
,
Arkansas
72561
Re/Max Edge Realty Melbourne
$142,500
3
bd /
1
ba /
1,158
sqft
4401 N Main Street
Mount Pleasant
,
Arkansas
72556
Cities In IZARD, AR
Brockwell
Calico Rock
Dolph
Franklin
Guion
Horseshoe Bend
Melbourne
Mount Pleasant
Oxford
Pineville
Sage
Violet Hill
Wideman
Wiseman
mount pleasant
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 ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Brenda Astle
ASCII
Outdoor Properties
work
Direct
:
(870) 615-1755
work
Office
:
(870) 269-3378
I'm interested in properties in IZARD, AR
1839689
1839689
0
Contact Me
USHUD.com on the Go!