A plan to knock down two homes and replace them with nine new houses at a residential area in Sandhurst has been rejected.