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] => 615 [1] => COOK (ALSIP) [2] => IL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 615 LocID: COOK (ALSIP) Region: IL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 615 Igate: njhud LocID: 615 Region: COOK (ALSIP) State: IL 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 = 615 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 615 [1] => COOK (ALSIP) [2] => IL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 615 LocID: COOK (ALSIP) Region: IL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 615 Igate: njhud LocID: 615 Region: COOK (ALSIP) State: IL 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 = 615 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 615 [1] => COOK (ALSIP) [2] => IL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 615 LocID: COOK (ALSIP) Region: IL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 615 Igate: njhud LocID: 615 Region: COOK (ALSIP) State: IL 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 = 615 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Illinois (IL) Foreclosure Listings
|
Cook (Alsip)
| Oak Lawn, Illinois
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Oak Lawn, Cook (Alsip), Illinois
Displaying 1 to 10 of 32 Properties (1 foreclosures)
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$212,000
3
bd /
1
ba /
1,624
sqft
10019 S Tripp Avenue
Oak Lawn
,
Illinois
60453
Realty Executives Elite
$758,700
4
bd /
2
ba /
5,010
sqft
6632 91st Place
Oak Lawn
,
Illinois
60453
Boutique Home Realty
$635,000
7
bd /
0
ba /
--
sqft
9821 S Ridgeland
Oak Lawn
,
Illinois
60453
Realty One Group Heartland
$575,000
4
bd /
3
ba /
3,360
sqft
8860 Moody Avenue
Oak Lawn
,
Illinois
60453
Boutique Home Realty
$550,000
7
bd /
0
ba /
--
sqft
9417 S Kenton Avenue
Oak Lawn
,
Illinois
60453
RE/MAX 10
$529,900
4
bd /
3
ba /
2,950
sqft
9817 S Mcvicker Avenue
Oak Lawn
,
Illinois
60453
Realty Executives New Image
$465,000
--
bd /
0
ba /
2,200
sqft
6737 W 95th Street
Oak Lawn
,
Illinois
60453
HomeSmart Realty Group
$429,900
5
bd /
2
ba /
2,290
sqft
5711 W 87th Place
Oak Lawn
,
Illinois
60453
MUV Real Estate
$400,000
5
bd /
2
ba /
2,306
sqft
10401 Lacrosse Avenue
Oak Lawn
,
Illinois
60453
HomeSmart Realty Group
$397,500
4
bd /
2
ba /
1,532
sqft
11004 S Kilbourn Avenue
Oak Lawn
,
Illinois
60453
«
‹
1
2
3
›
»
Cities In COOK (ALSIP), IL
Alsip
Aurora
Bridgeview
Burbank
Chicago Ridge
Eola
Hickory Hills
Hometown
Justice
Midlothian
Oak Lawn
Palos Heights
Palos Hills
Palos Park
Robbins
Summit Argo
Willow Springs
Worth
oak lawn
USHUD.com on the Go!