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

Maine - PBOLIST Maine - PBOLIST

6 Listing results for 'Maine'