string(171) " SELECT hotel_id, TRIM(CONCAT(prefix,' ',title,' ',postfix)) AS hotel, area FROM hotels WHERE (hotels.status != 'Live') AND (UPPER(hotels.title) = 'BEAUFORT')" Videos | Hotels-London.co.uk

Hotels London

Reservations:       (UK) FreePhone 0800 066 4911       (International) +44 203 026 6805

- Videos

Back to