SQL:SELECT *, ((CASE WHEN cloud LIKE '%Private%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Islands%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%sale%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Chios%' THEN 1 ELSE 0 END)) AS relevance FROM properties WHERE (cloud LIKE '%Private%') AND (cloud LIKE '%Islands%') AND (cloud LIKE '%sale%') AND (cloud LIKE '%Chios%') AND munic = 'Chios' AND cloud LIKE '% %' ORDER BY pid DESC
Ktimatoemporiki Real Estate
0

Language: EN

  1. Real Estate
  2. Private-Islands-for-sale-in-Chios

Private Islands For Sale Chios -

1 Properties found


More Filters Reset Fields
Filters
Price range
Features

Loading your selected locations...