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

Rhode Island - PBOLIST Rhode Island - PBOLIST

2 Listing results for 'Rhode Island'