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

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

Tyre NANKANG SP-9 245/70R17 110 H
Nankang Nankang SP-9
245/70 R17 110H
Car Icon
Lable
£89.03

Fully Fitted price

Nankang Tyre From
£89.03 to £89.03
Fully Fitted
Tyre COOPER DISCOVERER AT3 4S 245/70R17 110 T
Cooper Cooper DISCOVERER AT3 4S
245/70 R17 110T
Car Icon
Lable
£132.57

Fully Fitted price

Cooper Tyre From
£132.57 to £132.57
Fully Fitted
Summer Tyre MICHELIN LATITUDE CROSS 245/70R17 114 T
Michelin Michelin LATITUDE CROSS
245/70 R17 114T
Car Icon XL Summer Season
Lable
£152.10

Fully Fitted price

Michelin Tyre From
£152.10 to £152.10
Fully Fitted
Tyre YOKOHAMA G015 AT 245/70R17 119/116R R
Yokohama Yokohama G015 AT
245/70 R17 119/11R
Car Icon
Lable
£161.40

Fully Fitted price

Yokohama Tyre From
£161.40 to £161.40
Fully Fitted
Tyre BRIDGESTONE AT001 245/70R17 110S SR
Bridgestone Bridgestone AT001
245/70 R17 110SSR
Car Icon
Lable
£176.66

Fully Fitted price

Bridgestone Tyre From
£176.66 to £176.66
Fully Fitted

For more information and quotes