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

Maryland - PBOLIST Maryland - PBOLIST

5 Listing results for 'Maryland'