Accessoires de cheminées et poêles

 

Retrouvez des centaines de références produits dans les catalogues Reignoux et Atelier dix-neuf : serviteurs, plaques en fontes, chenets, stockages de bois, pare-feu, pierre à feu, soufflets...

N'hésitez pas aussi à visiter notre magasin à Grasse pour y découvrir de nombreux accessoires ou idées cadeaux utiles et déco !

  • (8.8610ms) SELECT * FROM parameter order by name asc
  • (0.8910ms) SELECT * FROM book_cat WHERE id=58 LIMIT 1
  • (0.7850ms) select * from book_cat WHERE parentId=58 AND isAvailable=1 ORDER BY position ASC, name DESC
  • (0.7420ms) select count(*) as counter from book WHERE bookCatId=58 AND isAvailable=1 ORDER BY id desc
  • (1.1140ms) select * from book WHERE bookCatId=58 AND isAvailable=1 ORDER BY position ASC, name DESC LIMIT 0,100
  • (1.0030ms) SELECT * FROM book_cat WHERE id=58 LIMIT 1
  • (1.0200ms) SELECT * FROM book_cat WHERE id=48 LIMIT 1
  • (0.9470ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
  • (1.2790ms) select * from menu WHERE type!='I' AND parentId=27 ORDER BY position ASC
  • (0.9390ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
  • (0.8400ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
  • (0.7570ms) select * from menu WHERE type!='I' AND parentId=3 ORDER BY position ASC
  • (0.6480ms) select * from menu WHERE type!='I' AND parentId=4 ORDER BY position ASC
  • (0.6520ms) SELECT * FROM article WHERE code='FOOTER_TEXT' LIMIT 1