FIREPLACE LAURUS K6261

Caractéristiques :

- Système "Comfort control"

- Hotte d'accumulation en option

- Ecodesign 2022

- Flamme verte

- Classe énergétique : A+

FIREPLACE

Faites votre demande de devis ou de renseignement directement ici...

Notre équipe vous recontactera très rapidement et vous aidera à évaluer votre projet au plus près de votre budget

Retour

(4.4290ms) SELECT * FROM parameter order by name asc
(0.9410ms) SELECT * FROM product WHERE id=1395 LIMIT 1
(0.8100ms) SELECT * FROM product_vendor WHERE id=28 LIMIT 1
(0.6150ms) SELECT * FROM article WHERE code='PRODUCT_DETAIL' LIMIT 1
(0.8990ms) SELECT * FROM product_cat WHERE id=1 LIMIT 1
(0.8700ms) SELECT * FROM product_cat WHERE id=14 LIMIT 1
(0.5900ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
(0.6150ms) select * from menu WHERE type!='I' AND parentId=36 ORDER BY position ASC
(0.6360ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
(0.5860ms) select * from menu WHERE type!='I' AND parentId=56 ORDER BY position ASC
(0.9470ms) SELECT * FROM article WHERE code='COMMUNICATION' LIMIT 1
(0.6650ms) SELECT * FROM communication WHERE isAvailable=1 order by position ASC LIMIT 12
(0.6760ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
(0.7020ms) select * from menu WHERE type!='I' AND parentId=3 ORDER BY position ASC
(0.5750ms) select * from menu WHERE type!='I' AND parentId=4 ORDER BY position ASC
(0.8330ms) SELECT * FROM article WHERE code='FOOTER_TEXT' LIMIT 1