Workers looking for a place to live that offers a good combination of career opportunities and affordable housing are finding that the best options are not always the most obvious.