• Livraison France & Belgique exclusivement
  • Livraison offerte dès 40€ d'achats
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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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

Story - Camion de Pompiers Géant (bois)

Pour les petits fans de pompiers, voici un grand camion de pompiers en bois ! Il est équipé d'une lance à incendie et d'une échelle télescopique et rotative....
Lire la suite

35,50 €

Voir les modes de livraison

En stock

Ajouter à ma wishlist Retirer de ma wishlist

Description

Pour les petits fans de pompiers, voici un grand camion de pompiers en bois ! Il est équipé d'une lance à incendie et d'une échelle télescopique et rotative. Contient : 4 pompiers de la gamme Story.

Infos produit

Dimensions 40 x 7,5 x 12,6 cm
Matière Bois (pin)
Genre Garçon
Imprimer la fiche

Découvrez aussi

Ajouter à ma wishlist Retirer de ma wishlist
Camion de Pompiers (bois)
Camion de Pompiers (bois)
Pour les petits fans de pompiers et de bricolage, voici le cadeau idéal ! Ce jouet 2 en 1 est à la fois un jeu de construction et un camion de pompier à promener grâce à son cordon. Grâce à des écrous, des plaques et des vis qu'il faut assembler, l'enfant pourra reconstituer un beau camion de pompiers. Il pourra ensuite s'amuser à traîner son camion et développera ainsi sa motricité. Ce camion est robuste grâce aux axes des roues en métal et aux roues en plastique. Contient : 27 pièces dont 2 outils et 3 pompiers.
30,99 €
En stock
Ajouter à ma wishlist Retirer de ma wishlist
Story Box Pompiers (bois)
Story Box Pompiers (bois)
Vite, au feu au feu ! Plonge dans l'univers passionnant des pompiers avec ses camions, hélicoptère, chien de sauvetage . . . ! Comprend des personnages et de nombreux accessoires pour se raconter des tas d'histoires et se familiariser avec le monde des pompiers. Contient : 15 pièces en bois. Jolie boîte en forme de caserne pour compléter le décor.
28,99 €
En stock
Ajouter à ma wishlist Retirer de ma wishlist
Caserne de Pompiers (bois)
Caserne de Pompiers (bois)
Pin pon, pin pon ! Sortez les tuyaus et la grande échelle, un feu s'est déclaré ! Voilà une grande caserne de pompiers en bois prête à satisfaire tous les petits fans de pompiers et leurs histoires incroyables ! Sur 3 niveaux, cette caserne est équipée d'un ascenceur manuel et d'une piste d'atterissage pour hélicoptère ! Elle comprend 10 accessoires en bois pour recréer la vraie vie des pompiers en action ! La caserne contient 10 accessoires : 2 voitures, 1 hélicoptère, 1 échelle, 1 feu tricolore, 1 borne incendie, 1 feu et 3 pompiers.
69,99 €
En stock