https://api-prod.corelogic.com/trestle/odata/Property?$filter=(concat(concat(StreetName, '-'), City) eq 'Brickell Ave-Miami')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency
The concat function with string parameter values returns a string that appends the second parameter string value to the first. The concat function with collection parameter values returns a collection that appends all items of the second collection to the first. If both collections are ordered, the result is also ordered.