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


8 Mher Mkrtchyan, 0010 Yerevan, Armenia


This property is 1 minute walk from the beach. Barsam Suites is located in the centre of Yerevan, a 5-minute walk from Republic Square, and offers air-conditioned rooms with a fridge and flat-screen satellite TV. It provides free parking and free WiFi in public areas.

All rooms are decorated in warm colours, and feature carpeted floors and an electric kettle. The private bathrooms include a shower, hairdryer and free toiletries.



29000 AMD


36000 AMD

Double + Extra Bed

49600 AMD