Questions & Answers about Mi primo está de visita en Madrid esta semana.
Estar de visita is an idiomatic expression meaning “to be visiting” as in “to be here as a guest.” It uses the verb estar plus the noun visita.
By contrast, visitar is the action “to visit” (a place or a person).
• Mi primo está de visita en Madrid = “My cousin is here visiting Madrid” (focus on his current status).
• Mi primo visita Madrid = “My cousin visits Madrid” (focus on the action of visiting).
The de is part of the fixed phrase estár de + [sustantivo] which indicates a temporary state or role. Similar examples:
• estoy de vacaciones (I’m on vacation)
• está de acuerdo (he/she agrees)
Without de, the meaning changes or the sentence becomes ungrammatical.