How common are partnerships where the more passive partner only provides capital and get a return after a given time period rather than % of cashflow permanently? 

A manufactured home is permanently attacked to a foundation.

Creative things sellers can do sell their house-Seller contributions-seller funded permanent buy down-seller funded temporary buydown-owner financing-contract for deed-seller second-lease option and lease purchase-wraparound and assumable mortgageTwo: creative things buyers can do to purchase a home-gift funding-selling and refinancing existing assets-nonoccupant co-borrowers-using a 401(k)-temporary IRA transfer-pledged asset mortgage-equity transfer and bridge loan-employer assisted mortgageThree: creative things lenders can do to finance a transaction:-lender funded buydown-Fannie Mae's my community mortgage-running scenarios with automated underwriting systems-adjusting amortization period to lower payment-adjusting interest rates to cover closing costs-state, province, and local grant or bond programs-mortgage credit certificate-private lendingAll the three players above, the seller, buyer, and lender, can bring creative solutions to the table to get a house sold." end quoteMost brokers don't know these either, or know them and don't inform - teach their agents.This is through my direct experience.

learned a good lesson on this one: In the future don't make a permanent decision based on temporary situation.

You may want to look into what it would take to place the home on a permanent foundation, giving up the title and selling it as real property.

One way to remember this is there are “Three M’s”:1) mobile home (DMV)2) manufactured home - used to be a mobile home, the wheels were removed and it was set down on a permanent foundation.

The intention going in was to purchase the property for cash, make improvements and furnish the property, then refinance it into a permanent long-term loan.

You mentioned it had been repaired in the past... what exactly did they do to repair it and was the repair actually permanent or just a "band-aid" solution?

Neither of these two will be available for investors in 2023 which means if you planned on converting to a permanent loan at sub 4% rates you will be met with a solid 6% or higher rate and if you need to extend/refi your bridge into another period, you will be met with 10-13% rates environment.  

Still other people could qualify for, and pay for a mortgage, but they prefer to rent for a variety of reasons...perhaps they rent because they don't plan to stay in the area permanently, they don't want the responsibilities of owning a property, they think that the properties are over-priced, etc., etc....