If non of the fans turn, not even in the power supply, then the first thing I would try myself was to put in another powersupply, however this little red light burning is odd 'cause that would mean there is electricity going round so the powersupply can't be so broken that it does nothing, but then the question still remains, why doesn't it run it's fans if it does send some power to the motherboard? (I'm assuming the light is on the motherboard 'cause you said it's all the way at the bottom in the tower) If you have guarantee on it, then do NOT open the powersupply 'cause usually you'll blow your guarantee that way and the store won't give a replacement for free anymore.

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.