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

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

Tyre NANKANG N-890 285/60R18 116 H
Nankang Nankang N-890
285/60 R18 116H
Car Icon
Lable
£109.30

Fully Fitted price

Nankang Tyre From
£109.30 to £120.43
Fully Fitted
Summer Tyre MAXXIS AT980E 285/60R18 118 Q
Maxxis Maxxis AT980E
285/60 R18 118Q
Car Icon Summer Season
Lable
£148.74

Fully Fitted price

Maxxis Tyre From
£148.74 to £148.74
Fully Fitted
Tyre YOKOHAMA G015 AT 285/60R18 116H HR
Yokohama Yokohama G015 AT
285/60 R18 116HHR
Car Icon
Lable
£173.21

Fully Fitted price

Yokohama Tyre From
£173.21 to £173.21
Fully Fitted
Tyre BRIDGESTONE AT D693III 285/60R18 116V VR
Bridgestone Bridgestone AT D693III
285/60 R18 116VVR
Car Icon
Lable
£202.30

Fully Fitted price

Bridgestone Tyre From
£202.30 to £202.30
Fully Fitted

For more information and quotes