Undercounter/Beer fridge (New Wortley LS12)

Hi,
Would anyone possibly have a quiet under counter or beer fridge. If it has that little freezer compartment that would be even better.
My room is like an oven, so need to keep food and drink cool, the house fridge freezer is quite small for us to share, so this would help me greatly.

Please note i would need it delivered as i have no transport, but i live on 2nd floor and no lift available.
Just hoping, someone will be generous enough to help me out, especially in this hot weather.