WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW COLUMNS FROM `lz_trustindex_booking_reviews` LIKE "highlight"
WordPress database error: [Duplicate column name 'highlight'] ALTER TABLE `lz_trustindex_booking_reviews` ADD highlight VARCHAR(11) NULL AFTER rating
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
Lazaros Stone House – Lazaros StoneHouse
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `lz_options`
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT lz_posts.*
FROM lz_posts LEFT JOIN lz_term_relationships ON (lz_posts.ID = lz_term_relationships.object_id)
WHERE 1=1 AND (
lz_term_relationships.term_taxonomy_id IN (61)
) AND lz_posts.post_type = 'nav_menu_item' AND ((lz_posts.post_status = 'publish'))
GROUP BY lz_posts.ID
ORDER BY lz_posts.menu_order ASC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT lz_posts.*
FROM lz_posts LEFT JOIN lz_term_relationships ON (lz_posts.ID = lz_term_relationships.object_id)
WHERE 1=1 AND (
lz_term_relationships.term_taxonomy_id IN (64)
) AND lz_posts.post_type = 'nav_menu_item' AND ((lz_posts.post_status = 'publish'))
GROUP BY lz_posts.ID
ORDER BY lz_posts.menu_order ASC
Welcome to Lazaros StoneHouse − a great stone house in one of the best agrotourism villages of Cyprus.
Home 1
Lazaros Stonehouse − a great stone house in one of the best agrotourism villages of Cyprus.
We are delighted to welcome you to our traditional home in Lefkara! A house built of stone that has been lovingly restored by us in the spirit of the traditions of this picturesque village.
Twin room comes with two single beds which we can put together to be a Double room. The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots […]
Twin room comes with two single beds which we can put together to be a Double room. The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots […]
Twin room comes with old Cypriot double bed made by wood The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots of city landmarks as our hotel […]
Twin room comes with old Cypriot double traditional bed with balcony The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots of city landmarks as our hotel […]
Twin room comes with old Cypriot double bed made by old wood The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots of city landmarks as our […]
Twin room comes with old Cypriot double bed made by iron The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots of city landmarks as our hotel […]
Twin room comes with two single beds which we can put together to be a Double room. The room size vary from 16 to 20 sqm. They is also equipped with a mini fridge, air-conditioning unit, wardrobe, flat-screen TV and kettle for your hot tea or coffee. You’ll enjoy a perfect Lefkara view with lots […]
Lazaros Stonehouse offers four private double rooms and three twin single rooms. On the upper floor there is cosy and spacious terrace and downstairs there is a specious living room with a fabulous fireplace and dining tables which offers enough space for 20 people!!!
Lefkara is the homeland of the island’s traditional embroidery, the Cypriot famous lace which is called “lefkaritiko”. Its reputation skidded from the boundaries of Cyprus and became known in most countries of Europe and not only. Continue reading “The Embroideries”
There are some beautiful nature trails that traverse across Lefkara mountainous areas, with each designed to show the very best of the island’s scenic beauty and excellent views in all directions.
Lefkara Dam is one of the biggest dams of Cyprus, with a capacity of about 14 million c.m of water. Is constructed in 1973. It is made of earth and has a height of 74 metres. While getting closer, you will realise that you are in extraordinary place. Continue reading “Lefkara Dam”
Every corner of Lefkara is deeply connected to Christianity since in every neighborhood and in short distances around the village, there are many preserved chapels that are operated frequently until this day. The church of the Holy Cross dominates at the center of Lefkara. According to tradition, the Cross on Pano Lefkara was allegedly transferred […]
Lefkara village celebrates Easter Monday with a traditional event including yard games, folkloric entertainment, activities and complimentary souvla (barbeque ) and wine.
Lefkara Festival is held every August. Cultural Events, competitions, music nights, dances and theatrical performances, every tourist and locals should see.
Our Guest’s Reviews
10
Exceptional
Stella
01/01/2021
9.0
☺Ήταν όλα πολυ ωραία!
Theodosia
01/12/2020
10
Exceptional
Marilena
01/11/2020
10
Exceptional
Pambos
01/10/2020
10
Exceptional
Panayiota
01/10/2020
10
Great owners, rooms and location!
☺ The rooms are modern and clean and in a great location and the owners were quick to answer all our questions and help us is anything they needed. Abs there is free parking close to the location even though it’s in the centre of Pano Lefkara.
☹ Nothing
Constantinos
01/10/2020
9.0
Superb
Ioannis
01/09/2020
10
Exceptional
Rafaella
01/09/2020
Ready to Get Started?
It’s safe to book online with us! Get your dream stay in clicks or drop us a line with your questions.
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1223' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1299' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1304' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1311' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1318' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1336' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system") in /home/lazarosstonehous/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Can't create/write to file '/tmp/#sql_762a_0.MAI' (Errcode: 30 "Read-only file system")]
SELECT DISTINCT lz_posts.*
FROM lz_posts INNER JOIN lz_postmeta ON ( lz_posts.ID = lz_postmeta.post_id ) INNER JOIN lz_posts AS mphb_reserved_rooms
ON mphb_reserved_rooms.post_parent = lz_posts.ID INNER JOIN lz_postmeta AS mphb_reserved_room_room_id
ON mphb_reserved_rooms.ID = mphb_reserved_room_room_id.post_id
WHERE 1=1 AND (
( lz_postmeta.meta_key = 'mphb_check_out_date' AND CAST(lz_postmeta.meta_value AS DATE) >= '2023-06-06' )
) AND lz_posts.post_type = 'mphb_booking' AND ((lz_posts.post_status = 'pending' OR lz_posts.post_status = 'pending-user' OR lz_posts.post_status = 'pending-payment' OR lz_posts.post_status = 'confirmed')) AND mphb_reserved_room_room_id.meta_key = '_mphb_room_id'
AND mphb_reserved_room_room_id.meta_value IN ( '1349' )
GROUP BY lz_posts.ID
ORDER BY lz_posts.post_date DESC
