A 58 year old man presents with a 12 hour history of severe right-sided spasmodic pain which starts in the loin, and radiates to the groin. On examination, he is haemodynamically stable and his urine dipstick demonstrates blood+++. Based on the likely diagnosis, what is the most appropriate management option?