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

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

Tyre YOKOHAMA V905 275/45R18 107 V
Yokohama Yokohama V905
275/45 R18 107V
Car Icon
Lable
£163.73

Fully Fitted price

Yokohama Tyre From
£163.73 to £163.73
Fully Fitted
Summer Tyre CONTINENTAL SPORT CONTACT 5 275/45R18 103 Y
Continental Continental SPORT CONTACT 5
275/45 R18 103Y
Car Icon Summer Season porsche
Lable
£176.70

Fully Fitted price

Continental Tyre From
£176.70 to £226.06
Fully Fitted
Tyre DUNLOP MAXX GT 275/45R18 107 Y
Dunlop Dunlop MAXX GT
275/45 R18 107Y
Car Icon
Lable
£236.57

Fully Fitted price

Dunlop Tyre From
£236.57 to £236.57
Fully Fitted
Tyre PIRELLI PZERO 275/45R18 103Y YR
Pirelli Pirelli PZERO
275/45 R18 103YYR
Car Icon
Lable
£240.74

Fully Fitted price

Pirelli Tyre From
£240.74 to £510.31
Fully Fitted

For more information and quotes