Promotion "Les Irresistibles" Cheminées et Poêles

 

Jusqu'au 2 Novembre 2019, profitez des conditions Irresistibles sur un large choix de :

 

- Poêles à bois et à poêles à pellets

 

- Foyers gaz et poêles à gaz

 

- Cheminées et inserts

 

Des conditions à découvrir en magasin !

 

Devis gratuit

 

  • (4.2960ms) SELECT * FROM parameter order by name asc
  • (0.8620ms) SELECT * FROM book WHERE id=5734 LIMIT 1
  • (0.7620ms) SELECT * FROM book_cat WHERE id=29 LIMIT 1
  • (0.5890ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
  • (0.5280ms) select * from menu WHERE type!='I' AND parentId=36 ORDER BY position ASC
  • (0.5600ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
  • (0.5470ms) select * from menu WHERE type!='I' AND parentId=56 ORDER BY position ASC
  • (0.5570ms) SELECT * FROM article WHERE code='COMMUNICATION' LIMIT 1
  • (0.4870ms) SELECT * FROM communication WHERE isAvailable=1 order by position ASC LIMIT 3
  • (0.9880ms) UPDATE communication SET hits=(hits+1) WHERE id=1
  • (0.6730ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
  • (0.5670ms) select * from menu WHERE type!='I' AND parentId=3 ORDER BY position ASC
  • (0.5590ms) select * from menu WHERE type!='I' AND parentId=4 ORDER BY position ASC
  • (0.7080ms) SELECT * FROM article WHERE code='FOOTER_TEXT' LIMIT 1