Nine metro areas, including Atlanta, Houston, and San Antonio are emerging as buyer's markets with rising inventory and growing seller concessions.