This would be my first deal (I already have a cash flowing SFR but it used to be my primary residence).

I have no idea what it would cost to get it removed and re-sided. 

Here is what I learned.Banks in my area will do VA, FHA, and usda loans on mobile homes as long as they're going to be the owners primary residence.

I am looking for a property than will generate positive cash flow but it seems that Oahu (my current residence for the next two years) might not be the best place to find a property that will do that.  

Eugene Rogachevsky Are you using it as a primary residence?

He was telling me about one of the new laws that was enacted this year that in order to avoid capital gains tax when selling a “personal residence” you NOW have to have lived in the property for 8 years.

The intent here is to purchase a new primary residence.  

By deferring maintenance, an investor gets a property that has not been maintained and therefore residents leave quickly.  

The network and broker you are with can certainly help boost your success, but in my opinion nothing replaces putting in the time and being creative with how you operate your business to show how you, as an agent, are unique to your clients (Investors, people planning to buy for their primary residence, etc.)I also have an REI mentor who has helped with my process a lot if you would like a recommendation.

It seems that you are trying to adapt this to your primary residence.