South Coast of Salerno,
Lago Trasimeno street
Salerno - Italy
Ph. +39 089 203 004
Fax.+39 089 203 458
» Click and headd your phone number, (mobile phone included). We will call you back right away!!!
Guests: 1 to 4 people
If you are on vacation with your partner, family, or on a business trip, our standard rooms will provide sufficient space for both relaxing as well as working in a quiet and calm atmosphere. The majority of the Standard rooms have a small terraced balcony with a table and chairs where you can simply enjoy the sun or read outside during the summer.
No valid database connection Unknown column 'A.ID' in 'where clause' SQL=SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, '' as catslug, 0 as catid, '' as category, 0 as sectionid, '' as section , u.name AS author FROM jos_content AS a LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-12-08 02:05:45' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-12-08 02:05:45' ) AND A.ID <> 186 AND A.ID <> 132 AND A.ID <> 140 AND A.ID <> 134 AND A.ID <> 112 AND A.ID <> 131 AND a.access <= 0 AND (a.id=28) ORDER BY a.created DESC LIMIT 0, 1