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 = '175' AND p.tyre_profile = '60' AND p.tyre_diameter = '19' ORDER BY price DESC Best price 175 60 r19 tyres online - Gilgal Tyre

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

Tyre NANKANG NA-1 175/60R19 86 Q
Nankang Nankang NA-1
175/60 R19 86Q
Car Icon
Lable
£121.32

Fully Fitted price

Nankang Tyre From
£121.32 to £137.41
Fully Fitted
Summer Tyre BRIDGESTONE EP500 175/60R19 86 Q
Bridgestone Bridgestone EP500
175/60 R19 86Q
Car Icon Summer Season bmw
Lable
£121.68

Fully Fitted price

Bridgestone Tyre From
£121.68 to £139.44
Fully Fitted

For more information and quotes