Welcome to our selection of holiday rentals in Larnaca, Cyprus. We offer villas, apartments, holiday homes and fincas to rent in Larnaca direct from their owners.
Choose a holiday rental in Larnaca
.:sql error:.
sql say: you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near ' rand(1215504601) limit 0,1000' at line 1 query: select prop.prop_id, prop.bedrooms, prop.propertytype, prop.area, prop.sleeps, prop.lowrent, prop.currency, prop.highrent, prop.rentperiod from prop where ( ((upper(prop.area) like upper('%larnaca%') )) ) and ( ((upper(prop.country) like upper('%cyprus%') )) ) order by (1215504601-prop._last_login > (30*86400)), (1215504601-prop._last_login < (30*86400)), , rand(1215504601) limit 0, 1000
