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"

Minotel

8 Mher Mkrtchyan, 0010 Yerevan, Armenia


Description

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.


Rooms

Single

29000 AMD


Double

36000 AMD


Double + Extra Bed

49600 AMD