• Consegne solo in Francia/Belgio
  • Scopri il nostro nuovo sito web !
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 15)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 15)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 16)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 16)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 20)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 20)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 18)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 18)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 14)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 14)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 19)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 19)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 17)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 17)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 13)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=9 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 13)) ORDER BY id_feature_value
Ajouter à ma wishlist

Vous devez avoir un compte pour pouvoir utiliser cette fonctionnalité.

Connexion Inscription

Bikloon Casco per Bici Rosa

Draisine e accessori

Ref. J03272

Taglia S : girotesta regolabile da 47 a 54 cm (tramite rotella), imbottiture in schiuma rimovibili, 11 fori di ventilazione, 3 punti di regolazione.
Leggi il seguito

Please wait ...

Giocattoli colorati e originali, progettati per contribuire allo sviluppo del bambino tramite il gioco.

Si prega di notare che al momento questo sito web consegna solo in Francia e in Belgio.

altre versioni disponibili
Bikloon Casco per Bici Rosso Bikloon Casco per Bici Rosso
Bikloon Casco per Bici Blu Bikloon Casco per Bici Blu
Casco Personalizzabile Casco Personalizzabile

Descrizione

Taglia S : girotesta regolabile da 47 a 54 cm (tramite rotella), imbottiture in schiuma rimovibili, 11 fori di ventilazione, 3 punti di regolazione.

Scheda tecnica

Dimensioni 25 x 20 x 15,5 cm
Materiale Guscio interno: polistirene espanso. Guscio esterno: policarbonato. Schiuma: poliuretano. Cinghie: poliestere.
Genere Femmina
Stampa la scheda

Scopri anche

Add this product to my list of favorites. Remove this product from my favorite's list.
product
Bikloon Casco per Bici Rosso
Taglia S : girotesta regolabile da 47 a 54 cm (tramite rotella), imbottiture in schiuma rimovibili, 11 fori di ventilazione, 3 punti di regolazione.
Add this product to my list of favorites. Remove this product from my favorite's list.
product
Bikloon Rossa/Bianca (legno)
Vera bicicletta senza pedali in legno, ideale per imparare a stare in equilibrio e ad andare in bicicletta più facilmente senza le rotelle. Pneumatici gonfiabili. Sella regolabile in altezza. Sedile ultra confortevole. Portata massima : 30 kg.
Add this product to my list of favorites. Remove this product from my favorite's list.
product
Bikloon Casco per Bici Blu
Taglia S : girotesta regolabile da 47 a 54 cm (tramite rotella), imbottiture in schiuma rimovibili, 11 fori di ventilazione, 3 punti di regolazione.
Add this product to my list of favorites. Remove this product from my favorite's list.
product
  • Nuovo
Casco Personalizzabile
Casco personalizzabile con gli adesivi della bici senza pedali J03276. Taglia S : girotesta regolabile da 47 a 54 cm (tramite rotella), imbottiture in schiuma rimovibili, 11 fori di ventilazione, 3 punti di regolazione.