You are here:
save up to 13% off list price
A solid and reliable SUV with a rugged exterior, the Volkswagen Tiguan has proved to be a popular choice for families. Comfortable for drivers and passengers alike, its tough interior will withstand the punishment that young occupants may inflict on it. It has great safety credentials, having been awarded five stars in its NCAP ratings, and a generous range of engine options ensures that there should be something for every need. Despite the fact that it is up against some worthy SUV rivals, the Volkswagen Tiguan remains very much in demand.
With the many pressures of family life it makes sense to let somebody else take the strain where that’s possible – and with a VW Tiguan personal lease you will relinquish many of the worries of car ownership. Budgeting is made less complicated with fixed monthly payments. Day-to-day maintenance is more or less covered with the help of a maintenance package where available. And finally, there are no worries about selling when the time comes – all you have to do is hand the car back.
There are several in-house alternatives to leasing a Volkswagen Tiguan. The German automaker has an indelible range that includes variants such as the seven-seater Tiguan Allspace which is ideal for towing caravans and horse boxes, or the larger, more powerful Volkswagen Touareg which is loaded with tech and a master at traversing off-road.
Having decided that a Volkswagen Tiguan car lease is right for you, you can find out all you need to know about Volkswagen Tiguan leasing with our help. At cars2buy, our transparent service and advanced filters make it simple to find the best possible Tiguan lease for you, saving you time and keeping your search stress-free. Our website is updated on a daily basis, ensuring that the latest prices are always available for you to compare.
1 x Application (93.71%) | 826ms |
1 x Booting (6.29%) | 55.50ms |
Backtrace |
|
select `trim` from `car_specs` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `trim_slug` = 'match') limit 1
Bindings |
|
Backtrace |
|
select `car_id` from `car_specs` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `trim_slug` = 'match') limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `lease_offers_personal` inner join `car_specs` on `car_specs`.`car_id` = `lease_offers_personal`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match'
Bindings |
|
Backtrace |
|
select lease_hash, same_deal_hash, d_sub, d_subid, lease_live, logo, name, linked, cap_id, car_id, business, personal, in_stock, delivery_time_type, delivery_time_value, metallic_inc, term, mileage, deposit, price_monthly, admin_fee, version, urllink, bid, lease_id, make, model, make_slug, model_slug, trim, uk_list from `lease_offers_personal` inner join `car_specs` on `car_specs`.`car_id` = `lease_offers_personal`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by price_monthly, effective_cost limit 10 offset 1860
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan') and `trim_slug` = 'match' group by `trim` order by `trim` asc
Bindings |
|
Backtrace |
|
select distinct `car_specs`.`cap_id` from `car_specs` inner join `images_izmo` on `car_specs`.`cap_id` = `images_izmo`.`cap_id` where `make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `trim_slug` = 'match' order by `car_specs`.`cap_id` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` where `cap_id` = 105212 and `ima_type` = 'CAR' and `path` != '' and `izmoAlias` != '' order by `ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `make`, `model` from `car_specs` where `cap_id` = 105212 limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Tiguan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Tiguan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `bid` from `lease_features` where `manufacturer` = 'Volkswagen' order by RAND() limit 1
Bindings |
|
Backtrace |
|
select `make_related`, `model_related`, `min_price` from `related_lease_models` inner join `min_price_personal_lease` on `min_price_personal_lease`.`make` = `related_lease_models`.`make_related` and `min_price_personal_lease`.`model` = `related_lease_models`.`model_related` where (`related_lease_models`.`make` = 'Volkswagen' and `related_lease_models`.`model` = 'Tiguan') group by `make_related`, `model_related` order by sort_order ASC limit 5
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Hyundai' and `car_specs`.`model` = 'Tucson' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'BMW' and `car_specs`.`model` = 'iX1' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Nissan' and `car_specs`.`model` = 'Qashqai' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Nissan' and `ima_model` = 'Qashqai' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Renault' and `car_specs`.`model` = 'Scenic E-Tech' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Renault' and `ima_model` = 'Scenic E-Tech' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Nissan' and `car_specs`.`model` = 'X-Trail' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Nissan' and `ima_model` = 'X-Trail' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan') group by `trim` order by `trim` asc
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `trim`, `version`, `car_id`, `version_slug` from `car_specs` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `trim` = 'Match') order by `version` asc
Bindings |
|
Backtrace |
|
select `make`, `make_slug`, `model_slug`, `model`, `version`, `cap_id`, `veh_id`, `urllink`, `logo`, `bid`, `d_subid`, `otrprice`, `linked`, `uk_list`, `dealers`.`acc_type`, `cpclick` from `cus_cars` inner join `car_specs` on `car_specs`.`car_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `broke_id` = `bid` or `broke_id` = `d_subid` inner join `partner_agents` on `partner_agents`.`pa_bid` = `dealers`.`did` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `otrprice` > 5000 and `pa_pid` = 5) and `trim_slug` = 'match' order by `otrprice` asc limit 2
Bindings |
|
Backtrace |
|
select make, model, MIN(otrprice/uk_list) as discount from `cus_cars` inner join `car_specs` on `car_specs`.`car_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `broke_id` = `bid` or `broke_id` = `d_subid` inner join `partner_agents` on `partner_agents`.`pa_bid` = `dealers`.`did` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `live` = 1 and `cap_id` > 1 and `d_live` = 1 and `amount` > 0 and `otrprice` > 5000 and `uk_list` > 1000 and `pa_pid` = 5) and (otrprice/uk_list) <= 0.995 group by `model`
Bindings |
|
Backtrace |
|
select distinct `make`, `make_slug` from `car_specs` order by `make` asc
Backtrace |
|
select `car_specs`.`make`, `car_specs`.`model`, `car_specs`.`make_slug`, `car_specs`.`model_slug`, `min_price_personal_lease`.`min_price` as `price_monthly` from `car_specs` left join `min_price_personal_lease` on `car_specs`.`make` = `min_price_personal_lease`.`make` and `car_specs`.`model` = `min_price_personal_lease`.`model` where `car_specs`.`make` = 'volkswagen' group by `car_specs`.`model` order by `car_specs`.`model` asc
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Arteon Shooting Brake' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Caddy' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Caddy' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Caddy California' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Caddy California Maxi' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Caddy Maxi' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'California' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Golf' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Golf Estate' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Grand California' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Grand California' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'ID.3' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'ID.4' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'ID.4' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'ID.5' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'ID.5' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'ID.7' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'ID.7 Tourer' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'ID.7 Tourer' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'ID.Buzz' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'ID.Buzz' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Multivan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Multivan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Passat Estate' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Passat Estate' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Polo' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'T-Cross' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'T-Cross' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'T-Roc' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'T-Roc Cabriolet' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'T-Roc Cabriolet' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Taigo' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Tayron' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Tayron' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Tiguan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Tiguan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Tiguan Allspace' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Tiguan Allspace' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Touareg' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Touran' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Touran' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Up' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
Bindings |
|
Backtrace |
|
select distinct MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match'
Bindings |
|
Backtrace |
|
select distinct MAX(price_monthly) as max_price, MIN(price_monthly) as min_price, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match'
Bindings |
|
Backtrace |
|
select distinct `car_id`, `version` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by `version` asc
Bindings |
|
Backtrace |
|
select distinct `fuel` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by `fuel` asc
Bindings |
|
Backtrace |
|
select distinct `transmission` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by `transmission` asc
Bindings |
|
Backtrace |
|
select distinct `engine` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by `engine` asc
Bindings |
|
Backtrace |
|
select distinct `bodytype` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by `bodytype` asc
Bindings |
|
Backtrace |
|
select distinct `doors` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' order by `doors` asc
Bindings |
|
Backtrace |
|
select distinct `term` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
Bindings |
|
Backtrace |
|
select distinct `deposit_type` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' and `term` in (6, 12, 18, 24, 36, 48, 60) and `deposit_type` in (1, 3, 6, 9, 12) order by `deposit_type` asc
Bindings |
|
Backtrace |
|
select distinct `mileage` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volkswagen' and `model_slug` = 'tiguan' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'match' and `term` in (6, 12, 18, 24, 36, 48, 60) and `deposit_type` in (1, 3, 6, 9, 12) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
Bindings |
|
Backtrace |
|
select (personal+business) as total from `lease_offers_count` order by `id` desc limit 1
Backtrace |
|
select `Text` from `seo` where (`Make` = 'Volkswagen' and `Model` = 'Tiguan' and `Type` = 'Car - Personal Lease')
Bindings |
|
Backtrace |
|
select `min_price` from `min_price_personal_lease` where `make` = 'Volkswagen' and `model` = 'Tiguan' limit 1
Bindings |
|
Backtrace |
|
200
0 of 0array:3 [▼ "page" => "187" "trimText" => "Match" "fTrim" => "match" ]
[]
0 of 0array:18 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "close" ] "x-accel-internal" => array:1 [▶ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [▶ 0 => "3.145.122.67" ] "host" => array:1 [▶ 0 => "laravel.cars2buy.co.uk" ] ]
[]
0 of 0array:7 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Fri, 24 Jan 2025 13:19:21 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:3 [▶ 0 => "uid=eyJpdiI6Imt6NVlUcDJDZENKWFF0dC9PU1EwR1E9PSIsInZhbHVlIjoiU3U3VkNXQU5SdUlMWll1WkVjZXA2d0dpeWJmMFkrR01laTRGNjhKaVR4U0xkajVaMCsxTTdGYjZ2Qm94bGZZbW5TTytGbTM4ZWRaMnU5V3AvY2xIeG42aG9yTEQ4NWQrNjEybVhwckhNb2c9IiwibWFjIjoiYTNjNTdhMTAxNGU1MDQ0Y2I3NDllZDA5NmJhMDgwNzBkYTMyMDI0ZGEwYmMxOWYzZjY5Yzk2NWQ3N2FmYTBmOCIsInRhZyI6IiJ9; expires=Sat, 12 Aug 5358 20:40:21 GMT; Max-Age=105196605660; path=/; secure; httponly; samesite=lax ◀uid=eyJpdiI6Imt6NVlUcDJDZENKWFF0dC9PU1EwR1E9PSIsInZhbHVlIjoiU3U3VkNXQU5SdUlMWll1WkVjZXA2d0dpeWJmMFkrR01laTRGNjhKaVR4U0xkajVaMCsxTTdGYjZ2Qm94bGZZbW5TTytGbTM4ZWRa ▶" 1 => "XSRF-TOKEN=eyJpdiI6IlBNZ0lYS1JOd2NxY0ZITmluY3dNclE9PSIsInZhbHVlIjoiQWZBUXp1bS9INGVJREVaa0RoekdBYVFubFMzWlY5WUtySll6RllRNVRneDBoZ0FvZFR1WTZGbHNkcHdoOEU5TlZtQzUxUm1aaGpKYXJTMERNT0dmdDBBcVRvM2ZYSTNGMkNSdmc0aWYzTGsxU3VtTS95QUhqWGE4N3lmVUNMb3ciLCJtYWMiOiJmNmJhNWI4YThlOWEyOTE5MjIwMjM3YmI5MDU3NWUyYTVjNmFmYjk2ZjNjNzI1MTdmOGNhNGE3M2VkYWM4MzMwIiwidGFnIjoiIn0%3D; expires=Fri, 24 Jan 2025 15:19:21 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlBNZ0lYS1JOd2NxY0ZITmluY3dNclE9PSIsInZhbHVlIjoiQWZBUXp1bS9INGVJREVaa0RoekdBYVFubFMzWlY5WUtySll6RllRNVRneDBoZ0FvZFR1WTZGbHNkcHdoOEU5TlZtQzUxU ▶" 2 => "laravel_session=eyJpdiI6IjQxTkNDQzlwOFB3L0dGdHRyOUh2NGc9PSIsInZhbHVlIjoiUU44SGNpdU00TU1tbDdkb2RndmFocStJcW0reU8vTUM2TWhsOE5IMk5mS3diMHE3VDNlOXRZVXFMNEVBaGoyTzUxVDUyQkE5OFdoa3Zxc3pqbU01TEhIdEhkejZ3Ukgwam9Oa2tFT1MrZjhIYXlSN1V5aXEvbFFtZFFNd21VYXUiLCJtYWMiOiIwMTNmN2I3MTU2OTNiMTRjNTE4ZDEyMTk4MjY3YTNkNDI1NmUzNTI4MzNjNWE3ODE0NDQ0MGQ0ODBmZjBiYThjIiwidGFnIjoiIn0%3D; expires=Fri, 24 Jan 2025 15:19:21 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjQxTkNDQzlwOFB3L0dGdHRyOUh2NGc9PSIsInZhbHVlIjoiUU44SGNpdU00TU1tbDdkb2RndmFocStJcW0reU8vTUM2TWhsOE5IMk5mS3diMHE3VDNlOXRZVXFMNEVBaGoyTzUx ▶" ] "Set-Cookie" => array:3 [▶ 0 => "uid=eyJpdiI6Imt6NVlUcDJDZENKWFF0dC9PU1EwR1E9PSIsInZhbHVlIjoiU3U3VkNXQU5SdUlMWll1WkVjZXA2d0dpeWJmMFkrR01laTRGNjhKaVR4U0xkajVaMCsxTTdGYjZ2Qm94bGZZbW5TTytGbTM4ZWRaMnU5V3AvY2xIeG42aG9yTEQ4NWQrNjEybVhwckhNb2c9IiwibWFjIjoiYTNjNTdhMTAxNGU1MDQ0Y2I3NDllZDA5NmJhMDgwNzBkYTMyMDI0ZGEwYmMxOWYzZjY5Yzk2NWQ3N2FmYTBmOCIsInRhZyI6IiJ9; expires=Sat, 12-Aug-5358 20:40:21 GMT; path=/; secure; httponly ◀uid=eyJpdiI6Imt6NVlUcDJDZENKWFF0dC9PU1EwR1E9PSIsInZhbHVlIjoiU3U3VkNXQU5SdUlMWll1WkVjZXA2d0dpeWJmMFkrR01laTRGNjhKaVR4U0xkajVaMCsxTTdGYjZ2Qm94bGZZbW5TTytGbTM4ZWRa ▶" 1 => "XSRF-TOKEN=eyJpdiI6IlBNZ0lYS1JOd2NxY0ZITmluY3dNclE9PSIsInZhbHVlIjoiQWZBUXp1bS9INGVJREVaa0RoekdBYVFubFMzWlY5WUtySll6RllRNVRneDBoZ0FvZFR1WTZGbHNkcHdoOEU5TlZtQzUxUm1aaGpKYXJTMERNT0dmdDBBcVRvM2ZYSTNGMkNSdmc0aWYzTGsxU3VtTS95QUhqWGE4N3lmVUNMb3ciLCJtYWMiOiJmNmJhNWI4YThlOWEyOTE5MjIwMjM3YmI5MDU3NWUyYTVjNmFmYjk2ZjNjNzI1MTdmOGNhNGE3M2VkYWM4MzMwIiwidGFnIjoiIn0%3D; expires=Fri, 24-Jan-2025 15:19:21 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlBNZ0lYS1JOd2NxY0ZITmluY3dNclE9PSIsInZhbHVlIjoiQWZBUXp1bS9INGVJREVaa0RoekdBYVFubFMzWlY5WUtySll6RllRNVRneDBoZ0FvZFR1WTZGbHNkcHdoOEU5TlZtQzUxU ▶" 2 => "laravel_session=eyJpdiI6IjQxTkNDQzlwOFB3L0dGdHRyOUh2NGc9PSIsInZhbHVlIjoiUU44SGNpdU00TU1tbDdkb2RndmFocStJcW0reU8vTUM2TWhsOE5IMk5mS3diMHE3VDNlOXRZVXFMNEVBaGoyTzUxVDUyQkE5OFdoa3Zxc3pqbU01TEhIdEhkejZ3Ukgwam9Oa2tFT1MrZjhIYXlSN1V5aXEvbFFtZFFNd21VYXUiLCJtYWMiOiIwMTNmN2I3MTU2OTNiMTRjNTE4ZDEyMTk4MjY3YTNkNDI1NmUzNTI4MzNjNWE3ODE0NDQ0MGQ0ODBmZjBiYThjIiwidGFnIjoiIn0%3D; expires=Fri, 24-Jan-2025 15:19:21 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjQxTkNDQzlwOFB3L0dGdHRyOUh2NGc9PSIsInZhbHVlIjoiUU44SGNpdU00TU1tbDdkb2RndmFocStJcW0reU8vTUM2TWhsOE5IMk5mS3diMHE3VDNlOXRZVXFMNEVBaGoyTzUx ▶" ] ]
0 of 0array:7 [▼ "_token" => "l05AkAzDwGrXv523mNwkwTE09pIH10gV36BhoCDJ" "views" => 1 "uid" => "f04efde3020326b9eea0a99933194e62" "last_results_page" => "/personal-car-leasing/volkswagen/tiguan/match/?page=187&trimText=Match" "_previous" => array:1 [▶ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/volkswagen/tiguan/match?page=187&trimText=Match" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]