Search
tel. 02034415298
Shopping Cart
your cart is empty
CycleScheme.co.uk
Logo
  • Koga Adaptor
  • Facebook
  • Price Match Promise
  • Super Metro
News
20 Feb . 2012 : FACEBOOK FACEBOOK ›
New Gazelle models and every weekend some promotions available on our FACEBOOK page  ...
07 Feb . 2012 : Bicycle Compare Bicycle Compare ›
Now you can select up to 3 Dutch bikes models and compare them in order to make your...
22 Dec . 2011 : Safety Warning! Safety Warning! ›
Safety Warning! As a manufacturer of quality bikes, we pay the utmost attention to our...
05 Dec . 2011 : Gazelle: winner of three awards Dutch Good Industrial Design 2011! Gazelle: winner of three awards Dutch Good... ›
  An independent jury has examined over 70 entries for the Dutch Good Industrial...
29 Oct . 2011 : Gazelle SHOW 2011 Gazelle SHOW 2011 ›
Gazelle experience center in Amersfoort 2011   More pictures available on:...
Featured
Bobike Child Front... Bobike Child Front Seat Mini Splash Colour Black
Price :
£ 76,23
GT85 Lubrication GT85 Lubrication
Price :
£ 4,99
38C-45C Bicycle Inner... 38C-45C  Bicycle Inner tube  Valve Auto/Shrader
Price :
£ 4,99

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 `cms_currency`.* FROM `cms_currency` WHERE (active=1) ORDER BY `priority` asc 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 (t.active=1) ORDER BY `t`.`priority` asc LIMIT 6 SELECT `cms_carousel`.* FROM `cms_carousel` WHERE (active=1) ORDER BY `priority` asc SELECT `di`.`id`, `c`.`title` FROM `cms_dict` AS `d` INNER JOIN `cms_dict_items` AS `di` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=di.id and c.controller='dictitems' and c.lang='en' WHERE (di.dict_id=d.id) AND (di.active=1) AND (d.active=1) AND (d.identifier='bikes-types') ORDER BY `di`.`priority` asc 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`.`genre`, `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 (t.featured=1) GROUP BY `t`.`id` ORDER BY rand() ASC LIMIT 3 SELECT `t`.`id`, `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_news` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='news' and c.lang='en' LEFT JOIN `cms_news_types` AS `nt` ON nt.news_id=t.id LEFT JOIN `cms_dict_items` AS `di` ON di.id=nt.dict_items_id WHERE (t.active=1) GROUP BY `t`.`id` ORDER BY `t`.`add_date` desc LIMIT 6