Best revitalizing neighbourhoods to invest in right now?

[Tetsuo]

I think Hastings if thinking long term is going to be a solid investment, either SFH or commercial lots fronting the street.

Its cheap right now and would skyrocket if it ever gets a transit line.

I'm personally looking at Gastown/DTES/Chinatown for a studio/living/work space since I appreciate higher ceilings, and I do appreciate the nightlife in the area for someone in their 20's.
Looking at SFH I still havn't decided but am looking towards New West/Surrey/North Delta/Coquitlam/Langley. Lesser extents Burnaby/Vancouver

The problem with the big non pedestrian friendly condos at BrentWood, Surrey Central, Marine, Metro is that the condo supply will keep on growing since there are plenty large lots to redevelop into towers. Oakridge manages to avoid this since the area is surrounded by NIMBYS and small lots.

Just my 0.05 cents