SELECT *, CASE WHEN `locality` LIKE "castor%" 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 ("castor") 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.
$950,00014038 County Road 405Dexter MO 63841View Listing
$687,50025182 State Highway ABEssex MO 63846View Listing
$550,00014088 County Road 517Dexter MO 63841View Listing
$469,50011725 Fairway Circle DrDexter MO 63841View Listing
$439,90013874 White Oak DrDexter MO 63841View Listing
$396,50014342 State Highway 25Dexter MO 63841View Listing
$369,90011699 Highway ZZDexter MO 63841View Listing
$335,00018049 Thomas DrDexter MO 63841View Listing
$325,000700 Cate DrBloomfield MO 63825View Listing
$299,90016747 Chalk Bluff TrlDexter MO 63841View Listing
$275,00017057 Lakewood DrDexter MO 63841View Listing
$269,90014614 County Road 652Dexter MO 63841View 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
