Excellent location for visiting Istanbul for the first time, close to all the major sites.
Pictures reflect reality, even though the apartment seems to be in a better (newer) state on them than reality. It is most obvious in the bathroom, it could use some refurbishment, walls could also need painting.
The wifi access in the room is not only slow but also not reliable, especially when used on multiple devices. You may be better off buying a local SIM card to avoid annoyances. (And yes, that corkscrew mentioned by someone above is still broken :) )
Good value for the money though and I'm sure the place will be improved when possible