SELECT p.product_id, (p.price+ pov.price) price, p.manufacturer_id FROM oc_product p LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_option_value pov ON (p.product_id = pov.product_id) WHERE p.quantity > 0 AND p.tyre_source != 'newtyre' AND pov.option_value_id = '50' AND p.stock_status_id = 6 AND p.tyre_width = '265' AND p.tyre_profile = '40' AND p.tyre_diameter = '22' ORDER BY price DESC Best price 265 40 r22 tyres online - Gilgal Tyre

fully fitted price includes VAT, fitting & disposal of old tyres

All Season Tyre ACCELERA IOTA ST68 265/40R22 106 Y
ACCELERA ACCELERA IOTA ST68
265/40 R22 106Y
Car Icon XL All Season
Lable
£94.20

Fully Fitted price

ACCELERA Tyre From
£94.20 to £94.20
Fully Fitted
Tyre NANKANG SP-9 265/40R22 106 Y
Nankang Nankang SP-9
265/40 R22 106Y
Car Icon XL
Lable
£138.94

Fully Fitted price

Nankang Tyre From
£138.94 to £138.94
Fully Fitted
All Season Tyre PIRELLI SCORPION ZERO AS 265/40R22 106 Y
Pirelli Pirelli SCORPION ZERO AS
265/40 R22 106Y
Car Icon XL All Season
Lable
£213.54

Fully Fitted price

Pirelli Tyre From
£213.54 to £559.42
Fully Fitted
Summer Tyre CONTINENTAL CROSS CONT LX SPORT 265/40R22 106 Y
Continental Continental CROSS CONT LX SPORT
265/40 R22 106Y
Car Icon XL Summer Season
Lable
£225.48

Fully Fitted price

Continental Tyre From
£225.48 to £291.72
Fully Fitted
Summer Tyre MICHELIN PILOT SPORT 4 SUV 265/40R22 106 Y
Michelin Michelin PILOT SPORT 4 SUV
265/40 R22 106Y
Car Icon XL Summer Season
Lable
£255.90

Fully Fitted price

Michelin Tyre From
£255.90 to £255.90
Fully Fitted

For more information and quotes