www.dbstalk.com is a great resource.
I beta test the DVR software and have been for almost 3 years now. Had Multi room viewing for the last 2 years.
There are two ways to set this up:
Whole Home DVR Service
Basically the DVR's in your home are connected via Ethernet over coaxial cable. Each room will have their own controls and can integrate / watch / delete content from every other DVR
Requires special equipment to install and set up
Multi Room Viewing
Same as above except the DVR's are connected through your existing Ethernet infrastructure.
No special equipment required. Plug into your network and go..
Both great options..