Honest opinions and help thanks

so I'm looking at relocating to Nottingham in the near future.

I don't know a great deal of the areas but the things I'm looking for are:

affordable.

not a rough area (I'm not a ponce but I also don't want to have an issue every time I go out)(we are moving away from a place like that)

has good connections to the main city (center)

I have a family member in Gedling and have looked around there but not much going house/Flat wise round there atm.

please no wind up answers as time is of the essence with this. thank you.