Mortgage rates that have doubled over the past year are sapping demand from the housing market, which saw price growth decelerate at the fastest pace on record in August.