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='nissan' AND base.url_model='x-trail' 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–33 of 33 results
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Acenta Premium 5dr [7 Seat] Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £35810.00
BIK: £441.66/£220.83
CO2: 160
Insurance: 22
0 miles
£330.12 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Acenta Premium 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £34810.00
BIK: £429.32/£214.66
CO2: 157
Insurance: 22
0 miles
£335.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 N-Connecta 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £37520.00
BIK: £462.75/£231.37
CO2: 157
Insurance: 22
0 miles
£350.64 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 Acenta Premium 5dr Xtronic
Station Wagon
Hybrid
P11D: £37275.00
BIK: £385.18/£192.59
CO2: 129
Insurance: 24
£353.43 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 N-Connecta [7 St/SkyPack] 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £39155.00
BIK: £482.91/£241.46
CO2: 161
Insurance: 23
0 miles
£354.79 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 N-Connecta 5dr [7 Seat] Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £38520.00
BIK: £475.08/£237.54
CO2: 160
Insurance: 23
0 miles
£357.20 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 N-Connecta [Sky Pack] 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £38155.00
BIK: £470.58/£235.29
CO2: 158
Insurance: 22
0 miles
£359.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 N-Connecta [Sky Pack] 5dr Xtronic
Station Wagon
Hybrid
P11D: £40980.00
BIK: £437.12/£218.56
CO2: 131
Insurance: 25
£367.67 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Acenta Premium 5dr Auto
Station Wagon
Hybrid
P11D: £39475.00
BIK: £447.38/£223.69
CO2: 141
Insurance: 28
£370.11 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 N-Connecta 5dr Xtronic
Station Wagon
Hybrid
P11D: £39985.00
BIK: £426.51/£213.25
CO2: 130
Insurance: 25
£372.14 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 N-Connecta Sky 5dr Auto
Station Wagon
Hybrid
P11D: £43180.00
BIK: £489.37/£244.69
CO2: 142
Insurance: 29
£389.34 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 N-Connecta 7St/Sky 5dr At
Station Wagon
Hybrid
P11D: £44180.00
BIK: £500.71/£250.35
CO2: 144
Insurance: 30
£401.75 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Outstanding
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Acenta Prem 5dr 7 St Auto
Station Wagon
Hybrid
P11D: £40475.00
BIK: £458.72/£229.36
CO2: 143
Insurance: 29
£402.66 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Tekna 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £40875.00
BIK: £504.13/£252.06
CO2: 161
Insurance: 23
0 miles
£410.03 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Tekna [Bose Pack] 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £41105.00
BIK: £506.96/£253.48
CO2: 161
Insurance: 23
0 miles
£412.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Tekna 5dr [7 Seat] Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £41875.00
BIK: £516.46/£258.23
CO2: 163
Insurance: 24
0 miles
£415.88 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 N-Connecta 5dr Auto
Station Wagon
Hybrid
P11D: £42185.00
BIK: £478.10/£239.05
CO2: 141
Insurance: 29
£419.34 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Tekna [Bose Pack] 5dr [7 St] Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £42105.00
BIK: £519.30/£259.65
CO2: 163
Insurance: 24
0 miles
£424.86 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 N-Connecta 5dr 7Seat Auto
Station Wagon
Hybrid
P11D: £43185.00
BIK: £489.43/£244.72
CO2: 144
Insurance: 30
£426.53 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 Tekna 5dr Xtronic
Station Wagon
Hybrid
P11D: £43340.00
BIK: £462.29/£231.15
CO2: 133
Insurance: 26
£433.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Tekna+ 5dr Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £43115.00
BIK: £531.75/£265.88
CO2: 161
Insurance: 24
0 miles
£435.06 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 MHEV 163 Tekna+ 5dr [7 Seat] Xtronic
Station Wagon
Petrol (Mild Hybrid)
P11D: £44115.00
BIK: £544.09/£272.04
CO2: 163
Insurance: 25
0 miles
£440.90 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 Tekna [Bose Pack] 5dr Xtronic
Station Wagon
Hybrid
P11D: £43930.00
BIK: £468.59/£234.29
CO2: 133
Insurance: 26
£442.89 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 N-Trek 5dr Xtronic
Station Wagon
Hybrid
P11D: £43185.00
BIK: £460.64/£230.32
CO2: 132
Insurance: 32
£446.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power 204 Tekna+ 5dr Xtronic
Station Wagon
Hybrid
P11D: £45580.00
BIK: £486.19/£243.09
CO2: 133
Insurance: 27
£454.97 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Tekna 5dr Auto
Station Wagon
Hybrid
P11D: £45540.00
BIK: £516.12/£258.06
CO2: 144
Insurance: 30
£461.50 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Tekna [Bose Pack] 5dr Auto
Station Wagon
Hybrid
P11D: £46130.00
BIK: £522.81/£261.40
CO2: 144
Insurance: 30
£466.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Tekna Bose pk 5dr 7St Auto
Station Wagon
Hybrid
P11D: £47130.00
BIK: £549.85/£274.93
CO2: 146
Insurance: 31
£467.57 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 N-Trek 5dr Auto
Station Wagon
Hybrid
P11D: £45385.00
BIK: £514.36/£257.18
CO2: 143
Insurance: 36
£467.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Tekna 5dr [7 Seat] Auto
Station Wagon
Hybrid
P11D: £46540.00
BIK: £542.97/£271.48
CO2: 146
Insurance: 31
£469.96 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 N-Trek 5dr [7 Seat] Auto
Station Wagon
Hybrid
P11D: £46385.00
BIK: £541.16/£270.58
CO2: 145
Insurance: 36
£479.54 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Tekna+ 5dr Auto
Station Wagon
Hybrid
P11D: £47780.00
BIK: £541.51/£270.75
CO2: 144
Insurance: 31
£479.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
NISSAN X-TRAIL
X-TRAIL STATION WAGON 1.5 E-Power E-4orce 213 Tekna+ 5dr [7 Seat] Auto
Station Wagon
Hybrid
P11D: £48780.00
BIK: £569.10/£284.55
CO2: 146
Insurance: 31
£487.15 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great