You must find people you want to work with and initiate the conversation from your end.

@Yoav Gilad, circling back to my initial questions, with that in mind, do you know of any sites or resources where you can source individuals who have outstanding medical bills or expenses? 

Unfortunately, upon doing some initial research (including on biggerpockets and reading Brandon's book on real estate investing), its not always feasible to invest where we reside - do you alternatives in mind?

The one I mentioned in the original post was one we never even went and visited because the initial approach to the property scared me.

While initially enthusiastic about the potential of the property, upon inspection, I found myself overwhelmed by the extent of work required for its rehabilitation.As a beginner in this field, I must admit that I feel ill-equipped to accurately assess the necessary renovations and calculate the total cost of rehabilitation.

my initial inclination is in line with both of yours: it's a slightly upscale community, property + type of traveler, so i would prefer a focus on making it great vs making it, in essence, 'cheap' per head.+ yes, that was also my initial reservation: a house that is filled with a bunch of beds is not a very interesting space.thank you for sharing that this isn't necessarily a mistake or the wrong way to go to build it out with a focus on design/experience more than utility.

Since we didn't necessarily have a say in who takes over the loan after the initial closing I thought we might be stuck with it.

There are variables that can have terminal rates lower than initial rates, supply and demand as well as interest rates are a few.

Then, look to rent it after the initial year.

Also great first name and initials!