SELECT * FROM `properties` WHERE `status` IN ('1') and address like('%Oregon%') OR `state` = 'Oregon' OR `state_code` = 'Oregon' OR `city` = 'Oregon' order by totalView desc

Oregon - PBOLIST Oregon - PBOLIST

5 Listing results for 'Oregon'