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='audi' AND base.url_model='q5' 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–38 of 38 results
AUDI Q5
Q5 ESTATE 2.0 TFSI Quattro Sport 5dr S Tronic
Estate
Petrol
P11D: £50845.00
BIK: £627.09/£313.54
CO2: 159
Insurance: 37
£573.93 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL ESTATE 2.0 TDI Quattro Sport 5dr S Tronic
Estate
Diesel
P11D: £52495.00
BIK: £647.44/£323.72
CO2: 156
Insurance: 38
£574.41 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI Quattro S Line 5dr S Tronic
Estate
Petrol
P11D: £53445.00
BIK: £659.16/£329.58
CO2: 167
Insurance: 38
£591.52 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL ESTATE 2.0 TDI Quattro S Line 5dr S Tronic
Estate
Diesel
P11D: £55095.00
BIK: £679.51/£339.75
CO2: 166
Insurance: 39
£599.00 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI Quattro Sport 5dr S Tronic [Sound+Vision]
Estate
Petrol
P11D: £53040.00
BIK: £654.16/£327.08
CO2: 159
Insurance: 37
£602.97 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL ESTATE 2.0 TDI Quattro Sport 5dr S Tronic [Sound+Vision]
Estate
Diesel
P11D: £54690.00
BIK: £674.51/£337.26
CO2: 156
Insurance: 38
£603.47 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL ESTATE 2.0 TDI Quattro Edition 1 5dr S Tronic
Estate
Diesel
P11D: £59295.00
BIK: £731.31/£365.65
CO2: 167
Insurance: 39
£607.75 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI Quattro Edition 1 5dr S Tronic
Estate
Petrol
P11D: £57645.00
BIK: £710.96/£355.48
CO2: 169
Insurance: 38
£609.69 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI Quattro Sport 5dr S Tronic
Estate
Petrol
P11D: £53344.99
BIK: £657.92/£328.96
CO2: 159
Insurance: 38
£611.16 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI Quattro S Line 5dr S Tronic [S+V]
Estate
Petrol
P11D: £55639.99
BIK: £686.23/£343.11
CO2: 167
Insurance: 38
£614.94 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL SPORTBACK 2.0 TDI Quattro Sport 5dr S Tronic
Estate
Diesel
P11D: £54994.99
BIK: £678.27/£339.14
CO2: 157
Insurance: 39
£615.76 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL ESTATE 2.0 TDI Quattro S Line 5dr S Tronic [Sound+Vision]
Estate
Diesel
P11D: £57289.99
BIK: £706.58/£353.29
CO2: 166
Insurance: 39
£617.21 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI Quattro S Line 5dr S Tronic
Estate
Petrol
P11D: £55945.00
BIK: £689.99/£344.99
CO2: 167
Insurance: 38
£623.70 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL SPORTBACK 2.0 TDI Quattro S Line 5dr S Tronic
Estate
Diesel
P11D: £57595.00
BIK: £710.34/£355.17
CO2: 164
Insurance: 39
£628.29 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI Quattro Sport 5dr S Tronic [Sound+Vision]
Estate
Petrol
P11D: £55540.00
BIK: £684.99/£342.50
CO2: 159
Insurance: 38
£630.41 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL ESTATE 2.0 TDI Quattro Edition 1 5dr S Tronic [S+V]
Estate
Diesel
P11D: £61489.99
BIK: £758.38/£379.19
CO2: 167
Insurance: 39
£636.81 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI Quattro Edition 1 5dr S Tronic [S+V]
Estate
Petrol
P11D: £59839.99
BIK: £738.03/£369.01
CO2: 169
Insurance: 38
£638.74 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL SPORTBACK 2.0 TDI Quattro Sport 5dr S Tronic [Sound+Vision]
Estate
Diesel
P11D: £57190.00
BIK: £705.34/£352.67
CO2: 157
Insurance: 39
£644.80 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL SPORTBACK 2.0 TDI Quattro Edition 1 5dr S Tronic
Estate
Diesel
P11D: £61795.00
BIK: £762.14/£381.07
CO2: 165
Insurance: 40
£645.49 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI Quattro Edition 1 5dr S Tronic
Estate
Petrol
P11D: £60145.00
BIK: £741.79/£370.89
CO2: 168
Insurance: 39
£646.90 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI e Quattro 299 Sport 5dr S Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £58155.00
BIK: £329.55/£164.77
CO2: 58
Insurance: 43
61 miles
£650.52 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI Quattro S Line 5dr S Tronic [S+V]
Estate
Petrol
P11D: £58140.00
BIK: £717.06/£358.53
CO2: 167
Insurance: 38
£652.73 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL SPORTBACK 2.0 TDI Quattro S Line 5dr S Tronic [Sound+Vision]
Estate
Diesel
P11D: £59790.00
BIK: £737.41/£368.71
CO2: 164
Insurance: 39
£657.35 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI e Quattro 299 S Line 5dr S Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £60754.99
BIK: £364.53/£182.26
CO2: 64
Insurance: 43
57 miles
£663.66 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 DIESEL SPORTBACK 2.0 TDI Quattro Edition 1 5dr S Tronic [S+V]
Estate
Diesel
P11D: £63990.00
BIK: £789.21/£394.61
CO2: 165
Insurance: 40
£674.53 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI Quattro Edition 1 5dr S Tronic [S+V]
Estate
Petrol
P11D: £62340.00
BIK: £768.86/£384.43
CO2: 168
Insurance: 39
£676.33 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI e Quattro 299 Sport 5dr S Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £60655.00
BIK: £343.71/£171.86
CO2: 58
Insurance: 43
61 miles
£678.22 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI e Quattro 299 Sport 5dr S Tronic [S+V]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £60349.99
BIK: £341.98/£170.99
CO2: 58
Insurance: 43
61 miles
£678.63 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI e Quattro 299 Edition 1 5dr S Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £64954.99
BIK: £411.38/£205.69
CO2: 65
Insurance: 45
56 miles
£685.41 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI e Quattro 299 S Line 5dr S Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £63255.00
BIK: £379.53/£189.77
CO2: 64
Insurance: 43
57 miles
£690.77 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI e Quattro 299 S Line 5dr S Tronic [S+V]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £62950.00
BIK: £377.70/£188.85
CO2: 64
Insurance: 43
57 miles
£697.88 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI e Quattro 299 Sport 5dr S Tronic [S+V]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £62850.00
BIK: £356.15/£178.08
CO2: 58
Insurance: 43
61 miles
£705.83 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI e Quattro 299 Edition 1 5dr S Tronic
Estate
Petrol/PlugIn Elec Hybrid
P11D: £67455.00
BIK: £427.22/£213.61
CO2: 65
Insurance: 45
56 miles
£711.59 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE 2.0 TFSI e Quattro 299 Edition1 5dr S Tronic [S+V]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £67150.00
BIK: £425.28/£212.64
CO2: 65
Insurance: 45
56 miles
£713.51 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI e Quattro 299 S Line 5dr S Tronic [S+V]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £65449.99
BIK: £392.70/£196.35
CO2: 64
Insurance: 43
57 miles
£718.36 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 SPORTBACK 2.0 TFSI e Quattro 299 Edition1 5dr S Tronic [S+V]
Estate
Petrol/PlugIn Elec Hybrid
P11D: £69649.99
BIK: £441.12/£220.56
CO2: 65
Insurance: 45
56 miles
£739.18 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Great
AUDI Q5
Q5 ESTATE SQ5 TFSI Quattro Edition 1 5dr S Tronic
Estate
Petrol
P11D: £74880.00
BIK: £923.52/£461.76
CO2: 188
Insurance: 45
£910.54 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good
AUDI Q5
Q5 SPORTBACK SQ5 TFSI Quattro Edition 1 5dr S Tronic
Estate
Petrol
P11D: £77380.00
BIK: £954.35/£477.18
CO2: 189
Insurance: 46
£951.13 per month
(exc. VAT)
Lease Value Score:
Lease Value Score:
Rating:
Good