Riga Apartment for up to 3 people

A compact apartment in Riga with one double bed that has a single bunk bed above it. Ground floor apartment where car can be parked directly outside the entrance. Very little passing vehicle traffic at night.

Open plan kitchen, walk-in wardrobe, clothes washing machine in the bathroom. TV with DVD player and cable channels. Wifi and internet computer. 

A short 5 minute walk to Arena Riga and the Skonto Sports Stadium where you can attend international sports events and watch bands play from all over the world.

Electric buses and trams have stops within 200 mtrs of the apartment.

RIMI Supermarket is located within a shopping centre 100 mtrs away.

 
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 = 36 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM rigaaparts_session WHERE ( ( time < '1571005132' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1571005132' ) AND guest = 1 AND userid = 0 )
5 SELECT * FROM rigaaparts_menu WHERE id = 36
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 = 23 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-14 01:33' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-14 01:33' ) AND a.access <= 0
7 UPDATE rigaaparts_content SET hits = ( hits + 1 ) WHERE id = '23'
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 = 36 ) 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 = 'Argonaut 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=23'
16 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=14'
17 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=12'