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

Steel findings

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 = '2' AND _articles.id_categorieB = '163' 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 0, 12
Steel clasps
From
5.40€ TTC - Steel clasps
(5 models to choose from)
Stainless steel clasps
From
1.98€ TTC - Stainless steel clasps
(5 models to choose from)
Stainless steel magnetic clasps
From
4.20€ TTC - Stainless steel magnetic clasps
(14 models to choose from)
Steel bolt rings
From
2.28€ TTC - Steel bolt rings
(3 models to choose from)
Stainless steel lobster trigger catches
From
2.46€ TTC - Stainless steel lobster trigger catches
(9 models to choose from)
Stainless steel ear backs
3.48€ TTC - Stainless steel ear backs
Stainless steel bayonet clasps
From
4.08€ TTC - Stainless steel bayonet clasps
(4 models to choose from)
Steel round magnetic clasps
From
7.32€ TTC - Steel round magnetic clasps
(2 models to choose from)
Stainless steel jump rings
From
2.40€ TTC - Stainless steel jump rings
(2 models to choose from)
Steel necklace ends with trigger clasp
From
3.96€ TTC - Steel necklace ends with trigger clasp
(4 models to choose from)
1

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.