is why they want a payment plan.. personally I would take them up on it. 

Or we gradually perform high-quality updates for a live-in flip, then roll the equity into a new home.Regarding rental income, we aim to boost income, lower our effective tax rate by generating more low tax-drag income with rental income (since there’s not much we can do to lower out W2 tax bills) and have retirement cash flow.To compare the financial impact over 10-20 years, we want to analyze renting versus flipping.

My father-in-law told me he plans to sell his 6 unit condo building ASAP so he can "retire" from being a landlord.

My goal is to achieve financial freedom through house hacking and long-term rental properties.

It might take a large financial institution with capital for “brainpower” and marketing, and financial and reputation strength to design as well as create a trading market for this type of security. 

A good real estate accountant can save you thousands of dollars by leveraging entity selection and formation, tax deductions, cost segregations, bonus depreciation and tax planning.I recommend finding an accountant who specializes in real estate taxation, business taxation, financial planning and tax planning.You may want to consider working with your accountant remotely to expand your options.I would also recommend looking for a accountant willing to work with you throughout the year.

However, I don't like the fact that properties they will show me, they will have a financial interest in, because it could affect my purchase negatively. what are the pros and cons of going with an agent that requires dual agency vs. not?

With some proper planning and the funds to lock in materials early, you can have an efficient build, but certainly not fast.

They love the idea of wealth, financial freedom, but don't want to put their own financials on the line.

If your entity has several years of operating history and good and reliable financials, you may be able to find something.