Monday, 31 December 2012 11:14

Meli Traditional House

Additional Info

  • Region Δράγανο
  • Contact Person Έλενα Κατωπόδη
  • Tel.1 -------------------------------------
  • Fax -------------------------------------
  • Mob. +30 6945262123
  • e-mail -------------------------------------
Published in Boutique Hotels
Saturday, 30 July 2011 13:52

Stavlos Cottage

Stavlos Cottage is situated in the middle of a big beach just a few minutes by foot from the center of Vassiliki and 38 km away from the city of Lefkada.  Stavlos cottage include four Lux apartments, fully renovated on February 2011, in the middle of a wonderful scenery which offers you many recreational activities and an interesting night life.

The cottage includes wonderful decorated apartments which have plenty of room for comfortable living in a cozy environment with a view of the quiet garden of the compartment.  Utilities include mini refrigerator, kitchen, Air Condition, TV and Internet access through Wi-Fi.

Stavlos Cottage is an extension of Hotel Phoenix, so guests can use the facilities of the hotel which include a pool with free loungers, restaurant, bar, a rich morning buffet for their breakfast on a daily basis and room service at the pool or in the apartments.


Additional Info

Published in Boutique Hotels

Profile Information

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.018 seconds, 2.41 MB
Application afterRoute: 0.028 seconds, 3.08 MB
Application afterDispatch: 0.140 seconds, 5.02 MB
Application afterRender: 0.328 seconds, 8.79 MB

Memory Usage

9295976

