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='2-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–52 of 52 results
BMW 2 SERIES
2 SERIES GRAN COUPE 220 M Sport 4dr Step Auto
Saloon
Petrol (Mild Hybrid)
P11D: £35665.00
BIK: £356.65/£178.33
CO2: 120
Insurance: 23
0 miles
£474.19 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 220i MHT Sport 5dr DCT
Hatchback
Petrol (Mild Hybrid)
P11D: £34864.99
BIK: £360.27/£180.14
CO2: 129
Insurance: 24
0 miles
£474.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 220i MHT Luxury 5dr DCT
Hatchback
Petrol (Mild Hybrid)
P11D: £36709.99
BIK: £379.34/£189.67
CO2: 129
Insurance: 24
0 miles
£484.68 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES COUPE 220i M Sport 2dr Step Auto
Coupe
Petrol
P11D: £38475.00
BIK: £448.88/£224.44
CO2: 146
Insurance: 30
£490.93 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 2 SERIES
2 SERIES ACTIVE TOURER 223i MHT Sport 5dr DCT
Hatchback
Petrol (Mild Hybrid)
P11D: £37699.99
BIK: £402.13/£201.07
CO2: 133
Insurance: 29
0 miles
£509.88 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES GRAN COUPE 223 xDrive M Sport 4dr Step Auto
Saloon
Petrol (Mild Hybrid)
P11D: £38745.00
BIK: £413.28/£206.64
CO2: 133
Insurance: 28
0 miles
£510.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES GRAN COUPE 220 M Sport 4dr Step Auto [Tech+ Pack]
Saloon
Petrol (Mild Hybrid)
P11D: £38415.00
BIK: £384.15/£192.08
CO2: 120
Insurance: 23
0 miles
£511.61 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 220i MHT Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol (Mild Hybrid)
P11D: £38305.00
BIK: £395.82/£197.91
CO2: 129
Insurance: 24
0 miles
£521.98 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 220i MHT M Sport 5dr DCT
Hatchback
Petrol (Mild Hybrid)
P11D: £38605.00
BIK: £411.79/£205.89
CO2: 131
Insurance: 25
0 miles
£524.40 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES GRAN COUPE 220 M Sport 4dr Step Auto [Pro Pack]
Saloon
Petrol (Mild Hybrid)
P11D: £39289.99
BIK: £392.90/£196.45
CO2: 120
Insurance: 23
0 miles
£528.08 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 223i MHT Luxury 5dr DCT
Hatchback
Petrol (Mild Hybrid)
P11D: £39520.00
BIK: £421.55/£210.77
CO2: 133
Insurance: 29
0 miles
£535.48 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES COUPE 220i M Sport 2dr Step Auto [Pro Pack]
Coupe
Petrol
P11D: £40915.00
BIK: £477.34/£238.67
CO2: 146
Insurance: 28
£538.92 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES GRAN COUPE 220 M Sport 4dr Step Auto [Tech+/Pro Pack]
Saloon
Petrol (Mild Hybrid)
P11D: £40489.99
BIK: £404.90/£202.45
CO2: 120
Insurance: 23
0 miles
£558.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES COUPE 220i M Sport 2dr Step Auto [Tech Pack]
Coupe
Petrol
P11D: £41475.00
BIK: £483.88/£241.94
CO2: 146
Insurance: 28
£559.84 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 220i MHT Luxury 5dr DCT [Tech Plus Pack]
Hatchback
Petrol (Mild Hybrid)
P11D: £40150.00
BIK: £414.88/£207.44
CO2: 129
Insurance: 24
0 miles
£570.51 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE 230i M Sport 2dr Step Auto
Coupe
Petrol
P11D: £41989.99
BIK: £503.88/£251.94
CO2: 151
Insurance: 33
£575.13 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES GRAN COUPE 223 xDrive M Sport 4dr Step Auto [Tech+ Pack]
Saloon
Petrol (Mild Hybrid)
P11D: £41494.99
BIK: £442.61/£221.31
CO2: 133
Insurance: 28
0 miles
£578.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 223i MHT M Sport 5dr DCT
Hatchback
Petrol (Mild Hybrid)
P11D: £41374.99
BIK: £441.33/£220.67
CO2: 131
Insurance: 29
0 miles
£581.58 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 223i MHT Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol (Mild Hybrid)
P11D: £41140.00
BIK: £438.83/£219.41
CO2: 133
Insurance: 29
0 miles
£584.20 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive Sport 5dr DCT
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £40105.00
BIK: £240.63/£120.32
CO2: 60
Insurance: 27
53 miles
£587.44 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE 220i M Sport 2dr Step Auto [Tech/Pro Pack]
Coupe
Petrol
P11D: £43324.99
BIK: £505.46/£252.73
CO2: 146
Insurance: 28
£594.72 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive Luxury 5dr DCT
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £41925.00
BIK: £251.55/£125.78
CO2: 60
Insurance: 27
52 miles
£598.26 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 223i MHT Luxury 5dr DCT [Tech Plus Pack]
Hatchback
Petrol (Mild Hybrid)
P11D: £42960.00
BIK: £458.24/£229.12
CO2: 133
Insurance: 29
0 miles
£599.19 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES GRAN COUPE 223 xDrive M Sport 4dr Step Auto [Pro Pack]
Saloon
Petrol (Mild Hybrid)
P11D: £42370.00
BIK: £451.95/£225.97
CO2: 133
Insurance: 28
0 miles
£599.72 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES GRAN COUPE 223 xDrive M Sport 4dr Step Auto [Tech+/Pro Pack]
Saloon
Petrol (Mild Hybrid)
P11D: £43570.00
BIK: £464.75/£232.37
CO2: 133
Insurance: 28
0 miles
£608.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 220i MHT M Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol (Mild Hybrid)
P11D: £42045.00
BIK: £448.48/£224.24
CO2: 131
Insurance: 25
0 miles
£611.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive M Sport 5dr DCT
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £43780.00
BIK: £262.68/£131.34
CO2: 60
Insurance: 30
52 miles
£625.95 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES GRAN COUPE M235 xDrive 4dr Step Auto
Saloon
Petrol
P11D: £44530.00
BIK: £549.20/£274.60
CO2: 170
Insurance: 31
£633.50 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE 230i M Sport 2dr Step Auto [Pro Pack]
Coupe
Petrol
P11D: £44430.00
BIK: £533.16/£266.58
CO2: 151
Insurance: 33
£634.17 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 392 2dr Step Auto
Coupe
Petrol
P11D: £47815.00
BIK: £589.72/£294.86
CO2: 166
Insurance: 39
£637.22 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £43545.00
BIK: £261.27/£130.64
CO2: 60
Insurance: 27
53 miles
£640.40 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive M Sport Executive Edition 5dr DCT
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £43780.00
BIK: £131.34/£65.67
CO2: 49
Insurance: 30
53 miles
£640.42 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE 230i M Sport 2dr Step Auto [Tech Pack]
Coupe
Petrol
P11D: £44989.99
BIK: £539.88/£269.94
CO2: 151
Insurance: 33
£645.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 223i MHT M Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol (Mild Hybrid)
P11D: £44815.00
BIK: £478.03/£239.01
CO2: 131
Insurance: 29
0 miles
£646.04 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 230e xDrive Luxury 5dr DCT
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £44860.00
BIK: £269.16/£134.58
CO2: 60
Insurance: 31
53 miles
£653.90 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 2dr Step Auto
Coupe
Petrol
P11D: £47815.00
BIK: £589.72/£294.86
CO2: 185
Insurance: 36
£654.74 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 392 2dr Step Auto [Pro Pack]
Coupe
Petrol
P11D: £48859.99
BIK: £602.61/£301.30
CO2: 166
Insurance: 39
£658.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive M Sport Executive Ed 5dr DCT [Tech+]
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £46519.99
BIK: £139.56/£69.78
CO2: 49
Insurance: 30
53 miles
£658.99 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive Luxury 5dr DCT [Tech Plus Pack]
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £45364.99
BIK: £272.19/£136.09
CO2: 60
Insurance: 27
52 miles
£667.61 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 2dr Step Auto [Pro Pack]
Coupe
Petrol
P11D: £48859.99
BIK: £602.61/£301.30
CO2: 185
Insurance: 36
£676.75 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES COUPE 230i M Sport 2dr Step Auto [Tech/Pro Pack]
Coupe
Petrol
P11D: £46840.00
BIK: £562.08/£281.04
CO2: 151
Insurance: 33
£676.90 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES ACTIVE TOURER 230e xDrive M Sport 5dr DCT
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £46714.99
BIK: £280.29/£140.14
CO2: 60
Insurance: 33
52 miles
£685.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES GRAN COUPE M235 xDrive 4dr Step Auto [Tech+ Pack]
Saloon
Petrol
P11D: £47280.00
BIK: £583.12/£291.56
CO2: 170
Insurance: 31
£688.19 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES GRAN COUPE M235 xDrive 4dr Step Auto [Pro Pack]
Saloon
Petrol
P11D: £48154.99
BIK: £593.91/£296.96
CO2: 170
Insurance: 31
£694.20 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 392 2dr Step Auto [Tech Pack]
Coupe
Petrol
P11D: £50815.00
BIK: £626.72/£313.36
CO2: 166
Insurance: 39
£699.39 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 225e xDrive M Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £47220.00
BIK: £283.32/£141.66
CO2: 60
Insurance: 30
52 miles
£699.76 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 392 2dr Step Auto [Tech/Pro Pack]
Coupe
Petrol
P11D: £51810.00
BIK: £638.99/£319.50
CO2: 166
Insurance: 39
£705.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 230e xDrive Luxury5dr DCT [Tech Plus Pack]
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £48300.00
BIK: £289.80/£144.90
CO2: 60
Insurance: 31
53 miles
£706.58 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES GRAN COUPE M235 xDrive 4dr Step Auto [Tech+/Pro Pack]
Saloon
Petrol
P11D: £49354.99
BIK: £608.71/£304.36
CO2: 170
Insurance: 31
£707.61 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 2dr Step Auto [Tech Pack]
Coupe
Petrol
P11D: £50815.00
BIK: £626.72/£313.36
CO2: 185
Insurance: 36
£709.60 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES COUPE M240i xDrive 2dr Step Auto [Tech/Pro Pack]
Coupe
Petrol
P11D: £51810.00
BIK: £638.99/£319.50
CO2: 185
Insurance: 36
£723.24 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 2 SERIES
2 SERIES ACTIVE TOURER 230e xDrive M Sport 5dr DCT [Tech Plus Pack]
Hatchback
Petrol/PlugIn Elec Hybrid
P11D: £50155.00
BIK: £300.93/£150.47
CO2: 60
Insurance: 33
52 miles
£735.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Acceptable