Apartments in Riga

All our Riga Apartments come with fully Equipped Kitchen, Cable TV and DVD, Clothes Washing Machine, WIFI with Internet Computer, and Car Parking.

The Fastest way to see prices and availability is to use the separate booking page for each apartment on this website. If you have questions then please call Paul on +371 2614 7214

If you intend to stay less than 2 days then the only option we have for you is rooms at Barons Hostel.

1. Hospitala iela Apartment for up to 3 people. Ground level apartment with free car parking directly at the entrance to the apartment.  Located on a nice cobble stoned street with tram and electric bus transport options within 200 mtrs. Large Norwegian style supermarket is 100 mtrs away. Book Now.


2. Krisjana Barona Street Apartment for up to 4 people. Sixth floor apartment with no lift. Has excellent views North and South. Free secure car parking behind the apartment building with direct access door. Includes clothes dryer with the Washing Machine. Tram stop and supermarket 100 mtrs away.  Many cafes all around. Book Now.


3. Barons Apartment Rooms from 1 to over 4 people for 1 to many days. Largest fully equipped kitchen and largest lounge room. Within 200mtrs there are plenty bars, cafes and restaurants and shops to keep you busy between sightseeing. Book Now.


Click on the Pictures across the top to read more details on apartments and how to collect keys.
 
14 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 id, link FROM rigaaparts_menu WHERE menutype = 'mainmenu' AND published = 1 ORDER BY parent, ordering LIMIT 1
4 SELECT template FROM rigaaparts_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 1 ) ORDER BY menuid DESC LIMIT 1
5 DELETE FROM rigaaparts_session WHERE ( ( time < '1568850584' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1568850584' ) AND guest = 1 AND userid = 0 )
6 SELECT * FROM rigaaparts_menu WHERE id = 1
7 SELECT COUNT(a.id) FROM rigaaparts_content AS a INNER JOIN rigaaparts_content_frontpage AS f ON f.content_id = a.id INNER JOIN rigaaparts_categories AS cc ON cc.id = a.catid INNER JOIN rigaaparts_sections AS s ON s.id = a.sectionid 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.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 s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0
8 SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits, CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups , s.id AS sec_id, cc.id as cat_id FROM rigaaparts_content AS a INNER JOIN rigaaparts_content_frontpage AS f ON f.content_id = a.id INNER JOIN rigaaparts_categories AS cc ON cc.id = a.catid INNER JOIN rigaaparts_sections AS s ON s.id = a.sectionid 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.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 s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0 ORDER BY f.ordering LIMIT 4
9 SELECT folder, element, published, params FROM rigaaparts_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
10 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'
11 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 = 1 ) ORDER BY ordering
12 SELECT m.* FROM rigaaparts_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
13 SELECT COUNT( id ) FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1
14 SELECT id FROM rigaaparts_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=36'