selectcount(*) as aggregate from`resoapi_properties`where`CurrentPriceForStatus` between 1and1500000000000and ((`PropertySubType`like'%portland%'or`PublicRemarks`like'%portland%'or`City`like'%portland%'or`StreetName`like'%portland%'or`StreetNumber`like'%portland%'or`PostalCode`like'%portland%')) and`StateOrProvince` = 'OR'