The Federal Reserve Bank of New York’s latest survey gives fresh insight into how consumers feel about the trajectory of the housing market.