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='bmw' AND base.url_model='5-series' 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–56 of 56 results
BMW 5 SERIES
5 SERIES SALOON 520i M Sport 4dr Auto
Saloon
Petrol (Mild Hybrid)
P11D: £51690.00
BIK: £551.36/£275.68
CO2: 131
Insurance: 35
0 miles
£675.38 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 520i M Sport 5dr Auto
Estate
Petrol (Mild Hybrid)
P11D: £53940.00
BIK: £593.34/£296.67
CO2: 139
Insurance: 34
0 miles
£709.64 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 520i M Sport Pro 4dr Auto
Saloon
Petrol (Mild Hybrid)
P11D: £54690.00
BIK: £583.36/£291.68
CO2: 132
Insurance: 35
0 miles
£709.89 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 530e M Sport 4dr Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £59490.00
BIK: £178.47/£89.24
CO2: 49
Insurance: 39
63 miles
£711.24 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £61740.00
BIK: £185.22/£92.61
CO2: 16
Insurance: 40
58 miles
£736.95 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 520i M Sport Pro 5dr Auto
Estate
Petrol (Mild Hybrid)
P11D: £56940.00
BIK: £626.34/£313.17
CO2: 139
Insurance: 34
0 miles
£738.39 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 520i M Sport 4dr Auto [Comfort Plus]
Saloon
Petrol (Mild Hybrid)
P11D: £56689.99
BIK: £604.69/£302.35
CO2: 130
Insurance: 35
0 miles
£747.01 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 530e M Sport Pro 4dr Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £62490.00
BIK: £187.47/£93.74
CO2: 49
Insurance: 40
62 miles
£747.08 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 520i M Sport 4dr Auto [Tech Plus]
Saloon
Petrol (Mild Hybrid)
P11D: £56010.00
BIK: £597.44/£298.72
CO2: 130
Insurance: 35
0 miles
£750.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £64740.00
BIK: £194.22/£97.11
CO2: 17
Insurance: 40
58 miles
£773.31 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £61740.00
BIK: £329.28/£164.64
CO2: 54
Insurance: 40
58 miles
£773.71 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 530e M Sport 4dr Auto [Tech Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £63810.00
BIK: £191.43/£95.72
CO2: 49
Insurance: 39
63 miles
£778.44 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 520i M Sport 5dr Auto [Tech Plus]
Estate
Petrol (Mild Hybrid)
P11D: £58260.00
BIK: £640.86/£320.43
CO2: 139
Insurance: 34
0 miles
£782.45 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 520i M Sport 5dr Auto [Comfort Plus]
Estate
Petrol (Mild Hybrid)
P11D: £58540.00
BIK: £643.94/£321.97
CO2: 139
Insurance: 34
0 miles
£782.78 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 530e M Sport 4dr Auto [Comfort Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £64489.99
BIK: £193.47/£96.73
CO2: 49
Insurance: 39
63 miles
£786.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 520i M Sport Pro 4dr Auto [Tech Plus]
Saloon
Petrol (Mild Hybrid)
P11D: £59010.00
BIK: £629.44/£314.72
CO2: 132
Insurance: 35
0 miles
£792.63 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [Tech Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £66060.00
BIK: £198.18/£99.09
CO2: 16
Insurance: 40
58 miles
£800.93 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 520i M Sport Pro 4dr Auto [Comfort Plus]
Saloon
Petrol (Mild Hybrid)
P11D: £59689.99
BIK: £636.69/£318.35
CO2: 132
Insurance: 35
0 miles
£801.96 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 520i M Sport Pro 5dr Auto [Tech Plus]
Estate
Petrol (Mild Hybrid)
P11D: £61260.00
BIK: £673.86/£336.93
CO2: 139
Insurance: 34
0 miles
£803.35 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [Comfort Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £66340.00
BIK: £199.02/£99.51
CO2: 16
Insurance: 40
58 miles
£806.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 520i M Sport Pro 5dr Auto [Comfort Plus]
Estate
Petrol (Mild Hybrid)
P11D: £61540.00
BIK: £676.94/£338.47
CO2: 139
Insurance: 34
0 miles
£808.92 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 520i M Sport 4dr Auto [Tech Plus/Comfort Plus]
Saloon
Petrol (Mild Hybrid)
P11D: £59989.99
BIK: £639.89/£319.95
CO2: 130
Insurance: 35
0 miles
£812.07 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 530e M Sport Pro 4dr Auto [Tech Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £66810.00
BIK: £200.43/£100.22
CO2: 49
Insurance: 40
62 miles
£812.14 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £64740.00
BIK: £366.86/£183.43
CO2: 56
Insurance: 40
57 miles
£812.25 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 520i M Sport 5dr Auto [Tech Plus/Comfort Plus]
Estate
Petrol (Mild Hybrid)
P11D: £61840.00
BIK: £680.24/£340.12
CO2: 139
Insurance: 34
0 miles
£819.61 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 530e M Sport Pro 4dr Auto [Comfort Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £67489.99
BIK: £202.47/£101.23
CO2: 49
Insurance: 40
62 miles
£825.25 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [Tech Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69060.00
BIK: £207.18/£103.59
CO2: 17
Insurance: 40
57 miles
£835.15 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 530e M Sport 4dr Auto [Tech Plus/Comfort Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £67789.99
BIK: £203.37/£101.68
CO2: 49
Insurance: 39
62 miles
£836.95 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [Tech Plus] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £66060.00
BIK: £352.32/£176.16
CO2: 54
Insurance: 40
58 miles
£839.79 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [Comfort Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69340.00
BIK: £208.02/£104.01
CO2: 17
Insurance: 40
57 miles
£840.55 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 520i M Sport Pro 4dr Auto [Tech Plus/Comfort Plus]
Saloon
Petrol (Mild Hybrid)
P11D: £62989.99
BIK: £671.89/£335.95
CO2: 132
Insurance: 35
0 miles
£840.88 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [Comfort Plus] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £66340.00
BIK: £353.81/£176.91
CO2: 54
Insurance: 40
58 miles
£845.29 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [Tech Plus/Comfort Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69640.00
BIK: £208.92/£104.46
CO2: 16
Insurance: 40
58 miles
£849.58 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 520i M Sport Pro 5dr Auto [Tech Plus/Comfort Plus]
Estate
Petrol (Mild Hybrid)
P11D: £64840.00
BIK: £713.24/£356.62
CO2: 139
Insurance: 34
0 miles
£856.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 530e M Sport Pro 4dr Auto [Tech Plus/Comfort Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £70789.99
BIK: £212.37/£106.18
CO2: 49
Insurance: 40
62 miles
£874.40 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [Tech Plus] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69060.00
BIK: £391.34/£195.67
CO2: 56
Insurance: 40
57 miles
£875.71 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [Comfort Plus] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69340.00
BIK: £392.93/£196.46
CO2: 56
Insurance: 40
57 miles
£881.22 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [Tech Plus/Comfort Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £72640.00
BIK: £217.92/£108.96
CO2: 17
Insurance: 40
57 miles
£887.56 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport 5dr Auto [Tech +/Comfort +] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69640.00
BIK: £371.41/£185.71
CO2: 54
Insurance: 40
58 miles
£890.28 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES TOURING 530e M Sport Pro 5dr Auto [Tech +/Comfort +] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £72640.00
BIK: £411.63/£205.81
CO2: 56
Insurance: 40
57 miles
£929.34 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport 4dr Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £76639.99
BIK: £459.84/£229.92
CO2: 63
Insurance: 44
56 miles
£1012.17 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport 5dr Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £78889.99
BIK: £499.64/£249.82
CO2: 67
Insurance: 45
54 miles
£1027.64 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport Pro 4dr Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £79639.99
BIK: £477.84/£238.92
CO2: 64
Insurance: 44
56 miles
£1048.63 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport Pro 5dr Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £81889.99
BIK: £518.64/£259.32
CO2: 69
Insurance: 45
53 miles
£1061.99 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport 4dr Auto [Tech Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £80959.99
BIK: £485.76/£242.88
CO2: 63
Insurance: 44
56 miles
£1081.40 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport 4dr Auto [Comfort Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £81640.00
BIK: £489.84/£244.92
CO2: 63
Insurance: 44
56 miles
£1090.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport 5dr Auto [Tech Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £83209.99
BIK: £527.00/£263.50
CO2: 67
Insurance: 45
54 miles
£1094.25 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport 5dr Auto [Comfort Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £83490.00
BIK: £528.77/£264.39
CO2: 67
Insurance: 45
54 miles
£1095.04 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport Pro 4dr Auto [Tech Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £83959.99
BIK: £503.76/£251.88
CO2: 64
Insurance: 44
55 miles
£1117.85 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport Pro 4dr Auto [Comfort Plus]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £84640.00
BIK: £507.84/£253.92
CO2: 64
Insurance: 44
55 miles
£1125.98 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport Pro 5dr Auto [Tech Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £86209.99
BIK: £546.00/£273.00
CO2: 69
Insurance: 45
53 miles
£1131.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport Pro 5dr Auto [Comfort Plus]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £86490.00
BIK: £547.77/£273.89
CO2: 69
Insurance: 45
53 miles
£1132.01 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport 4dr Auto [Tech+/Comfort+]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £84940.00
BIK: £509.64/£254.82
CO2: 63
Insurance: 44
56 miles
£1137.66 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport 5dr Auto [Tech+/Comfort+]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £86790.00
BIK: £549.67/£274.84
CO2: 67
Insurance: 45
54 miles
£1144.22 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES SALOON 550e xDrive M Sport Pro 4dr Auto [Tech+/Comfort+]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £87940.00
BIK: £527.64/£263.82
CO2: 64
Insurance: 44
55 miles
£1174.64 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 5 SERIES
5 SERIES TOURING 550e xDrive M Sport Pro 5dr Auto [Tech+/Comfort+]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £89790.00
BIK: £568.67/£284.34
CO2: 69
Insurance: 45
53 miles
£1181.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average