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 = '70' AND p.tyre_diameter = '17' ORDER BY price DESC Best price 285 70 r17 tyres online - Gilgal Tyre

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

Tyre COOPER DISCOVERER AT3 4S 285/70R17 117 T
Cooper Cooper DISCOVERER AT3 4S
285/70 R17 117T
Car Icon
Lable
£180.32

Fully Fitted price

Cooper Tyre From
£180.32 to £214.03
Fully Fitted
Tyre YOKOHAMA G015 AT 285/70R17 117T TR
Yokohama Yokohama G015 AT
285/70 R17 117TTR
Car Icon
Lable
£194.23

Fully Fitted price

Yokohama Tyre From
£194.23 to £199.85
Fully Fitted

For more information and quotes