Some good advice there already, note the nose hill park is also in NW. A big creational area. If you want to be a little closer to urban center, try tuxedo, mount pleasant, or charleswood.
The farther your get the more you will have to use the deer foot. Congestions is bad in rush hour as the airport expansion took over Barlow trail, which use to house some of the traffic.
If you want a true urban living, Kensington is your best bet while bein reasonable. Mission/Erlton(where I am) /inglewood/ Marda loop/ eau Claire/ are also great for no car living, but I don't think it's worth it if you work a the airport.
“I train every day of my life as they have never trained a day in theirs.” – Alexander Karelin