In short, I think this apartment has a lot of potential and the location is great, but I think it needs some extra effort in cleaning and equipment arrangements (including dish soap, having the dishes in the kitchen and not in the bedroom closet, improving bathroom drainage) and some safety fixes (loose floor panels...).
I think once these are cared for, this could be a very nice apartment for a short stay. Perhaps price needs be adjusted too.