SELECT *, CASE WHEN `name` LIKE "lynnwood%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lynnwood" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lynnwood" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lynnwood" 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 ("lynnwood") 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 *, "0" as `rank` FROM `wp_slides` WHERE st = "WA" 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 58
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,899,8881223 S Lake Stickney DrLynnwood WA 98087View Listing
$1,690,00017828 44th Ave WLynnwood WA 98037View Listing
$1,250,00014512 Madison WayLynnwood WA 98087View Listing
$1,249,9504306 178th Pl SWLynnwood WA 98037View Listing
$1,225,50018313 Butternut RdLynnwood WA 98037View Listing
$1,200,0004124 188th Pl SWLynnwood WA 98036View Listing
$1,160,0001005 187th Pl SWLynnwood WA 98036View Listing
$1,149,99014325 5th Ave WLynnwood WA 98087View Listing
$1,100,00019623 N Danvers RdLynnwood WA 98036View Listing
$1,099,90014502 43rd Ave WLynnwood WA 98087View Listing
$949,90019507 Bing RdLynnwood WA 98036View Listing
$925,00020516 Damson Rd Unit ALynnwood WA 98036View Listing
$899,9902126 143rd Pl SWLynnwood WA 98087View Listing
$899,95017511 13th Pl WLynnwood WA 98037View Listing
$899,0003301 156th St SWLynnwood WA 98087View Listing
$898,00020033 11th Ave WLynnwood WA 98036View Listing
$889,99915313 Meadow RdLynnwood WA 98087View Listing
$875,0003723 Shelby RdLynnwood WA 98087View Listing
$875,0001231 145th St SWLynnwood WA 98087View Listing
$869,90014808 40th Ave W Unit 2Lynnwood WA 98087View Listing
$869,90014812 40th Ave W Unit 3Lynnwood WA 98087View Listing
$850,00014207 14th Ave WLynnwood WA 98087View Listing
$850,0002824 145th St SWLynnwood WA 98087View Listing
$849,95015008 40th Ave W Unit A6Lynnwood WA 98087View 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-02-2024 3:33:41 pm.
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