SELECT *, CASE WHEN `name` LIKE "lake forest%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake forest" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake forest" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake forest" 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 ("lake forest") 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 *, CASE WHEN `name` LIKE "lake forest%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake forest" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake forest" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake forest" 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 ("lake forest") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] 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.
$1,695,000464 Oakwood AveLake Forest IL 60045View Listing
$1,676,6721895 Amberley Ct Lot 10Lake Forest IL 60045View Listing
$1,599,000100 Hestercombe LnLake Forest IL 60045View Listing
$1,500,000950 W James Ct SLake Forest IL 60045View Listing
$1,499,9991570 Littlefield CtLake Forest IL 60045View Listing
$1,476,2601905 Amberley Ct Lot 11Lake Forest IL 60045View Listing
$1,463,6301865 Ct #Lot 7Lake Forest IL 60045View Listing
$1,425,0001565 S Ridge RdLake Forest IL 60045View Listing
$1,425,000291 W Deerpath RdLake Forest IL 60045View Listing
$1,350,000336 N Western AveLake Forest IL 60045View Listing
$1,349,9001288 Lakewood DrLake Forest IL 60045View Listing
$1,349,000811 S Ridge RdLake Forest IL 60045View Listing
$1,328,0811885 Ct #Lot 9Lake Forest IL 60045View Listing
$1,299,000881 N Sheridan RdLake Forest IL 60045View Listing
$1,294,9001965 Ct #Lot 17Lake Forest IL 60045View Listing
$1,292,4001995 Amberley Ct Lot 20Lake Forest IL 60045View Listing
$1,288,8501855 Amberley Ct Lot 6Lake Forest IL 60045View Listing
$1,284,9001955 Amberley Ct Lot 16Lake Forest IL 60045View Listing
$1,199,900375 Deerpath SqLake Forest IL 60045View Listing
$1,165,3001825 Ct #Lot 3Lake Forest IL 60045View Listing
$1,145,0001111 Walden LnLake Forest IL 60045View Listing
$1,125,0001776 Westbridge CirLake Forest IL 60045View Listing
$1,100,000511 Oakwood Ave Apt 2CLake Forest IL 60045View Listing
$1,100,0001300 Elm Tree RdLake Forest IL 60045View 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-16-2024 2:07:06 pm.
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