Do I have to be in San Miguel for closing?

The Short Answer

No. However, you will need to give someone a Power of Attorney (POA) so that they can sign on your behalf, in person, on closing day.

If you are a buyer, there are some occasions where someone can sign on your behalf as gestor oficioso with no POA required, but a seller always has to have a POA. 

A POA can be completed both within and outside of Mexico. 

To learn how to create a POA and for more details, go to The In-Depth Answer.