Email Us  01483 267676 Contact Us
Latest News  

 Road Bikes

Showing: 1–30 of 40 items
20% Off
Specialized Dolce

Specialized Dolce

£575.00 £460.00

From £15.91 per month on finance
20% Off
Specialized Allez E5

Specialized Allez E5

£575.00 £460.00

From £15.91 per month on finance
From £20.72 per month on finance
From £20.72 per month on finance
From £20.72 per month on finance
From £27.64 per month on finance
20% Off
Specialized Dolce Elite E5

Specialized Dolce Elite E5

£1000.00 £800.00

From £27.67 per month on finance
From £55.34 per month on finance
From £60.53 per month on finance
From £65.72 per month on finance
From £65.72 per month on finance
From £76.10 per month on finance
From £76.10 per month on finance
From £86.48 per month on finance
From £86.48 per month on finance
From £89.93 per month on finance
From £89.93 per month on finance
From £89.93 per month on finance
From £107.23 per month on finance
From £107.23 per month on finance
From £107.23 per month on finance
From £112.42 per month on finance
From £112.42 per month on finance
From £112.42 per month on finance
From £112.42 per month on finance
From £112.42 per month on finance
From £112.42 per month on finance
From £112.42 per month on finance
From £121.07 per month on finance
From £121.07 per month on finance

SELECT *, ((rrp-sale_price)/rrp)*100 as percentage FROM products WHERE deleted=0 AND active=1 AND category_level_1 = 'Bikes' AND (brand ='Specialized') AND (category_level_2 ='Road') AND rrp >= 550.00 AND rrp <= 9995.00 AND (stock>=1 OR warehouse_stock>=1) GROUP BY linked_id, colour ORDER BY rrp ASC LIMIT 0, 30