https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=contains(toupper(StreetName),'MAIN')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent
Filter on a string field value that contains a certain value. This is case sensitive