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=1 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 - Protaras Property - Real Estate for Sale Villas Houses
Search for Cyprus Property





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

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

Home -> Protaras Property - Real Estate for Sale Villas Houses

Protaras Property - Real Estate for Sale Villas Houses

Protaras Property

The Main Mreas of Protaras

Ayios Elias - which is set back from the tourist areas on the hill over looking Protaras town and with views to the sea.

Cape Greko - is on the beach where Ayia Napa meets Protaras. An exclusive area with 5 star hotels and and residential properties to match.

Fig Tree Bay - famous for its golden sands and cyrstal clear water. Very much the heart and hub of Protaras.

See Also: Ayia Napa Property | Larnaca Property | Larnaca Village Houses | Polis Property | Latchi Property | Limassol Properties | Limassol Village Houses | Paphos Property | Paphos Village Houses | Paralimni Property | Pissouri Property | Nicosia Property | Nicosia Village Houses | Protaras Residential Property