No matter what your vacation preference are, there are homes available to purchase that can provide you with a place to rest in between your adventures.
If you are purchasing it to live in as your primary residence, called owner occupied, you generally get more favorable loan terms than if you are purchasing it as an investment, called non-owner occupied.
If you are able to afford the costs of the second home without renting it out, lenders will often offer you the same or similar terms to an owner occupied mortgage.
If you have to rent it out to cover the costs, however, it is viewed more like an investment property and you can expect to pay slightly higher interest rates and provide more documentation during the purchase process.