Hotel with Six Rooms and One Apartment for sale in Karpenisi
500.000€
- ID Ste2-626
- 10
- 10
- 600 ㎡
- 2500 ㎡
SQL:SELECT *, ((CASE WHEN cloud LIKE '%Evrytania%' THEN 1 ELSE 0 END)) AS relevance FROM properties WHERE (cloud LIKE '%Evrytania%') AND prefe LIKE 'Evrytania%' AND cloud LIKE '% %' ORDER BY pid DESC
Loading your selected locations...