• Mon caddie
  • My account
  •  
Minimum order: €50 incl. VAT (without postage and packaging fees)
  • Mon caddie
  • My account
  •  
  • FR
 Refine my search

Ear and nose piercing

SELECT SQL_CALC_FOUND_ROWS _prix.id_article,_articles.uk, IFNULL( _articles.titre_uk , IFNULL( _articles.titre_uk, _articles.titre_fr )) AS 'titre_uk', IF( _articles.titre_uk IS NULL , IF( _articles.titre_uk IS NULL , 'fr' , 'uk'), 'uk' ) AS 'titre_langue', _prix.ref_prix as 'reference', _articles.id_categorieA, _articles.id_categorieB, _articles.id_categorieC, _articles.selection , _prix.id_article, Tri_Caract.Nom_fr FROM _articles INNER JOIN _prix on _articles.id_article = _prix.id_article INNER JOIN Tri_Trieur on _prix.id_prix = Tri_Trieur.ID_Prix LEFT OUTER JOIN Tri_Caract on Tri_Caract.ID_Caract = Tri_Trieur.ID_Caract3 WHERE _articles.uk = '1' AND _prix.actif = '1' AND ( (_prix.stock > 0 ) ) AND ( (_prix.indispo = 0 ) OR ( _prix.indispo = 1 AND _prix.indispo_date < ADDDATE(_prix.indispo_date, INTERVAL 7 DAY) ) ) AND _prix.SE = 1 AND _articles.id_categorieA = '14' GROUP BY Tri_Trieur.id_article, Tri_Trieur.id_article, Tri_Trieur.ID_Caract3 ORDER BY _prix.date_miseenligne DESC, _articles.ordre, _articles.id_article DESC LIMIT 120, 12
Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
From
2.28€ TTC - Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
(25 models to choose from)
Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
From
2.28€ TTC - Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
(25 models to choose from)
Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
From
2.28€ TTC - Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
(25 models to choose from)
Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
From
2.28€ TTC - Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
(25 models to choose from)
Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
From
2.28€ TTC - Caflon Blu gold coloured steel ear piercing studs with bezel set birthstone crystal
(25 models to choose from)
Caflon Blu solid ear piercing studs in steel gilded with fine gold
From
1.80€ TTC - Caflon Blu solid ear piercing studs in steel gilded with fine gold
(2 models to choose from)
Caflon Blu heart shaped piercing studs in steel gilded with fine gold
From
2.28€ TTC - Caflon Blu heart shaped piercing studs in steel gilded with fine gold
(2 models to choose from)
Caflon Blu flower shaped piercing studs in steel gilded with fine gold
2.28€ TTC - Caflon Blu flower shaped piercing studs in steel gilded with fine gold
Caflon Blu gold coloured stainless steel piercing studs with rock crystal coloured stone
2.28€ TTC - Caflon Blu gold coloured stainless steel piercing studs with rock crystal coloured stone
Caflon Blu gold coloured stainless steel ear piercing studs with black diamond coloured crystal
2.28€ TTC - Caflon Blu gold coloured stainless steel ear piercing studs with black diamond coloured crystal
Caflon Blu star shaped piercing studs in stainless steel
2.28€ TTC - Caflon Blu star shaped piercing studs in stainless steel
Caflon Blu cabochon piercing studs in stainless steel and black onyx
2.28€ TTC - Caflon Blu cabochon piercing studs in stainless steel and black onyx

Selfor logo

OUR STORES :

SELFOR, 20 rue Réaumur, 75003 Paris
01 42 78 06 66 -  selfor@selforparis.com

SELFOR +, 11 rue Réaumur, 75003 Paris
01 42 74 11 76 - selforplus@selforparis.com

SELFOR Décor, 19 rue Réaumur, 75003 Paris
01 42 74 48 08 - selfordecor@selforparis.com

 

 

INFORMATION

100% secure payment
Terms and conditions
Legal notices

 

MY PROFILE

Open an account
Log in
My orders
My basket

 

FIND US

Facebook

Instagram

Pinterest

Youtube

 

NEWSLETTER

Sign up and stay up to date with our new products and great deals! 

OK

Delivery
France, Luxembourg, Belgium: Delivery in 48/72 hrs - Other countries: 2 to 5 days according to destination.
Some items may take longer to be delivered.