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 = '50' AND p.tyre_diameter = '21' ORDER BY price DESC Best price 275 50 r21 tyres online - Gilgal Tyre

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

Tyre ACCELERA IOTA - ST68 275/50R21 113 V
ACCELERA ACCELERA IOTA - ST68
275/50 R21 113V
Car Icon XL
Lable
£89.94

Fully Fitted price

ACCELERA Tyre From
£89.94 to £89.94
Fully Fitted
Tyre NANKANG SP-9 275/50R21 113 W
Nankang Nankang SP-9
275/50 R21 113W
Car Icon XL
Lable
£179.33

Fully Fitted price

Nankang Tyre From
£179.33 to £179.33
Fully Fitted
Summer Tyre DUNLOP GRANDTREK PT3A 275/50R21 113 V
Dunlop Dunlop GRANDTREK PT3A
275/50 R21 113V
Car Icon XL Summer Season
Lable
£271.32

Fully Fitted price

Dunlop Tyre From
£271.32 to £271.32
Fully Fitted

For more information and quotes