Rental Cars Menidi

| Australia | EN EN
SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '483' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483' 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 cars.car_id = '2061' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


1SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '1093' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1093' 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 cars.car_id = '2062' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'

SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '1089' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1089' 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 cars.car_id = '2063' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


2SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '1114' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1114' 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 cars.car_id = '2042' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


3SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '483' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483' 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 cars.car_id = '2049' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


4SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '1092' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1092' 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 cars.car_id = '2058' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


5SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '483' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483' 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 cars.car_id = '2059' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


6SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '1104' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1104' 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 cars.car_id = '2038' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


7SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '483' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483' 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 cars.car_id = '2050' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


8SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto FROM cars INNER JOIN ctcountry ON ctcountry.id='61' INNER JOIN ctregion ON ctregion.id = 14 INNER JOIN ctlocation ON ctlocation.id = '1089' INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1089' 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 cars.car_id = '2048' 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 ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'


9

Car Rental Menidi

Special Offers (01/01 → 07/06)

Rent a Car Menidi

Rental Cars Menidi
Vans 9 Seats (H1)
Citroen Jumpy

Car Hire Menidi

Rental Cars Menidi
Vans 9 Seats Diesel (H2)
Volkswagen Transporter TDI Diesel

Hire Car Menidi

Rental Cars Menidi
Large Family (D2)
Volkswagen Golf

Menidi Car Hire

Rental Cars Menidi
Mini Economy (A)
Skoda Citigo

Menidi Rent a Car

Rental Cars Menidi
Vans 7 Seats (L1)
Fiat Doblo

Menidi Car Rental

Rental Cars Menidi
Vans 7 Seats (L1)
Volkswagen Caddy Maxi

Menidi Car Rentals

Rental Cars Menidi
Family Limousine (D3)
Peugeot 407

Menidi Hire Car

Rental Cars Menidi
Large Family (D1)
Nissan Note

Car Rentals Menidi

Rental Cars Menidi
Medium Family (C1)
Volkswagen Polo
Useful Information |

Imperial Car Rental Ioannina


SSL Secure Site SSL Secure Site