I know that there are low down payment loans for primary residence.

So, if I am putting down say 20 percent on a new loan for a vacation rental, my realistic goal should be "Let other people pay off the rest of my investment for me."

Is there an existing loan on the building?  

The lease (with the current college students) was just renewed through their 2025 school year.I'm trying to figure out how to make this happen with little-to-no money down, as I have other 'irons in the fire' at the moment.I'm planning to offer $400-450k for the home, and am trying to structure something where a conventional lender would loan an amount that would be covered by the current rental rate (lets just say $300-350k)...   ...then, anything outside of that amount, would be carried by the Seller (for a short while)...   ...Seller financed with a ballon in 5-years?  

Could limit access to favorable loans and insurance on a new primary residence in the future.

Portfolio loan through a local bank that we have a good relationship with.

No idea how to deal with the 2021 originated underlying mortgage loan with the owner's share of the current principal due of $200,000.

Most lenders should be able to have both of these loan products.

Trailers and fabricated houses have their own loan programs called Chattel Loans. 

I'd look at population growth and job growth next.Cash flow is not only a function of the rent and purchase price, but also that of your loan value.