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

Colorado - PBOLIST Colorado - PBOLIST

3 Listing results for 'Colorado'