DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 175' at line 10
Trim, Ireland Overlooking the mystical Trim Castle, once the largest Anglo-Norman castle in Ireland, Trim Castle Hotel in the heart of the heritage town of Trim opened its doors in July 2006. Located in the heart of the Boyne Valley amongst the medieval wonders of Bective Abbey, Newgrange, The Hill of Tara, Knowth and Talbot Castle, yet only a 40 minute drive from Dublin city, Trim Castle Hotel is the perfect retreat for relaxation and tranquillity. The historical centres of Kells, Slane and Navan, with their culture and range of golf courses are just a short distance away.