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 Findings

Findings

 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 = '29187' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
Round \\\'Forever Brilliant\\\' Moissanite - 57 facets
Round 'Forever Brilliant' Moissanite - 57 facets
(2 models to choose from)
Sqaure Princess cut \\\'Forever Brilliant\\\' Moissanite - 57 facets
Sqaure Princess cut 'Forever Brilliant' Moissanite - 57 facets
(4 models to choose from)
Marquise cut  \\\'Forever Brilliant\\\' Moissanite - 57 facets
Marquise cut 'Forever Brilliant' Moissanite - 57 facets
(2 models to choose from)
Cushion cut \\\'Forever Brilliant\\\' Moissanite - 81 facets
338293 - Cushion cut 'Forever Brilliant' Moissanite - 81 facets
Oval-cut \\\'Forever Brilliant\\\' Moissanite - 69 facets
338427 - Oval-cut 'Forever Brilliant' Moissanite - 69 facets
Octogan cut \\\'Forever Brilliant\\\' Moissanite - 53 facets
Octogan cut 'Forever Brilliant' Moissanite - 53 facets
(2 models to choose from)
Pear cut \\\'Forever Brilliant\\\' Moissanite - 71 facets
Pear cut 'Forever Brilliant' Moissanite - 71 facets
(4 models to choose from)
Triangle cut \\\'Forever Brilliant\\\' Moissanite - 37 facets
338160 - Triangle cut 'Forever Brilliant' Moissanite - 37 facets
Heart cut \\\'Forever Brilliant\\\' Moissanite - 56 facets
Heart cut 'Forever Brilliant' Moissanite - 56 facets
(3 models to choose from)
Scroll down to display the following items.
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