SELECT *, CASE WHEN `locality` LIKE "bonne terre%" 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 = "MO" AND (locality IN ("bonne terre") 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
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MO" 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
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,770,000262 Old Cadet RdBonne Terre MO 63628View Listing
$849,900415 Big River CirBonne Terre MO 63628View Listing
$675,0004461 Hazel Run RdBonne Terre MO 63628View Listing
$672,00067 Highway Stormy LnBonne Terre MO 63628View Listing
$599,90010325 Laporte RdBonne Terre MO 63628View Listing
$449,9001110 Judy CirBonne Terre MO 63628View Listing
$405,0008689 Snowdell RdFrench Village MO 63036View Listing
$379,900253 Highway MIrondale MO 63648View Listing
$375,000812 State Highway 47Bonne Terre MO 63628View Listing
$374,9004030 Oakwood RdPark Hills MO 63601View Listing
$369,9002890 Riversbend Rd SBonne Terre MO 63628View Listing
$349,500115 Lashley DrPark Hills MO 63601View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MO" 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
Blah
Commercial
Land
Ranch
Single Family
