SELECT *, CASE WHEN `name` LIKE "downers grove%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "downers grove" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "downers grove" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "downers grove" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "IL" AND (locality IN ("downers grove") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 12
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 12
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$2,975,0004500 Downers DrDowners Grove IL 60515View Listing
$1,999,000505 Lincoln AveDowners Grove IL 60515View Listing
$1,799,9004816 Montgomery Ave Lot 46Downers Grove IL 60515View Listing
$1,700,0001045 Grove StDowners Grove IL 60515View Listing
$1,699,9004809 Seeley Ave Lot 73Downers Grove IL 60515View Listing
$1,674,9004805 Seeley Ave Lot 72Downers Grove IL 60515View Listing
$1,599,9004812 Montgomery St Lot 47Downers Grove IL 60515View Listing
$1,500,0004605 Linscott AveDowners Grove IL 60515View Listing
$1,495,0004636 Prince StDowners Grove IL 60515View Listing
$1,495,0006034 Margo Ct Lot 5Downers Grove IL 60516View Listing
$1,490,0006035 Margo Ct Lot 2Downers Grove IL 60516View Listing
$1,435,0007135 Dunham Rd Lot 2Downers Grove IL 60516View Listing
$1,435,0007135 Dunham RdDowners Grove IL 60516View Listing
$1,325,000512 Wilson StDowners Grove IL 60515View Listing
$1,295,0004600 Forest AveDowners Grove IL 60515View Listing
$1,259,000312 Prairie AveDowners Grove IL 60515View Listing
$1,250,0001243 59th StDowners Grove IL 60516View Listing
$1,195,0007625 Dunham RdDowners Grove IL 60517View Listing
$1,175,0004099 Sterling RdDowners Grove IL 60515View Listing
$1,124,0004206 Forest AveDowners Grove IL 60515View Listing
$1,069,9906014 Fairview AveDowners Grove IL 60516View Listing
$1,000,000904 Cumnor RdDowners Grove IL 60516View Listing
$999,9906010 Fairview AveDowners Grove IL 60516View Listing
$905,4746018 Fairview AveDowners Grove IL 60516View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-06-2024 9:02:55 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 12
Blah