SELECT *, CASE WHEN `locality` LIKE "greenville%" 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 ("greenville") 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.
$64,5004680 Ashlyn Dr Lot 44Pocahontas IL 62275View Listing
$60,9004668 Ashlyn Dr Lot 43Pocahontas IL 62275View Listing
$52,0004612 Kay Lynn Dr Lot 14Pocahontas IL 62275View Listing
$52,0004625 Ashlyn Dr Lot 20Pocahontas IL 62275View Listing
$52,0004637 Ashlyn Dr Lot 19Pocahontas IL 62275View Listing
$45,0004620 Ashlyn Dr Lot 25Pocahontas IL 62275View Listing
$40,0004673 Kay Lynn Dr Lot 6Pocahontas IL 62275View Listing
$30,0000-XXX Joseph Dr Lots 1 & 2Pocahontas IL 62275View Listing
$26,000Deerwood Trl Lot 5Greenville IL 62246View Listing
$26,0000-XXX Deerwood Trl Lot 2Greenville IL 62246View Listing
$26,0000-XXX Deerwood Trl Lot 6Greenville IL 62246View Listing
$26,0000-XXX Deerwood Trl Lot 3Greenville IL 62246View 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