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

New Hampshire - PBOLIST New Hampshire - PBOLIST

4 Listing results for 'New Hampshire'