I have carried back a second mortgage for my buyers, so that we'd get a lump sum and a small stream of income when we sold. 

Your dilemma is most-likely due to how much equity you have in the property, the property's income, your personal income, net worth and many more factors.For some reason, I think Canadians make some very good B+ movies and I try to watch every movie I see that is made in Canada.

I would love some advice from the pros out there - I'm really stumped on the best way to accomplish my goal...I have two businesses and want to purchase an office building under a new LLC and lease space to my businesses.However, what I really want to do is also have other tenants so that I will have multiple revenue streams.

@Alan Ouellette right you are, another way to think of it is “who owns the income stream and equity?”

Keep running numbers and finding new streams for leads, you'll know your deal when you see it. 

Since I'm good at finding undervalued properties in Orange County, I might find the best deal I can locally and maybe look for a home with ADU potential so I can create 2 income streams.

I was just wondering if anybody has heard anything about MISU (or Multiple Income Stream University)? 

Right now I am focussing on Memphis, Jacksonville, Alabama, Akron(OH)My goal is more inclined towards cash flow so I can build a stream of passive income and obviously I would not mind appreciation.

A great mix of different income streams with value add.

I believe a duplex is worth more to an investor, because when all things are equal between the duplex and the SFH, the duplex generates 2 streams of income, instead of one, that’s an extra door of income to cover partially for when the other is vacant.