SELECT *, CASE WHEN `locality` LIKE "turley%" 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 ("turley") 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.
$6,250,0005862 N Eagle Summit RdOwasso OK 74055View Listing
$3,995,0005879 N Eagle Summit RdOwasso OK 74055View Listing
$2,700,000999 County Road 2265Skiatook OK 74070View Listing
$2,495,0009818 N Stonewick RdOwasso OK 74055View Listing
$2,000,0004812 E 76th StSperry OK 74073View Listing
$1,999,00011408 N 129th East AveOwasso OK 74055View Listing
$1,900,0008320 E 80th St NOwasso OK 74055View Listing
$1,799,50096 N Quebec AveSperry OK 74073View Listing
$1,650,00010728 N Memorial DrOwasso OK 74055View Listing
$1,499,9008320 N Delaware AveSperry OK 74073View Listing
$1,450,0006352 N Emerson LoopOwasso OK 74055View Listing
$1,100,00012621 N Cooper Ridge RdSkiatook OK 74070View 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
Commercial
Land
Ranch
Single Family
