You are here:
cars2buy want to make it as easy as possible for you to find a new Lotus Evija Fittipaldi at the best possible price. In order to do this we have collected prices from a range of providers - including Lotus dealers and independent car brokers - for you to compare, saving you the hassle of having to negotiate yourself.
All Lotus Evija Fittipaldi cars advertised on cars2buy are UK cars with the standard Lotus warranty and all the usual pre-delivery inspections are carried out by an authorised dealer. For further information please speak directly to the supplier of your choice.
Our service is completely transparent, we put you in direct contact with the supplier, either via their website or by sending an enquiry direct. It is a completely free service to you, simply click the 'Deal Details' button on the Lotus Evija Fittipaldi deal you are interested in to view more details and contact the dealer directly.
1 x Application (78.03%) | 171ms |
1 x Booting (21.97%) | 48.22ms |
Backtrace |
|
select `trim` from `car_specs` where (`make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi') limit 1
Bindings |
|
Backtrace |
|
select `car_id` from `car_specs` where (`make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi') limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate 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` = 'lotus' and `model_slug` = 'evija' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `totdis` >= 0 and `pa_pid` = 5) and `trim_slug` = 'fittipaldi'
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'lotus' and `model_slug` = 'evija') and `trim_slug` = 'fittipaldi' 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` = 'lotus' and `model_slug` = 'evija' and `trim` = 'Fittipaldi') order by `version` asc
Bindings |
|
Backtrace |
|
select distinct `tt_cpc` as `cpclick`, `live`, `tt_vehid` as `veh_id`, `cap_id`, `make`, `model`, `make_slug`, `model_slug`, `version`, `otrprice`, `name`, `motr`, `id_car`, `uk_list`, `rfl`, `car_specs`.`delivery`, `prereg`, `linked`, `logo`, `dealers`.`acc_type`, `d_live`, `urllink`, `bid`, `d_sub`, `d_subid`, `colour`, `b_delivery`, `options`, `mileage`, `reg_date`, `nearly_new` 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 `topten` on `topten`.`tt_vehid` = `cus_cars`.`veh_id` and `topten`.`tt_broker` = `cus_cars`.`bid` inner join `partner_agents` on `partner_agents`.`pa_bid` = `cus_cars`.`bid` where (`make_slug` = 'lotus' and `model_slug` = 'evija' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `pa_pid` = 5) order by RAND() limit 1
Bindings |
|
Backtrace |
|
select `make`, `make_slug`, `model`, `model_slug`, `price_monthly` from `lease_offers` inner join `car_specs` on `car_specs`.`car_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'lotus' and `model_slug` = 'evija' and `personal` = 1 and `business` = 0 and `lease_live` = 1 and `lease_active` = 1 and `live` = 1 and `price_monthly` > 1) and `lease_hash` is not null order by `price_monthly` asc limit 1
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'lotus' and `model_slug` = 'evija') group by `trim` order by `trim` asc
Bindings |
|
Backtrace |
|
select `lease_hash`, `same_deal_hash`, `car_id`, `make`, `model`, `make_slug`, `model_slug`, `version`, `cap_id`, `lease_id`, `logo`, `bid`, `d_subid`, MIN(price_monthly) as price_monthly 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 (`lease_live` = 1 and `lease_active` = 1 and `live` = 1 and `price_monthly` > 1 and `make_slug` = 'lotus' and `model_slug` = 'evija') and `trim_slug` = 'fittipaldi' group by `bid` order by `price_monthly` asc limit 2
Bindings |
|
Backtrace |
|
select COUNT(DISTINCT bid) as totalBrokers 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 (`amount` > 0 and `d_live` = 1 and `live` = 1 and `totdis` >= 0 and `otrprice` > 5000 and `d_live` = 1 and `pa_pid` = 5) and (`make_slug` = 'lotus' and `model_slug` = 'evija') and `trim_slug` = 'fittipaldi' limit 1
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` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `car_specs`.`cap_id` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` where `cap_id` = 103022 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` = 103022 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` = 'Lotus' and `car_specs`.`model` = 'Evija' 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` = 'Lotus' and `ima_model` = 'Evija' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
Bindings |
|
Backtrace |
|
select distinct `make`, `make_slug` from `car_specs` order by `make` asc
Backtrace |
|
select distinct `model`, `model_slug`, `make` from `car_specs` where `make_slug` = 'lotus' order by `model` asc
Bindings |
|
Backtrace |
|
select distinct `car_id`, `version` from `car_specs` where `make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `version` asc
Bindings |
|
Backtrace |
|
select distinct `fuel` from `car_specs` where `make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `fuel` asc
Bindings |
|
Backtrace |
|
select distinct `transmission` from `car_specs` where `make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `transmission` asc
Bindings |
|
Backtrace |
|
select distinct `engine` from `car_specs` where `make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `engine` asc
Bindings |
|
Backtrace |
|
select distinct `bodytype` from `car_specs` where `make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `bodytype` asc
Bindings |
|
Backtrace |
|
select distinct `doors` from `car_specs` where `make_slug` = 'lotus' and `model_slug` = 'evija' and `trim_slug` = 'fittipaldi' order by `doors` asc
Bindings |
|
Backtrace |
|
select `Text` from `seo` where (`Make` = 'Lotus' and `Model` = 'Evija' and `Type` = 'Car - New')
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "fTrim" => "fittipaldi" ]
[]
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.17.109.119" ] "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 22:55:28 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:3 [▶ 0 => "uid=eyJpdiI6IlFVRHNBYS9kK3Bta2xJUkdETWZYV0E9PSIsInZhbHVlIjoicWlkOHk5NndjZjI2WFNSNlVON2tsQWpab2J0eWJJSHJSYW82Zmd4MTBHMklPSnZRSDhLUTRkZTJBcCtyaVFxRUhNUHU3dW43MFE4R3VlY3FzTTFpeFA5M3h6cGZGSVV3YzhOeWZ5SGhxdkU9IiwibWFjIjoiYTc2YjdhMDFkZWNhZjU2ZWUzZjNhMGViM2U3NDIwNThjNjQ3MTU2YzIyMTk4MGFhM2M3N2Q2NDQ4NzRmNjhmMyIsInRhZyI6IiJ9; expires=Fri, 07 Sep 5359 06:23:28 GMT; Max-Age=105229783680; path=/; secure; httponly; samesite=lax ◀uid=eyJpdiI6IlFVRHNBYS9kK3Bta2xJUkdETWZYV0E9PSIsInZhbHVlIjoicWlkOHk5NndjZjI2WFNSNlVON2tsQWpab2J0eWJJSHJSYW82Zmd4MTBHMklPSnZRSDhLUTRkZTJBcCtyaVFxRUhNUHU3dW43MFE4 ▶" 1 => "XSRF-TOKEN=eyJpdiI6InFITEVIdmxYR2w1QlNKdFpVTFZ3TlE9PSIsInZhbHVlIjoiRHlLTmFHN1pxWFJ3NHE2VDFHT2hFMndwV0twR2FISFBrRFVoZFoxblUzY0JJaVEzUW9LTFhVdzYwVlVLaUhRZFZnNnl5T2FQQnFwZ212WVRqTk5PSklDd1NFaWVYeTl2czhreUlaMGhxaUZBWkFSWlpCdE9XK1MxUVRPbzFQYUsiLCJtYWMiOiJmMDQ5Mjk5NDYxOTI5MzFjOTkyMDM5NWUzYmRkM2Q3NTJkNDNjOWU5MTY3Y2QxMjEyMTM4MWM4NWM4YmU1ZWMyIiwidGFnIjoiIn0%3D; expires=Fri, 31 Jan 2025 00:55:28 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InFITEVIdmxYR2w1QlNKdFpVTFZ3TlE9PSIsInZhbHVlIjoiRHlLTmFHN1pxWFJ3NHE2VDFHT2hFMndwV0twR2FISFBrRFVoZFoxblUzY0JJaVEzUW9LTFhVdzYwVlVLaUhRZFZnNnl5T ▶" 2 => "laravel_session=eyJpdiI6IjVHTTlWSnlpSlkxeDdYL0RoYWxtaEE9PSIsInZhbHVlIjoiUVhHNS9RS09GWk1RbGg0em1LaUdKMHY4cVZUTU5MUy8zMTNXVDlyUGdsM09DeHBpam9jczBtTHk2RHNGVXJYNzl4SFRHT0JyNW94NkVYZGZCdnpRVGl3aVNNbENCQXFnY3VHYzlic3FmN2YxdE5uQWpzT1hEVXF1aEZxbXp0QUoiLCJtYWMiOiI0OTEzZDBhMzAzOTVkMjFmZTk1ZGUxY2VmMGYyOGQyNDZlNjc2MGM0YjU5YjY4YjZiNmJlOWM1Nzg2YWY1NTgyIiwidGFnIjoiIn0%3D; expires=Fri, 31 Jan 2025 00:55:28 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjVHTTlWSnlpSlkxeDdYL0RoYWxtaEE9PSIsInZhbHVlIjoiUVhHNS9RS09GWk1RbGg0em1LaUdKMHY4cVZUTU5MUy8zMTNXVDlyUGdsM09DeHBpam9jczBtTHk2RHNGVXJYNzl4 ▶" ] "Set-Cookie" => array:3 [▶ 0 => "uid=eyJpdiI6IlFVRHNBYS9kK3Bta2xJUkdETWZYV0E9PSIsInZhbHVlIjoicWlkOHk5NndjZjI2WFNSNlVON2tsQWpab2J0eWJJSHJSYW82Zmd4MTBHMklPSnZRSDhLUTRkZTJBcCtyaVFxRUhNUHU3dW43MFE4R3VlY3FzTTFpeFA5M3h6cGZGSVV3YzhOeWZ5SGhxdkU9IiwibWFjIjoiYTc2YjdhMDFkZWNhZjU2ZWUzZjNhMGViM2U3NDIwNThjNjQ3MTU2YzIyMTk4MGFhM2M3N2Q2NDQ4NzRmNjhmMyIsInRhZyI6IiJ9; expires=Fri, 07-Sep-5359 06:23:28 GMT; path=/; secure; httponly ◀uid=eyJpdiI6IlFVRHNBYS9kK3Bta2xJUkdETWZYV0E9PSIsInZhbHVlIjoicWlkOHk5NndjZjI2WFNSNlVON2tsQWpab2J0eWJJSHJSYW82Zmd4MTBHMklPSnZRSDhLUTRkZTJBcCtyaVFxRUhNUHU3dW43MFE4 ▶" 1 => "XSRF-TOKEN=eyJpdiI6InFITEVIdmxYR2w1QlNKdFpVTFZ3TlE9PSIsInZhbHVlIjoiRHlLTmFHN1pxWFJ3NHE2VDFHT2hFMndwV0twR2FISFBrRFVoZFoxblUzY0JJaVEzUW9LTFhVdzYwVlVLaUhRZFZnNnl5T2FQQnFwZ212WVRqTk5PSklDd1NFaWVYeTl2czhreUlaMGhxaUZBWkFSWlpCdE9XK1MxUVRPbzFQYUsiLCJtYWMiOiJmMDQ5Mjk5NDYxOTI5MzFjOTkyMDM5NWUzYmRkM2Q3NTJkNDNjOWU5MTY3Y2QxMjEyMTM4MWM4NWM4YmU1ZWMyIiwidGFnIjoiIn0%3D; expires=Fri, 31-Jan-2025 00:55:28 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InFITEVIdmxYR2w1QlNKdFpVTFZ3TlE9PSIsInZhbHVlIjoiRHlLTmFHN1pxWFJ3NHE2VDFHT2hFMndwV0twR2FISFBrRFVoZFoxblUzY0JJaVEzUW9LTFhVdzYwVlVLaUhRZFZnNnl5T ▶" 2 => "laravel_session=eyJpdiI6IjVHTTlWSnlpSlkxeDdYL0RoYWxtaEE9PSIsInZhbHVlIjoiUVhHNS9RS09GWk1RbGg0em1LaUdKMHY4cVZUTU5MUy8zMTNXVDlyUGdsM09DeHBpam9jczBtTHk2RHNGVXJYNzl4SFRHT0JyNW94NkVYZGZCdnpRVGl3aVNNbENCQXFnY3VHYzlic3FmN2YxdE5uQWpzT1hEVXF1aEZxbXp0QUoiLCJtYWMiOiI0OTEzZDBhMzAzOTVkMjFmZTk1ZGUxY2VmMGYyOGQyNDZlNjc2MGM0YjU5YjY4YjZiNmJlOWM1Nzg2YWY1NTgyIiwidGFnIjoiIn0%3D; expires=Fri, 31-Jan-2025 00:55:28 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjVHTTlWSnlpSlkxeDdYL0RoYWxtaEE9PSIsInZhbHVlIjoiUVhHNS9RS09GWk1RbGg0em1LaUdKMHY4cVZUTU5MUy8zMTNXVDlyUGdsM09DeHBpam9jczBtTHk2RHNGVXJYNzl4 ▶" ] ]
0 of 0array:6 [▼ "_token" => "6gIqZAK7iknElwH83WL21sYCrINdUceedrJp84gh" "views" => 1 "uid" => "7524541141d88a5b7af71bcb67551c9b" "_previous" => array:1 [▶ "url" => "https://laravel.cars2buy.co.uk/new-cars/lotus/evija/fittipaldi" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]