SELECT DISTINCT(p.productID) as productID,p.categorieID,p.kortingID,p.leverID,p.titel,p.url,p.prijs,p.promoprijs,p.foto,p.nieuw,p.omschrijving, p.volgorde, p.doorlopend 
			FROM product p 
			INNER JOIN stock s ON s.productID = p.productID 
			INNER JOIN korting k ON k.id = p.kortingID 
			INNER JOIN merken m ON p.merkID = m.id 			
			INNER JOIN seizoen sz ON sz.seizoenID = p.seizoenID
			WHERE p.overzicht=1 AND p.merkID = '140' AND p.verwijderd=0 AND p.outlet=0 AND p.actief=1 AND s.verkocht=0  
			ORDER BY p.nieuw desc, p.doorlopend DESC, p.kortingID ASC, m.volgorde ASC, p.volgorde ASC

Kinderschoenen - Merken

Toon filter

Beberlis (14)

  • Veterschoen Goud Metallic
    NIEUW

    € 80,00

    Veterschoen Goud Metallic
  • Veterschoen Tressé Roze Leder
    NIEUW

    € 80,00

    Veterschoen Tressé Roze Leder
  • Schoen Gesp Tressé Roze Leder
    NIEUW

    € 76,00

    Schoen Gesp Tressé Roze Leder
  • Veterschoen Tressé Cognac Leder
    NIEUW

    € 80,00

    Veterschoen Tressé Cognac Leder
  • derby Goud Metallic
    NIEUW

    € 96,00

    derby Goud Metallic
  • derby Koper Metallic
    NIEUW

    € 96,00

    derby Koper Metallic
  • ballerina Goud Metallic
    NIEUW

    € 86,00

    ballerina Goud Metallic
  • ballerina Koper Metallic
    NIEUW

    € 80,00

    ballerina Koper Metallic
  • Sneaker Runner Beige Geel Roze Glitter Streep
    NIEUW

    € 88,00

    Sneaker Runner Beige Geel Roze Glitter Streep
  • Sneaker  Runner Roze Groen Lila Glitter Streep
    NIEUW

    € 88,00

    Sneaker Runner Roze Groen Lila Glitter Streep
  • Schoen Gesp Gouden Metallic
    DOORLOPEND

    € 75,00

    Schoen Gesp Gouden Metallic
  • Schoen Gesp Koper Metallic
    DOORLOPEND

    € 75,00

    Schoen Gesp Koper Metallic
  • Veterschoen Gouden Metallic
    DOORLOPEND

    € 96,00

    Veterschoen Gouden Metallic
  • Veterschoen rose
    DOORLOPEND

    € 96,00

    Veterschoen rose

Over Beberlis The company focuses on manufacturing products with first class materials, developing a large range of products which enables us to meet our clients´ requests. We design and manufacture our models with first class materials, since wearing good shoes is extremely important for your health and above all when children are growing, as it is essential for their physical development. Our entire production is located on our premises. This way, through rigorous controls, we can affirm that our product offers all the guarantees of MADE IN SPAIN footwear

© 2023 Raaf en Vos
Website by core-graphics.be and exsited.be
Close

Zoek in onze shop