Sales of previously owned homes tumbled in August as home ownership became increasingly unaffordable for many prospective buyers thanks to higher mortgage rates.