I agree with you in that landlords should be exploding over this.

I've watched several areas break ground for a mall or condos seemingly in the middle of nowhere to have it only explode 3 years later.Example( and this is magnified) my first investment was in framingham as it was being dug out of a hole...but the surrounding towns east toward boston were getting cramped and overpriced-I got a location within a mile of 2 commuter rail stations and within 10 minutes of the mall and local university. 6 years later its worth double what I paid and unit 2 covers the entire mortgage - taxes and all!

With the amount of wholesalers stepping into the industry, and the creative financing frenzy exploding into the market, how does everyone go about sourcing the ideal opportunity?

Toilet supply line exploded..)

There are plenty of great areas in Philadelphia to flip, buy/hold, etc. but I think Brewerytown is poised to explode over the next two years.

Usually once a year I find one that is ready for prime time articulate knows what they heck they are doing and is just a capital partner away from exploding.. 

A couple years ago, we bought a flipped property to use as a rental (this was before the market exploded and you could actually get a rehabbed property that cash flowed). 

BRRRR = Buy, Renovate, Rent, Refinance, and RepeatTurnkey and new construction sell for market price so you can't "refinance" and cash out the gained equity unless your market explodes and property values increase dramatically in a short time.You buy a fixer-upper below market value.

My brain is ready to explode from all this input but I want to succeed and create a better life for my family. 

You can make the numbers work, analyze properties all day long, and research until your head explodes but you need to know people in the area you are focused on.