Get a Quote
Pick Up
Pick Up Date:
Time:
Drop Off
Drop Off Date:
Time:
Currency
Secured by COMODO
Special Offers - Vigo 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 = '235' AND ctlocation_ids.brand_id=1 AND ctlocation_ids.level='W' GROUP BY special_offers.id ORDER BY RAND()

Vigo Airport
Car Rental

Medium Family Diesel (C2)
Suzuki Swift Diesel

from €27/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Large Automatic (E1)
Peugeot 307 Automatic

from €37/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Small Automatic (E3)
Peugeot 108 Automatic

from €27/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Economy (B)
Fiat Panda

from €21/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Large Family (D1)
Hyundai I30

from €27/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Large Family (D2)
Opel Vectra

from €36/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Large Automatic (E1)
Hyundai I30 Automatic

from €37/day

(01/01 - 31/12)

Vigo Airport
Car Rental

Mini Economy (A)
Chevrolet Spark

from €19/day

(01/01 - 31/12)