SELECT *, CASE WHEN `name` LIKE "spokane%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spokane" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spokane" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spokane" 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 = "WA" AND (locality IN ("spokane") 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 58
Blah
SELECT *, CASE WHEN `name` LIKE "spokane%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spokane" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spokane" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spokane" 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 = "WA" AND (locality IN ("spokane") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[1] matching rows / [0.00 msec]
Blog ID 58
Blah
$2,300,0001919 E Pinecrest RdSpokane WA 99203View Listing
$2,000,0001514 E South Ridge CtSpokane WA 99223View Listing
$1,950,00011512 S Hoot Owl LnSpokane WA 99224View Listing
$1,890,0002116 E Emily LnSpokane WA 99208View Listing
$1,850,0001518 E 20th AveSpokane WA 99203View Listing
$1,790,00010826 S George Rd S George Rd Unit 10828Spokane WA 99224View Listing
$1,760,0002509 W Hazard RdSpokane WA 99208View Listing
$1,750,0007920 W Mary Lee LnSpokane WA 99208View Listing
$1,750,00012918 N Norman RdSpokane WA 99217View Listing
$1,699,0004844 E Gleneagle LnSpokane WA 99223View Listing
$1,695,0001108 N River Ridge BlvdSpokane WA 99224View Listing
$1,650,0006609 E Sanzy LnSpokane WA 99217View Listing
$1,635,000930 E 20th AveSpokane WA 99203View Listing
$1,595,0003609 W Thorpe RdSpokane WA 99224View Listing
$1,565,0006414 S Helena StSpokane WA 99223View Listing
$1,500,0003909 N Old Trails RdSpokane WA 99224View Listing
$1,499,0003535 S Croydon CtSpokane WA 99203View Listing
$1,495,00016606 N Napa LnSpokane WA 99208View Listing
$1,449,00012023 N Osprey LnSpokane WA 99218View Listing
$1,400,000415 W Cliff DrSpokane WA 99204View Listing
$1,399,0006304 S Helena StSpokane WA 99223View Listing
$1,399,00016417 N Napa LnSpokane WA 99208View Listing
$1,375,0006324 S Helena StSpokane WA 99223View 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-03-2024 7:20:29 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "WA" 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 58
Blah