On finding a room in a shared flat

Finally,I have arrived in Madrid yesterday. It all started with me waiting in line at the check in, knowing that I had way to much luggage for the 20 kg allowance. So, I spontaneously asked the nice couple in front of me as they only had a small backpack whether they would check in some of mine. And the lady did which saved me a great amount of money!!! To be exact I had 43 kilos, but to my excuse it wasn't easy to pack my life in two pieces of luggage... With a two hour delay we arrived in Madrid and I was picked up by a french guy who only a friend of mine knew. It was kind of funny and exciting to meet a complete stranger (we only had emailed before), but he turned out to be a really nice and friendly bloke. Poor him, on the way to town his brandnew videocamera was stolen on the metro. I still got all my stuff, but it was quite an extraordinary start at the police station to report his loss. Take extra care of your valuables on the metro in Madrid!!!
Later we went to the shared flat he has rented from September on and as he is returning to France tommorow until the middle of September I can luckily stay in his room until then. In the meantime I have to find my own room though which proves to be very difficult in this city. I've had a look around today, but rooms are tiny or haven't even got a window and above all are really expensive. Hopefully, I will have better luck in the coming days. Above all I already went out to a nice bar with other students last night and I absolutely love to be back in this "crazy" city!!!