I have enjoyed a great stay at Kemal's place in Özyurtlar Nlogo. The apartment is very clean with photos being pretty accurate. You can find everything you need nearby from supermarkets to bottle shops, restaurants, shisha lounge, and live Turkish music (about 700 meters). The wifi connection in Kemal's place is fast enough for those who want to watch movies or have meetings during the day.
Kemal himself is a great host and very fast in responding to all your questions and requests. Kemal takes care of the registration process in the Complex and grabbing the access card to the building for you.
Only one recommendation for future guests - If you want to travel to Istanbul's city center using public transport "frequently" during your stay and return home at midnight or later, it might be exhausting a bit. But if you want to relax in Esenyurt, Bahçesehir, Küçükçekmece and Büyükçekmece like me, this can be a perfect place for you. There are plenty of shopping centrs around Esenyurt Meydan. You can find almost everything in Akbati ALM if you want to buy clothes, shoes, electronics, etc...
Thanks again Kemal for hosting me! :)