How much on average are closing costs when you buy a house?

My and my fiancee moved into our house in October 2006. We have done some small upgrades like sod the back yard and painting. He will be getting a significant raise soon and we want a bigger house further from downtown San Antonio, TX. We moved into this house now because it was a promotional thing with no closing costs so we did not have to pay anything to move in. I need to know how much we need to save for closing costs on a house price range from 175-200 thousand. Also, do we need all the $$ in tha bank or do people often take out other small loans for closing costs? Sorry if this is a stupid question but I have no idea how it works. Thanks. I will choose a best answer.