$200k purchase, $400k rehab, $800k appraised value (living in this one).  

Don't forget that you'll be required to pay for an appraisal and usually required to disclose if you've applied for additional financing on that property.

Can you waive the appraisal contingency if your confident it will appraise? 

After renovations were complete, the house appraised for $190,000.

Unfortunately the home appraised for $15k less than the owner wanted, we wouldn’t over pay, he wouldn’t accept the appraised value so we had to move.

I prefer to get an appraisal done so I can borrow through FNMA but lack of access is hampering that plan.

That means you can use the money up to 95% of appraised value, freeing up that 50k you want to use.Unlike a mortgage, where you're charged for the money as soon as the refinance is signed, with a HELOC, you aren't charged interest on money you aren't using.

Right now I am looking to connect with real estate agents, contractors, hard/private money lenders, property managers, and appraisers.

Rental Property - Loan under my name only119k mortgage with 5% interest $1246 payment, appraised at 200k-220kPrimary - Loan under wife’s name only205k mortgage with 2.7% interest $1470 payment , appraised at 220kWe plan on either purchasing another single family or a multi family up to 4 doors.Thanks all in advance Henry from Houston , TX

I also have had lenders say they are doing a desktop appraisal, which means outside only.