After months of sitting on the sidelines, many homebuyers who were priced out by high mortgage rates and affordability challenges finally have an opportunity to make their move.