Does this completely prevent the tax lien holder of getting additional gains after foreclosing? 

However, for long-term holders who need liquidity, it could be a viable alternative.-----1.

I am on a visa and am interested to find out how much I can afford and use it as guidance on type of commercial property to research in to as this would also be my first investment.ThanksMallik welcome to austin!

Sometimes an $800k 4-unit could be a better return than a $300k 2-unit...or visa versa. 

By the way - for the same reason the 1st position lien holder will be uneasy with 100% CLTV, as a buyer I would be uneasy with it as well.

Many voucher holders also work and so sometimes they will have a higher amount to spend than someone who doesn’t work because they can pay up to a % of their net income from the HA’s calculations, often 30-40%.

The permit allows holders to work or study, as well as to travel in Schengen countries.

Quote from @Victor Correa: Have a deal, subject to mobile home with bank lien, Not payed off, Seller just bought 2 years ago & I am taking over but reading about the title transfer need consent from lien holder.

For example, would a temporary work visa qualify?

Whenever I have used seller financing as a buyer I always put in the note that the note holder must give me the first right of refusal to purchase my note at the same discount they are selling it at.