SELECT *, CASE WHEN `name` LIKE "beaverton%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "beaverton" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "beaverton" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "beaverton" 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 = "OR" AND (locality IN ("beaverton") 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 56
Blah
SELECT *, CASE WHEN `name` LIKE "beaverton%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "beaverton" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "beaverton" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "beaverton" 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 = "OR" AND (locality IN ("beaverton") 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 56
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,500,00010050 NE Walker RdBeaverton OR 97006View Listing
$2,200,0004870 SW Lombard AveBeaverton OR 97005View Listing
$1,750,00015865 SW Nora RdBeaverton OR 97007View Listing
$1,450,0008923 SW Marseilles DrBeaverton OR 97007View Listing
$1,374,00018317 SW Ewen DrBeaverton OR 97003View Listing
$1,300,00015075 NW Pioneer RdBeaverton OR 97006View Listing
$1,150,00017350 SW Bany RdBeaverton OR 97007View Listing
$1,030,00018281 SW Florendo LnBeaverton OR 97007View Listing
$999,00017112 SW High Hill LnBeaverton OR 97007View Listing
$995,00013525 SW 31st StBeaverton OR 97008View Listing
$975,000560 SW 144th AveBeaverton OR 97006View Listing
$970,00010936 SW Lindenwold CtBeaverton OR 97005View Listing
$949,9508881 SW 176th Ave Unit 15Beaverton OR 97007View Listing
$949,500500 NW 167th AveBeaverton OR 97006View Listing
$945,00012255 SW Silvertip StBeaverton OR 97007View Listing
$944,00012325 SW Silvertip StBeaverton OR 97007View Listing
$939,9508911 SW 176th Ave Unit 17Beaverton OR 97007View Listing
$939,50016610 NW Mission Oaks DrBeaverton OR 97006View Listing
$925,00011353 SW Meadowlark LnBeaverton OR 97007View Listing
$919,9507791 SW Thornbridge Ter Lot 7Beaverton OR 97007View Listing
$909,9009745 SW 160th AveBeaverton OR 97007View Listing
$900,88912155 SW Silvertip StBeaverton OR 97007View Listing
$899,9957704 SW Millerglen DrBeaverton OR 97007View Listing
$899,95019855 SW Gannon Ln Lot 4Beaverton OR 97007View 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 8:30:29 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "OR" 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 56
Blah