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=16 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 - Government Offices Ministry of Interior
Search for Cyprus Property





from

to

from

to


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

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

Home -> Government Offices Ministry of Interior

Government Offices Ministry of Interior

 Ministry of the Interior Cyprus

Ministry of the Interior

Cyprus government portal including pages and information on the following Citizen's Charter.

Departments

Civil Registry and Migiration Department Including:

Preface
Identity Cards
Electoral List
Cyprus Passports
Cypriot Citizenship
Immigration Permits
Entry Visas
Alien Students
Employment of Aliens 

Services for Displaced Persons Including:

General Information
Citizen's Rights
Citizen's Obligations
General Information about Housing Schemes
"Refugee due to Profession"
Legislation Applications 

Turkish Cypriot Property Management Service Including:

Preface
Property Management
Delegation of Powers of
the Custodian
T/C Properties
Categories of T/C Properties
Criteria for Allocating T/C Properties
Examination of Applications
Contact Us 

Land and Services Including:

Introduction
Applications
Transfers / Mortgages
Encumbrances
Forced Sales
Leases
Compulsory Acquisition / Requisition
Disposal of State Land
Fees and Charges
Contact Us 

Planning System Including:

General Information
The Planning System
Development Plans
Development Control
Representations & Opinions
Planning Permission through Departure
Planning Appeals
Compensation
Appeals to the Supreme Court
Appendices 

District  Administration Including:

Civil Registry
Housing Loans
Buildings
Water Development
Licences
Management of
T/C Properties
Registration of Clubs
Aliens
Certifying Officers
Fund-Raising Permits
Cyprus Electricity Authority
Tax Complaints
Certificates of Permanent Residence
Forms / Applications 



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