The U.S. housing market is cooling due to mounting economic uncertainty and affordability woes, but some regional markets are heating up—fueled by surging buyer demand and limited supply of for-sale ...