We have detected that your browser has JavaScript disabled.

You will not be able to access some areas of this website.
For instructions on enabling JavaScript, please click here

HIDE THIS MESSAGE
Shamrock Restaurant and Apartments
Back Tour Search Shopping Cart Reset Cart Terms/Conditions
Select * from qrycustomersall where customerid = 16136 and ( control_id = 40 ) and show = 1 The specified operator could not be found. Please go back and try again.