"Here is the guest room."
Translation:Burası misafir odası.
Burası = This place
Burada = IN this place
Only "Burası" works in this context.
"Misafir odası." because you have two nouns. When you have more than one noun, the last noun needs to be in the 3rd person possessive. If you have more than 2 nouns, the middle ones can be left in nominative at will. For example:
Student exchange program application form = Öğrenci değişim(i) programı başvuru(su) formu.