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

Hawaii - PBOLIST Hawaii - PBOLIST

1 Listing results for 'Hawaii'