SELECT *, CASE WHEN `name` LIKE "seattle%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "seattle" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "seattle" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "seattle" 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 ("seattle") 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 "seattle%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "seattle" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "seattle" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "seattle" 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 ("seattle") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 58
Blah
$4,695,0001220 2nd Ave NSeattle WA 98109View Listing
$4,595,0002530 42nd Ave WSeattle WA 98199View Listing
$4,499,00010936 Rainier Ave SSeattle WA 98178View Listing
$3,999,8885622 39th Ave WSeattle WA 98199View Listing
$3,600,0002429 Montavista Pl WSeattle WA 98199View Listing
$3,589,0002926 Fuhrman Ave ESeattle WA 98102View Listing
$3,500,0001609 19th AveSeattle WA 98122View Listing
$3,500,0004775 Ballard Ave NWSeattle WA 98107View Listing
$3,495,0003811 Eastern Ave NSeattle WA 98103View Listing
$3,475,0001627 40th AveSeattle WA 98122View Listing
$3,400,0001135 21st Ave ESeattle WA 98112View Listing
$3,250,00011502 6th Ave NWSeattle WA 98177View Listing
$2,995,0008308 25th Adu Ave NW Unit 1Seattle WA 98117View Listing
$2,990,0003805 E Pine StSeattle WA 98122View Listing
$2,900,0005477 Beach Dr SWSeattle WA 98136View Listing
$2,899,9501628 30th AveSeattle WA 98122View Listing
$2,850,0003834 58th Ave SWSeattle WA 98116View Listing
$2,625,0001229 NW 122nd StSeattle WA 98177View 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-13-2024 2:11:20 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
Ranch
Single Family
