camere_ing

Weekend_ing

banner_parchi_ing

altravacanza_ing

piccolialberghi

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WH' at line 1 SQL=SELECT DISTINCT a.id, a.*, jfc.value as jfcvalue, , u.name AS author, u.usertype, cc.title AS category, s.title AS section, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = "content" LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id LEFT JOIN jos_jf_content as jfc ON jfc.reference_table='content' AND jfc.reference_id=a.id AND jfc.reference_field='title' AND jfc.language_id =1 WHERE jfc.reference_id IS NOT NULL AND jfc.published=1 AND a.id = 50 AND ( ( a.created_by = 0 ) OR ( a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 15:32:51' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 15:32:51' ) ) OR ( a.state = -1 ) )

image3

APARTMENT TO RENT in Montecenere

near Sestola

 

The House of Montecenere,
to relax in the charming medieval village
not far from the tourist resort of Sestola
and surrounded by woods of Frignano just inland from Modena.


Apartment with 3 bedrooms hall kitchen and bathroom with beautiful stone fireplace and antique furniture.
Charming medieval village not far from the tourist resort of Sestola and surrounded by woods of Frignano.


prices for week beginning from
€ 250.00


for any further information
 

Tel +39 0541 478585 -  This e-mail address is being protected from spambots. You need JavaScript enabled to view it

image1image2