SELECT *, CASE WHEN `name` LIKE "federal way%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "federal way" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "federal way" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "federal way" 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 ("federal way") 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.
$2,600,00029903 Marine View Dr SWFederal Way WA 98023View Listing
$2,150,000404 S 289th StFederal Way WA 98003View Listing
$1,457,00031050 53rd Ave SWFederal Way WA 98023View Listing
$1,399,00029812 24th Ave SWFederal Way WA 98023View Listing
$1,189,950427 SW 366th St Unit 7Federal Way WA 98023View Listing
$1,174,950537 SW 366th St Unit 3Federal Way WA 98023View Listing
$1,150,00029417 1st Ave SFederal Way WA 98003View Listing
$1,150,00029203 3rd Ave SWFederal Way WA 98023View Listing
$1,149,950421 SW 366th St Unit 8Federal Way WA 98023View Listing
$925,000501 SW 336th StFederal Way WA 98023View Listing
$925,00030420 28th Ave SWFederal Way WA 98023View Listing
$915,00033305 43rd Ave SWFederal Way WA 98023View Listing
$899,00036619 2nd Pl SWFederal Way WA 98023View Listing
$898,95033110 3rd Ct SWFederal Way WA 98023View Listing
$889,95029620 1st Ave SFederal Way WA 98003View Listing
$869,00033206 2nd Pl SWFederal Way WA 98023View Listing
$819,99530321 19th Ave SFederal Way WA 98003View Listing
$819,99530321 19th Ave S Unit WR54Federal Way WA 98003View Listing
$819,9951940 S 301st CtFederal Way WA 98003View Listing
$809,99530215 19th Ave SFederal Way WA 98003View Listing
$804,9951949 S 301st CtFederal Way WA 98003View Listing
$804,9951949 S 301st Ct Unit WR14Federal Way WA 98003View Listing
$799,9951952 S 301st Ct Unit WR21Federal Way WA 98003View Listing
$799,00035804 9th Ave SWFederal Way WA 98023View 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 6:01:32 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
