SELECT *, CASE WHEN `name` LIKE "bellevue%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bellevue" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bellevue" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bellevue" 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 ("bellevue") 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 *, CASE WHEN `name` LIKE "bellevue%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bellevue" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bellevue" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bellevue" 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 ("bellevue") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[1] 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,838,00015016 45th St SEBellevue WA 98006View Listing
$2,820,0001607 W Lake Sammamish Pkwy SEBellevue WA 98008View Listing
$2,790,0005658 171st Ave SEBellevue WA 98006View Listing
$2,750,0002718 142nd Pl NEBellevue WA 98007View Listing
$2,700,0004335 130th Pl SEBellevue WA 98006View Listing
$2,700,000750 168th Pl SEBellevue WA 98008View Listing
$2,699,0004008 173rd Ln SEBellevue WA 98008View Listing
$2,690,0002225 157th Pl SEBellevue WA 98008View Listing
$2,688,0003264 112th Ave SEBellevue WA 98004View Listing
$2,687,0001437 169th Pl NEBellevue WA 98008View Listing
$2,495,95015118 SE 40th PlBellevue WA 98006View Listing
$2,475,00015 Skagit KyBellevue WA 98006View Listing
$2,399,00033023 Rs UndisclosedBellevue WA 98007View Listing
$2,399,00016510 SE 61st PlBellevue WA 98006View Listing
$2,350,0002800 122nd Pl NEBellevue WA 98005View Listing
$2,300,0004460 Somerset Blvd SEBellevue WA 98006View Listing
$2,295,00013632 NE 42nd StBellevue WA 98005View Listing
$2,289,00010536 SE 10th LnBellevue WA 98004View Listing
$2,170,00010425 NE 28th PlBellevue WA 98004View Listing
$2,100,000110 174th Pl NEBellevue WA 98008View Listing
$2,080,00012623 NE 28th StBellevue WA 98005View Listing
$2,050,00013800 SE 44th StBellevue WA 98006View Listing
$2,050,00010202023 Res UndisclosedBellevue WA 98008View Listing
$2,050,0003825 140th Ave NEBellevue WA 98005View 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-10-2024 4:46:56 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