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

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

Summer Tyre MICHELIN PRIMACY 3 245/55R17 102 W
Michelin Michelin PRIMACY 3
245/55 R17 102W
Car Icon Summer Season bmw
Lable
£136.68

Fully Fitted price

Michelin Tyre From
£136.68 to £158.38
Fully Fitted
Tyre HANKOOK K115 PRM2 245/55R17 102W WR
Hankook Hankook K115 PRM2
245/55 R17 102WWR
Car Icon
Lable
£144.70

Fully Fitted price

Hankook Tyre From
£144.70 to £144.70
Fully Fitted
Summer Tyre PIRELLI P7 CINTURATO 245/55R17 102 V
Pirelli Pirelli P7 CINTURATO
245/55 R17 102V
Car Icon Run Flat Summer Season bmw
Lable
£214.08

Fully Fitted price

Pirelli Tyre From
£214.08 to £214.08
Fully Fitted

For more information and quotes