You can go to http://www.rosarychurchqatar.com/ to check out the mass timings. Its located in Abu Hamour next to Barwa Village. Its about 30 mins or so away from QNCC if you take the new express way. There are no hotels close to the church that i can think of..but there are a few in the city and one on Airport road.