Search

search

Login »
New Account »

Shopping Cart
your cart is empty

Happy Gazelle Owners

Workshop

Contact us

Categories

FAQ

Bicycles

Accessories

Baskets

Bells

Lubricants and maintenance

Tubes

Carrier

Chain case

Child seats

Computers

Crate

Dress guards

Bottles

Lights

Locks

Panniers

Pedals

Pumps

Saddles

Straps

Tires

Tools

Components

SACHS Parts

Bike tray racks

About Gazelle

Mini Micro Scooters

Contact

	info@popiel.co.uk
	02034415298
	SKYPE : POPIEL.co.uk

Hamax PLUS Premium Carrier with 5 LED Rear Light Luggage Strap and Pump

‹ back

HOME  ›  Accessories  ›  Child seats  › 

Hamax PLUS Premium Carrier with 5 LED Rear Light Luggage Strap and Pump

Producer
Item number	HPLPC
Delivery week	in stock
Ordering
Quantity	1 2 3 4 5 6 7 8 9 10
Add to Cart »
Price : £ 67,93

Description

Hamax PLUS Premium Carrier with 5 LED Rear Light Luggage Strap and Pump strap colours vary

Shop Brands About us Dutch bike hire Why our bicycles ?

Orders Returns How to buy Terms and conditions Postage And Delivery

Informations FAQ Specials New products

My account Login New Account Forgot Your Password?

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`.`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`.`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`, `c`.`title`, `c`.`description`, `c`.`specification`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_products` AS `t` LEFT JOIN `cms_products_desc` AS `c` ON c.products_id=t.id and c.lang='en' WHERE (c.niceurl='hamax-plus-premium-carrier-with-5-led-rear-light-luggage-strap-and-pump') AND (t.active=1) SELECT `f`.`id`, `f`.`add_date`, `f`.`file_name`, `f`.`file_size`, `f`.`file_ext`, `f`.`priority`, `f`.`active`, `c`.`title`, `c`.`description` FROM `cms_files_to_controllers` AS `ftc` INNER JOIN `cms_files` AS `f` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=f.id and c.controller='files' and c.lang='en' WHERE (f.id=ftc.id_files) AND (ftc.controller='products') AND (ftc.controller_item_id='220') AND (f.active=1) ORDER BY `f`.`priority` ASC UPDATE `cms_content` SET `visits` = visits+1 WHERE (controller_item_id = '220') AND (controller = 'products') AND (lang = 'en') 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.id='18') AND (t.active=1) SELECT `pc`.*, `c`.`niceurl`, `c`.`title` FROM `cms_products_categories` AS `pc` INNER JOIN `cms_products_to_categories` AS `ptc` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=pc.id and c.controller='productscategories' and c.lang='en' WHERE (ptc.products_id='220') AND (pc.id=ptc.products_categories_id) SELECT `t`.`id`, `t`.`file`, `t`.`template`, `t`.`parent_id`, `t`.`priority`, `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 `p`.`id`, `p`.`file`, `p`.`price`, `p`.`last_price`, `c`.`title`, `c`.`niceurl` FROM `cms_products` AS `p` INNER JOIN `cms_products_to_categories` AS `ptc` LEFT JOIN `cms_products_desc` AS `c` ON c.products_id=p.id and c.lang='en' WHERE (ptc.products_categories_id='59') AND (p.id=ptc.products_id) AND (p.active=1) ORDER BY `ptc`.`priority` asc, `p`.`price` desc, `p`.`add_date` desc SELECT `t`.*, `ag`.`required`, `c`.`title` AS `attributesTitle`, `cc`.`title` AS `groupsTitle`, `cc`.`id` AS `groupsId` FROM `cms_products_to_attributes` AS `t` INNER JOIN `cms_attributes` AS `a` INNER JOIN `cms_attributes_groups` AS `ag` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=a.id and c.controller='attributes' and c.lang='en' LEFT JOIN `cms_content` AS `cc` ON cc.controller_item_id=ag.id and cc.controller='attributesgroups' and cc.lang='en' WHERE (a.id=t.attributes_id) AND (a.attributes_groups_id=ag.id) AND (a.active=1) AND (ag.active=1) AND (t.products_id='220') ORDER BY `ag`.`priority` asc, `a`.`priority` asc SELECT `di`.`id`, `di`.`file`, `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='products-options') ORDER BY `di`.`priority` asc SELECT `cms_products_to_parameters`.* FROM `cms_products_to_parameters` WHERE (products_id=220)