When you cosign for a loan on real estate does your name go on the title of the property?

Only if you're going to be one of the owners.  A simple guarantor may have committed other collateral, and the lender would have you sign a separate security agreement naming the property being pledged.