I 100% agree with what @Travis Timmons says above, his journey described above mirrors mine a lot, albeit his numbers look a little better haha! I did a value add on my first property that got out of hand but now does well. Recently went into contract on my second that is mostly a facelift with room to add 2 bedrooms into existing floor space, which should be possible for <$25K. I don't even consider anything that can't fit at least 4 bedrooms, your competition shrinks dramatically at 4+ bedrooms and your revenue potential hockey sticks. I also look for game room space. 3 bedrooms that can't be expanded are the squishy middle because it's too big for a couple and is priced higher accordingly, yet is also too small for more than 1 family. IMO you are better off with either a small 1-2 bed unit that is easy to clean, economical and is great for 1-2 people or a 4-5+ bed property that fits lots of people. Which isn't to say that a 3 bedroom can't do great because many certainly do, but for that money it is a small premium to get 4+ beds with much more potential.
I would also emphasize that you may want to keep your vacation and businesses separate. With personal use you are taking money off of the table by taking the space of paying guests, especially if it's high season. The exception to this would be if you plan to retire there eventually and/or you enjoy being there during the slow season.