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
In order to have more space at your disposal, choose a Superior room. Superior rooms are furnished with particular care and are equipped with air conditioning, and a 32” LCD TV with free satellite channels. All rooms come with either a sea view or a view of the internal courtyard depending on availability. They are equipped with table and chairs where you can enjoy the sun or read in total privacy during the summer season.
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-06 14:07:11' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-12-06 14:07:11' ) 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