The good ones will have access to off-market deals. 

Everything was progressing smoothly until I met the appraiser to provide access to the property.Right away, I sensed something was off.

One thing to be aware of, and I hope that this never happens to any of you guys, is my connected bank link somehow failed or became disconnected?

So, a tenant can better tolerate small yearly increases rather than holding off and giving them a large increase further down the line.

Bunch of realtors come on a spout off that their clients cash flow from day 1 all the time.

Quote from @Simon Horowitz: I'd love to connect on here with trustworthy contractors that I can bounce ideas off. 

All of these assets are paid off.

There are good relations with the neighbor so this likely wouldn't be terribly difficult to pull off, but I haven't ever developed a property from scratch so I would definitely like the opportunity to partner with someone on this to help ensure the success but first I want to finish the smaller property to have sufficient funding available if it is needed.

However will I be biting off more than I chew with this one? 

If it is only one flip for now, I suggest you find a CPA just to advise you on State filing requirements, ensure you are claiming all write-offs and issuing 1099s, etc.