I'm particularly drawn to SFH's because they are easier to sell as ordinary people buy them, not only investors.

Particularly experience with affordable housing development via CMHC. 

Particularly new ones, who might not be able to spread their expenses over their entire portfolio.  

The 8-10% Investment option have many people had good luck with this and particularly anyone raising 100% of the money?

@Joe Cassandra - while the author is not entirely wrong, there's a component he left out - which actually messes up his hypothesis: many of the loan modifications involved new terms, particularly lower rates. 

I know of one lender in particular that will be opening back up their doors to offer stated on a primary residence. 

This particular house should have appraised at contract value for sure.

A quick look at their website is that its 'probably' tied to your house as a lien and would in fact need to be paid of at closing...but really you would have to look at the paperwork for the loan and see if it was structured that way with the property as collateral or if it was structured as an unsecured loan.I have no personal experience with how that company does their lending.Is there a particular reason you would not want to pay it off at closing?

This is a heated topic for a lot of people particularly if you are an agent.  

As far as using a Realtor, I am biased as I am an agent and feel we provide a wealth of knowledge and are particularly valuable to most home buyers and newer investors.