Average housing prices are moving lower, with "pockets of opportunity" for potential home buyers arising as mortgage rates get higher.