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 = '295' AND p.tyre_profile = '40' AND p.tyre_diameter = '19' ORDER BY price DESC Best price 295 40 r19 tyres online - Gilgal Tyre

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

Summer Tyre GOODYEAR EAGLE F1 ASYM 3 295/40R19 108 Y
Goodyear Goodyear EAGLE F1 ASYM 3
295/40 R19 108Y
Car Icon XL Summer Season porsche
Lable
£197.76

Fully Fitted price

Goodyear Tyre From
£197.76 to £201.36
Fully Fitted
Summer Tyre MICHELIN PILOT SPORT 4 295/40R19 108 Y
Michelin Michelin PILOT SPORT 4
295/40 R19 108Y
Car Icon XL Summer Season porsche
Lable
£231.36

Fully Fitted price

Michelin Tyre From
£231.36 to £271.85
Fully Fitted
Tyre PIRELLI P-ZERO SP 295/40R19 108Y YR
Pirelli Pirelli P-ZERO SP
295/40 R19 108YYR
Car Icon
Lable
£266.81

Fully Fitted price

Pirelli Tyre From
£266.81 to £266.81
Fully Fitted

For more information and quotes