They definitely exist here.

Build mobile home on the vacant lot I understand the cost involved for rehab the existing house.  

If I buy a property with tenant in place, do I need to inherit the existing lease terms?

High interest rates are preventing existing homeowners from selling, so Buyers are turning to new construction homes.

Frame it as, "This Lease exists so we all know what is expected of us, and what we can expect of each other.

the simple reply to your question is they do not exist  except for very experienced repeat clients. someone with no experience or very limited experience is not going to get a true no money down HML..

I will move out of my existing unit and into the new one.

Wrap the existing mortgage, as suggested... or take a balloon second for your equity.

I'll explain...When you purchase a property with existing tenants, who have a lease in place (in MN you can also have verbal leases), you'll inherit those tenants and the leases they signed with the seller on closing day. 

If you want a true duplex, you'd also need to make sure zoning would allow it vs adding a legal suite.Why not just buy an existing duplex?