It depends on your risk threshold, what kind of deals you can get, and your opinion on the future of interest rates.Personally, I prefer home equity loans (fixed interest, fixed term) in this environment as I have ample deal flow.

What advice does anyone have for someone who's enthusiastic but at the same time clueless in his new environment

Understood the current market and interest rate environment may be difficult to navigate. 

Tenant agrees and acknowledges that the Premises to be occupied by Tenant shall be designated as a smoke-free living environment.

I agree  on the above but as an investor in this raising rate environment, asset-based (aka DSCR loans) are the way to go irregardless of Partnership or Solo venture purchases.

I also didn't have a team in the other location, where I did have contacts and handymen in the local environment. 

Short not all inclusive summary of regulations:You need a Zoning Permit for limited lodging to rent your home for up to 30 consecutive days to any one person or group.

Market savvy with a knowledge and understanding of current the economic environment and how to tax strategize for the future.5.

This isn't inclusive but should give you a good start.

Factories reduced production of everything during COVID getting ready for a recession type environment that never appeared.