You get the title for your house once you officially own it. However, since the title is a concept that reflects ownership of the property, you won’t necessarily obtain a physical title for the property you buy.
If you want to obtain a copy of the deed (the legal document showing you own the property), you can request one from the appropriate office of your local government (county recorder, county clerk, recorder of deeds, etc.). You can also hire an attorney or a title company to acquire a copy for you, but you’ll probably pay a fee for this service.