Search
tel. 02034415298
Shopping Cart
your cart is empty
CycleScheme.co.uk
Logo
AXA BASTA
‹ back
HOME  › 
AXA BASTA
We offer a comprehensive assortment of AXA and Basta cycle accessories. The products are arranged by category: cycle locks and cycle lighting
Axa Cherto 100 Axa Cherto 100
Price :
£ 35,63
AXA Basta Lock ring... AXA Basta  Lock ring  black
Price :
£ 30,69
AXA Lock Defender with... AXA Lock Defender with cilinder M/CHIP
Price :
£ 24,74
AXA Lock Defender with... AXA Lock Defender with cilinder M/CHIP   Black
Price :
£ 21,39
AXA Basta Solid Lock... AXA Basta Solid Lock ring  black
Price :
£ 19,79
AXA-BASTA Defender... AXA-BASTA Defender RLC100 plug-in chain
Price :
£ 19,10

connect set charset utf8; SELECT `cms_menu`.* FROM `cms_menu` WHERE (active=1) AND (lang='en') ORDER BY `priority` ASC SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `t`.`id`, `t`.`file`, `t`.`template`, `t`.`parent_id`, `t`.`priority`, `t`.`discount`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`meta_title`, `c`.`meta_description`, `c`.`meta_keywords` FROM `cms_products_categories` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='productscategories' and c.lang='en' WHERE (t.active=1) AND (c.active=1) ORDER BY `t`.`priority` ASC SELECT `t`.`id`, `t`.`file`, `t`.`add_date`, `t`.`recommend`, `t`.`template`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_pages` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='pages' and c.lang='en' WHERE (t.id='21') AND (t.active=1) SELECT `t`.`id`, `t`.`priority`, `t`.`active`, `t`.`file`, `t`.`add_date`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_producers` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='producers' and c.lang='en' WHERE (c.niceurl='axa-basta') AND (t.active=1) SELECT `t`.`id`, `t`.`producers_id`, `t`.`price`, `t`.`last_price`, `t`.`price_eur`, `t`.`code`, `t`.`weight`, `t`.`featured`, `t`.`quantity`, `t`.`special1`, `t`.`types_id`, `t`.`file`, `t`.`active`, `t`.`add_date`, `t`.`outside_b2b`, `t`.`outside_avaliable`, `t`.`outside_img`, `c`.`title`, `c`.`description`, `c`.`specification`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description`, `ptc`.`products_categories_id` FROM `cms_products` AS `t` LEFT JOIN `cms_products_desc` AS `c` ON c.products_id=t.id and c.lang='en' LEFT JOIN `cms_products_to_categories` AS `ptc` ON ptc.products_id=t.id WHERE (t.active=1) AND (producers_id=3) ORDER BY `t`.`price` desc