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

New Jersey - PBOLIST New Jersey - PBOLIST

2 Listing results for 'New Jersey'

No exact matches: "New Jersey"

Please check the spelling or try searching for something else

Showing 10-2 of 2 Listings