nose piercing

last year at this time, I got my nose pierced and I stupidly went to the mall to get it done with a piercing gun. of course, it got swollen and painful. I made it to the point in which they say you can switch out the piercing. so I put a ring in instead of the original stud. That was soooooo much better and more comfortable. anyway, shit happened and I stupidly took out the piercing and then couldn't get it back in...so I let it close. now, here I am a year later and I really want to get it done again. but this time, I want to get it professionally done with a needle, not a gun. my question is, how much did you pay to get your nose pierced with a needle? And was it painful??