OK, this is not about real estate photography but I can't help it, I got a Canon G9 last week and I just love it! I wanted camera I could carry in my pocket that shoots RAW and shoots video. That has all the controls that my big-boy camera has.
The G9 is a wonderful little camera. 12-megapixel sensor, built-in image stabilization, Canon's DIGIC III image processor, 6x zoom (35-210 equivalent) with a dial based design that lets you quickly access a variety of control- including a dial for changing ISO (80-1600). One cool feature I've never seen before is a real-time histogram display. The display and navigation on this camera is the best I've ever used.
This is not a real estate camera. Although I think this will be come my new PAP camera.