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.
$789,95015216 106th Ave EPuyallup WA 98374View Listing
$779,9907706 185th Street Ct EPuyallup WA 98375View Listing
$774,99018308 134th Ave E Lot 152Puyallup WA 98374View Listing
$772,03018642 136th Ave E Unit 65Puyallup WA 98374View Listing
$771,95013623 187th St E Unit 66Puyallup WA 98374View Listing
$771,43018637 136th Avenue Ct E Unit 42Puyallup WA 98374View Listing
$770,00013026 157th St EPuyallup WA 98374View Listing
$769,9967460 172nd Street Ct EPuyallup WA 98375View Listing
$769,9957527 172nd Street Ct EPuyallup WA 98375View Listing
$762,87018641 136th Street Ct E Unit 41Puyallup WA 98374View Listing
$760,69918642 136th Avenue Ct E Unit 64Puyallup WA 98374View Listing
$759,95014308 56th Avenue Ct EPuyallup WA 98373View Listing
$759,95014304 56th Avenue Ct EPuyallup WA 98373View Listing
$757,45014202 56th Avenue Ct EPuyallup WA 98373View Listing
$752,95013421 Liberty Pl E Unit 12Puyallup WA 98374View Listing
$749,99813616 168th Street Ct EPuyallup WA 98374View Listing
$749,9907714 185th Street Ct EPuyallup WA 98375View Listing
$749,99013215 Lot 5 Pines Ln E Unit 5Puyallup WA 98374View Listing
$749,99013430 183rd St E Lot 37Puyallup WA 98374View Listing
$749,95010910 71st Avenue Ct EPuyallup WA 98373View Listing
$749,95015403 131st Ave EPuyallup WA 98374View Listing
$749,95015407 131st Ave EPuyallup WA 98374View Listing
$749,95014210 56th Avenue Ct EPuyallup WA 98373View Listing
$749,95015023 116th Avenue Ct 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-18-2024 3:39:21 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