You are here:
leasing deals from £575 per month
Compare new LAND ROVER DISCOVERY DIESEL deals on cars2buy's new van price comparison site to find the best new van deals available in the UK. We advertise the best LAND ROVER DISCOVERY DIESEL deals we have been able to find to ensure that you are getting the best possible price available. Browse the LAND ROVER DISCOVERY DIESEL prices above and use cars2buy to contact the dealer directly. If you are looking to buy new a new LAND ROVER DISCOVERY DIESEL then you have come to the right place!
1 x Application (83.58%) | 188ms |
1 x Booting (16.42%) | 36.96ms |
Backtrace |
|
select `van_id` from `vans` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery' and `model_long_slug` = 'discovery-diesel') limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `cus_cars` inner join `vans` on `vans`.`van_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` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `capid` > 1 and `otrprice` > '4000') and `model_long_slug` = 'discovery-diesel'
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug`, `derivative` from `vans` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
Bindings |
|
Backtrace |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'LAND ROVER' and `vandirect`.`vans`.`model` = 'DISCOVERY' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' 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` = 'LAND ROVER' and `ima_model` = 'DISCOVERY' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
Bindings |
|
Backtrace |
|
select `model_cap` from `vandirect`.`vans` where `model` = 'DISCOVERY' limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'LAND ROVER' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'DISCOVERY' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `model_long`, `model_long_slug`, `derivative`, `van_id`, `derivative_slug` from `vans` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery' and `model_long` = 'DISCOVERY DIESEL') order by `derivative` asc
Bindings |
|
Backtrace |
|
select `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `derivative`, `derivative_slug`, `lease_id`, `urllink`, `linked`, `bid`, `d_subid`, `logo`, MIN(price_monthly) as price_monthly from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0 and `capid` > 1) and `model_long_slug` = 'discovery-diesel' group by `bid` order by `price_monthly` asc limit 2
Bindings |
|
Backtrace |
|
select COUNT(DISTINCT bid) as totalBrokers from `cus_cars` inner join `vans` on `vans`.`van_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` where (`live` = 1 and `capid` > 1 and `d_live` = 1 and `amount` > 0) and (`make_slug` = 'land-rover' and `model_slug` = 'discovery') and `model_long_slug` = 'discovery-diesel' limit 1
Bindings |
|
Backtrace |
|
select distinct `make`, `make_slug` from `vans` order by `make` asc
Backtrace |
|
select distinct `model`, `model_slug`, `make` from `vans` where `make_slug` = 'land-rover' order by `model` asc
Bindings |
|
Backtrace |
|
select `lease_live`, `linked`, `logo`, `derivative`, `derivative_slug`, `capid`, `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `bid`, `lease_id`, `type`, `term`, `mileage`, `price_monthly`, `deposit_type`, `deposit`, `vans`.`delivery`, `urllink`, `d_subid`, `name`, `live` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'discovery-diesel' order by `price_monthly` asc limit 1
Bindings |
|
Backtrace |
|
select `make`, `make_slug`, `model`, `model_slug`, `price_monthly` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 1) order by `price_monthly` asc limit 1
Bindings |
|
Backtrace |
|
select distinct `van_id`, `derivative`, `model_long` from `vans` where `make_slug` = 'land-rover' and `model_slug` = 'discovery' and `model_long_slug` = 'discovery-diesel' order by `derivative` asc
Bindings |
|
Backtrace |
|
select distinct `fuel` from `vans` where `make_slug` = 'land-rover' and `model_slug` = 'discovery' and `model_long_slug` = 'discovery-diesel' order by `fuel` asc
Bindings |
|
Backtrace |
|
select distinct `transmission` from `vans` where `make_slug` = 'land-rover' and `model_slug` = 'discovery' and `model_long_slug` = 'discovery-diesel' order by `transmission` asc
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug`, `derivative` from `vans` where (`make_slug` = 'land-rover' and `model_slug` = 'discovery') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "fVariant" => "discovery-diesel" ]
[]
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.135.216.99" ] "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 => "Thu, 30 Jan 2025 19:12:50 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:3 [▶ 0 => "uid=eyJpdiI6Imx2WnNzRnZ0N01RQUtEbkd3Q2tWUEE9PSIsInZhbHVlIjoiSUpsVlZ6d0h1VVJZOE14SHl4bFM2TnpDcjZkVVdTT3oxQkdPTkY1aU9rNVVxN2N3TnZRUG8xQzBXRVJzd1VVanQ1SStKeEJka0JPRStWc2J4UXJoYU5jOGJ5a2RzZXdEV0lEZzNIVENOR1E9IiwibWFjIjoiNzc0MTE0ZDBiM2M0MmQwMDg1MjA2ZTAyMTc5NzNkY2FjNzVlOTc3ZTIyMjMyNTY3MGI1M2VlNzUyNTcwMzc2NCIsInRhZyI6IiJ9; expires=Tue, 28 Aug 5359 20:02:50 GMT; Max-Age=105228982200; path=/; secure; httponly; samesite=lax ◀uid=eyJpdiI6Imx2WnNzRnZ0N01RQUtEbkd3Q2tWUEE9PSIsInZhbHVlIjoiSUpsVlZ6d0h1VVJZOE14SHl4bFM2TnpDcjZkVVdTT3oxQkdPTkY1aU9rNVVxN2N3TnZRUG8xQzBXRVJzd1VVanQ1SStKeEJka0JP ▶" 1 => "XSRF-TOKEN=eyJpdiI6IjlOY2p4UjRHT2pYUnBVUitJa05NVnc9PSIsInZhbHVlIjoieVFyWlFnYS91ZFdFNUJwb01lYXZLbXRrQmZ4eGg2NUI1UGR6V09IWGd2OHl5YUVoNGNjOENKRmo3bXJUUFNwSThlcU1XQllhbmxRemQ1TVoyYWt3emx5RmdZLy9aVWhOSC9kNXNuaHFCNkF5aEtMd2N3T1podzcrK0ZhUFE5Ny8iLCJtYWMiOiIzYmZlNTZmODYwZDJmNzM4YWU2ZjI3YTZjZDhhODU2MDAwNzg5NmNlZmIwMjU0ODBmZWIzMWIzNWRlMDY3OTgyIiwidGFnIjoiIn0%3D; expires=Thu, 30 Jan 2025 21:12:50 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjlOY2p4UjRHT2pYUnBVUitJa05NVnc9PSIsInZhbHVlIjoieVFyWlFnYS91ZFdFNUJwb01lYXZLbXRrQmZ4eGg2NUI1UGR6V09IWGd2OHl5YUVoNGNjOENKRmo3bXJUUFNwSThlcU1XQ ▶" 2 => "laravel_session=eyJpdiI6InhzVkhjM3VDUUNpcGxhN1dWYkUyS3c9PSIsInZhbHVlIjoiWW9SNTBZNlFnWG1hcGhTQUM2ZFF1NlcwRFlkMHVjb3hTRTBFRG9idkVhSGZjT3VDUWU4ajBSMmNRVjMzUkhKK3huT3FEYkx6UHNjRm1leURMNEJoclF2cjJtR2l5cUpUeXY0Y3JUUkMxWlVUdjdpRXFXNVlDSms5ZzJlMVVmMHUiLCJtYWMiOiI1MWU1MDA0YjdkNTA5ODdlZjI0ZjdjYzQ1MjhlMDJiNzI5OWE0ZTMyNWQyMWE4MDM3MGNkYjdiNmQ0NmE3ZjBmIiwidGFnIjoiIn0%3D; expires=Thu, 30 Jan 2025 21:12:50 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6InhzVkhjM3VDUUNpcGxhN1dWYkUyS3c9PSIsInZhbHVlIjoiWW9SNTBZNlFnWG1hcGhTQUM2ZFF1NlcwRFlkMHVjb3hTRTBFRG9idkVhSGZjT3VDUWU4ajBSMmNRVjMzUkhKK3hu ▶" ] "Set-Cookie" => array:3 [▶ 0 => "uid=eyJpdiI6Imx2WnNzRnZ0N01RQUtEbkd3Q2tWUEE9PSIsInZhbHVlIjoiSUpsVlZ6d0h1VVJZOE14SHl4bFM2TnpDcjZkVVdTT3oxQkdPTkY1aU9rNVVxN2N3TnZRUG8xQzBXRVJzd1VVanQ1SStKeEJka0JPRStWc2J4UXJoYU5jOGJ5a2RzZXdEV0lEZzNIVENOR1E9IiwibWFjIjoiNzc0MTE0ZDBiM2M0MmQwMDg1MjA2ZTAyMTc5NzNkY2FjNzVlOTc3ZTIyMjMyNTY3MGI1M2VlNzUyNTcwMzc2NCIsInRhZyI6IiJ9; expires=Tue, 28-Aug-5359 20:02:50 GMT; path=/; secure; httponly ◀uid=eyJpdiI6Imx2WnNzRnZ0N01RQUtEbkd3Q2tWUEE9PSIsInZhbHVlIjoiSUpsVlZ6d0h1VVJZOE14SHl4bFM2TnpDcjZkVVdTT3oxQkdPTkY1aU9rNVVxN2N3TnZRUG8xQzBXRVJzd1VVanQ1SStKeEJka0JP ▶" 1 => "XSRF-TOKEN=eyJpdiI6IjlOY2p4UjRHT2pYUnBVUitJa05NVnc9PSIsInZhbHVlIjoieVFyWlFnYS91ZFdFNUJwb01lYXZLbXRrQmZ4eGg2NUI1UGR6V09IWGd2OHl5YUVoNGNjOENKRmo3bXJUUFNwSThlcU1XQllhbmxRemQ1TVoyYWt3emx5RmdZLy9aVWhOSC9kNXNuaHFCNkF5aEtMd2N3T1podzcrK0ZhUFE5Ny8iLCJtYWMiOiIzYmZlNTZmODYwZDJmNzM4YWU2ZjI3YTZjZDhhODU2MDAwNzg5NmNlZmIwMjU0ODBmZWIzMWIzNWRlMDY3OTgyIiwidGFnIjoiIn0%3D; expires=Thu, 30-Jan-2025 21:12:50 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjlOY2p4UjRHT2pYUnBVUitJa05NVnc9PSIsInZhbHVlIjoieVFyWlFnYS91ZFdFNUJwb01lYXZLbXRrQmZ4eGg2NUI1UGR6V09IWGd2OHl5YUVoNGNjOENKRmo3bXJUUFNwSThlcU1XQ ▶" 2 => "laravel_session=eyJpdiI6InhzVkhjM3VDUUNpcGxhN1dWYkUyS3c9PSIsInZhbHVlIjoiWW9SNTBZNlFnWG1hcGhTQUM2ZFF1NlcwRFlkMHVjb3hTRTBFRG9idkVhSGZjT3VDUWU4ajBSMmNRVjMzUkhKK3huT3FEYkx6UHNjRm1leURMNEJoclF2cjJtR2l5cUpUeXY0Y3JUUkMxWlVUdjdpRXFXNVlDSms5ZzJlMVVmMHUiLCJtYWMiOiI1MWU1MDA0YjdkNTA5ODdlZjI0ZjdjYzQ1MjhlMDJiNzI5OWE0ZTMyNWQyMWE4MDM3MGNkYjdiNmQ0NmE3ZjBmIiwidGFnIjoiIn0%3D; expires=Thu, 30-Jan-2025 21:12:50 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InhzVkhjM3VDUUNpcGxhN1dWYkUyS3c9PSIsInZhbHVlIjoiWW9SNTBZNlFnWG1hcGhTQUM2ZFF1NlcwRFlkMHVjb3hTRTBFRG9idkVhSGZjT3VDUWU4ajBSMmNRVjMzUkhKK3hu ▶" ] ]
0 of 0array:6 [▼ "_token" => "9Cx4WZuoRbiWhQMkzie3gWzjFzmKlu93PG9Wxzor" "views" => 1 "uid" => "55adf222d3f60057949b3466dc82c844" "_previous" => array:1 [▶ "url" => "https://laravel.cars2buy.co.uk/new-vans/land-rover/discovery/discovery-diesel" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]