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] => 48 [1] => MOBILE [2] => AL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 48 LocID: MOBILE Region: AL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 48 Igate: njhud LocID: 48 Region: MOBILE State: AL 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 = 48 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 48 [1] => MOBILE [2] => AL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 48 LocID: MOBILE Region: AL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 48 Igate: njhud LocID: 48 Region: MOBILE State: AL 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 = 48 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 48 [1] => MOBILE [2] => AL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 48 LocID: MOBILE Region: AL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 48 Igate: njhud LocID: 48 Region: MOBILE State: AL 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 = 48 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Alabama (AL) Foreclosure Listings
|
Mobile
| Irvington, Alabama
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Irvington, Mobile, Alabama
Displaying 1 to 10 of 30 Properties (0 foreclosures)
RE/MAX Realty Professionals
$70,000
--
bd /
0
ba /
--
sqft
0 Walker Road
Irvington
,
Alabama
36544
EXIT REALTY LYON & ASSOCIATES
$60,000
--
bd /
0
ba /
--
sqft
0 Pearl Lane
Irvington
,
Alabama
36544
EXIT REALTY LYON & ASSOCIATES
$59,900
--
bd /
0
ba /
--
sqft
0 Roush Road
Irvington
,
Alabama
36544
KELLER WILLIAMS MOBILE
$49,900
3
bd /
3
ba /
--
sqft
10800 Magnolia Road
Irvington
,
Alabama
36544
Bellator RE & Dev-Spanish Fort
$488,800
--
bd /
0
ba /
--
sqft
10475 Padgett Switch Road
Irvington
,
Alabama
36544
IXL Real Estate LLC
$465,000
3
bd /
2
ba /
--
sqft
8219 Kimber Ridge Drive
Irvington
,
Alabama
36544
ROBERTS BROTHERS WEST
$459,900
4
bd /
3
ba /
--
sqft
8224 Kimber Ridge Drive
Irvington
,
Alabama
36544
Coldwell Banker Smith Homes
$439,000
4
bd /
3
ba /
--
sqft
7811 Ken Buck Road
Irvington
,
Alabama
36544
IXL Real Estate LLC
$425,000
4
bd /
3
ba /
--
sqft
11570 Waterford Drive
Irvington
,
Alabama
36544
ROBERTS BROTHERS TREC
$400,000
--
bd /
0
ba /
--
sqft
0 March Road
Irvington
,
Alabama
36544
«
‹
1
2
3
›
»
Cities In MOBILE, AL
Axis
Bayou La Batre
Bucks
Chunchula
Citronelle
Coden
Creola
Dauphin Island
Eight Mile
Grand Bay
Irvington
Mobile
Mount Vernon
Saint Elmo
Saraland
Satsuma
Semmes
Theodore
Wilmer
irvington
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => mobile [3] => AL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: mobile State: AL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: mobile State: AL 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 = 48 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Janice & Mark Barber
ASCII
Keller Williams Alabama Gulf Coast
work
Call Today!
:
(251) 256-9116
I'm interested in properties in MOBILE, AL
1842433
1842433
0
Contact Me
USHUD.com on the Go!