OK.  I'm not an architectural type shooter, but here's a few quick
observations:

1. You'll almost certainly need a wide angle lens, eg 28mm equivalent
or better.
2. You probably won't need a huge amount of resolution, 5Mp-ish would
be probably be enough for nice quality DVD/web images.
3. You'll be shooting indoors sometimes with difficult/low light.  A
camera with decent low-light capability would be good.  That means
DSLR, or perhaps some of the better Fuji point&shoots (p&s) might be ok
(but I'm not sure if they go wide enough).  A tripod would be
essential, imo.  Also an accessory flash with bounce capability...
4. If fully-automated, the camera should still offer a good range of
exposure compensation (+/-2EV at the very least, preferably 3), so you
can adjust for rooms with brightly lit windows, etc.

A lot then depends on your quality requirements.  For example, most
'point & shoot' cameras with suitably wide lenses will introduce
distortions - walls and door/window frames will 'bend'.  DSLRs will
have these issues too, but hopefully to a lesser extent.  Correctable
in software, and maybe it won't bother you, but forewarned...etc

Hopefully others who do more of this type of work can help further.
Me?  I'd post this request on a real-estate forum, and see what comes
up!