I've got an LG one that I bought at a ding & dent sale @ Best Buy. It's got a couple dings under the handle but works great otherwise. It doesn't have the water/ice thing in the door. It does have an ice maker in the freezer though.
Overall it's a great fridge and really prefer it to my Side by Side. The pull out chest in the bottom is very easy to organize and handles some really awkward items that most other freezers short of full size chest style deep freeze wouldn't be able to hold.
The fridge portion is also great for storing wide items that my side by side wouldn't take (sheet cakes, pizza boxes, ect).
It's incredibly efficient. It only adds a few extra bucks a month onto the electric bill.
My only real beef with it is that doors are harder to close and won't seal up if you just give them a light shove like you can with a normal fridge. Luckily it has a sensor that beeps because my wife left it open twice before she finally started closing it all the way.
My fridge was $1499 @ Best buy. When I bought it I got a $750 gift card(ding & dent sale), free delivery, and 0% financing for 18 months. Not a bad deal.