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
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Mobile, Alabama
Displaying 1 to 10 of 1067 Properties (3 foreclosures)
Ty Irby Realty & Development
FORECLOSURE
$49,900
3
bd /
1
ba /
870
sqft
13885 Jernberg Ave
Bayou La Batre
,
Alabama
36509
Ty Irby Realty & Development
FORECLOSURE
$31,200
2
bd /
1
ba /
949
sqft
960 Duval St
Mobile
,
Alabama
36605
Ty Irby Realty & Development
FORECLOSURE
$167,000
3
bd /
3
ba /
2,218
sqft
8350 Pecan St
Citronelle
,
Alabama
36522
ROBERTS BROTHERS TREC
$999,995
4
bd /
3
ba /
--
sqft
5801 Fairfax Road S
Mobile
,
Alabama
36608
Realty Executives Bay Group
$99,900
--
bd /
0
ba /
--
sqft
28 Everett Avenue W
Saraland
,
Alabama
36571
TY IRBY REALTY & DEVELOPMENT
$99,900
--
bd /
0
ba /
--
sqft
14860 Moffett Road
Wilmer
,
Alabama
36587
Boardwalk Realty
$997,500
4
bd /
2
ba /
--
sqft
2623 Bienville Boulevard
Dauphin Island
,
Alabama
36528
Gulfbelt Properties Inc
$995
4
bd /
1
ba /
--
sqft
214 3rd Street
Chickasaw
,
Alabama
36611
Gulfbelt Properties Inc
$995
3
bd /
1
ba /
--
sqft
1412 Greenbrier Drive
Mobile
,
Alabama
36605
KELLER WILLIAMS MOBILE
$99,120
2
bd /
1
ba /
--
sqft
2423 Denmark Street
Mobile
,
Alabama
36617
«
‹
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
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!