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)
| Palos Hills, Illinois
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Palos Hills, Cook (Alsip), Illinois
Displaying 1 to 10 of 12 Properties (0 foreclosures)
Prospect Equities Real Estate
$920,000
--
bd /
0
ba /
--
sqft
7801 W 111th Street
Palos Hills
,
Illinois
60465
RE/MAX 10
$539,900
3
bd /
3
ba /
2,400
sqft
10709 E Olympia Circle
Palos Hills
,
Illinois
60465
Compass
$425,000
3
bd /
2
ba /
2,097
sqft
8121 Circle Drive
Palos Hills
,
Illinois
60465
REMAX Legends
$420,000
3
bd /
2
ba /
2,000
sqft
10431 S Tod Drive
Palos Hills
,
Illinois
60465
Kale Realty
$415,000
4
bd /
2
ba /
2,186
sqft
10135 S 87th Avenue
Palos Hills
,
Illinois
60465
RE/MAX 10
$319,900
3
bd /
2
ba /
2,300
sqft
9192 Del Prado Drive
Palos Hills
,
Illinois
60465
Berkshire Hathaway HomeServices Chicago
$315,000
2
bd /
2
ba /
2,200
sqft
9066 Del Prado Drive
Palos Hills
,
Illinois
60465
Better Homes and Gardens Real Estate Connections
$289,900
--
bd /
0
ba /
--
sqft
8825 W 95th Street
Palos Hills
,
Illinois
60465
RE/MAX 10 in the Park
$259,873
2
bd /
2
ba /
--
sqft
11212 Cottonwood Drive
Palos Hills
,
Illinois
60465
REMAX Legends
$22
--
bd /
0
ba /
--
sqft
11264 Southwest Highway
Palos Hills
,
Illinois
60465
«
‹
1
2
›
»
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
palos hills
USHUD.com on the Go!