This modern three-storey home in the north Cork town is remarkably affordable, but it’s only half an hour from the city, writes Trish Dromey