When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
Is it a condition that a woman should untie her locks while making Ghusl (ritual bath)?
Ghusl from Janabah (ritual impurity), or menstruation obligates that water reaches the roots of the hair in order for the Ghusl to be valid, but if it doesn`t, then hair locks must be untied for water to reach them, and for Ghusl to become valid.
Is it permissible for a man to wear transparent clothing?
It is not permissible for a man to wear transparent clothing that reveals his 'Awrah (the area that must be covered). The 'Awrah of a man is "from his navel to his knees", and modesty is more prudent. And Allah Knows Best.
What is the ruling of Sharia on marrying the maternal niece of one`s wife?
All perfect praise be to Allah the Lord of The Worlds. May His blessings and peace be upon our Prophet Mohammad and upon all his family and companions.
One may not combine in marriage a woman and her paternal aunt, or a woman and her maternal aunt, as stated the Prophet (PBUH). And Allah The Almighty Knows Best.