This 4,500 sq ft, five-bedroom house in Cork’s Carrigrohane has a movie screen in red velvet-clad basement room, says Tommy Barker