SELECT *, CASE WHEN `locality` LIKE "brumley%" 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 ("brumley") 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,100,000290 Osage River Bridge RdLake Ozark MO 65049View Listing
$1,050,0001201 Bonard LnOsage Beach MO 65065View Listing
$895,0004319 Pogue HolwOsage Beach MO 65065View Listing
$850,000Tbd 5 Highway 242Lake Ozark MO 65049View Listing
$800,000Osage Beach Pkwy and Jojo LnOsage Beach MO 65065View Listing
$750,0001348 San Jose DrOsage Beach MO 65065View Listing
$699,900Highway 54Osage Beach MO 65065View Listing
$699,50037 Wide Sky DrOsage Beach MO 65065View Listing
$675,0009072 State Highway 7 SMontreal MO 65591View Listing
$660,000Moreland LnLake Ozark MO 65049View Listing
$649,90076 Beacon Hill DrLake Ozark MO 65049View Listing
$600,000Barton School RdBrumley MO 65017View 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