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` = '14' 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"


10/5 Sayat Nova Ave, 0001 Yerevan, Armenia


Featuring free WiFi and a spa center, Nova Hotel Yerevan offers accommodations in Yerevan, just 501 m from Armenian Opera and Ballet Theatre. Guests can enjoy the on-site bar.

The rooms have a flat-screen TV with satellite channels. Certain rooms feature a sitting area where you can relax. You will find a kettle in the room. All rooms are equipped with a private bathroom.


Single Economy

32000 AMD

Single Standard

37000 AMD

Double Economy

41000 AMD

Double Standard

45000 AMD

Double + Extra Bed

57000 AMD