Remote workers living in expensive cities drove relocation activity over the summer, as they have the flexibility to move to more affordable locations, a Redfin report said.