Motherboard is ok, ram is more than enough, processor isn't that fast but adequate for current games. Power supply is 250w, which is wholly inadequate. I can't believe how expensive that computer is given the specs, but that's what you get for a prebuilt from a big box store.
I know l mentioned this in another thread, but aren't there any smaller businesses where you live that fix/build computers? Seriously -- I know you don't want to buy online, but surely one of these places could build you a decent PC that would be suitable for gaming. I live in a fairly small city of 200k people and there are a half dozen shops that stock PC components and build PCs. With a little legwork you could actually find something worth buying.