SELECT *, CASE WHEN `name` LIKE "puyallup%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "puyallup" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "puyallup" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "puyallup" 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 ("puyallup") 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.
$859,0001414 12th St SWPuyallup WA 98371View Listing
$855,02713640 187th St E Unit 39Puyallup WA 98374View Listing
$850,0003924 Victoria LnPuyallup WA 98372View Listing
$849,95015305 106th Ave EPuyallup WA 98374View Listing
$849,95015212 106th Ave EPuyallup WA 98374View Listing
$849,00014107 104th Street Ct EPuyallup WA 98374View Listing
$847,56113418 Liberty Pl E Unit 8Puyallup WA 98374View Listing
$834,9952309 28th Street Pl SEPuyallup WA 98374View Listing
$830,0007613 185th Street Ct EPuyallup WA 98375View Listing
$829,9507219 83rd Street Ct EPuyallup WA 98371View Listing
$823,53513602 186th Street Ct E Unit 61Puyallup WA 98374View Listing
$820,99018402 183rd St E Unit 44Puyallup WA 98374View Listing
$820,00013109 Sunridge Way EPuyallup WA 98374View Listing
$815,95011127 71st Avenue Ct EPuyallup WA 98373View Listing
$809,95010914 71st Avenue Ct EPuyallup WA 98373View Listing
$799,9992824 14th Ave NWPuyallup WA 98371View Listing
$799,9957628 173rd Street Ct EPuyallup WA 98375View Listing
$799,9907710 185th Street Ct EPuyallup WA 98375View Listing
$799,9902716 13th Street Pl SWPuyallup WA 98373View Listing
$799,98015503 65th Avenue Ct EPuyallup WA 98375View Listing
$799,9502309 29th Street Pl SE Lot 13Puyallup WA 98374View Listing
$799,9002721 Thornhill RdPuyallup WA 98374View Listing
$799,00013801 172nd Pl EPuyallup WA 98374View Listing
$789,95015301 106th Ave EPuyallup WA 98374View 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 7:32:54 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