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 ('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] => 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 ('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] => 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 ('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
|
Alabama (AL) Foreclosure Listings
|
Mobile
| Citronelle, Alabama
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Citronelle, Mobile, Alabama
Displaying 1 to 10 of 16 Properties (1 foreclosures)
Ty Irby Realty & Development
FORECLOSURE
$167,000
3
bd /
3
ba /
2,218
sqft
8350 Pecan St
Citronelle
,
Alabama
36522
National Land Realty, Gulf Coast
$50,000
--
bd /
0
ba /
--
sqft
7940 Lebaron Avenue
Citronelle
,
Alabama
36522
IXL Real Estate LLC
$450,000
--
bd /
0
ba /
--
sqft
11910 Earl Booth Road
Citronelle
,
Alabama
36522
IXL Real Estate LLC
$398,000
3
bd /
2
ba /
--
sqft
17035 Brannon Fork Road
Citronelle
,
Alabama
36522
TY IRBY REALTY & DEVELOPMENT
$39,500
--
bd /
0
ba /
--
sqft
0 Beverly Jefferies Highway
Citronelle
,
Alabama
36522
National Land Realty, Gulf Coast
$384,000
--
bd /
0
ba /
--
sqft
0 Old Gulfcrest Road Private Road
Citronelle
,
Alabama
36522
Realty Executives Bay Group
$38,000
--
bd /
0
ba /
--
sqft
0 Coy Smith Highway
Citronelle
,
Alabama
36522
eXp Realty, LLC Central
$35,000
--
bd /
0
ba /
--
sqft
00 North Street
Citronelle
,
Alabama
36522
Realty Executives Bay Group
$28,500
--
bd /
0
ba /
--
sqft
10835 Mitt Drive
Citronelle
,
Alabama
36522
Berkshire Hathaway Cooper & Co
$249,900
3
bd /
2
ba /
--
sqft
19855 Indiana Street
Citronelle
,
Alabama
36522
«
‹
1
2
›
»
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
citronelle
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 ('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;
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!