Is it permissible to offer prayer at home, or should it be offered in the mosque?
All perfect praise be to Allah, The Lord of The Worlds. It isn`t preferable for the man to pray at home as praying in the mosque is twenty seven times more rewarding. Therefore, this should motivate him to offer prayers in the mosque. And Allah Knows Best.
What is the Du`a (supplication) of Istikhara (guidance prayer)?
O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."
A person prays in a certain spot within the rows of the mosque, and gets angry if someone else prayed at his spot. What is the ruling on this behavior?
All Perfect Praise be to Allah The Lord of The Worlds and may His Peace and blessings be upon our Prophet Muhammad and upon all of his family and companions Prophet Mohammad (PBUH) make it prohibited for a Muslim from having/taking a certain spot in the mosque when performing prayers if they arrived and find it occupied, furthermore; it is the religious duty on others (praying people) to offer a piece of advice to alert the ones who don't know, that whoever reaches a spot first at the mosque having a priority/privilege upon others in that spot. And Allah Knows Best.
In our region in southern Oman, specifically in the city of Taqah, there is a mosque that they say was built hundreds of years ago. This mosque is surrounded by graves, meaning it is in the middle and the graves are around it. People in our area differ, with some considering it permissible and others considering it forbidden to pray there. Moreover, my grandmother saw in a dream that she entered this mosque..."
Praying in this mosque is valid and and there is reprehensibility in its location so long as no grave exist within it. Besides, Sharia rulings aren't derived out of dreams. And Allah Knows Best.