Couldn't really have wished for anything better. In a beautiful area of the city, surrounded by many restaurants, drinking places and suchlike, but also really quiet (in February anyway). The building itself is phenomenal, but the apartment inside is clean, tidy, warm and homely. Marcos was a rerally good host - there was a problem with the shower while I was there (which can obviously happen) and he was upfront about it rather than try to hide it. The place itself was spotlessly clean, and the kitchen area was well stocked with a whole host of clean utensils. The view from the window was fantastic, and there were a few times I saw tourists outside actually taking photos of the building I was staying in.
If I was in Riga again I wouldn't hesitate to stay in the same place again.