SELECT *, CASE WHEN `name` LIKE "broken arrow%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "broken arrow" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "broken arrow" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "broken arrow" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "OK" AND (locality IN ("broken arrow") 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,999,90012205 E 151st St SBroken Arrow OK 74011View Listing
$1,950,00029101 E 41st St SBroken Arrow OK 74014View Listing
$1,799,0004113 S Nogal AveBroken Arrow OK 74011View Listing
$1,750,00023220 E 121st St SBroken Arrow OK 74014View Listing
$1,650,0009433 S 282nd East AveBroken Arrow OK 74014View Listing
$1,549,0008581 S 273rd East AveBroken Arrow OK 74014View Listing
$1,500,00011500 S Lynn Lane RdBroken Arrow OK 74011View Listing
$1,400,00011413 E 132nd Pl SBroken Arrow OK 74011View Listing
$1,349,0004321 S Mimosa AveBroken Arrow OK 74011View Listing
$1,325,0007319 E Broadway AveBroken Arrow OK 74014View Listing
$1,250,0005809 W Vicksburg StBroken Arrow OK 74011View Listing
$1,075,0007171 S 282nd East AveBroken Arrow OK 74014View Listing
$990,00011601 S 193rd East AveBroken Arrow OK 74014View Listing
$890,0009429 S 280th East AveBroken Arrow OK 74014View Listing
$875,0007705 S 3rd PlBroken Arrow OK 74011View Listing
$849,00015088 S 129th East AveBroken Arrow OK 74011View Listing
$845,00012420 S Garnett RdBroken Arrow OK 74011View Listing
$845,0008301 E Freeport StBroken Arrow OK 74014View Listing
$839,0004709 S Retana AveBroken Arrow OK 74011View Listing
$830,0004509 E Sequoia AveBroken Arrow OK 74011View Listing
$825,0006811 S Tamarack AveBroken Arrow OK 74011View Listing
$825,0007505 S 6th StBroken Arrow OK 74011View Listing
$798,4533820 W Orlando StBroken Arrow OK 74011View Listing
$789,900212 S 77th StBroken Arrow OK 74014View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-07-2024 11:07:31 pm.
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