Warning: PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 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 ''5) AND A.attr_etat = 1 ORDER BY attr_ordre,attr_libelle,A.attr_lib...' at line 4 in /var/www/vhosts/apg-immo.com/sitesweb3/models/Detail_bienManager.php on line 348
Riferimento : APM-86434426
Cascina Cardielos e Serreleis
13 Camere 891 m² 17 bagni con vasca Superficie esterna 32 700 m²
3 900 000 €
A 3.27-hectare farm, completely flat and with around 205 meters of riverbank, comprising a completely rebuilt 18th-century manor house, with approximately 891 m² spread over three floors, and several independent housing units, ideal for a private residence or tourist investment. The property has a saltwater swimming pool with support area, gym, sauna, large living areas, green wine vineyards, orchards, abundant water resources and infrastructures prepared for events or accommodation, as well as two wells, a borehole for collecting water, an underground water tank with 80,000 liters and an automatic irrigation system, making this property unique due to its size, versatility and high potential for profitability.
Proprietari, valutate il vostro immobile!
Se avete un immobile da vendere, contattate i nostri consulenti per ottenere una valutazione seria e dettagliata.
Valutare il mio immobile
Seguici su Instagram
@barnesrealty
