Barons Apartment Rooms

 


A large 5 bed room apartment in Riga with a very good equipped kitchen. Full time receptionist to assist you with tour information and anything you require. This apartment is a quiet place to stay with the ability to meet other travellers. Perfect for couples, families and small groups of friends.

All 5 rooms can be rented or just one or a few rooms. 

Same location as the Australian Chamber of Commerce in Riga. Top security as each guest receives a Smart Card that opens 5 doors from the street to their room.

Free WIFI, Free Internet Computer, Free Large Lockers in Dorm Rooms, Free DVD Movies, Free Guide Map on arrival, Cable TV, Linen and Towel included in the price with no surprise charges. Laundry facilities.

No Stag/Bux groups allowed. Hens welcome.

 
17 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM rigaaparts_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT template FROM rigaaparts_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 35 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM rigaaparts_session WHERE ( ( time < '1575803261' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1575803261' ) AND guest = 1 AND userid = 0 )
5 SELECT * FROM rigaaparts_menu WHERE id = 35
6 SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access, s.id AS sec_id, cc.id as cat_id FROM rigaaparts_content AS a LEFT JOIN rigaaparts_categories AS cc ON cc.id = a.catid LEFT JOIN rigaaparts_sections AS s ON s.id = cc.section AND s.scope = 'content' LEFT JOIN rigaaparts_users AS u ON u.id = a.created_by LEFT JOIN rigaaparts_groups AS g ON a.access = g.id WHERE a.id = 22 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-08 13:22' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-08 13:22' ) AND a.access <= 0
7 UPDATE rigaaparts_content SET hits = ( hits + 1 ) WHERE id = '22'
8 SELECT folder, element, published, params FROM rigaaparts_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
9 SELECT a.* FROM rigaaparts_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
10 SELECT id, title, module, position, content, showtitle, params FROM rigaaparts_modules AS m INNER JOIN rigaaparts_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 35 ) ORDER BY ordering
11 SELECT m.* FROM rigaaparts_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
12 SELECT COUNT( id ) FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1
13 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=36'
14 SELECT m.* FROM rigaaparts_menu AS m WHERE menutype = 'Liepaja Hostel' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
15 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'
16 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=20'
17 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=18'