To answer your question. Here, your friends, various real estate sites. But any and all of these will be knowledgeable in one area and lost in another. You should identify the area and i can direct you to an agent in that area or if it is one of mine, help you myself. Great question even if too broad.
Benny Smith 412-498-7868.
I have been a City of Pittsburgh resident most of my life and was a police officer for the City for ten years. I have taken classes given by the URA and City of Pittsburgh living. Well rehearsed in the neighborhoods.
There are many resources available, it really depends on what specifically you are looking for and in what areas. A good real-estate professional does not claim to know everything but knows how to find out and what questions to ask.