Your search did not return any results
Your criteria may be too restrictive, try removing some of them.
A loan commits you and must be repaid. Check your payment capabilities before you commit.
You cannot find the vehicle you were looking for ?
Make a personalised search request. We will contact you when it becomes available.
Contact us
"SELECT v0_.model_name AS model_name_0, v0_.model_slug AS model_slug_1, v0_.maker_name AS maker_name_2, v0_.maker_slug AS maker_slug_3, COUNT(v0_.id) AS sclr_4 FROM vehicle__vehicle v0_ LEFT JOIN agency__agency a1_ ON v0_.main_agency_id = a1_.id AND (a1_.deleted_at IS NULL) INNER JOIN vehicle__stock v2_ ON v0_.id = v2_.vehicle_id AND (v2_.deleted_at IS NULL) AND (v2_.agency_id IN (?)) WHERE ((v0_.cond = 'vo' AND (v0_.type = 'VP' AND v0_.type = 'VUL')) AND v0_.maker_id = ?) AND (v0_.deleted_at IS NULL) GROUP BY v0_.model_id ORDER BY sclr_4 DESC"
ArrayCollection {#6484
-elements: array:2 [
0 => Parameter {#6471
-name: "maker"
-value: Maker {#3153
#agencies: PersistentCollection {#3151
-snapshot: []
-owner: Maker {#3153}
-association: array:16 [ …16]
-em: EntityManager {#322 …11}
-backRefFieldName: "makers"
-typeClass: ClassMetadata {#649 …}
-isDirty: false
#collection: ArrayCollection {#3150
-elements: []
}
#initialized: false
}
#sort: 999
#formAvailable: true
#id: 107
#name: "FORD"
#usualName: "FORD"
#slug: "ford"
#distributed: null
#image: null
#models: PersistentCollection {#3182
-snapshot: []
-owner: Maker {#3153}
-association: array:15 [ …15]
-em: EntityManager {#322 …11}
-backRefFieldName: "maker"
-typeClass: ClassMetadata {#3146 …}
-isDirty: false
#collection: ArrayCollection {#156
-elements: []
}
#initialized: false
}
#fromArgus: false
#photo: null
#configuratorUrl: null
}
-type: 2
-typeSpecified: false
}
1 => Parameter {#6479
-name: "agencies"
-value: array:1 [
0 => Agency {#991
#youtubeAgency: null
#zipcode: "54700"
#weight: 999
#presentationShort: "-"
#presentationFull: ""
#schedule: ""
#apv: ""
#commercial: ""
#displayNameSlug: "car-avenue-store"
#image: Media {#1002
+__isInitialized__: false
#id: 782872
#originalUrl: null
#md5: null
#category: null
#name: null
#description: null
#enabled: false
#providerName: null
#providerStatus: null
#providerReference: null
#providerMetadata: []
#width: null
#height: null
#length: null
#copyright: null
#authorName: null
#context: null
#cdnIsFlushable: null
#cdnFlushIdentifier: null
#cdnFlushAt: null
#cdnStatus: null
#updatedAt: null
#createdAt: null
#binaryContent: null
#previousProviderReference: null
#contentType: null
#size: null
#galleryHasMedias: null
…2
}
#logo: Media {#1003
+__isInitialized__: false
#id: 578712
#originalUrl: null
#md5: null
#category: null
#name: null
#description: null
#enabled: false
#providerName: null
#providerStatus: null
#providerReference: null
#providerMetadata: []
#width: null
#height: null
#length: null
#copyright: null
#authorName: null
#context: null
#cdnIsFlushable: null
#cdnFlushIdentifier: null
#cdnFlushAt: null
#cdnStatus: null
#updatedAt: null
#createdAt: null
#binaryContent: null
#previousProviderReference: null
#contentType: null
#size: null
#galleryHasMedias: null
…2
}
#rental: null
#isInRdvForm: true
#hasMoto: false
#brandAgency: null
#brandUrl: null
#vehicleListUrl: null
#caabDealerBusinessPartner: null
#caabSalesmanBusinessPartner: null
-heroBackgroundColor: "#FF4F01"
-heroBackgroundImage: null
#id: 74
#displayName: "CAR Avenue STORE"
#active: true
#sort: null
#subdomain: "caravenue-store"
#publicarId: "caravenue_occasions"
#publicarHookKey: null
#exportPublicar: false
#theme: null
#mainSite: Site {#1015
+__isInitialized__: true
#countAgencies: 130
-heroBackgroundColor: "#000000"
-heroBackgroundImage: Media {#3397
+__isInitialized__: false
#id: 1503086
#originalUrl: null
#md5: null
#category: null
#name: null
#description: null
#enabled: false
#providerName: null
#providerStatus: null
#providerReference: null
#providerMetadata: []
#width: null
#height: null
#length: null
#copyright: null
#authorName: null
#context: null
#cdnIsFlushable: null
#cdnFlushIdentifier: null
#cdnFlushAt: null
#cdnStatus: null
#updatedAt: null
#createdAt: null
#binaryContent: null
#previousProviderReference: null
#contentType: null
#size: null
#galleryHasMedias: null
…2
}
#id: 1
#description: "Caravenue"
#emailServices: PersistentCollection {#3405
-snapshot: []
-owner: Site {#1015 …2}
-association: array:15 [ …15]
-em: EntityManager {#322 …11}
-backRefFieldName: "webSite"
-typeClass: ClassMetadata {#3332 …}
-isDirty: false
#collection: ArrayCollection {#3406
-elements: []
}
#initialized: false
}
#deletedAt: null
#name: "Caravenue"
#hostname: "caravenue.com"
#prependHostname: "www"
#code: "group"
#bundle: "AppGroupBundle"
#displayCity: "LESMÉNILS"
#displayCitySlug: "lesmenils"
#contactName: null
#phone: "+33633476820"
#fax: null
#email: "contact@caravenue.com"
#schedule: null
#agencies: PersistentCollection {#3318
-snapshot: []
-owner: Site {#1015 …2}
-association: array:16 [ …16]
-em: EntityManager {#322 …11}
-backRefFieldName: "sites"
-typeClass: ClassMetadata {#649 …}
-isDirty: false
#collection: ArrayCollection {#3383
-elements: []
}
#initialized: false
}
#address: "706 RUE DE LESMÉNILS-BOUXIÈRES"
#address2: null
#zipcode: "54700"
#city: "LESMÉNILS"
#country: "FR"
#lat: "43.6191236"
#lng: "1.446005"
#googlePlus: null
#facebook: "https://www.facebook.com/caravenuegroup/"
#twitter: "https://twitter.com/CAR_Avenue"
#instagram: "https://www.instagram.com/caravenue_group/"
#linkedin: "https://www.linkedin.com/company/car-avenue-mobility/"
#youtube: "https://www.youtube.com/channel/UChgyo_sC-crAOzplYRA75kQ"
#tiktok: null
#urlIframeBuyBack: null
#fundingService: "vivafi"
#fundingContribution: 0.15
#fundingDuration: 48
#translations: PersistentCollection {#3353
-snapshot: []
-owner: Site {#1015 …2}
-association: array:16 [ …16]
-em: EntityManager {#322 …11}
-backRefFieldName: "translatable"
-typeClass: ClassMetadata {#3396 …}
-isDirty: false
#collection: ArrayCollection {#3348
-elements: []
}
#initialized: false
}
#newTranslations: null
#currentLocale: "en"
#defaultLocale: "fr"
…2
}
#makers: PersistentCollection {#1030
-snapshot: []
-owner: Agency {#991}
-association: array:21 [ …21]
-em: EntityManager {#322 …11}
-backRefFieldName: "agencies"
-typeClass: ClassMetadata {#1023 …}
-isDirty: false
#collection: ArrayCollection {#1058
-elements: []
}
#initialized: true
}
#emailServices: PersistentCollection {#1092
-snapshot: []
-owner: Agency {#991}
-association: array:15 [ …15]
-em: EntityManager {#322 …11}
-backRefFieldName: "webSite"
-typeClass: ClassMetadata {#1089 …}
-isDirty: false
#collection: ArrayCollection {#1113
-elements: []
}
#initialized: false
}
#duplicatedFromAgencies: PersistentCollection {#1016
-snapshot: []
-owner: Agency {#991}
-association: array:15 [ …15]
-em: EntityManager {#322 …11}
-backRefFieldName: "duplicateToAgencies"
-typeClass: ClassMetadata {#649 …}
-isDirty: false
#collection: ArrayCollection {#1017
-elements: []
}
#initialized: false
}
#duplicateToAgencies: PersistentCollection {#1018
-snapshot: []
-owner: Agency {#991}
-association: array:19 [ …19]
-em: EntityManager {#322 …11}
-backRefFieldName: "duplicatedFromAgencies"
-typeClass: ClassMetadata {#649 …}
-isDirty: false
#collection: ArrayCollection {#1019
-elements: []
}
#initialized: false
}
#sites: PersistentCollection {#1004
-snapshot: array:1 [ …1]
-owner: Agency {#991}
-association: array:20 [ …20]
-em: EntityManager {#322 …11}
-backRefFieldName: "agencies"
-typeClass: ClassMetadata {#353 …}
-isDirty: false
#collection: ArrayCollection {#1005
-elements: array:1 [
0 => Site {#1015 …2}
]
}
#initialized: true
}
#name: "CAR Avenue STORE"
#hostname: null
#prependHostname: "www"
#code: "agency_vo"
#bundle: "AppGroupBundle"
#displayCity: "Lesménils"
#displayCitySlug: "lesmenils"
#contactName: null
#phone: "+33383842770"
#fax: null
#email: "store.lorraine@caravenue.com"
#address: "612 Chemin de Bouxières"
#address2: null
#city: "Lesménils"
#country: "FR"
#lat: "48.9414701"
#lng: "6.1140725"
#deletedAt: null
#googlePlus: null
#facebook: "https://www.facebook.com/CARAvenueOccasions/"
#twitter: null
#instagram: null
#linkedin: null
#youtube: null
#tiktok: null
#scheduleObject: null
#buyBackType: "iframe"
#urlIframeBuyBack: null
#fundingConfiguration: array:4 [
"agency_code" => "T006205368"
"partner_code" => "CAR_AVENUE"
"simulator_code" => "FI"
"maker_code" => "code"
]
#rdvTypes: PersistentCollection {#1124
-snapshot: []
-owner: Agency {#991}
-association: array:19 [ …19]
-em: EntityManager {#322 …11}
-backRefFieldName: "agencies"
-typeClass: ClassMetadata {#1118 …}
-isDirty: false
#collection: ArrayCollection {#1142
-elements: []
}
#initialized: false
}
#translations: PersistentCollection {#1084
-snapshot: []
-owner: Agency {#991}
-association: array:16 [ …16]
-em: EntityManager {#322 …11}
-backRefFieldName: "translatable"
-typeClass: ClassMetadata {#1059 …}
-isDirty: false
#collection: ArrayCollection {#1085
-elements: []
}
#initialized: false
}
#newTranslations: null
#currentLocale: "en"
#defaultLocale: "fr"
}
]
-type: 102
-typeSpecified: false
}
]
}
