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 - Government Hospitals Telephone Contacts
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 Hospitals Telephone Contacts

Government Hospitals Telephone Contacts

Cyprus Hospitals Contact Details

Please do not worry over visiting any government hospital in Cyprus, their services are very good and they will welcome you for any emergency case. I have used them on several occasions for our kids and once when I burned my hands in a fire.

Cyprus Hospitals -  Telephone Contact Details


Apollonion Private Hospital, Nicosia - Tel: +357 22350022
Archbishop Makarios III Hospital, Nicosia - Tel: +357  22493600
Nicosia General Hospital, Nicosia - Tel: +357  22801400


Larnaca New Hospital, Larnaca - Tel: +357  24630300
Larnaca Hospital, Larnaca - Tel: +357 24630312


Limassol New Hospital, Limassol - Tel: +357 25330333
Limassol Hospital, Limassol - Tel: +357 25330777


Paphos Hospital, Paphos - Tel: +357 26940111

Paralimni Hospital: Tel: +357 23 82 12 11

Polis Hospital: Tel: +357 26 32 14 31

Kyperounta Hospital: Tel: +357 25 53 20 21

Please use our suggestion/feedback form if you wish to add any hospital/clinic recommendations to this page.



See Also: Cyprus Our Home | Cyprus Residence Permit | Cyprus Income Tax | Work Permit Cyprus | Emergency Numbers Cyprus | Doctors & Chemists Cyprus | Cyprus Hospitals | Cyprus Health Care | Cyprus Medical Insurance | Cyprus Medical Card | Common Ownership Law