https://sparkapi.com/Reso/OData/Property?$filter=City eq 'Holland' and (PropertyType eq 'Residential') and toupper(StreetName) eq 'MAIN'&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City,StreetName
Convert a string to upper case (toupper). Lower case would use the function tolower().