Create your ideal investor avatar. 

Our Ideal investment would be as follows (for context)Find an ideal investmentPartner A & B both review and agree on investmentPartner A or b or A and B apply for mortgage on investment (please advise on this)Partner A supplies down payment on investmentPartner B supplies all labor and materials to repair, rehab.

Yes waiting until it is rented is ideal.

Ideally while the walls were opened up I would have completed plumbing for 2nd and 3rd floor too, but I was living on the second floor and didn't want to lose having a usable bathroom and kitchen at my residence.

You are in an ideal situation.

Finding a lender,a good contractor, analyzing potential properties etc.Crazy cause I've been reading and watching videos about this for almost a year and have alot of knowledge, but still a little overwhelmed about where to start..lol what's the best way to look for a lender?

Search youtube for replacing whatever piece is broken, should be able to find a good video in a couple minutes. 

I suggest watching all the Del Walmsley youtube videos.

I sell dozens of properties every year and nobody has ever complained about my photos or video taken with my cell phone.

In an ideal world, I value cash flow over appreciation.