This was a great apartment for our family of 4 during our 6 nights in Istanbul. The description and photos are accurate-- it has recently been completely remodeled. The bedrooms and bathroom are upstairs, and downstairs is a half-bath and a kitchen/living room with a huge TV, a video game console, and a very large DVD collection. There isn't a real dining area indoors, but there is a garden table on the patio, which is exclusively accessed by this apartment. All windows in the apartment face onto the patio/courtyard, so there is no street noise, and the call to prayer was very faint at night.
The owner was great to work with-- very responsive to all questions as we prepared for our trip and very responsive once we were there. He kindly prepared the flat with drinks and bottled water, fresh fruit, and a bunch of snacks at no charge. He also has provided basics such as oils and spices for cooking. In the bathroom he has every toiletry imaginable, including soap for the washing machine, and in the bedrooms there are nice slippers and robes for everyone. He also provided a metro card for us to load up and use.
The apartment is located on a side street that is not very picturesque, but it's only a few blocks from the main downtown Galata area. It's a 5-10 minute walk downhill to the T1 tram, which takes you directly into the Sultanahamet area. A word of caution-- the streets around the apartment are sometimes narrow and steep and the sidewalks are very inconsistent. You definitely have to walk a few hills either up or down to get anywhere.
The owner arranged transport for us from the airport (which we were glad to have, since the roads around the apartment are confusing at first), and our return trip to the airport. Note that the traffic in Istanbul is really really bad, even on a Sunday afternoon, and you should give yourself at least 75-90 minutes to get to the airport.
I might give the apartment 4 stars, but the owner's attention to us makes me give it 5 stars.