Very good location, very close to Bahnhoff Oerlikon, so you have a good amount of connections to anywhere in Zurich and sorroundings with trams, S-Bahn or buses. Since it is by a main road, it could actually be a bit noisy for some people, you can really hear the trams passing by, but it was not a problem for me and I think it will not be for most people.
The close sorroundings have several supermarkets and shops to buy anything you may need.
Kitchen is well equipped, but there is no microwave, which I missed.
The rest of the apartment is actually quite ok, two big rooms with big beds, and a main room with a big table and sofa. Bathroom is ok, although sometimes there was a bit of bad smell.
The doors open using an app for the smartphone, you need either internet or bluetooth. It is not difficult, but I had to ask for clarifications. Make sure you have your phone with batteries...
The tv uses an Apple platform. I did not use, I do not know how these platforms work.
All in all, relatively good price for the city of Zurich, which is actually a quite expensive city. I would repeat.