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

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

All Season Tyre ACCELERA PHI-R 195/45R15 78 V
ACCELERA ACCELERA PHI-R
195/45 R15 78V
Car Icon All Season
Lable
£43.62

Fully Fitted price

ACCELERA Tyre From
£43.62 to £43.62
Fully Fitted
Tyre MOHAWK M105 195/45R15 78 V
MOHAWK MOHAWK M105
195/45 R15 78V
Car Icon
Lable
£53.27

Fully Fitted price

MOHAWK Tyre From
£53.27 to £53.27
Fully Fitted
Tyre DO NOT LIST DH2 195/45R15 78V VR
DO NOT LIST DO NOT LIST DH2
195/45 R15 78VVR
Car Icon
Lable
£54.41

Fully Fitted price

DO NOT LIST Tyre From
£54.41 to £56.86
Fully Fitted
Tyre HANKOOK K105 195/45R15 78 V
Hankook Hankook K105
195/45 R15 78V
Car Icon
Lable
£58.60

Fully Fitted price

Hankook Tyre From
£58.60 to £58.60
Fully Fitted
Tyre UNIROYAL RAINSP5 195/45R15 78V VR
Uniroyal Uniroyal RAINSP5
195/45 R15 78VVR
Car Icon
Lable
£74.80

Fully Fitted price

Uniroyal Tyre From
£74.80 to £79.85
Fully Fitted
Summer Tyre GOODYEAR EAGLE F1 GSD3 195/45R15 78 V
Goodyear Goodyear EAGLE F1 GSD3
195/45 R15 78V
Car Icon Summer Season
Lable
£84.06

Fully Fitted price

Goodyear Tyre From
£84.06 to £84.06
Fully Fitted

For more information and quotes