Got error 28 from storage engine
SELECT *, (SELECT image_path FROM images WHERE images.owner_id = properties.p_id AND images.owner_prefix = 1 ORDER BY image_id LIMIT 1) as img FROM properties LEFT JOIN properties_types ON properties_types.t_id = properties.p_type LEFT JOIN properties_areas ON properties_areas.area_id = properties.p_area LEFT JOIN properties_districts ON properties_districts.d_id = properties.p_district WHERE p_area=15 AND p_type_global=1 AND p_is_featured=1 AND p_date_start > UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 400 DAY)) ORDER BY RAND() LIMIT 0,2
Cyprus Properties - Cyprus Ministry of Foreign Affairs
Search for Cyprus Property





Find Property by Ref:
(Featuring — Search by AREA)

Enter keywords to search this site
Mobile: 00357 99537985
Cyprus Map

Home -> Cyprus Ministry of Foreign Affairs

Cyprus Ministry of Foreign Affairs

Foreign Affairs Ministry Cyprus

Portal of the Cyprus Ministry of Foreign Affairs with on line information in the following areas.


 The Cyprus Question

         Historical Review

         Latest Developments

         Missing Persons

         Enclaved Persons

         Greek Cypriot Properties

         Closed Ports and Airports

         Turkish Measures Against Cyprus' Shipping

         Illegal Demographic Changes

         Destruction of Cultural Heritage

         Political Situation in the Occupied Areas

         Policy Towards the Turkish Cypriots


         The UN and the Cyprus Question


         International Organisations and the Cyprus Question



 Foreign Policy


         International Organisations

         Bilateral Relations


         Human Rights

         Fighting International Crime

 Protocol Information

         Presentation of Credentials

         State Protocol

         Order of Precedence



         Permanent Secretary

         The Ministry


         Student Internship

         The Citizen's Charter



 European Union

         Historical Overview

         Policy Issues




       Treaty of Lisbon

       Common Foreign and Security Policy / European
          Security and Defence Policy (CFSP / ESDP)


         Useful Information


 Overseas Cypriots

         Service for Overseas Cypriots

         Magazine H KYPROS MAS


         Educational Institutions

         Learning Modern Greek

         Information for Overseas and Repatriated Cypriots

         Communities Overseas

         Repatriated Cypriots



         Lates News

         Speeches / Interviews

         Mass Media


 Documents and Publications

         The Cyprus Question

         Cyprus and the EU

         Foreign Policy


See Also: Cyprus Ministry Interior | Cyprus Ministry Interior 2 | Cyprus Web Portal | Cyprus Ministry of Health | Cyprus Ministry Foreign Affairs