SELECT DISTINCT `p`.`id`, `pt`.`nombre`, `pt`.`descripcion`, `pt`.`descripcion` FROM `producto` AS `p` INNER JOIN `linea` AS `l` ON p.linea_id = l.id INNER JOIN `producto_translation` AS `pt` ON p.id = pt.producto_id INNER JOIN `language` AS `lang` ON pt.language_id = lang.id WHERE (p.id=78 AND p.activo=1 AND lcase(l.min)='aire' AND lang.prefijo='en')
Fireplaces

Corner fireplace with door
ESTELA
ALEXANDRA
ELBIA

Frontal fireplace with door
BARBARA 120
BARBARA 90
AITANA
ALBA 60
D-9
D-7
D-8

Central fireplace with door
GISELLE 80
GISELLE 100
GALA

Alternative fireplace with door
D-4 80
ARIANE
D-5

Air modules

G Series Normal two-sided
INSERTABLE MODULE G-30 DC

G Series Conventional frontal
INSERTABLE MODULE G-30 F
INSERTABLE MODULE G-35 F
INSERTABLE MODULE G-40 F

G Series Horizontal frontal
INSERTABLE MODULE G-45 F
INSERTABLE MODULE G-50 F

G Series Horizontal side-opening
INSERTABLE MODULE G-45 LD/LI

G Series Horizontal two-sided
INSERTABLE MODULE G-45 DC
INSERTABLE MODULE G-50 DC

G Series Normal side-opening
INSERTABLE MODULE G-30 LD/LI

G Series Horizontal corner
INSERTABLE MODULE G-50 R

Insert
LAVEL 65 INSERT
LAVEL 70 INSERT
LAVEL 80 INSERT
GARHO INSERT
INSERT RCR 65
INSERT RCR 70
INSERT RCR 80
INSERT RCR 70 Cónico
INSERT RCR 100
INSERT RCR 70 LD/LI
INSERT RCR 70 TC

Water modules

Termogar
Termogar for open water circuit L-N70A
Termogar for closed water circuit L-N70C

Stoves
HABIT
HABIT TC

Barbecues
TRADITIONAL SYSTEM
ARGENTINIAN SYSTEM
FORNELLS INDOOR
FORNELLS OUTDOOR
PALMA 60 PORCH
PALMA 60 GARDEN
PALMA 75 PORCH
PALMA 75 GARDEN
PLEK 66
PLEK 66 BASIC

Raval de Sant Antoni, 2 08540 Centelles Barcelona T +34 93 881 24 51 Legal notices