An exchange student, looking for an affordable accomodation, Around the University of Cologne!

My name is ŞUAYP and I am an exchange student at master's from Turkey. I need a room for 6 months starting from early march! I am not only looking for a nice room or an affordable accomodation but also great friendship! I lived in a flatshare for whole of my bacholars so I know how these things works. Thus, I am really good at cooking, cleaning etc. kind of stuff since I am experienced. As a responsible and thoughtfull adult, I strongly believe that I could be a really good flatmate and also a friend! If the flat has a nice kitchen(with dishwasher), bathroom(with washing machine) and the room has all the basics what would be enough for me. Location is not so important but if its close to the University of Cologne(or not longer than 20-30 min via public transportation) that would be wonderful! Hopefully the rent wouldnt be higher than €400! Thanks for your concern!