Man appears in court accused of string of offences including attempted murder