SELECT *, CASE WHEN `name` LIKE "wilsonville%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "wilsonville" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "wilsonville" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "wilsonville" 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 ("wilsonville") 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 *, "0" as `rank` FROM `wp_slides` WHERE st = "OR" 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 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.
$795,00032335 SW Lake DrWilsonville OR 97070View Listing
$792,99028241 SW Orleans AveWilsonville OR 97070View Listing
$791,78027286 SW Marigold TerWilsonville OR 97070View Listing
$791,35527131 SW Trillium LnWilsonville OR 97070View Listing
$789,99011253 SW Berlin AveWilsonville OR 97070View Listing
$767,99011223 SW Berlin AveWilsonville OR 97070View Listing
$766,99028219 SW Cherbourg LnWilsonville OR 97070View Listing
$764,99028265 SW Orleans AveWilsonville OR 97070View Listing
$760,0007161 SW Fallen Leaf StWilsonville OR 97070View Listing
$755,99011661 SW Barcelona StWilsonville OR 97070View Listing
$749,9906508 SW Lupine LnWilsonville OR 97070View Listing
$749,90029070 SW Monte Carlo AveWilsonville OR 97070View Listing
$749,00027837 SW Painter DrWilsonville OR 97070View Listing
$740,00028633 SW Coffee Lake DrWilsonville OR 97070View Listing
$709,9906628 SW Lupine WayWilsonville OR 97070View Listing
$699,99027424 SW Marigold TerWilsonville OR 97070View Listing
$695,00011099 SW Parkview DrWilsonville OR 97070View Listing
$674,99011701 SW Barcelona StWilsonville OR 97070View Listing
$673,00030597 SW Orchard DrWilsonville OR 97070View Listing
$660,00028468 SW Wagner StWilsonville OR 97070View 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-07-2024 4:50:19 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