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 = '145' AND p.tyre_profile = '80' AND p.tyre_diameter = '10' ORDER BY price DESC Best price 145 80 r10 tyres online - Gilgal Tyre

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

Tyre NANKANG TR-10 145/80R10 69 S
Nankang Nankang TR-10
145/80 R10 69S
Car Icon
Lable
£43.46

Fully Fitted price

Nankang Tyre From
£43.46 to £43.46
Fully Fitted
Summer Tyre MAXXIS CR966 145/80R10 84 N
Maxxis Maxxis CR966
145/80 R10 84N
Car Icon Summer Season
Lable
£45.84

Fully Fitted price

Maxxis Tyre From
£45.84 to £45.84
Fully Fitted

For more information and quotes