The Best Laid Plans of Mice and Men

So here's for an update on how our plans for moving are going.... have you ever read Rabbie Burns poems? Well, do you remember the one that says, "The best laid schemes o' Mice an' Men, gang aft agley"? Well, certain things are going agley!!!!!
Paul and I had a nice little flat that we were going to be renting over in Scotland. We needed it straight away so my immigration papers could go through. So we found an inexpensive flat near downtown, close to a mall and the train station. The guy renting the house out to us was a neighbor of my in-laws so we trusted him that the place had nice neighbors who were concerned about the noise the previous tenants were making and that it was a suitable place for us with the family. So, a couple days ago my in-laws get the keys early to clean up the flat and get it ready for our arrival. Nobody had seen the flat before other than the nice photos we saw on the website. We did kinda find it a bit odd that he wasn't letting the family over there take a look at the place until he was ready to hand over the keys and have them clean it up, in fact it was rather frusterating.
My in-laws found that the front door to the stairwell was broken and wide open, the back yard had heaps of garbage in it (at least 4 couches, fridge freezers, bottles, bags of garbage, etc. and this was all in front of toppled over wheely bins that we were meant to put garbage into and put out to the curb), inside the stairwell there was a closet with a broken door and garbage inside, in front of the door to our flat there was a mound of dirt, on the same landing they found a resident homeless man sleeping(he came inside to take shelter from the rain because he lives in the garbage heap out back). The door to the flat had been previously broken into and they could tell because there was a chunk in the door ripped out where the lock was before. From the inside you could see out through a large crack in the door. The carpets inside were light grey in the pictures we got but now they're brown. There's black mould growing in the living room. Later on we found out that the building is owned by a bunch of different people and they don't upkeep anything in the place. A couple of the flats are used to put people who say they are homeless into and in one of the places there are lots of different people coming and going all the time (drug house anyone?). In fact the people who were complaining about the noise were from the flats in the next building over(their garden looks beutiful).... and all this is just the beginning!!!!
Needless to say, we won't be living there.... in fact I'll make sure I don't even step foot on the street the flat is on, which is dissapointing because I had such high expectations of the place from what was said to us about it and the pictures.
Not to worry though, we already have other prospects for places.... but I think we'll just camp out in Paul's brother's living room so we can find a place that's suitable and see the whole place and not just pictures on the internet.