The Cambridge-Cambridge ROSAT Serendipity Survey — IV. The X-ray properties