A couple of "simple" ways to help mitigate this problem is to make sure that you 1) find and buy a deal well below actual market value and 2) have ample cash reserves.

As long as we have ample, healthy cash flow, we can service our debt and cover our expenses which allows us to hold our investment.

I'll assume you gave them ample warning before they signed the lease that construction was going to be done in the other unit.Most areas have city ordinances for the days and timeframes when construction is allowed. 

probably not what you want to hear but no experience and 100% LTV and 100%  rehab funding simply is not in the market place.. the only people that will offer that I will say with 99% accuracy are scammers telling you what you want to hear to beat you out of small amount of due diligence money or application fees and will never fund.. this simply is not attainable nor SHOULD it be..

I am trying to map out the best way to attain the best return on my money.

Your strict management combined with the reinvestment of ample cash flows should turn the eyesore into a nice park.

Since lasting relationships with people whom I can help attain business goals through funding is what I'm looking for in a social site, naturally BiggerPockets was a no-brainer for me!

Just have ample reserves while you get a handle on things and you will be good. 

Like all of you, I dream of attaining "financial freedom" and after doing research on the many different investment paths, I have been convinced that RE investing is the best option.

There is some level of difficulty to attain high income or high net worth.