We were planning on staying in Nikitas place for 9 nights as a family of 3 but it did not work out for us and we started looking elsewhere after the 1st night.
It would be perfectly fine for a short stay, especially for young people/couples. The location is as good as it gets for exploring Riga.
Hopefully, Nikita can install some heavier curtains as the apartment is very bright and you will be waking with the sun if you are a light sleeper. And get some earplugs as it can be noisy with the traffic on the cobblestoned Dzirnavu st.
Other reviewers have already described any issues as well as positives. So nothing new to add.