Housing sector activity will likely slow sharply in coming months, according to Goldman Sachs economists, with price growth eventually falling to zero.