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 = '345' AND p.tyre_profile = '30' AND p.tyre_diameter = '20' ORDER BY price DESC Best price 345 30 r20 tyres online - Gilgal Tyre

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

Tyre MICHELIN P SPORT 4S 345/30R20 106Y YR
Michelin Michelin P SPORT 4S
345/30 R20 106YYR
Car Icon
Lable
£439.46

Fully Fitted price

Michelin Tyre From
£439.46 to £439.46
Fully Fitted
Tyre PIRELLI PZ CORSA A2 345/30R20 106Y YR
Pirelli Pirelli PZ CORSA A2
345/30 R20 106YYR
Car Icon
Lable
£500.38

Fully Fitted price

Pirelli Tyre From
£500.38 to £500.38
Fully Fitted

For more information and quotes