The view is exactly as pictured, not too far from the East/Sphinx entrance to the pyramids complex and close enough to hear/see the nightly light show if you strain your eyes and ears a bit. The location is a little hard to find at first and it's almost impossible to reach the apartment manager by phone most of the time, but the neighbors are wonderful and super helpful. We grew to consider them very good friends and look forward to coming back just so we can visit them again (though you should be aware that you may be expected to pay some of them quite a bit for their services).
The apartment itself is more than adequate for most of your needs, but there are no hand towels, wash cloths, toilet paper, soap, or anything else along those lines, so it's difficult to wash dishes, etc. and you will have to use bath towels for your kitchen needs. Be prepared to buy or bring all of your own amenities. Also, the WiFi is extremely slow, when it works at all. One of our group members needed to work while on vacation and was unable to do so because the WiFi was insufficient. She ended up relocating to a hotel for the last few days of her stay (she's also a light sleeper and the street noises can be a bit loud throughout the night, so she struggled with that, as well).
Checkout time was flexible, so that's a huge plus when flights leave late at night, but make sure you're prepared to pay the remainder of your reservation fee in cash or via PayPal, because no other form of payment is accepted.
All in all, it was a great stay and I would come back again just to visit our new friends. And March was a great time to come. The crowds are smaller and the weather was great. Take a jacket for in the morning but otherwise the temperature was perfect!
And, if you want to do any sightseeing tours, ask for Ehab. He took us to Alexandria, Saqqara, and anywhere else we wanted to go, and his rates were competitive based on my research, but he was way better than any of the other guides we encountered at the various sites we visited.