First of all if you are,as you say,attractive, but you aren't at all successful at attracting women, then you simply havnt found the right bar.
If the student union bar isn't working for you keep going to different ones til you eventually find one where you feel at home. Go there regularly,get to know the staff and make it your own.
But above all else learn to dance! Honestly,being ok at dancing and attractive is all you need. However this only works if you genuinely love music.
Anyway I'm sure you're not going to do any of that so-escorts.
This is a tricky one for me to answer because I really really want to help and I know a lot about escorts.
I'm one of those 'old,bitter men' who pay for sex. Except I hope I'm not bitter especially as I don't have anything to be bitter about.
See the thing is there definitely are escorts that would love to help you. The only problem is the really great ones can get addictive and you really don't want that because it will stop you learning to dance or whatever you decide to do instead.
If you are wanting to visit an escort because she is stunning once in a while that is probably better
However I said I really want to help and I have to agree with a few others on here. In your case I really think it would be a mistake. Quite a big mistake possibly.
A sex therapist is a far better option possibly. However I defer to anything the incredibly perceptive foo might have to advise on this matter.
I sincerely wish you the best of luck.