PHP error [Warning]
PHP Error [Warning]
PHP Error [Warning]
Apollon Inn Arachova
greek english french

  • IOS Image Rotator

Welcome in Apollo Inn Arachova Rent a Room 3 keys

We offer single, double and triple.
Prices throughout the year are:

25 EUR single room
35 EUR double room
45 EUR Triple room

Winter holiday prices change

1000 meters high in the Parnassos Arachova built is beautiful and surrounded by snow capped mountains of the Apollo Inn is one of the most traditional hotels in Arachova, which opens its doors to guide you to the sites.

This 2 star hotel, located in beautiful stone, which began operating in 1992 and keeps the traditional style and beauty, it promises hours of relaxation and fun.

wifiWe offer access to the Internet via Wi-Fi

Random image

Arachova (8).jpg

Who's online

We have 3 guests online

70 queries executed
1
SELECT * FROM elx_core_acl_access_lists
2 SELECT seotitle FROM elx_sections WHERE scope='content' AND ((seotitle != '') OR (seotitle IS NOT NULL))
3 SELECT id, link FROM elx_menu WHERE menutype='mainmenu' AND published='1' AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY parent, ordering
4 SELECT template, params FROM elx_templates_menu WHERE client_id='0' AND menuid='8'
5 SELECT template, params FROM elx_templates_menu WHERE client_id='0' AND menuid='0'
6 DELETE FROM elx_session WHERE (time < 1513497215)
7 SELECT * FROM elx_session WHERE session_id='57f6152dd3dbce65a489396b9e35841c'
8 SELECT session_id FROM elx_session WHERE session_id='de48c0826bfd57920a76af15c28f25a2'
9 INSERT INTO elx_session ( `session_id`,`time`,`username`,`gid`,`allowed`,`guest`,`ip` ) VALUES ( '0fd4754b20872f8f9d3fbe282914761d','1513498115',NULL,'29','29','1','54.92.194.75' )
10 SELECT COUNT(*) FROM elx_stats_agents WHERE agent='Unknown' AND type='0'
11 UPDATE elx_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
12 SELECT COUNT(*) FROM elx_stats_agents WHERE agent='Unknown' AND type='1'
13 UPDATE elx_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
14 SELECT COUNT(*) FROM elx_stats_agents WHERE agent='com' AND type='2'
15 UPDATE elx_stats_agents SET hits=(hits+1) WHERE agent='com' AND type='2'
16 SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup FROM elx_mambots WHERE published > 0 AND access IN (29) AND folder='editors' ORDER BY ordering
17 SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup FROM elx_mambots WHERE published > 0 AND access IN (29) AND folder='editors-xtd' ORDER BY ordering
18 SELECT access FROM elx_menu WHERE id='8'
19 SELECT name FROM elx_core_acl_aro_groups WHERE group_id='29'
20 SELECT * FROM elx_menu WHERE id='8'
21 SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, cc.seotitle AS catseotitle, s.name AS section, s.seotitle AS secseotitle, g.name AS groups FROM elx_content a INNER JOIN elx_content_frontpage f ON f.content_id = a.id INNER JOIN elx_categories cc ON cc.id = a.catid INNER JOIN elx_sections s ON s.id = a.sectionid LEFT JOIN elx_users u ON u.id = a.created_by LEFT JOIN elx_content_rating v ON a.id = v.content_id LEFT JOIN elx_core_acl_aro_groups g ON a.access = g.group_id WHERE a.state = '1' AND s.published = '1' AND cc.published = '1' AND ((a.language IS NULL) OR (a.language LIKE '%english%')) AND ((cc.language IS NULL) OR (cc.language LIKE '%english%')) AND ((s.language IS NULL) OR (s.language LIKE '%english%')) AND a.access IN (29) AND ( publish_up = '1979-12-19 00:00:00' OR publish_up <= '2017-12-17 10:08:35' ) AND ( publish_down = '2060-01-01 00:00:00' OR publish_down >= '2017-12-17 10:08:35' ) ORDER BY f.ordering
22 SELECT COUNT( m.id ) FROM elx_content i LEFT JOIN elx_sections s ON i.sectionid=s.id LEFT JOIN elx_menu m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1'
23 SELECT COUNT( m.id ) FROM elx_content i LEFT JOIN elx_categories c ON i.catid=c.id LEFT JOIN elx_menu m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1'
24 SELECT COUNT( id ) FROM elx_menu WHERE type='content_blog_section' AND published='1' AND componentid=0
25 SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup FROM elx_mambots WHERE published > 0 AND access IN (29) AND folder='content' ORDER BY ordering
26 SELECT m.id FROM elx_menu m LEFT JOIN elx_categories c ON m.componentid=c.id WHERE m.type='content_category' AND m.published='1' AND c.id='13'
27 SELECT m.id FROM elx_menu m LEFT JOIN elx_sections s ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND s.id='13'
28 SELECT id FROM elx_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
29 SELECT id FROM elx_components WHERE name = 'Syndicate'
30 SELECT * FROM elx_components WHERE id='17'
31 SELECT id FROM elx_components WHERE name = 'Syndicate'
32 SELECT * FROM elx_components WHERE id='17'
33 SELECT a.*, u.name AS author, u.usertype FROM elx_content a LEFT JOIN elx_users u ON u.id = a.created_by WHERE a.state = '1' AND a.access = '29' AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2017-12-17 10:08:35' ) AND ( a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2017-12-17 10:08:35' ) AND ((a.language IS NULL) OR (a.language LIKE '%english%')) ORDER BY a.created DESC
34 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='20'
35 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='18'
36 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='16'
37 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='15'
38 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='13'
39 SELECT b.id, b.title, b.seotitle, b.blogid, b.blogtext, s.seotitle AS seoblog FROM elx_eblog b LEFT JOIN elx_eblog_settings s ON s.blogid = b.blogid WHERE s.published = '1' AND ((b.language IS NULL) OR (b.language LIKE '%english%')) ORDER BY b.dateadded DESC
40 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.language FROM elx_modules m, elx_modules_menu mm WHERE m.published='1' AND m.access IN (29) AND m.client_id='0' AND ((m.language IS NULL) OR (m.language LIKE '%english%')) AND mm.moduleid=m.id AND ((mm.menuid = '0') OR (mm.menuid = '8')) ORDER BY m.ordering
41 SELECT * FROM elx_menu WHERE menutype='topmenu' AND published='1' AND parent='0' AND access IN (29) AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY ordering
42 SELECT id FROM elx_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=16'
43 SELECT id FROM elx_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=16'
44 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='16'
45 SELECT id FROM elx_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=15'
46 SELECT id FROM elx_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=15'
47 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='15'
48 SELECT d.seotitle AS seoitem, c.seotitle AS seocat FROM elx_contact_details d LEFT JOIN elx_categories c ON c.id=d.catid WHERE d.id='1' AND d.published='1' AND c.published='1'
49 SELECT id, language FROM elx_menu WHERE id='8'
50 SELECT * FROM elx_menu WHERE menutype='mainmenu' AND published='1' AND access IN (29) AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY parent,ordering
51 SELECT id FROM elx_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=16'
52 SELECT id FROM elx_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=16'
53 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='16'
54 SELECT id FROM elx_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=15'
55 SELECT id FROM elx_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=15'
56 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='15'
57 SELECT d.seotitle AS seoitem, c.seotitle AS seocat FROM elx_contact_details d LEFT JOIN elx_categories c ON c.id=d.catid WHERE d.id='1' AND d.published='1' AND c.published='1'
58 SELECT * FROM elx_menu WHERE menutype='othermenu' AND published='1' AND parent='0' AND access IN (29) AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY ordering
59 SELECT id FROM elx_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=20'
60 SELECT id FROM elx_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=20'
61 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='20'
62 SELECT id FROM elx_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=18'
63 SELECT id FROM elx_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=18'
64 SELECT c.seotitle AS seoitem, cc.seotitle AS seocat, s.seotitle AS seosec FROM elx_content c LEFT JOIN elx_categories cc ON cc.id=c.catid LEFT JOIN elx_sections s ON s.id=c.sectionid WHERE c.id='18'
65 SELECT COUNT(*) FROM elx_banner WHERE showbanner = '1' AND cid IN (1)
66 SELECT * FROM elx_banner WHERE showbanner = '1' AND cid IN (1) ORDER BY rand()
67 UPDATE elx_banner SET impmade = impmade + 1 WHERE bid = '1'
68 SELECT COUNT(session_id) FROM elx_session WHERE gid='29'
69 SELECT COUNT(DISTINCT username) FROM elx_session WHERE userid<>'0' AND gid <> '29'
70 SELECT DISTINCT username, userid, gid FROM elx_session WHERE userid <> '0'