Vendita
€235.000 saldo
SASSARI SETTI FUNTANI , a 2 km da via Milano in zona residenziale completamente abitata, panoramica porzione di villa bifamiliare con ingresso autonomo e dai comodi spazi disposti in: ingresso, sala, cucina abitabile, tre letto, doppi servizi, ripostiglio e due verande, il tutto circondato da 8000 mq di curatissimo terreno alberato. Riscaldamento utonomo a gas. Ottime condizioni. C.E. “G” ipe 184. € 235000
079/281020
393/9499225
393/9396801
Errore sul database di WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',,,,,,,,,,,,,,,,)
) AND wp_posts.post_type = 'property' AND (wp_posts.post_st...' at line 4]SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND wp_posts.ID NOT IN (5308) AND wp_posts.post_parent NOT IN (5308) AND (
wp_term_relationships.term_taxonomy_id IN (,,,,,,,,,,,,,,,,,)
) AND wp_posts.post_type = 'property' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND ( ( ( wpml_translations.language_code = 'it' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','faq','agent','property','partners','slide' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','faq','agent','property','partners','slide' ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 2