Housing prices in most major U.S. metro areas are still on the rise as affordability remains a central topic for buyers.