SELECT *, CASE WHEN `locality` LIKE "taft%" 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 = "OK" AND (locality IN ("taft") 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 5
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "OK" 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 5
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,950,0001341 W Shawnee BypMuskogee OK 74401View Listing
$1,250,0001184 N 94th St WMuskogee OK 74401View Listing
$950,0003707 Country Club DrMuskogee OK 74403View Listing
$884,90023269 W 40th St NHaskell OK 74436View Listing
$747,50038892 E 211th St SPorter OK 74454View Listing
$695,0003401 E Shawnee BypMuskogee OK 74403View Listing
$675,00021153 W Skelly RdHaskell OK 74436View Listing
$649,50013810 W 33rd St SHaskell OK 74436View Listing
$599,0008821 S 24th St WMuskogee OK 74401View Listing
$447,0001871 N 194th St WHaskell OK 74436View Listing
$439,0004601 S 74th St WMuskogee OK 74401View Listing
$438,5003416 Harris AveMuskogee OK 74403View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "OK" 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 5
Blah