SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}La{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'La' OR prZip = 'La' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}La{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'La') AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Finca{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'Finca' OR prZip = 'Finca' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Finca{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'Finca') AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Golf{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'Golf' OR prZip = 'Golf' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Golf{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'Golf') AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}and{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'and' OR prZip = 'and' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}and{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'and') AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Spa{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'Spa' OR prZip = 'Spa' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Spa{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'Spa') AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Resort{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'Resort' OR prZip = 'Resort' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Resort{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'Resort') AND (prLocation LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Spain{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}Spain{e947c2b8e1d84d7a51b9d4e1265f1c99f60bbbeec147d9140afcf0c69c526bae}' OR prCountry = 'Spain')