En poursuivant votre navigation, vous acceptez l'utilisation de cookies destinés à améliorer la performance de ce site et à vous proposer des services et contenus personnalisés. Pour en savoir plus ou modifier vos paramètres cliquez ici.
Recherche Laval Europe
Specialist supplier accompanying Clockmakers and Jewellers for four generations
 All our products
Home Good deals Accessories

Bargain accessories

 See description
SELECT SQL_CALC_FOUND_ROWS _articles.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', _articles.reference,_articles.id_categorieA,_articles.id_categorieB,_articles.id_categorieC,_articles.selection FROM _articles INNER JOIN _prix on _articles.id_article = _prix.id_article WHERE _articles.uk = '1' AND _prix.actif = '1' AND ( (_prix.stock > 0 ) OR (_prix.stock = 0 AND sstitre1_uk != '')) AND ( _prix.indispo = 0 OR (_prix.indispo = 1 AND _prix.indispo_date BETWEEN CURDATE() AND ADDDATE(CURDATE(), INTERVAL 15 DAY)) ) AND _articles.id_categorieA = '23' AND _articles.id_categorieB = '28533' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
Hand embroidered black goat skin tablet carry case
717884 - Hand embroidered black goat skin tablet carry case
Hand embroidered beige goat skin tablet carry case
717883 - Hand embroidered beige goat skin tablet carry case
Hand embroidered white goat skin tablet carry case
717882 - Hand embroidered white goat skin tablet carry case
Hand embroidered red goat skin tablet carry case
717880 - Hand embroidered red goat skin tablet carry case
1

Newsletter

Sign up and stay up to date with our news, special offers and new arrivals...

Specialist supplier accompanying clockmakers and jewellers for four generations

Terms and Conditions - Legal notices