You'll find the Magic Road in Waterford hidden away in the Comeragh Mountains, not far from Mahon Falls (there's a link to the location on Google Maps at the top of the guide).