Welcome to our selection of holiday rentals in Tenerife, Spain. We offer villas, apartments, holiday homes and fincas to rent in Tenerife direct from their owners.
Choose a holiday rental in Tenerife
.: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(1223884935) 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('%tenerife%') )) ) and ( ((upper(prop.country) like upper('%spain%') )) ) order by (1223884935-prop._last_login > (30*86400)), (1223884935-prop._last_login < (30*86400)), , rand(1223884935) limit 0, 1000
