A few years ago my friend was on the same landing as a brothel and drug dealers but you might not be as lucky as them.
Jokes aside it was a nightmare for them and the drug dealer's huge dog shat all over the landing. It hasn't got much better as far as I'm aware. Look Southside or Dennistoun for cheap flats. Good luck!