SELECT *, CASE WHEN `locality` LIKE "johnsburg%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "IL" AND (locality IN ("johnsburg") 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.01 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.
$10,000,0009999 Main StCrystal Lake IL 60014View Listing
$3,500,00029650 N Garland RdWauconda IL 60084View Listing
$3,000,00026011 N Rand RdWauconda IL 60084View Listing
$2,900,00018752 W Edwards RdAntioch IL 60002View Listing
$2,400,00036113 N Highway 45Lake Villa IL 60046View Listing
$2,325,00018922 W Grand AveLake Villa IL 60046View Listing
$1,899,8954215 Route 31Crystal Lake IL 60012View Listing
$1,690,000978 Eastshore DrFox Lake IL 60020View Listing
$1,650,00027254 W Nippersink RdFox Lake IL 60020View Listing
$1,500,000Nec Route 176 and Westridge DrIsland Lake IL 60042View Listing
$1,500,000Eastwood DrRound Lake IL 60073View Listing
$1,350,00042601 N Linden LnAntioch IL 60002View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
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
Commercial
Land
Ranch
Single Family
