The housing market remains tight, but the price of entry is surprisingly low in many profitable vacation areas.