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

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. 

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?

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

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

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.

Based on what you shared you are not financially qualified to own real estate.

I would think in most situations the original owner is in financial trouble, probably delinquent on their mortgage and facing foreclosure.

Quote from @Devin James: Im currently learning this lesson with New Builds that have taken twice as long to complete than anticipated.....Finishing a Real Estate project ASAP is critical because...1) Holding Costs add up quickly- Loan Interest- Property Taxes- Insurance2) Investor Capital- Our financial projections are dependent on how fast we can turn our investors capital.

I’m happy to be in a forum with fellow investors and people wanting to master real estate.  I enjoy hearing about peoples’ personal wins and innovative, creative strategies.  I hope to be able to contribute to other p...