Riga Apartment for up to 4 people

Sixth floor Riga apartment without lift.Your reward is great views North and South. Excellent location on the main shopping street in Riga serviced by trams. Walking distance to the cafes, restaurants, and bars all around. 5 minutes to the Old Town centre.

Two Bed Rooms with a Double bed in each with the possibility for additional beds. Clothes Washing Machine and Dryer

Free Secure Car Parking directly behind the building with direct access to stairwell, large plasma TV with DVD and Cable channels in English, Wifi and Internet computer.

Although you can hear the passing traffic on the main shopping street it is not loud as the apartment faces Stabu Street.

Located just 300mtrs from our Barons Apartment Rooms that has 24 hr Receptionist that you can rely on for support and information.

Some type of security deposit to the value of 200 lvl is required.

 
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 = 37 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM rigaaparts_session WHERE ( ( time < '1575802174' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1575802174' ) AND guest = 1 AND userid = 0 )
5 SELECT * FROM rigaaparts_menu WHERE id = 37
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 = 24 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:04' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-08 13:04' ) AND a.access <= 0
7 UPDATE rigaaparts_content SET hits = ( hits + 1 ) WHERE id = '24'
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 = 37 ) 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 = 'Barons 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=24'
16 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=16'
17 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=15'