Some people would avoid Hucknall completely but I think it's ok, great access to the city centre with the tram and the train (12 mins) but close to the countryside as well. We're in Hucknall and our local pub is actually in Linby which is a lovely little village.
Nicer areas I would say are most of the north east bit, Papplewick Lane, Vaughan Estate (Haydn Lane), Linby Road.
Then the area round Farley's Lane, Shortwood Avenue is quite nice.
Wood Lane, Garden Road area is fine too.
Would avoid Ruff's Estate, area round Broomhill Road and centre.