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='3-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–32 of 32 results
BMW 3 SERIES
3 SERIES SALOON 320i M Sport 4dr Step Auto
Saloon
Petrol
P11D: £41965.00
BIK: £489.59/£244.80
CO2: 148
Insurance: 28
£515.49 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 320i Sport 4dr Step Auto
Saloon
Petrol
P11D: £40714.99
BIK: £475.01/£237.50
CO2: 147
Insurance: 28
£516.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh Sport 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £48820.00
BIK: £146.46/£73.23
CO2: 20
Insurance: 35
59 miles
£530.32 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh Sport 4dr Step Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £47020.00
BIK: £141.06/£70.53
CO2: 19
Insurance: 34
62 miles
£532.96 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £50070.00
BIK: £150.21/£75.11
CO2: 20
Insurance: 35
59 miles
£538.01 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 320i Sport 5dr Step Auto
Estate
Petrol
P11D: £42514.99
BIK: £510.18/£255.09
CO2: 153
Insurance: 28
£541.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £48270.00
BIK: £144.81/£72.41
CO2: 19
Insurance: 34
61 miles
£541.71 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 320i M Sport 5dr Step Auto
Estate
Petrol
P11D: £43765.00
BIK: £525.18/£262.59
CO2: 153
Insurance: 29
£548.45 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 320i M Sport 4dr Step Auto [Tech Pack]
Saloon
Petrol
P11D: £44065.00
BIK: £514.09/£257.05
CO2: 148
Insurance: 28
£550.03 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 320i M Sport 4dr Step Auto [Pro Pack]
Saloon
Petrol
P11D: £44314.99
BIK: £517.01/£258.50
CO2: 148
Insurance: 28
£553.79 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto [Tech Pack]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £50370.00
BIK: £151.11/£75.56
CO2: 19
Insurance: 34
61 miles
£557.68 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh Sport 5dr Step Auto [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £48820.00
BIK: £276.65/£138.32
CO2: 58
Insurance: 35
59 miles
£561.29 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto [Pro Pack]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £50620.00
BIK: £151.86/£75.93
CO2: 19
Insurance: 34
61 miles
£562.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh Sport 4dr Step Auto [NI]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £47020.00
BIK: £266.45/£133.22
CO2: 55
Insurance: 34
62 miles
£562.51 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto [Tech Pack]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £52170.00
BIK: £156.51/£78.26
CO2: 20
Insurance: 35
59 miles
£566.85 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 320i M Sport 5dr Step Auto [Tech Pack]
Estate
Petrol
P11D: £45865.00
BIK: £550.38/£275.19
CO2: 153
Insurance: 29
£568.37 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £50070.00
BIK: £283.73/£141.87
CO2: 59
Insurance: 35
59 miles
£569.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto [Pro Pack]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £52420.00
BIK: £157.26/£78.63
CO2: 20
Insurance: 35
59 miles
£570.63 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto [NI]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £48270.00
BIK: £273.53/£136.77
CO2: 55
Insurance: 34
61 miles
£572.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES TOURING 320i M Sport 5dr Step Auto [Pro Pack]
Estate
Petrol
P11D: £46114.99
BIK: £553.38/£276.69
CO2: 153
Insurance: 29
£573.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 320i M Sport 4dr Step Auto [Tech/Pro Pack]
Saloon
Petrol
P11D: £46414.99
BIK: £541.51/£270.75
CO2: 148
Insurance: 28
£587.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto [Tech] [NI]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £50370.00
BIK: £285.43/£142.72
CO2: 55
Insurance: 34
61 miles
£589.16 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto [Pro] [NI]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £50620.00
BIK: £286.85/£143.42
CO2: 55
Insurance: 34
61 miles
£593.57 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto Tech/Pro Pack
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £52720.00
BIK: £158.16/£79.08
CO2: 19
Insurance: 34
61 miles
£596.74 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto [Tech] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £52170.00
BIK: £295.63/£147.82
CO2: 59
Insurance: 35
59 miles
£599.45 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto Tech/Pro Pack
Estate
Petrol/PlugIn Elec Hybrid
P11D: £54520.00
BIK: £163.56/£81.78
CO2: 20
Insurance: 35
59 miles
£601.61 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW 3 SERIES
3 SERIES TOURING 320i M Sport 5dr Step Auto [Tech/Pro Pack]
Estate
Petrol
P11D: £48214.99
BIK: £578.58/£289.29
CO2: 153
Insurance: 29
£615.09 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto [Pro] [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £52420.00
BIK: £297.05/£148.52
CO2: 59
Insurance: 35
59 miles
£616.96 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON 330e 22.3 kWh M Sport 4dr Step Auto Tech/Pro [NI]
Saloon
Petrol/PlugIn Elec Hybrid
P11D: £52720.00
BIK: £298.75/£149.37
CO2: 55
Insurance: 34
61 miles
£629.06 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES TOURING 330e 22.3 kWh M Sport 5dr Step Auto Tech/Pro [NI]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £54520.00
BIK: £308.95/£154.47
CO2: 59
Insurance: 35
59 miles
£635.12 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW 3 SERIES
3 SERIES SALOON M340i xDrive MHT 392 4dr Step Auto
Saloon
Petrol (Mild Hybrid)
P11D: £59835.00
BIK: £737.97/£368.98
CO2: 159
Insurance: 39
0 miles
£779.66 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW 3 SERIES
3 SERIES TOURING M340i xDrive MHT 392 5dr Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £61635.00
BIK: £760.17/£380.08
CO2: 165
Insurance: 39
0 miles
£797.48 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average