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='cla' 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–42 of 42 results
MERCEDES CLA
CLA COUPE CLA 180 Sport Edition 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £32485.00
BIK: £346.51/£173.25
CO2: 133
Insurance: 22
0 miles
£462.50 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLA
CLA COUPE CLA 250e AMG Line Executive 4dr Tip Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £45589.99
BIK: £243.15/£121.57
CO2: 54
Insurance: 34
53 miles
£467.52 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLA
CLA SHOOTING BRAKE CLA 250e AMG Line Executive 5dr Tip Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £46965.00
BIK: £266.14/£133.07
CO2: 57
Insurance: 34
52 miles
£487.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLA
CLA COUPE CLA 180 Sport Executive 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £34669.99
BIK: £369.81/£184.91
CO2: 133
Insurance: 23
0 miles
£494.72 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLA
CLA COUPE CLA 250e AMG Line Premium 4dr Tip Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £47820.00
BIK: £286.92/£143.46
CO2: 61
Insurance: 35
49 miles
£495.14 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLA
CLA SHOOTING BRAKE CLA 250e AMG Line Premium 5dr Tip Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £49195.00
BIK: £295.17/£147.59
CO2: 64
Insurance: 35
51 miles
£508.08 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLA
CLA COUPE CLA 200 Sport Executive 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £36169.99
BIK: £385.81/£192.91
CO2: 133
Insurance: 26
0 miles
£522.14 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLA
CLA COUPE CLA 250e AMG Line Premium Plus 4dr Tip Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £51165.00
BIK: £306.99/£153.50
CO2: 62
Insurance: 35
48 miles
£528.93 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLA
CLA SHOOTING BRAKE CLA 180 Sport Executive 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £36045.00
BIK: £396.50/£198.25
CO2: 136
Insurance: 23
0 miles
£536.40 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA SHOOTING BRAKE CLA 250e AMG Line Premium Plus 5dr Tip Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £52540.00
BIK: £315.24/£157.62
CO2: 64
Insurance: 35
51 miles
£548.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
MERCEDES CLA
CLA COUPE CLA 180 AMG Line Executive 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £37840.00
BIK: £403.63/£201.81
CO2: 134
Insurance: 23
0 miles
£552.36 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLA
CLA SHOOTING BRAKE CLA 200 Sport Executive 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £37545.00
BIK: £413.00/£206.50
CO2: 136
Insurance: 26
0 miles
£574.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA ELECTRIC SALOON CLA 250+ 200kW EQ Tech Sport Ed 85kWh 4dr Auto
Saloon
Electric
P11D: £45550.00
BIK: £45.55/£22.78
CO2: 0
Insurance: 41
469 miles
£576.90 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
MERCEDES CLA
CLA COUPE CLA 200 AMG Line Executive 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £39340.00
BIK: £419.63/£209.81
CO2: 134
Insurance: 26
0 miles
£579.79 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
MERCEDES CLA
CLA DIESEL COUPE CLA 220d Sport Executive 4dr Tip Auto
Saloon
Diesel
P11D: £39390.00
BIK: £420.16/£210.08
CO2: 133
Insurance: 30
£591.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA COUPE CLA 180 AMG Line Premium 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £40030.00
BIK: £453.67/£226.84
CO2: 140
Insurance: 24
0 miles
£604.35 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA SHOOTING BRAKE CLA 180 AMG Line Executive 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £39214.99
BIK: £431.36/£215.68
CO2: 136
Insurance: 23
0 miles
£604.91 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA ELECTRIC SALOON CLA 250+ 200kW EQ Tech AMG Line Ed 85kWh 4dr Auto
Saloon
Electric
P11D: £49309.99
BIK: £49.31/£24.65
CO2: 0
Insurance: 41
469 miles
£617.70 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
MERCEDES CLA
CLA COUPE CLA 200 AMG Line Premium 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £41530.00
BIK: £442.99/£221.49
CO2: 133
Insurance: 27
0 miles
£631.78 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL SHOOTING BRAKE CLA 220d Sport Executive 5dr Tip Auto
Estate
Diesel
P11D: £40765.00
BIK: £448.42/£224.21
CO2: 136
Insurance: 30
£634.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA ELECTRIC SALOON CLA 250+ 200kW EQ AMG Line Prem Ed 85kWh 4dr Auto
Saloon
Electric
P11D: £51705.00
BIK: £51.71/£25.85
CO2: 0
Insurance: 42
462 miles
£643.16 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
MERCEDES CLA
CLA SHOOTING BRAKE CLA 200 AMG Line Executive 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £40714.99
BIK: £447.86/£223.93
CO2: 136
Insurance: 26
0 miles
£647.80 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA SHOOTING BRAKE CLA 180 AMG Line Premium 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £41404.99
BIK: £469.26/£234.63
CO2: 143
Insurance: 24
0 miles
£659.80 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL COUPE CLA 220d AMG Line Executive 4dr Tip Auto
Saloon
Diesel
P11D: £42559.99
BIK: £453.97/£226.99
CO2: 133
Insurance: 31
£663.56 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA COUPE CLA 180 AMG Line Premium Plus 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £43375.00
BIK: £491.58/£245.79
CO2: 140
Insurance: 24
0 miles
£664.87 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL SHOOTING BRAKE CLA 220d AMG Line Executive 5dr Tip Auto
Estate
Diesel
P11D: £43935.00
BIK: £483.29/£241.64
CO2: 136
Insurance: 31
£686.05 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA SHOOTING BRAKE CLA 200 AMG Line Premium 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £42904.99
BIK: £486.26/£243.13
CO2: 143
Insurance: 27
0 miles
£689.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA COUPE CLA 200 AMG Line Premium Plus 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £44875.00
BIK: £508.58/£254.29
CO2: 141
Insurance: 27
0 miles
£692.30 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL COUPE CLA 220d AMG Line Premium 4dr Tip Auto
Saloon
Diesel
P11D: £44749.99
BIK: £507.17/£253.58
CO2: 141
Insurance: 32
£694.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA SHOOTING BRAKE CLA 180 AMG Line Premium Plus 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £44749.99
BIK: £507.17/£253.58
CO2: 143
Insurance: 25
0 miles
£706.55 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL SHOOTING BRAKE CLA 220d AMG Line Premium 5dr Tip Auto
Estate
Diesel
P11D: £46125.00
BIK: £522.75/£261.38
CO2: 144
Insurance: 31
£717.31 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA SHOOTING BRAKE CLA 200 AMG Line Premium Plus 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £46249.99
BIK: £524.17/£262.08
CO2: 144
Insurance: 28
0 miles
£751.14 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL COUPE CLA 220d AMG Line Premium Plus 4dr Tip Auto
Saloon
Diesel
P11D: £48094.99
BIK: £545.08/£272.54
CO2: 141
Insurance: 32
£755.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA AMG COUPE CLA 35 Premium 4Matic 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £48480.00
BIK: £597.92/£298.96
CO2: 190
Insurance: 37
0 miles
£772.53 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA DIESEL SHOOTING BRAKE CLA 220d AMG Line Premium Plus 5dr Tip Auto
Estate
Diesel
P11D: £49470.00
BIK: £560.66/£280.33
CO2: 144
Insurance: 32
£777.83 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA AMG COUPE CLA 35 Touring Edition 4Matic 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £47355.00
BIK: £584.05/£292.02
CO2: 191
Insurance: 37
0 miles
£795.20 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Bad
MERCEDES CLA
CLA AMG SHOOTING BRAKE CLA 35 Premium 4Matic 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £49855.00
BIK: £614.88/£307.44
CO2: 194
Insurance: 38
0 miles
£833.12 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Bad
MERCEDES CLA
CLA ELECTRIC SALOON CLA 250+ 200kW EQ AMG Line Prem Ed+ 85kWh 4dr Auto
Saloon
Electric
P11D: £53055.00
BIK: £53.06/£26.53
CO2: 0
Insurance: 0
462 miles
£841.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA AMG COUPE CLA 35 Premium Plus 4Matic 4dr Tip Auto
Saloon
Petrol (Mild Hybrid)
P11D: £53029.99
BIK: £654.04/£327.02
CO2: 192
Insurance: 38
0 miles
£888.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Bad
MERCEDES CLA
CLA AMG SHOOTING BRAKE CLA 35 Premium Plus 4Matic 5dr Tip Auto
Estate
Petrol (Mild Hybrid)
P11D: £54405.00
BIK: £671.00/£335.50
CO2: 196
Insurance: 38
0 miles
£912.45 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Bad
MERCEDES CLA
CLA AMG COUPE CLA 45 S 4Matic+ Plus 4dr Tip Auto
Saloon
Petrol
P11D: £66300.00
BIK: £817.70/£408.85
CO2: 204
Insurance: 41
£1024.91 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre
MERCEDES CLA
CLA AMG SHOOTING BRAKE CLA 45 S 4Matic+ Plus 5dr Tip Auto
Estate
Petrol
P11D: £67675.00
BIK: £834.66/£417.33
CO2: 207
Insurance: 42
£1045.13 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Mediocre