SELECT *, CASE WHEN `name` LIKE "cle elum%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "cle elum" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "cle elum" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "cle elum" 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 ("cle elum") 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.
$7,850,0001060 Ruby King LoopCle Elum WA 98922View Listing
$4,500,000901 Iron Monarch LoopCle Elum WA 98922View Listing
$3,750,0001481 Coal Mine WayCle Elum WA 98922View Listing
$3,699,999580 Fortune Creek LnCle Elum WA 98922View Listing
$3,699,998161 Morning Star LnCle Elum WA 98922View Listing
$3,595,000210 Gold Fountain LnCle Elum WA 98922View Listing
$3,574,9981130 Ruby King LoopCle Elum WA 98922View Listing
$3,150,0001040 Pinegrass LoopCle Elum WA 98922View Listing
$3,125,0001200 Pinegrass LoopCle Elum WA 98922View Listing
$2,650,000140 Tired Creek LnCle Elum WA 98922View Listing
$2,500,000391 Southern Star LnCle Elum WA 98922View Listing
$2,499,9982241 Forest Ridge DrCle Elum WA 98922View Listing
$2,385,000321 Southern Star LnCle Elum WA 98922View Listing
$2,349,990271 Gold Leaf LnCle Elum WA 98922View Listing
$2,299,9982051 Forest Ridge DrCle Elum WA 98922View Listing
$2,295,000630 Tipple Hill LoopCle Elum WA 98922View Listing
$2,225,00041 Spragger WayCle Elum WA 98922View Listing
$2,196,800191 Gold Leaf LnCle Elum WA 98922View Listing
$2,195,0001231 Kokanee LoopCle Elum WA 98922View Listing
$2,124,9981610 Forest Ridge DrCle Elum WA 98922View Listing
$2,075,000270 Legacy TrlCle Elum WA 98922View Listing
$2,064,000300 Kings CtCle Elum WA 98922View Listing
$1,999,998330 Farmhouse WayCle Elum WA 98922View Listing
$1,999,000830 Pays RdCle Elum WA 98922View 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-17-2024 8:58:57 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