You are here:
cars2buy want to make it as easy as possible for you to find a new Genesis G70 Shooting Brake Premium at the best possible price. In order to do this we have collected prices from a range of providers - including Genesis dealers and independent car brokers - for you to compare, saving you the hassle of having to negotiate yourself.
All Genesis G70 Shooting Brake Premium cars advertised on cars2buy are UK cars with the standard Genesis 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 Genesis G70 Shooting Brake Premium deal you are interested in to view more details and contact the dealer directly.
1 x Application (76.88%) | 182ms |
1 x Booting (23.12%) | 54.65ms |
Backtrace |
|
select `trim` from `car_specs` where (`make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium') limit 1
Bindings |
|
Backtrace |
|
select `car_id` from `car_specs` where (`make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium') 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` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `totdis` >= 0 and `pa_pid` = 5) and `trim_slug` = 'premium'
Bindings |
|
Backtrace |
|
select distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake') and `trim_slug` = 'premium' 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` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim` = 'Premium') 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` = 'genesis' and `model_slug` = 'g70-shooting-brake' 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` = 'genesis' and `model_slug` = 'g70-shooting-brake' 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` = 'genesis' and `model_slug` = 'g70-shooting-brake') 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` = 'genesis' and `model_slug` = 'g70-shooting-brake') and `trim_slug` = 'premium' 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` = 'genesis' and `model_slug` = 'g70-shooting-brake') and `trim_slug` = 'premium' 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` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `car_specs`.`cap_id` desc limit 1
Bindings |
|
Backtrace |
|
select `path`, `izmoAlias` from `images_izmo` where `cap_id` = 103016 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` = 103016 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` = 'Genesis' and `car_specs`.`model` = 'G70 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_backfill` where `ima_make` = 'Genesis' and `ima_model` = 'G70 Shooting Brake' 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` = 'genesis' order by `model` asc
Bindings |
|
Backtrace |
|
select distinct `car_id`, `version` from `car_specs` where `make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `version` asc
Bindings |
|
Backtrace |
|
select distinct `fuel` from `car_specs` where `make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `fuel` asc
Bindings |
|
Backtrace |
|
select distinct `transmission` from `car_specs` where `make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `transmission` asc
Bindings |
|
Backtrace |
|
select distinct `engine` from `car_specs` where `make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `engine` asc
Bindings |
|
Backtrace |
|
select distinct `bodytype` from `car_specs` where `make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `bodytype` asc
Bindings |
|
Backtrace |
|
select distinct `doors` from `car_specs` where `make_slug` = 'genesis' and `model_slug` = 'g70-shooting-brake' and `trim_slug` = 'premium' order by `doors` asc
Bindings |
|
Backtrace |
|
select `Text` from `seo` where (`Make` = 'Genesis' and `Model` = 'G70 Shooting Brake' and `Type` = 'Car - New')
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "fTrim" => "premium" ]
[]
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.213.225" ] "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 21:43:29 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:3 [▶ 0 => "uid=eyJpdiI6IlBQMk9CS0JLbnBiK1FIOUd0d0o5ZHc9PSIsInZhbHVlIjoiMTMvdlVlNUY3TE1lcjhpeGpweEdiaG1rMnBHakkvc3JBTGovT0xKek9jbW94cnJ6MEdoZmZYdXRtalF6RTlkRm5vZTdxeHZScjdtSGsxOC9rV0R3ZzJ2Y2VTcTZ6STlxa2JxdXdhU2tKMVk9IiwibWFjIjoiNTA0NWFlNjcwMDZkZjlhYTA4ZjZiMGRmYTBkZWNmOTdhNTMzNTRhYzk2ZDdiZDg2ZGEzN2M2OGFhZjQyOTFkNyIsInRhZyI6IiJ9; expires=Tue, 04 Sep 5359 05:12:29 GMT; Max-Age=105229524540; path=/; secure; httponly; samesite=lax ◀uid=eyJpdiI6IlBQMk9CS0JLbnBiK1FIOUd0d0o5ZHc9PSIsInZhbHVlIjoiMTMvdlVlNUY3TE1lcjhpeGpweEdiaG1rMnBHakkvc3JBTGovT0xKek9jbW94cnJ6MEdoZmZYdXRtalF6RTlkRm5vZTdxeHZScjdt ▶" 1 => "XSRF-TOKEN=eyJpdiI6IkZTUDk3OGFEVGVlZ0d5ZW1LUDUvK2c9PSIsInZhbHVlIjoiRUh5MTZaM2IrVmI4Z1U4YUxIcGplb3F2T2ZPZmNjUlVxNHhBc0QyL0h3L2FlZVFLS2RwZ0RwOXdNOTZaOWwyZzhhb2Nvcm1ObUlPS0FNb3pPUTk3VmZUQTUxbkg3VDhFWENaQ1lLM3kwNUJkMWdRSUpUUEh0TWdYUFNOMlNTQlAiLCJtYWMiOiJlOThiODcxMDcxM2VlNzY0YjE4Nzc2YzI5YTM1YTU3N2RiZmQwMmIyZjNmZTg1NzI4ODgyMWYxZmEyMDZlZDMyIiwidGFnIjoiIn0%3D; expires=Thu, 30 Jan 2025 23:43:29 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkZTUDk3OGFEVGVlZ0d5ZW1LUDUvK2c9PSIsInZhbHVlIjoiRUh5MTZaM2IrVmI4Z1U4YUxIcGplb3F2T2ZPZmNjUlVxNHhBc0QyL0h3L2FlZVFLS2RwZ0RwOXdNOTZaOWwyZzhhb2Nvc ▶" 2 => "laravel_session=eyJpdiI6ImxYQ2J4eTFndEl6enRqVG9FNzdmcVE9PSIsInZhbHVlIjoiTWcwK3kyck90QUI0d3FTZTVQTStJWlhRTFMyZXFyRllxVGVxMjNLOWtHbVJuOFhWZC9QbmFzZDVJMjcybDV6aWFHUk5leGdGWW1DK3YwTEd3c296cktMN05sZWZ6NVcwVkRHUXJ2aFR1R1QvTFEzWXFvUitYYkwza3ZGTmwxWmYiLCJtYWMiOiI0NmU5MTk1NzRmOTVjY2Y5NDA0MWJiMThkZTAzMGM1OTk5N2E3ZDA5MDYxYmFhNmZjZmQyMmJmOGVjYzBmNzFlIiwidGFnIjoiIn0%3D; expires=Thu, 30 Jan 2025 23:43:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImxYQ2J4eTFndEl6enRqVG9FNzdmcVE9PSIsInZhbHVlIjoiTWcwK3kyck90QUI0d3FTZTVQTStJWlhRTFMyZXFyRllxVGVxMjNLOWtHbVJuOFhWZC9QbmFzZDVJMjcybDV6aWFH ▶" ] "Set-Cookie" => array:3 [▶ 0 => "uid=eyJpdiI6IlBQMk9CS0JLbnBiK1FIOUd0d0o5ZHc9PSIsInZhbHVlIjoiMTMvdlVlNUY3TE1lcjhpeGpweEdiaG1rMnBHakkvc3JBTGovT0xKek9jbW94cnJ6MEdoZmZYdXRtalF6RTlkRm5vZTdxeHZScjdtSGsxOC9rV0R3ZzJ2Y2VTcTZ6STlxa2JxdXdhU2tKMVk9IiwibWFjIjoiNTA0NWFlNjcwMDZkZjlhYTA4ZjZiMGRmYTBkZWNmOTdhNTMzNTRhYzk2ZDdiZDg2ZGEzN2M2OGFhZjQyOTFkNyIsInRhZyI6IiJ9; expires=Tue, 04-Sep-5359 05:12:29 GMT; path=/; secure; httponly ◀uid=eyJpdiI6IlBQMk9CS0JLbnBiK1FIOUd0d0o5ZHc9PSIsInZhbHVlIjoiMTMvdlVlNUY3TE1lcjhpeGpweEdiaG1rMnBHakkvc3JBTGovT0xKek9jbW94cnJ6MEdoZmZYdXRtalF6RTlkRm5vZTdxeHZScjdt ▶" 1 => "XSRF-TOKEN=eyJpdiI6IkZTUDk3OGFEVGVlZ0d5ZW1LUDUvK2c9PSIsInZhbHVlIjoiRUh5MTZaM2IrVmI4Z1U4YUxIcGplb3F2T2ZPZmNjUlVxNHhBc0QyL0h3L2FlZVFLS2RwZ0RwOXdNOTZaOWwyZzhhb2Nvcm1ObUlPS0FNb3pPUTk3VmZUQTUxbkg3VDhFWENaQ1lLM3kwNUJkMWdRSUpUUEh0TWdYUFNOMlNTQlAiLCJtYWMiOiJlOThiODcxMDcxM2VlNzY0YjE4Nzc2YzI5YTM1YTU3N2RiZmQwMmIyZjNmZTg1NzI4ODgyMWYxZmEyMDZlZDMyIiwidGFnIjoiIn0%3D; expires=Thu, 30-Jan-2025 23:43:29 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkZTUDk3OGFEVGVlZ0d5ZW1LUDUvK2c9PSIsInZhbHVlIjoiRUh5MTZaM2IrVmI4Z1U4YUxIcGplb3F2T2ZPZmNjUlVxNHhBc0QyL0h3L2FlZVFLS2RwZ0RwOXdNOTZaOWwyZzhhb2Nvc ▶" 2 => "laravel_session=eyJpdiI6ImxYQ2J4eTFndEl6enRqVG9FNzdmcVE9PSIsInZhbHVlIjoiTWcwK3kyck90QUI0d3FTZTVQTStJWlhRTFMyZXFyRllxVGVxMjNLOWtHbVJuOFhWZC9QbmFzZDVJMjcybDV6aWFHUk5leGdGWW1DK3YwTEd3c296cktMN05sZWZ6NVcwVkRHUXJ2aFR1R1QvTFEzWXFvUitYYkwza3ZGTmwxWmYiLCJtYWMiOiI0NmU5MTk1NzRmOTVjY2Y5NDA0MWJiMThkZTAzMGM1OTk5N2E3ZDA5MDYxYmFhNmZjZmQyMmJmOGVjYzBmNzFlIiwidGFnIjoiIn0%3D; expires=Thu, 30-Jan-2025 23:43:29 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImxYQ2J4eTFndEl6enRqVG9FNzdmcVE9PSIsInZhbHVlIjoiTWcwK3kyck90QUI0d3FTZTVQTStJWlhRTFMyZXFyRllxVGVxMjNLOWtHbVJuOFhWZC9QbmFzZDVJMjcybDV6aWFH ▶" ] ]
0 of 0array:6 [▼ "_token" => "W6B5K2NiGXLK5jPhqp2vCoEKtKFCkYJJNzrhy6uZ" "views" => 1 "uid" => "ec60f32cf8ec3656426c9a12e586add5" "_previous" => array:1 [▶ "url" => "https://laravel.cars2buy.co.uk/new-cars/genesis/g70-shooting-brake/premium" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]