Good areas near city centre: Denniston, Alexandra Parade, West end, Rutherglen.
Horrific areas: Maryhill, Castlemilk, Easterhouse. Most places on south and north side can be quite dodgy to be honest...
Unless you work as a diamond merchant I'd drop your idea of living in the G1 postcode mate...