Get a Quote
Pick Up
Pick Up Date:
Time:
Drop Off
Drop Off Date:
Time:
Currency
Secured by COMODO
Special Offers - Beja Airport - Book Now
SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctlocation.name2_en as location, ctlocation.id as location_id, ctregion.id as reg_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto, d.new_id, ctlocation_ids.new_id as new_loc_id FROM special_offers INNER JOIN ctcountry ON special_offers.country_id=ctcountry.id INNER JOIN ctregion ON special_offers.region_id=ctregion.id INNER JOIN ctregion_ids d ON special_offers.region_id=d.region_id INNER JOIN ctlocation ON special_offers.location_id=ctlocation.id INNER JOIN ctlocation_ids ON ctlocation.id = ctlocation_ids.location_id INNER JOIN cars ON special_offers.car_id=cars.car_id INNER JOIN groups ON cars.group_id = groups.group_id INNER JOIN pricelists ON cars.group_id = pricelists.group_id INNER JOIN periods ON pricelists.period_id = periods.period_id WHERE d.brand_id=1 AND d.level='W' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND special_offers.site_level='W' AND special_offers.page='R' AND special_offers.region_id = '168' AND ctlocation_ids.brand_id=1 AND ctlocation_ids.level='W' GROUP BY special_offers.id ORDER BY RAND()

Beja Airport
Car Rental

Large Family Diesel (D3)
Renault Megane Diesel

from €32/day

(22/08 - 04/09)

Beja Airport
Car Rental

Mini Economy (A)
Skoda Citigo

from €19/day

(22/08 - 04/09)

Beja Airport
Car Rental

Economy (B)
Skoda Fabia

from €21/day

(22/08 - 04/09)

Beja Airport
Car Rental

Vans 9 Seats (H2)
Nissan Primastar

from €66/day

(22/08 - 04/09)

Beja Airport
Car Rental

Medium Family Diesel (C2)
Hyundai I20 Diesel

from €27/day

(22/08 - 04/09)

Beja Airport
Car Rental

Mini Vans 7 Seats Automatic (L2)
Nissan Evalia Automatic

from €54/day

(22/08 - 04/09)

Beja Airport
Car Rental

Small Automatic (E3)
Peugeot 108 Automatic

from €27/day

(22/08 - 04/09)

Beja Airport
Car Rental

Large Family (D2)
Volvo S40

from €36/day

(22/08 - 04/09)