It appears that you are looking at the Audio Authority 9870 model? If so, then that looks like a solid piece and will get ONE HD component source from your head end to multiple rooms. But it only appears to handle component video and it is a single source to multi-location (2 max) distribution amplifier. This may or may not be ideal for your setup depending on your needs/wishes.
Dealing with HD distribution through a home can be a fairly costly proposition and because of all the different video formats, things can be, at the very least, convoluted.
I am not sure, but there really needs to be some products like the 9870 that include transcoding from composite/s-video to component and allow for matrix switching in the process. But, that's not exactly a cheap way to do things.
In my home I ran a couple of runs of mini-high resolution cable to multiple locations. Each run of mini-hr cable consists of 5 pieces of mini RG-59 cable and can carry HD signals over it for distribution. So, two runs delivers component video w/audio and composite video w/audio if I want. I actually just run component video to the locations though as almost all my gear is HD at this point. I then use an Extron Matrix switcher to switch between multiple HD sources and have speakers in every room (15 sets) for audio distribution.
Fun stuff!