Rising rates and nervous consumers have set up the housing market for its "slowest fourth quarter in a decade," according to one economist.