Rent a car

Choice and tranquility
SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

SONET

or similar

  • 5 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
85.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

MINI COOPER

or similar

  • 4 seats
  • 3 doors
  • Automatic
  • A/C
  • Driving license required

from
105.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC
CS55 Plus - welcomesbh.com - location de véhicules à Saint-Barthélemy

CS55 PLUS

or similar

  • 5 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
105.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

FIAT 500

or similar

  • 4 seats
  • 3 doors
  • Automatic
  • A/C
  • Driving license required

from
115.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

MINI COUNTRYMAN

or similar

  • 5 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
120.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

T-ROC

or similar

  • 4 seats
  • 3 doors
  • Automatic
  • A/C
  • Driving license required

from
135.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

MINI COUNTRYMAN ELECTRIC

or similar

  • 5 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
150.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

BJ40 3 PORTES

or similar

  • 4 seats
  • 3 doors
  • Automatic
  • A/C
  • Driving license required

from
150.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

SORENTO

or similar

  • 7 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
160.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

X7 PLUS

or similar

  • 7 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
160.00€/ day

Select your dates of stay to book your car.

SELECT L.*, tarif.minTarif FROM LOC_VEHICULES_CATEGORIES L, (SELECT IDObjet, MIN(Tarif_jour) AS minTarif FROM LOC_TARIFS T WHERE Statut = 1 AND StatutSaison > 0 GROUP BY IDObjet) AS tarif WHERE L.ID = tarif.IDObjet AND L.Statut = 1 AND L.WdMenu = 'rent-a-car' ORDER BY tarif.minTarif ASC

BJ40 5 PORTES

or similar

  • 5 seats
  • 5 doors
  • Automatic
  • A/C
  • Driving license required

from
190.00€/ day

Select your dates of stay to book your car.