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=4 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 - Nicosia Investment Property Locations
Search for Cyprus Property





from

to

from

to


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

Enter keywords to search this site
View More Cyprus Property - Info 
View More Cyprus Money & Finance 
View More Planning a Trip Cyprus 
View More Living in Cyprus 
View More Cyprus Residential Property  
View More Cyprus Investment Property 
View More Cyprus Town Guide 
View More Cyprus Schools 
View More Moving to Cyprus 
View More Cyprus Property Management 
View More Cyprus Government 
View More Cyprus Corporate Services 
Bookmark us
Contact us via Skype
Request a Call Back
Mobile: 00357 99537985
Cyprus Map