Cerca strutture

Città di destinazione



Data di arrivo
dateinput

Data di partenza
dateinput

Qualsiasi data

Tipologia
Best Rate Guaranteed



Ischitella

Ischitella: il centro storico

Ischitella è un antico borgo agricolo del Gargano a 310 metri sul livello del mare. Si affaccia su un'ampia vallata, su colline degradanti verso il lago di Varano.

Il centro storico è attraversato da angusti viottoli che convergono verso la piazza. Qui, di fronte al palazzo settecentesco è collocato un busto di Pietro Giannone, che ad Ischitella ebbe i natali.

 

Territorio

No valid database connection Got error 28 from storage engine SQL=SELECT a.*, u.name, u.username, cc.image AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,'link' as link FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_users AS u ON u.id = a.created_by INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 02:31:18') AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 02:31:18' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND ( a.catid=5 ) AND ( a.sectionid=2 ) AND ((TO_DAYS('2012-02-08') - TO_DAYS(a.created)) <= '1200') AND f.content_id IS NULL AND s.published = 1 AND cc.published = 1 ORDER BY RAND() limit 0,6
Got error 28 from storage engine SQL=SELECT a.*, u.name, u.username, cc.image AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,'link' as link FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_users AS u ON u.id = a.created_by INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 02:31:18') AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 02:31:18' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND ( a.catid=5 ) AND ( a.sectionid=2 ) AND ((TO_DAYS('2012-02-08') - TO_DAYS(a.created)) <= '1200') AND f.content_id IS NULL AND s.published = 1 AND cc.published = 1 ORDER BY RAND() limit 0,6