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='x1' 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
BMW X1
X1 ESTATE sDrive 20i MHT Sport 5dr Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £36424.99
BIK: £376.39/£188.20
CO2: 128
Insurance: 25
0 miles
£456.99 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 DIESEL ESTATE sDrive 18d Sport 5dr Step Auto
Estate
Diesel
P11D: £37594.99
BIK: £401.01/£200.51
CO2: 131
Insurance: 24
£476.17 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE sDrive 20i MHT xLine 5dr Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £38455.00
BIK: £397.37/£198.68
CO2: 129
Insurance: 25
0 miles
£483.29 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 DIESEL ESTATE sDrive 18d xLine 5dr Step Auto
Estate
Diesel
P11D: £39634.99
BIK: £422.77/£211.39
CO2: 133
Insurance: 24
£491.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 25e Sport Edition 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £42705.00
BIK: £128.12/£64.06
CO2: 47
Insurance: 29
54 miles
£499.29 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE sDrive 20i MHT M Sport 5dr Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £41245.00
BIK: £439.95/£219.97
CO2: 130
Insurance: 26
0 miles
£517.43 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 25e xLine 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £44704.99
BIK: £253.33/£126.66
CO2: 55
Insurance: 30
49 miles
£526.31 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 25e Sport Edition 5dr [Tech Plus] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £44955.00
BIK: £134.87/£67.43
CO2: 47
Insurance: 29
54 miles
£527.37 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 23i MHT xLine 5dr Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £41640.00
BIK: £485.80/£242.90
CO2: 145
Insurance: 31
0 miles
£534.64 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 DIESEL ESTATE sDrive 18d M Sport 5dr Step Auto
Estate
Diesel
P11D: £42424.99
BIK: £452.53/£226.27
CO2: 133
Insurance: 25
£538.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 25e M Sport 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £47455.00
BIK: £253.09/£126.55
CO2: 52
Insurance: 31
51 miles
£545.92 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW X1
X1 ESTATE xDrive 30e xLine 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £46975.00
BIK: £266.19/£133.10
CO2: 57
Insurance: 33
50 miles
£546.36 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE sDrive 20i MHT xLine 5dr [Tech Plus] Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £41895.00
BIK: £432.92/£216.46
CO2: 129
Insurance: 25
0 miles
£559.77 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 23i MHT M Sport 5dr Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £44415.00
BIK: £518.18/£259.09
CO2: 145
Insurance: 31
0 miles
£559.99 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 30e M Sport 5dr Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £49725.00
BIK: £281.78/£140.89
CO2: 55
Insurance: 34
50 miles
£564.37 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
BMW X1
X1 DIESEL ESTATE xDrive 23d MHT xLine 5dr Step Auto
Estate
Diesel (Mild Hybrid)
P11D: £43345.00
BIK: £447.90/£223.95
CO2: 126
Insurance: 30
0 miles
£572.50 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 DIESEL ESTATE sDrive 18d xLine 5dr [Tech Plus Pack] Step Auto
Estate
Diesel
P11D: £43075.00
BIK: £459.47/£229.73
CO2: 133
Insurance: 24
£572.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 25e xLine 5dr [Tech Plus Pk] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £48145.00
BIK: £272.82/£136.41
CO2: 55
Insurance: 30
50 miles
£575.37 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE sDrive 20i MHT M Sport 5dr [Tech Plus] Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £44685.00
BIK: £476.64/£238.32
CO2: 130
Insurance: 26
0 miles
£580.05 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 DIESEL ESTATE xDrive 23d MHT M Sport 5dr Step Auto
Estate
Diesel (Mild Hybrid)
P11D: £46135.00
BIK: £461.35/£230.68
CO2: 124
Insurance: 31
0 miles
£583.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE sDrive 20i MHT M Sport 5dr [Tech/Pro] Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £45325.00
BIK: £483.47/£241.73
CO2: 130
Insurance: 26
0 miles
£589.87 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 25e M Sport 5dr [Tech Plus Pack] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £50895.00
BIK: £271.44/£135.72
CO2: 52
Insurance: 31
51 miles
£592.84 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 30e xLine 5dr [Tech Plus Pack] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £50415.00
BIK: £285.69/£142.84
CO2: 57
Insurance: 33
50 miles
£597.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 23i MHT xLine 5dr [Tech Plus] Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £45079.99
BIK: £525.93/£262.97
CO2: 145
Insurance: 31
0 miles
£598.34 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 DIESEL ESTATE sDrive 18d M Sport 5dr [Tech Plus Pack] Step Auto
Estate
Diesel
P11D: £45865.00
BIK: £489.23/£244.61
CO2: 133
Insurance: 25
£598.96 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 25e M Sport 5dr [Tech/Pro Pack] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £51535.00
BIK: £274.85/£137.43
CO2: 52
Insurance: 31
50 miles
£600.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 DIESEL ESTATE sDrive 18d M Sport 5dr [Tech/Pro Pack] Step Auto
Estate
Diesel
P11D: £46504.99
BIK: £496.05/£248.03
CO2: 133
Insurance: 25
£601.06 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 30e M Sport 5dr [Tech Plus Pack] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £53164.99
BIK: £301.27/£150.63
CO2: 55
Insurance: 34
50 miles
£615.05 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 DIESEL ESTATE xDrive 23d MHT xLine 5dr [Tech Plus] Step Auto
Estate
Diesel (Mild Hybrid)
P11D: £46785.00
BIK: £483.45/£241.72
CO2: 126
Insurance: 30
0 miles
£615.55 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 30e M Sport 5dr [Tech/Pro Pack] Step Auto
Estate
Petrol/PlugIn Elec Hybrid
P11D: £53805.00
BIK: £304.90/£152.45
CO2: 55
Insurance: 34
50 miles
£627.39 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
BMW X1
X1 ESTATE xDrive 23i MHT M Sport 5dr [Tech Plus] Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £47854.99
BIK: £558.31/£279.15
CO2: 145
Insurance: 31
0 miles
£629.62 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE xDrive 23i MHT M Sport 5dr [Tech/Pro] Step Auto
Estate
Petrol (Mild Hybrid)
P11D: £48495.00
BIK: £565.78/£282.89
CO2: 145
Insurance: 31
0 miles
£630.83 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 DIESEL ESTATE xDrive 23d MHT M Sport 5dr [Tech Plus] Step Auto
Estate
Diesel (Mild Hybrid)
P11D: £49575.00
BIK: £495.75/£247.88
CO2: 124
Insurance: 31
0 miles
£642.22 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 DIESEL ESTATE xDrive 23d MHT M Sport 5dr [Tech/Pro] Step Auto
Estate
Diesel (Mild Hybrid)
P11D: £50215.00
BIK: £502.15/£251.08
CO2: 124
Insurance: 31
0 miles
£649.53 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE M35i xDrive 5dr Step Auto
Estate
Petrol
P11D: £49275.00
BIK: £607.73/£303.86
CO2: 175
Insurance: 35
£657.72 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE M35i xDrive 5dr [Tech/Pro Pack] Step Auto
Estate
Petrol
P11D: £52665.00
BIK: £649.54/£324.77
CO2: 175
Insurance: 35
£709.08 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average
BMW X1
X1 ESTATE M35i xDrive 5dr [Tech Plus Pack] Step Auto
Estate
Petrol
P11D: £52714.99
BIK: £650.15/£325.08
CO2: 175
Insurance: 35
£710.10 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Average