SELECT
base.*,
base.source_uid AS quote_source_uid,
source_meta.source_name AS source_name,
base.Lease_Rental AS effective_rental,
base.vmf_norm AS effective_vmf_norm
FROM Rates_Friday base
LEFT JOIN sources source_meta ON source_meta.source_id = base.source_uid
WHERE base.url_make='mercedes' AND base.url_model='e-class' AND base.Term='36' AND base.Mileage='10000' AND base.spread='6' AND base.Lease_Rental BETWEEN '100' AND '2000' AND COALESCE(base.Electric_Range, 0) >= '0' AND base.COMMERCIAL != 'Y' AND base.Active = 1
ORDER BY CASE WHEN base.offer_uid IS NOT NULL AND base.offer_uid <> '' AND base.offer_uid <> '0' THEN 1 ELSE 0 END DESC, effective_rental ASC LIMIT 60 OFFSET 0
Choose a variant:
Showing 1–52 of 52 results
MERCEDES E CLASS
E CLASS SALOON E300e Urban Edition 4dr 9G-Tronic
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £65554.99
BIK: £131.11/£65.55
CO2: 48
Insurance: 48
70 miles
£633.43 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL SALOON E300de Urban Edition 4dr 9G-Tronic
Saloon
Diesel/PlugIn Elec Hybrid
P11D: £67555.00
BIK: £135.11/£67.56
CO2: 41
Insurance: 49
71 miles
£640.92 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
MERCEDES E CLASS
E CLASS SALOON E300e AMG Line Premium 4dr 9G-Tronic [Pan Roof]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £70680.00
BIK: £141.36/£70.68
CO2: 49
Insurance: 50
70 miles
£667.92 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
MERCEDES E CLASS
E CLASS DIESEL SALOON E300de Exclusive Premium 4dr 9G-Tronic
Saloon
Diesel/PlugIn Elec Hybrid
P11D: £72679.99
BIK: £218.04/£109.02
CO2: 43
Insurance: 50
69 miles
£671.84 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
MERCEDES E CLASS
E CLASS DIESEL SALOON E300de AMG Line Premium 4dr 9G-Tronic [Pan Roof]
Saloon
Diesel/PlugIn Elec Hybrid
P11D: £72679.99
BIK: £145.36/£72.68
CO2: 41
Insurance: 50
69 miles
£672.88 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
MERCEDES E CLASS
E CLASS SALOON E300e Exclusive Premium 4dr 9G-Tronic
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £70680.00
BIK: £212.04/£106.02
CO2: 50
Insurance: 50
69 miles
£673.11 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
MERCEDES E CLASS
E CLASS DIESEL ESTATE E300de Urban Edition 5dr 9G-Tronic
Estate
Diesel/PlugIn Elec Hybrid
P11D: £69805.00
BIK: £209.42/£104.71
CO2: 45
Insurance: 49
67 miles
£688.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS ESTATE E300e Urban Edition 5dr 9G-Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £67804.99
BIK: £361.63/£180.81
CO2: 52
Insurance: 48
68 miles
£720.37 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL ESTATE E300de Exclusive Premium 5dr 9G-Tronic
Estate
Diesel/PlugIn Elec Hybrid
P11D: £74929.99
BIK: £224.79/£112.39
CO2: 47
Insurance: 50
65 miles
£724.09 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL ESTATE E300de AMG Line Premium 5dr 9G-Tronic [Pan Roof]
Estate
Diesel/PlugIn Elec Hybrid
P11D: £74929.99
BIK: £224.79/£112.39
CO2: 46
Insurance: 50
65 miles
£726.17 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS ESTATE E300e Exclusive Premium 5dr 9G-Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £72930.00
BIK: £388.96/£194.48
CO2: 54
Insurance: 50
66 miles
£761.09 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS ESTATE E300e AMG Line Premium 5dr 9G-Tronic [Pan Roof]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £72930.00
BIK: £388.96/£194.48
CO2: 53
Insurance: 50
67 miles
£764.13 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS SALOON E300e AMG Line Premium Plus 4dr 9G-Tronic
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £77554.99
BIK: £232.66/£116.33
CO2: 50
Insurance: 50
69 miles
£774.49 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL SALOON E300de AMG Line Premium Plus 4dr 9G-Tronic
Saloon
Diesel/PlugIn Elec Hybrid
P11D: £79555.00
BIK: £238.67/£119.33
CO2: 43
Insurance: 50
68 miles
£778.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL ESTATE E300de AMG Line Premium Plus 5dr 9G-Tronic
Estate
Diesel/PlugIn Elec Hybrid
P11D: £81805.00
BIK: £245.42/£122.71
CO2: 47
Insurance: 50
65 miles
£826.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS SALOON E300e Exclusive Premium Plus 4dr 9G-Tronic
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £77554.99
BIK: £232.66/£116.33
CO2: 50
Insurance: 50
69 miles
£833.76 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL SALOON E300de Exclusive Premium Plus 4dr 9G-Tronic
Saloon
Diesel/PlugIn Elec Hybrid
P11D: £79555.00
BIK: £238.67/£119.33
CO2: 43
Insurance: 50
69 miles
£836.41 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL ESTATE E300de Exclusive Premium Plus 5dr 9G-Tronic
Estate
Diesel/PlugIn Elec Hybrid
P11D: £81805.00
BIK: £245.42/£122.71
CO2: 47
Insurance: 50
65 miles
£839.40 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS SALOON E200 Urban Edition 4dr 9G-Tronic
Saloon
Petrol (Mild Hybrid)
P11D: £56055.00
BIK: £653.98/£326.99
CO2: 148
Insurance: 0
0 miles
£870.43 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS ESTATE E300e AMG Line Premium Plus 5dr 9G-Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £79804.99
BIK: £425.63/£212.81
CO2: 54
Insurance: 50
67 miles
£872.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS ESTATE E300e Exclusive Premium Plus 5dr 9G-Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £79804.99
BIK: £425.63/£212.81
CO2: 54
Insurance: 50
66 miles
£879.83 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES E CLASS
E CLASS DIESEL SALOON E220d Urban Edition 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £57805.00
BIK: £597.32/£298.66
CO2: 126
Insurance: 0
0 miles
£897.38 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS SALOON E200 AMG Line Premium 4dr 9G-Tronic [Pan Roof]
Saloon
Petrol (Mild Hybrid)
P11D: £60930.00
BIK: £731.16/£365.58
CO2: 150
Insurance: 43
0 miles
£913.85 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES E CLASS
E CLASS ESTATE E200 Urban Edition 5dr 9G-Tronic
Estate
Petrol (Mild Hybrid)
P11D: £58305.00
BIK: £719.10/£359.55
CO2: 155
Insurance: 0
0 miles
£925.89 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS SALOON E200 Exclusive Premium 4dr 9G-Tronic
Saloon
Petrol (Mild Hybrid)
P11D: £60930.00
BIK: £731.16/£365.58
CO2: 151
Insurance: 44
0 miles
£931.63 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E220d Urban Edition 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £60055.00
BIK: £640.59/£320.29
CO2: 132
Insurance: 0
0 miles
£935.10 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E220d AMG Line Premium 4dr 9G-Tronic [Pan Roof]
Saloon
Diesel (Mild Hybrid)
P11D: £62680.00
BIK: £647.69/£323.85
CO2: 127
Insurance: 44
0 miles
£950.43 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E220d Exclusive Premium 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £62680.00
BIK: £647.69/£323.85
CO2: 129
Insurance: 44
0 miles
£950.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS ESTATE E200 AMG Line Premium 5dr 9G-Tronic [Pan Roof]
Estate
Petrol (Mild Hybrid)
P11D: £63180.00
BIK: £779.22/£389.61
CO2: 156
Insurance: 43
0 miles
£969.32 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS ESTATE E200 Exclusive Premium 5dr 9G-Tronic
Estate
Petrol (Mild Hybrid)
P11D: £63180.00
BIK: £779.22/£389.61
CO2: 157
Insurance: 43
0 miles
£971.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E220d Exclusive Premium 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £64930.00
BIK: £692.59/£346.29
CO2: 134
Insurance: 44
0 miles
£985.56 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E220d AMG Line Premium 5dr 9G-Tronic [Pan Roof]
Estate
Diesel (Mild Hybrid)
P11D: £64930.00
BIK: £692.59/£346.29
CO2: 133
Insurance: 44
0 miles
£986.58 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E220d AMG Line Premium Plus 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £69555.00
BIK: £718.74/£359.37
CO2: 129
Insurance: 44
0 miles
£1074.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E220d Exclusive Premium Plus 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £69555.00
BIK: £718.74/£359.37
CO2: 129
Insurance: 44
0 miles
£1074.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS SALOON E200 Exclusive Premium Plus 4dr 9G-Tronic
Saloon
Petrol (Mild Hybrid)
P11D: £67804.99
BIK: £813.66/£406.83
CO2: 151
Insurance: 44
0 miles
£1075.22 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS SALOON E200 AMG Line Premium Plus 4dr 9G-Tronic
Saloon
Petrol (Mild Hybrid)
P11D: £67804.99
BIK: £813.66/£406.83
CO2: 152
Insurance: 44
0 miles
£1080.46 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS ESTATE E200 Exclusive Premium Plus 5dr 9G-Tronic
Estate
Petrol (Mild Hybrid)
P11D: £70054.99
BIK: £864.01/£432.01
CO2: 158
Insurance: 44
0 miles
£1111.85 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS ESTATE E200 AMG Line Premium Plus 5dr 9G-Tronic
Estate
Petrol (Mild Hybrid)
P11D: £70054.99
BIK: £864.01/£432.01
CO2: 158
Insurance: 44
0 miles
£1113.95 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E220d Exclusive Premium Plus 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £71805.00
BIK: £765.92/£382.96
CO2: 134
Insurance: 44
0 miles
£1128.91 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E220d AMG Line Premium Plus 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £71805.00
BIK: £765.92/£382.96
CO2: 134
Insurance: 44
0 miles
£1130.64 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E450d 4M AMG Line Premium 4dr 9G-Tronic [Pan Roof]
Saloon
Diesel (Mild Hybrid)
P11D: £79680.00
BIK: £982.72/£491.36
CO2: 158
Insurance: 50
0 miles
£1252.49 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E450d 4Matic Exclusive Premium 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £79680.00
BIK: £982.72/£491.36
CO2: 158
Insurance: 50
0 miles
£1255.04 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E450d 4M AMG Line Premium 5dr 9G-Tronic [Pan Roof]
Estate
Diesel (Mild Hybrid)
P11D: £81930.00
BIK: £1010.47/£505.24
CO2: 164
Insurance: 50
0 miles
£1283.92 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E450d 4Matic Exclusive Premium 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £81930.00
BIK: £1010.47/£505.24
CO2: 163
Insurance: 50
0 miles
£1288.50 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E450d 4Matic AMG Line Premium Plus 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £86554.99
BIK: £1067.51/£533.76
CO2: 160
Insurance: 50
0 miles
£1397.41 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL SALOON E450d 4Matic Exclusive Premium Plus 4dr 9G-Tronic
Saloon
Diesel (Mild Hybrid)
P11D: £86554.99
BIK: £1067.51/£533.76
CO2: 158
Insurance: 50
0 miles
£1398.39 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E450d 4Matic AMG Line Premium Plus 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £88804.99
BIK: £1095.26/£547.63
CO2: 166
Insurance: 50
0 miles
£1429.42 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS DIESEL ESTATE E450d 4Matic Exclusive Premium Plus 5dr 9G-Tronic
Estate
Diesel (Mild Hybrid)
P11D: £88804.99
BIK: £1095.26/£547.63
CO2: 164
Insurance: 50
0 miles
£1430.32 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS AMG SALOON E53 4Matic+ Premium 4dr TCT
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £91954.99
BIK: £613.03/£306.52
CO2: 71
Insurance: 50
60 miles
£1473.47 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS AMG ESTATE E53 4Matic+ Premium 5dr TCT
Estate
Petrol/PlugIn Elec Hybrid
P11D: £94324.99
BIK: £660.27/£330.14
CO2: 75
Insurance: 50
58 miles
£1502.55 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS AMG SALOON E53 4Matic+ Night Edition Prem+ 4dr TCT
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £97830.00
BIK: £652.20/£326.10
CO2: 71
Insurance: 50
60 miles
£1564.09 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES E CLASS
E CLASS AMG ESTATE E53 4Matic+ Night Edition Prem+ 5dr TCT
Estate
Petrol/PlugIn Elec Hybrid
P11D: £100080.00
BIK: £700.56/£350.28
CO2: 76
Insurance: 50
58 miles
£1601.36 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre