With a foundation course, it doesn't matter what you got before that assuming you do well. I did my foundation course at Oxford Brookes and I got offers from Edinburgh, Newcastle and Southampton University even though my AS levels were three Ds and an A in Media Studies.
So with a foundation degree you can definitely do better than Southampton Solent.
And foundation courses are totally dependent on the university. Oxford Brookes' one has low entry requirements and you basically are a a university student for the entire year where you do 8 modules (just like in undergrad) at foundation level (and you get to choose, so you can choose business/technology related ones) and have lectures and all that just like at undergraduate level. But it's foundation. It was pretty good, I'd recommend it. And there is no deadline, I applied two days before the start of the course!
And yes. You'd live in halls. You'd be part of the University as a full fledged student in every way possible.
So yeah, I highly recommend Oxford Brookes foundation.