I must say I agree with the 2 previous posters. However, if having rec facilities close by where you wouldn't have to load up the car might offset the disadvantages of living in your neighbour's pocket.

I would suggest if you go the compound route try to choose one that has a private yard (either front or back) that at least you can decompress a little. Some of the older compounds have bigger yards (but maybe fewer facilities) - there's one behind the Ramada where the person I visited had a smallish grassed back yard with high walls - I was very envious.