Most homeowners are still making a profit on the resale of their home, but the tide is expected to slowly turn as prices begin to drop.