Why Book With Us

Basket is Empty

Excursions & Entertainment

Car Hire

select distinct(main_price_attribute_id) from product_price_attributes where product_id='152' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT

Group C - Renault Clio, VW polo, Citroen C3

Group C cars include Renault Clio Alize, Volkswagen Polo 1.4 and Citroen C3 1.1 with air conditioning.

 

Price From € 42.00

select distinct(main_price_attribute_id) from product_price_attributes where product_id='153' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT

Group D - Seat Ibiza, Renault Clio

Group D cars include Seat Ibiza 1.4, Renault Clio III and Renault Clio Alize with air conditioning.

 

Price From € 42.50

select distinct(main_price_attribute_id) from product_price_attributes where product_id='154' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT

Group E - Seat Cordoba 1.4, VW Polo (automatic), Seat Ibiza 1.4

Group E - Seat Cordoba 1.4, VW Polo (automatic), Seat Ibiza 1.4 with air conditioning.

 

Price From € 75.00

select distinct(main_price_attribute_id) from product_price_attributes where product_id='155' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT

Group F - Mercedes & Renault Scenic

Group F - Mercedes A-160, Renault Scenic 1.9 Dci with air conditioning.

 

Price From € 72.09

select distinct(main_price_attribute_id) from product_price_attributes where product_id='156' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT

Group F1 - Renault Megane Cabriolet Coupe 1.6

With a choice of 2 Megane Cabriolets this one is the new shape with air conditioning and electric roof.

 

Price From € 83.00

select distinct(main_price_attribute_id) from product_price_attributes where product_id='157' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT

Group G - Opel Zafira, Renault Scenic, VW Transporter, Renault Traffic

Group G cars include Opel Zafira 1.9 Cdti, Renault Grand Scenic 1.9 Tdi, VW Transporter 1.9 Tdi and Renault Traffic 1.9 Dci with air conditioning.

 

Price From € 93.90