Home buyers are finally seeing a light at the end of the tunnel, but it is going to be painful for homeowners and sellers