We enjoyed staying at David's place. It's super close to the metro, a supermarket and different restaurants. It has an amazing view over the city and it's super close to Estadio Santiago Bernabéu.
David was a great host.
It was a bit cold at night, because we visited in the winter, but if you bring a pair of socks and some clothes to sleep in, you'll be fine :-)