FILTER
Glass flat glass       corner glass       double sided       three-sided glass       invertní rohové       průhledové rohové      
Flue diameter 150mm       180mm       200mm       250mm      
Extensible Pulling up Door System       Normal Side opening Door      
length logs 40cm       45cm       50cm       55cm       60cm       65cm       95cm       100cm      

Number of selected products: 113


Fireplace inserts AIR - double sided   



 BeF Double 6 Feel NEW

BeF Double 6 Feel

Nominal heat output:5 kW
Efficiency:84%
 BeF Double 6 N Feel NEW

BeF Double 6 N Feel

Nominal heat output:5 kW
Efficiency:84%
 BeF Double 7 Feel NEW

BeF Double 7 Feel

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Double 7 N Feel NEW

BeF Double 7 N Feel

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Double V 6 Feel NEW

BeF Double V 6 Feel

Nominal heat output:5 kW
Efficiency:84%
 BeF Double V 6 N Feel NEW

BeF Double V 6 N Feel

Nominal heat output:5 kW
Efficiency:84%
 BeF Double V 7 Feel NEW

BeF Double V 7 Feel

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Double V 7 N Feel NEW

BeF Double V 7 N Feel

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Feel 6 NEW

BeF Feel 6

Nominal heat output:5 kW
Efficiency:84%
 BeF Feel 6 C NEW

BeF Feel 6 C

Nominal heat output:5 kW
Efficiency:84%
 BeF Feel 6 CL NEW

BeF Feel 6 CL

Nominal heat output:5 kW
Efficiency:84%
 BeF Feel 6 CP NEW

BeF Feel 6 CP

Nominal heat output:5 kW
Efficiency:84%
 BeF Feel 7 NEW

BeF Feel 7

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Feel 7 CL NEW

BeF Feel 7 CL

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Feel 7 CP NEW

BeF Feel 7 CP

Nominal heat output:7 kW
Efficiency:82,2%
 BeF Feel 8 NEW

BeF Feel 8

Nominal heat output:8 kW
Efficiency:85%



DB/SQL chyba v souboru: en
Chyba:
 V dotazu ang.ptype_id,
                           lang.ptype_name,
                           lang.ptype_custom_name,
                           lang.ptype_name_seo,
                           lang.ptype_short_desc,
                           cz.ptype_product_line,
                           cz.ptype_voda
                    FROM en_product_types AS lang JOIN cz_product_types AS cz
                           ON cz.ptype_id = lang.ptype_id
                     WHERE lang.ptype_display = '1'
                       AND cz.ptype_product_line = '2'
                    ORDER BY cz.ptype_poradi, lang.ptype_name

Popis: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '??' at line 1


DB/SQL chyba v souboru: en
Chyba:
 V dotazu ang.ptype_id,
                           lang.ptype_name,
                           lang.ptype_custom_name,
                           lang.ptype_name_seo,
                           lang.ptype_short_desc,
                           cz.ptype_product_line,
                           cz.ptype_voda
                    FROM en_product_types AS lang JOIN cz_product_types AS cz
                           ON cz.ptype_id = lang.ptype_id
                     WHERE lang.ptype_display = '1'
                       AND cz.ptype_product_line = '1'
                    ORDER BY cz.ptype_poradi, lang.ptype_name

Popis: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '??' at line 1


DB/SQL chyba v souboru: en
Chyba:
 V dotazu ang.ptype_id,
                           lang.ptype_name,
                           lang.ptype_custom_name,
                           lang.ptype_name_seo,
                           lang.ptype_short_desc,
                           cz.ptype_product_line,
                           cz.ptype_voda
                    FROM en_product_types AS lang JOIN cz_product_types AS cz
                           ON cz.ptype_id = lang.ptype_id
                     WHERE lang.ptype_display = '1'
                       AND cz.ptype_product_line = '3'
                    ORDER BY cz.ptype_poradi, lang.ptype_name

Popis: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '??' at line 1


DB/SQL chyba v souboru: en
Chyba:
 V dotazu ang.ptype_id,
                           lang.ptype_name,
                           lang.ptype_custom_name,
                           lang.ptype_name_seo,
                           lang.ptype_short_desc,
                           cz.ptype_product_line,
                           cz.ptype_voda
                    FROM en_product_types AS lang JOIN cz_product_types AS cz
                           ON cz.ptype_id = lang.ptype_id
                     WHERE lang.ptype_display = '1'
                       AND cz.ptype_product_line = '5'
                    ORDER BY cz.ptype_poradi, lang.ptype_name

Popis: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '??' at line 1