About Riga Apartments

We are Australians that have set up family life in Latvia.

We offer you apartments not only with the comforts expected but you will find helpful information on how to get around and find a wide variety of things to see and do in Riga.

What is most unique is that all people that stay at our apartments are allowed to access the resources at our hostels in Riga. At our hostels you can meet with other travellers, drink at the bar and join in organised tours.

On top of all the above we have a Beach Hostel in Liepaja to provide you with a escape option in the best city of Latvia.

If you have anything you would like to contact us direct about then please do via the Australian Chamber of Commerce in Latvia as we run that as well :-)

Happy travels from Dean and family
 
13 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 = 56 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM rigaaparts_session WHERE ( ( time < '1568850596' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1568850596' ) AND guest = 1 AND userid = 0 )
5 SELECT * FROM rigaaparts_menu WHERE id = 56
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 = 35 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-19 03:04' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-19 03:04' ) AND a.access <= 0
7 UPDATE rigaaparts_content SET hits = ( hits + 1 ) WHERE id = '35'
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 = 56 ) 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'