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='cle' 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–37 of 37 results
MERCEDES CLE
CLE COUPE CLE 300e AMG Line Premium 2dr 9G-Tronic
Coupe
Petrol/PlugIn Elec Hybrid
P11D: £61455.00
BIK: £122.91/£61.46
CO2: 49
Insurance: 45
69 miles
£616.16 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLE
CLE COUPE CLE 200 AMG Line 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £47080.00
BIK: £549.27/£274.63
CO2: 148
Insurance: 35
0 miles
£671.99 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLE
CLE COUPE CLE 300e AMG Line Premium Plus 2dr 9G-Tronic
Coupe
Petrol/PlugIn Elec Hybrid
P11D: £65455.00
BIK: £130.91/£65.46
CO2: 50
Insurance: 45
69 miles
£673.91 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLE
CLE COUPE CLE 300e Premier Edition 2dr 9G-Tronic
Coupe
Petrol/PlugIn Elec Hybrid
P11D: £67830.00
BIK: £135.66/£67.83
CO2: 50
Insurance: 45
69 miles
£695.14 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLE
CLE DIESEL COUPE CLE 220d AMG Line 2dr 9G-Tronic
Coupe
Diesel (Mild Hybrid)
P11D: £49579.99
BIK: £495.80/£247.90
CO2: 123
Insurance: 36
0 miles
£726.42 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLE
CLE COUPE CLE 200 AMG Line Premium 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £50955.00
BIK: £611.46/£305.73
CO2: 150
Insurance: 36
0 miles
£741.76 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLE
CLE DIESEL COUPE CLE 220d AMG Line Premium 2dr 9G-Tronic
Coupe
Diesel (Mild Hybrid)
P11D: £53455.00
BIK: £552.37/£276.18
CO2: 125
Insurance: 37
0 miles
£797.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 200 AMG Line Premium Plus 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £54955.00
BIK: £659.46/£329.73
CO2: 150
Insurance: 37
0 miles
£821.68 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 200 AMG Line 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £53080.00
BIK: £636.96/£318.48
CO2: 153
Insurance: 40
0 miles
£831.66 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 200 AMG Line Premium 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £54955.00
BIK: £659.46/£329.73
CO2: 154
Insurance: 41
0 miles
£843.65 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 200 Premier Edition 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £57330.00
BIK: £687.96/£343.98
CO2: 150
Insurance: 37
0 miles
£853.24 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLE
CLE COUPE CLE 300 4Matic AMG Line Premium 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £55954.99
BIK: £690.11/£345.06
CO2: 158
Insurance: 40
0 miles
£856.56 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE DIESEL CABRIOLET CLE 220d AMG Line 2dr 9G-Tronic
Cabriolet
Diesel (Mild Hybrid)
P11D: £55579.99
BIK: £574.33/£287.16
CO2: 129
Insurance: 41
0 miles
£857.39 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE DIESEL CABRIOLET CLE 220d AMG Line Premium 2dr 9G-Tronic
Cabriolet
Diesel (Mild Hybrid)
P11D: £57454.99
BIK: £612.85/£306.43
CO2: 130
Insurance: 42
0 miles
£883.48 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE DIESEL COUPE CLE 220d AMG Line Premium Plus 2dr 9G-Tronic
Coupe
Diesel (Mild Hybrid)
P11D: £57454.99
BIK: £593.70/£296.85
CO2: 126
Insurance: 38
0 miles
£883.48 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE DIESEL COUPE CLE 220d Premier Edition 2dr 9G-Tronic
Coupe
Diesel (Mild Hybrid)
P11D: £59830.00
BIK: £618.24/£309.12
CO2: 126
Insurance: 38
0 miles
£916.17 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 300 4Matic AMG Line Premium + 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £59955.00
BIK: £739.45/£369.72
CO2: 158
Insurance: 40
0 miles
£924.42 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 200 AMG Line Premium Plus 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £58954.99
BIK: £727.11/£363.56
CO2: 155
Insurance: 42
0 miles
£925.15 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 300 4Matic AMG Line Premium 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £59955.00
BIK: £739.45/£369.72
CO2: 163
Insurance: 44
0 miles
£939.09 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 300 4Matic Premier Edition 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £62329.99
BIK: £768.74/£384.37
CO2: 158
Insurance: 40
0 miles
£955.99 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE DIESEL CABRIOLET CLE 220d AMG Line Premium Plus 2dr 9G-Tronic
Cabriolet
Diesel (Mild Hybrid)
P11D: £61455.00
BIK: £655.52/£327.76
CO2: 130
Insurance: 42
0 miles
£956.54 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 200 Premier Edition 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £61330.00
BIK: £756.40/£378.20
CO2: 155
Insurance: 42
0 miles
£957.75 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE DIESEL CABRIOLET CLE 220d Premier Edition 2dr 9G-Tronic
Cabriolet
Diesel (Mild Hybrid)
P11D: £63829.99
BIK: £680.85/£340.43
CO2: 130
Insurance: 42
0 miles
£989.74 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 300 4Matic AMG Line Premium Plus 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £63955.00
BIK: £788.78/£394.39
CO2: 163
Insurance: 44
0 miles
£1009.05 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 450 4Matic AMG Line Premium 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £66079.99
BIK: £814.99/£407.49
CO2: 175
Insurance: 43
0 miles
£1044.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 300 4Matic Premier Edition 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £66330.00
BIK: £818.07/£409.04
CO2: 163
Insurance: 44
0 miles
£1058.43 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 53 4Matic+ AMG Premium 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £72304.99
BIK: £891.76/£445.88
CO2: 212
Insurance: 44
0 miles
£1124.37 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 450 4Matic AMG Line Premium 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £70080.00
BIK: £864.32/£432.16
CO2: 182
Insurance: 46
0 miles
£1134.04 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 450 4Matic AMG Line Premium + 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £70080.00
BIK: £864.32/£432.16
CO2: 176
Insurance: 43
0 miles
£1134.04 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 450 4Matic Premier Edition 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £72454.99
BIK: £893.61/£446.81
CO2: 176
Insurance: 43
0 miles
£1167.71 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 53 4Matic+ AMG Premium 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £76305.00
BIK: £941.10/£470.55
CO2: 218
Insurance: 47
0 miles
£1177.56 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE CLE 53 4Matic+ AMG Night Edn Prem + 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £78055.00
BIK: £962.68/£481.34
CO2: 213
Insurance: 44
0 miles
£1200.41 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 450 4Matic AMG Line Premium Plus 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £74080.00
BIK: £913.65/£456.83
CO2: 182
Insurance: 47
0 miles
£1212.38 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 450 4Matic Premier Edition 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £76455.00
BIK: £942.95/£471.47
CO2: 182
Insurance: 47
0 miles
£1246.57 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET CLE 53 4Matic+ AMG Night Edn Prem + 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £82054.99
BIK: £1012.01/£506.01
CO2: 219
Insurance: 48
0 miles
£1273.51 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE CABRIOLET SPECIAL EDITION CLE 53 4Matic+ AMG Limited Edition 2dr 9G-Tronic
Cabriolet
Petrol (Mild Hybrid)
P11D: £90805.00
BIK: £1119.93/£559.96
CO2: 218
Insurance: 48
0 miles
£1412.89 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLE
CLE COUPE SPECIAL EDITION CLE 53 4Matic+ AMG Limited Edition 2dr 9G-Tronic
Coupe
Petrol (Mild Hybrid)
P11D: £90805.00
BIK: £1119.93/£559.96
CO2: 215
Insurance: 45
0 miles
£1412.89 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre