Q3 typically sees 1.48M home sales, but high rates and low affordability are cooling activity. Experts expect mortgage rates to stay between 6.5% and 7% through Q3.