Housing Sector Navigates Divergent Sentiment Amidst High Inventory and Affordability Challenges