elect Tatev Tour Agency
string(481) "SELECT tpl.*, t.`room_id` AS `room_id` FROM `tariff_price_list` tpl LEFT JOIN (SELECT * FROM `tariffs` WHERE `adult_count` >= '1' AND `child_count` >= '0' AND `deleted` ='0' GROUP BY `room_id`) t ON tpl.`tariff_id` = t.`id` LEFT JOIN `rooms` r ON t.`room_id` = r.`id` WHERE r.`property_id` = '25' AND tpl.`tariff_package_id` = '1' AND tpl.`deleted` = '0' AND tpl.`start_date` < '2017-04-30' AND tpl.`end_date` >= '2017-04-29' AND tpl.`deleted` = '0' ORDER BY tpl.`tariff_id` DESC"

National

Amiryan Street 4/3, 0010 Yerevan, Armenia


Description

A 5-minute walk from Republic Square Metro Station, the National Museum and Fountains Park, Hotel National is set in the centre of Yerevan. This Art-Deco-style hotel features an indoor swimming pool, a gym, spa and Turkish bath.

Hotel National features high, cornice ceilings, large windows with luxurious drapes, fireplaces and colorful tiling work. The spacious rooms, studios and suites are decorated in attractive neutral tones.

All rooms have free Wi-Fi, a flat-screen TV and a private bathroom with a bathrobe and free toiletries.


Rooms

Double

68160 AMD


Double + Extra Bed

84960 AMD