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] => 36 [1] => JEFFERSON (SOUTHEAST) [2] => AL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 36 LocID: JEFFERSON (SOUTHEAST) Region: AL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 36 Igate: njhud LocID: 36 Region: JEFFERSON (SOUTHEAST) 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 = 36 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] => 36 [1] => JEFFERSON (SOUTHEAST) [2] => AL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 36 LocID: JEFFERSON (SOUTHEAST) Region: AL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 36 Igate: njhud LocID: 36 Region: JEFFERSON (SOUTHEAST) 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 = 36 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] => 36 [1] => JEFFERSON (SOUTHEAST) [2] => AL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 36 LocID: JEFFERSON (SOUTHEAST) Region: AL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 36 Igate: njhud LocID: 36 Region: JEFFERSON (SOUTHEAST) 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 = 36 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
|
Jefferson (Southeast)
| Vestavia Hills, Alabama
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Vestavia Hills, Jefferson (Southeast), Alabama
Displaying 1 to 10 of 82 Properties (2 foreclosures)
Home Team Realty
FORECLOSURE
$155,000
--
bd /
0
ba /
--
sqft
1939 Old Creek Trail
Vestavia Hills
,
Alabama
35216
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$155,000
--
bd /
0
ba /
--
sqft
1939 Old Creek Trl
Vestavia Hills
,
Alabama
35216
ARC Realty Mountain Brook
$999,999
--
bd /
0
ba /
--
sqft
4021 Marthas Circle
Vestavia Hills
,
Alabama
35243
Wedgworth Realty
$950,000
5
bd /
4
ba /
--
sqft
909 Viridian Way
Vestavia Hills
,
Alabama
35226
Ray & Poynor Properties
$935,000
5
bd /
4
ba /
--
sqft
3432 Southampton Circle
Vestavia Hills
,
Alabama
35243
ARC Realty
$929,000
5
bd /
5
ba /
--
sqft
1205 Branchwater Lane
Vestavia Hills
,
Alabama
35216
ARC Realty Mountain Brook
$899,900
5
bd /
4
ba /
--
sqft
1964 Rocky Brook Drive
Vestavia Hills
,
Alabama
35243
LIST Birmingham
$899,900
4
bd /
3
ba /
--
sqft
3640 Miller Hill Way
Vestavia Hills
,
Alabama
35243
RE/MAX Advantage South
$895,000
5
bd /
4
ba /
--
sqft
251 Big Springs Drive
Vestavia Hills
,
Alabama
35216
Ray & Poynor Properties
$849,900
4
bd /
3
ba /
--
sqft
2300 Hunters Cove
Vestavia Hills
,
Alabama
35216
«
‹
1
2
3
›
»
Cities In JEFFERSON (SOUTHEAST), AL
Bessemer
Birmingham
Homewood
Hoover
Leeds
Mc Calla
Mountain Brook
New Castle
Palmerdale
Sayre
Shannon
Vestavia Hills
Watson
vestavia hills
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => jefferson-southeast [3] => AL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: jefferson-southeast State: AL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: jefferson-southeast 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 = 36 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;
Mollie Eck
ASCII
RealtySouth Chelsea Branch
work
Call Today!
:
(205) 873-8512
I'm interested in properties in JEFFERSON (SOUTHEAST), AL
1842293
1842293
0
Contact Me
USHUD.com on the Go!