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