What specifically are you wanting to know? There are a lot of things about the city that would be dependant on your preferences, like are you going to driving or using public transport, do you have kids, do you prefer quiet, do you go out a lot, how much are you looking to spend on rent/mortgage, etc.
Overall it is a decent city. As already mentioned, it is very, very much a party town so if you are going to be anywhere near the city centre it can get very loud and sometimes dangerous due to the sheer volume of intoxicated people out on the streets.
The Quayside is nice and the bridges are a beautiful sight. We live on the Quayside and it is nice because its still within walking distance to everything but not right in the thick of it all.
The West end is quite rough and I would avoid that area if I were you. Further afield there are lots of nice little suburban type neighbourhoods. Gosforth and Jesmond are very nice leafy sort of areas with a high proportion of students so lots of little trendy bars and restaurants.
The people tend to be nice, but again, it is very much a party city so night time sometimes brings out the not so nice side. The accent is a bit hard to adjust to if you're not familiar with it. Um... I think that is all the generic stuff I can think of but if you have any specific questions, feel free to let loose
