Is there such thing as an Attractive Nerd?

Yes. A lot of girls are looking for someone just like you and have no interest in frat guys or jocks. Stay away from sorority girls. Try joining a club or group that is centered around one of the activities you like such as moves, art, books, hiking etc. Also, be open to widening your ideas about what you think is an attractive girl.