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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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 17 Properties (0 foreclosures)
eXp Realty, LLC
$650,000
--
bd /
0
ba /
--
sqft
11050 S Roberts Road
Palos Hills
,
Illinois
60465
eXp Realty, LLC
$599,500
--
bd /
0
ba /
--
sqft
8048 W 111th Street
Palos Hills
,
Illinois
60465
Better Homes and Gardens Real Estate Connections
$575,000
4
bd /
4
ba /
4,080
sqft
8850 W 101st Place
Palos Hills
,
Illinois
60465
Boutique Home Realty
$559,900
4
bd /
3
ba /
2,000
sqft
9859 S 81st Avenue
Palos Hills
,
Illinois
60465
Homesmart Connect LLC
$549,900
3
bd /
3
ba /
2,406
sqft
8029 98th Street
Palos Hills
,
Illinois
60465
United Real Estate Elite
$538,000
4
bd /
2
ba /
2,426
sqft
10427 S Alta Drive
Palos Hills
,
Illinois
60465
Morandi Properties, Inc
$449,900
4
bd /
2
ba /
2,797
sqft
7833 W 100th Place
Palos Hills
,
Illinois
60465
RE/MAX 1st Service
$421,000
3
bd /
2
ba /
1,278
sqft
10436 S Kathy Court
Palos Hills
,
Illinois
60465
Crosstown Realtors, Inc.
$379,900
3
bd /
2
ba /
1,296
sqft
10443 S 82nd Court
Palos Hills
,
Illinois
60465
United Real Estate Elite
$299,912
2
bd /
2
ba /
1,550
sqft
11012 S Theresa Circle
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
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cook-alsip [3] => IL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cook-alsip State: IL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cook-alsip State: IL 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 = 615 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Amanda Chalus
ASCII
Century 21 Circle - Ryan Hill Group
work
Call Today!
:
(708) 655-6309
I'm interested in properties in COOK (ALSIP), IL
1847042
1847042
0
Contact Me
USHUD.com on the Go!