The apartment is in a great location for people looking to discover Istanbul. It's within walking distance of tourist areas/locations but also to 'cooler' areas where you can get a sense of what life in Istanbul is really like. There are many fantastic restaurants and places to eat nearby, and the entire area is great.
The photos of the apartment are extremely accurate, it's big, modern, clean, and super cool - I especially like the little sunroom/enclave looking over the street.
The only issue, which has been stated already, is that it's very noisy at night, which can make it difficult to sleep. The hosts are kind enough to provide earplugs, but if sleeping with noise is an issue for you it could be tricky.
Otherwise, 100% recommend.