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 ('alhud','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 = 'alhud', 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 ('alhud','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 = 'alhud', 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 ('alhud','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 = 'alhud', 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
| Dauphin Island, Alabama
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Dauphin Island, Mobile, Alabama
Displaying 1 to 10 of 24 Properties (0 foreclosures)
ROBERTS BROTHERS WEST
$1,500,000
3
bd /
2
ba /
--
sqft
917 Delchamps Avenue
Dauphin Island
,
Alabama
36528
KELLER WILLIAMS MOBILE
$1,250,000
--
bd /
0
ba /
--
sqft
504 Lemoyne Drive
Dauphin Island
,
Alabama
36528
IXL Real Estate LLC
$1,200,000
3
bd /
2
ba /
--
sqft
2206 Cadillac Avenue
Dauphin Island
,
Alabama
36528
ROBERTS BROTHERS TREC
$1,119,000
3
bd /
2
ba /
--
sqft
535 Barcelona Drive
Dauphin Island
,
Alabama
36528
RE/MAX Realty Professionals
$875,000
4
bd /
3
ba /
--
sqft
104 Surf Court
Dauphin Island
,
Alabama
36528
eXp Realty Southern Branch
$850,000
3
bd /
2
ba /
--
sqft
316 Pineda Street
Dauphin Island
,
Alabama
36528
KELLER WILLIAMS MOBILE
$685,000
--
bd /
0
ba /
--
sqft
0 Audubon Place
Dauphin Island
,
Alabama
36528
Better Homes and Gardens Real Estate Platinum Properties
$624,900
--
bd /
0
ba /
--
sqft
2408 Bienville Boulevard
Dauphin Island
,
Alabama
36528
RE/MAX Realty Professionals
$550,000
4
bd /
2
ba /
--
sqft
112 Audubon Street
Dauphin Island
,
Alabama
36528
Sam Winter and Company, Inc
$515,000
3
bd /
2
ba /
--
sqft
1221 Chaumont Street
Dauphin Island
,
Alabama
36528
«
‹
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
dauphin island
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 ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Chad Hartley
ASCII
Hartley Real Estate Inc.
work
Call Today!
:
(251) 421-3004
I'm interested in properties in MOBILE, AL
1847616
1847616
0
Contact Me
USHUD.com on the Go!