The "Bahnhofsviertel" is definately the most intense area in Frankfurt am Main. There are loads of bars and nightclubs and the city's diverse scene is located here.
My small, cozy room is in the heart of the red light district, two minutes far from main train station(by foot). It is a shared flat, but you really have your private zone.
Views from the room = Europes unique skyline.