SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Boa{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCity = 'Boa' OR prZip = 'Boa' OR prStreet LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Boa{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCountry = 'Boa') AND (prLocation LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Vista{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCity = 'Vista' OR prZip = 'Vista' OR prStreet LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Vista{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCountry = 'Vista') AND (prLocation LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Cape{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCity = 'Cape' OR prZip = 'Cape' OR prStreet LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Cape{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCountry = 'Cape') AND (prLocation LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Verde{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCity = 'Verde' OR prZip = 'Verde' OR prStreet LIKE '{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}Verde{8396f0db69c6417eef1dc77a09266a29628d3e22814bf661a3e00710a841f3b3}' OR prCountry = 'Verde')