I took a housing loan from the bank for a 20-year period. Four years have passed, and I recently learned that this loan is usurious. I wish to perform Umrah. Am I permitted to perform it? If not, what should I do?
You are permitted to perform Umrah. Strive to repay the debt in hopes of reducing the amount of usurious interest. Allah Says (What means): "And there are others who have acknowledged their sins. They had mixed a righteous deed with another that was bad. Perhaps Allah will turn to them in forgiveness. Indeed, Allah is Forgiving and Merciful." [At-Tawbah/102]. And Allah Knows Best.
Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].
Is Zakah (obligatory charity) due on leased property, and how is it calculated?
Zakah isn`t due on the leased property itself, but on the saved income from that property if it reached Nissab (minimum amount liable for Zakah), and a whole lunar year had lapsed over saving it.
Is supplicating in Qunoot, at times of affliction, during obligatory and voluntary prayer a Sunnah, and should it be done before Rukoo` (bowing), or after it?
At times of affliction, it is a Sunnah that Muslims supplicate in Qunoot after the final Rukoo` of each obligatory, or voluntary prayer as individuals, or in congregation.