SELECT *, CASE WHEN `locality` LIKE "freeburg%" 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 ("freeburg") 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.
$230,0004 Mildred StBelleville IL 62223View Listing
$225,000119 Starlight DrBelleville IL 62226View Listing
$209,9003061 Plum Hill School RdBelleville IL 62221View Listing
$185,000200 Paradise LnBelleville IL 62220View Listing
$179,90012 Johnson PlBelleville IL 62223View Listing
$170,00010835 Platinum Ln Lot 1Mascoutah IL 62258View Listing
$125,000Town Hall RdBelleville IL 62223View Listing
$115,0002147 Clover Leaf School Rd Lot 6Belleville IL 62223View Listing
$75,0003140 Sir Phillip Ct Lot 3Belleville IL 62221View Listing
$59,000122 Wyndrose Estates DrBelleville IL 62226View Listing
$51,500134 Wyndrose Estates Dr Lot 26Belleville IL 62226View Listing
$50,0005317 White Oak DrSmithton IL 62285View 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