48 queries logged

  1. SELECT MAX(TIME)  
      FROM jos_vvcounter_logs
  2. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  3. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(20,51,173,1,52,178,24,172,174,166,175,214,186,215,177,219,225,185,179,217,202,218,171,216,220,221,223,222,151,153,154,155,156,157,158,159,160,161,162,163,147,187,189,196,148,208,193,213,206,207,203,149,205,191,165,180,182,190,224)
       
      AND jf_content.reference_table='menu'
  4. SELECT *
      FROM jos_rokcandy
      WHERE published=1
  5. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  6. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  7. SELECT *
      FROM jos_k2_categories
      WHERE published=1
      AND trash=0
      AND access<=0
  8. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(130,2,3,4,5,6,7,8,9,10,131,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,133,132,125,126,127,128,91,92,93,94,95,134,97,98,99,100,101,102,103,104,105,106,107,108,109,129,111,136,114,135,115,116,117,118,119,120,121,122,123,124,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,179,175,176,177,178)
       
      AND jf_content.reference_table='k2_categories'
  9. SELECT reference_id
      FROM jos_jf_content AS jfc
      LEFT JOIN jos_languages AS jfl
      ON jfc.language_id = jfl.id
      WHERE jfc.VALUE = 'Boutique Hotel'
      AND jfc.reference_table = 'k2_tags'
      AND jfc.reference_field = 'name'
      AND jfc.published=1
      LIMIT 0, 1
  10. SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
      FROM jos_k2_items AS i
      LEFT JOIN jos_k2_categories AS c
      ON c.id = i.catid
      LEFT JOIN jos_k2_tags_xref AS tags_xref
      ON tags_xref.itemID = i.id
      LEFT JOIN jos_k2_tags AS tags
      ON tags.id = tags_xref.tagID
      WHERE i.published = 1
      AND i.access <= 0
      AND i.trash = 0
      AND c.published = 1
      AND c.access <= 0
      AND c.trash = 0
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-22 02:50:18' )
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 02:50:18' )
      AND (tags.id) = 37
      ORDER BY i.id DESC
      LIMIT 0, 10
  11. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(167,11)
       
      AND jf_content.reference_table='k2_items'
  12. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(114,109)
       
      AND jf_content.reference_table='k2_categories'
  13. SELECT reference_id
      FROM jos_jf_content AS jfc
      LEFT JOIN jos_languages AS jfl
      ON jfc.language_id = jfl.id
      WHERE jfc.VALUE = 'Boutique Hotel'
      AND jfc.reference_table = 'k2_tags'
      AND jfc.reference_field = 'name'
      AND jfc.published=1
      LIMIT 0, 1
  14. SELECT COUNT(*)
      FROM jos_k2_items AS i
      LEFT JOIN jos_k2_categories c
      ON c.id = i.catid
      LEFT JOIN jos_k2_tags_xref tags_xref
      ON tags_xref.itemID = i.id
      LEFT JOIN jos_k2_tags tags
      ON tags.id = tags_xref.tagID
      WHERE i.published = 1
      AND i.access <= 0
      AND i.trash = 0
      AND c.published = 1
      AND c.access <= 0
      AND c.trash = 0
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-22 02:50:18' )
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 02:50:18' )
      AND (tags.id) = 37
  15. SELECT *
      FROM jos_k2_categories
      WHERE id=114
      LIMIT 0, 1
  16. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(114)
       
      AND jf_content.reference_table='k2_categories'
  17. SELECT *
      FROM jos_k2_extra_fields
      WHERE published=1
      AND id IN (20,19,4,5,6,17,18,7)
      ORDER BY ordering ASC
  18. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(20,19,4,5,6,17,18,7)
       
      AND jf_content.reference_table='k2_extra_fields'
  19. SELECT COUNT(*)
      FROM jos_k2_comments
      WHERE published=1
      AND itemID=167
  20. SELECT *
      FROM jos_komento_configs
      WHERE component = 'com_k2'
  21. SELECT g.*
      FROM jos_core_acl_aro_groups AS g
      INNER JOIN jos_core_acl_groups_aro_map AS gm
      ON gm.group_id = g.id
      INNER JOIN jos_core_acl_aro AS ao
      ON ao.id = gm.aro_id
      WHERE ao.VALUE='62'
      ORDER BY g.id
  22. SELECT a.*, c.alias AS category_alias
      FROM `jos_k2_items` AS a
      LEFT JOIN `jos_k2_categories` AS c
      ON c.id = a.catid
      WHERE a.id='167'
  23. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(167)
       
      AND jf_content.reference_table='k2_items'
  24. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(167)
       
      AND jf_content.reference_table='k2_categories'
  25. SELECT `id`
      FROM `jos_komento_mailq`
      WHERE `status` = 0
      ORDER BY `created` ASC
      LIMIT 5
  26. SELECT *
      FROM jos_komento_configs
      WHERE component = 'com_komento'
  27. SELECT *
      FROM `jos_komento_acl`
      WHERE `cid`='29'
      AND `type`='usergroup'
      AND `component`='com_k2'
      ORDER BY `id`
  28. SELECT *
      FROM `jos_komento_acl`
      WHERE `cid`='0'
      AND `type`='user'
      AND `component`='com_k2'
      ORDER BY `id`
  29. SELECT COUNT(1)
      FROM (SELECT x.*, 0 AS depth
      FROM `jos_komento_comments` AS x
      WHERE x.component = 'com_k2'
      AND x.cid IN (167)
      AND x.published = '1') AS x
  30. SELECT COUNT(1)
      FROM (SELECT x.*, 0 AS depth
      FROM `jos_komento_comments` AS x
      WHERE x.component = 'com_k2'
      AND x.cid IN (167)
      AND x.published = '1') AS x
  31. SELECT *
      FROM jos_k2_categories
      WHERE id=109
      LIMIT 0, 1
  32. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(109)
       
      AND jf_content.reference_table='k2_categories'
  33. SELECT *
      FROM jos_k2_categories
      WHERE id=114
      LIMIT 0, 1
  34. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(114)
       
      AND jf_content.reference_table='k2_categories'
  35. SELECT *
      FROM jos_k2_extra_fields
      WHERE published=1
      AND id IN (4,8,5,6,7)
      ORDER BY ordering ASC
  36. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(4,5,6,7)
       
      AND jf_content.reference_table='k2_extra_fields'
  37. SELECT COUNT(*)
      FROM jos_k2_comments
      WHERE published=1
      AND itemID=11
  38. SELECT *
      FROM jos_modules
      WHERE client_id = 0
      AND access <= 0
      AND ( title='Stavlos Cottage Booking' )  
      AND published = 1
      ORDER BY ordering
      LIMIT 1
  39. SELECT a.*, c.alias AS category_alias
      FROM `jos_k2_items` AS a
      LEFT JOIN `jos_k2_categories` AS c
      ON c.id = a.catid
      WHERE a.id='11'
  40. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(11)
       
      AND jf_content.reference_table='k2_items'
  41. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(11)
       
      AND jf_content.reference_table='k2_categories'
  42. SELECT COUNT(1)
      FROM (SELECT x.*, 0 AS depth
      FROM `jos_komento_comments` AS x
      WHERE x.component = 'com_k2'
      AND x.cid IN (11)
      AND x.published = '1') AS x
  43. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 208 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  44. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(195,199,205,43,167,196,287,286,136,302)
       
      AND jf_content.reference_table='modules'
  45. SELECT *
      FROM jos_languages
      WHERE active=1
      ORDER BY ordering
  46. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1  
      ORDER BY m.sublevel, m.parent, m.ordering
  47. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(20,51,173,1,52,178,24,172,174,166,175,214,186,215,177,219,225,185,179,217,202,218,171,216,220,221,223,222,151,153,154,155,156,157,158,159,160,161,162,163,147,187,189,196,148,208,193,213,206,207,203,149,205,191,165,180,182,190,224)
       
      AND jf_content.reference_table='menu'
  48. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(166,208)
       
      AND jf_content.reference_table='menu'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None