Builder sentiment in the market for single-family homes tumbled in September to the lowest level in two years, indicating the housing market is officially in a recession.