SELECT *, CASE WHEN `locality` LIKE "cherokee pass%" 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 ("cherokee pass") 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.
$2,400,00029316 Bidwell Creek RdFredericktown MO 63645View Listing
$1,752,000Madison 313Marquand MO 63655View Listing
$875,0001778 Madison # 9563Fredericktown MO 63645View Listing
$569,9001121 Madison 92103Fredericktown MO 63645View Listing
$554,90013907 Highway TFredericktown MO 63645View Listing
$397,5001074 Madison 281Fredericktown MO 63645View Listing
$395,000405 N Deer TrlFredericktown MO 63645View Listing
$369,9001112 Madison 207Fredericktown MO 63645View Listing
$350,0003367 W Highway 72Fredericktown MO 63645View Listing
$329,9001968 Madison 410Fredericktown MO 63645View Listing
$315,0005003 County Road 860Marquand MO 63655View Listing
$295,0001059 Madison 210Fredericktown MO 63645View 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
