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

Budva
Car Rental

Babin Do
Car Rental

Large Family (D1)
Toyota Auris

from €27/day

(22/08 - 04/09)

Budva
Car Rental

Budva Center
Car Rental

Medium Family Diesel (C2)
Hyundai I20 Diesel

from €27/day

(22/08 - 04/09)

Budva
Car Rental

Budva Bus Station
Car Rental

Medium Family (C1)
Suzuki Swift

from €23/day

(22/08 - 04/09)

Budva
Car Rental

Budva Center
Car Rental

Family Jeeps (I1)
Nissan Qashqai

from €75/day

(22/08 - 04/09)

Budva
Car Rental

Budva Old Town
Car Rental

Mini Economy (A)
Suzuki Alto

from €19/day

(22/08 - 04/09)

Budva
Car Rental

Budva Center
Car Rental

Economy (B)
Hyundai Getz

from €21/day

(22/08 - 04/09)

Budva
Car Rental

Budva Port
Car Rental

Family Limousine (J1)
Opel Insignia

from €39/day

(22/08 - 04/09)

Budva
Car Rental

Petrovac
Car Rental

Vans 9 Seats (H2)
Nissan Primastar

from €66/day

(22/08 - 04/09)