Strona G��wna iPolska.info Maszyny i urządzenia Maszyny chłodnicze, klimatyzatory Klimatyzatory typu Split
Agregaty (24)Centrale sprężarkowe (2)Centrale wentylacyjne (4)Części i akcesoria maszyn chłodniczych (3)Klimakonwektory (2)Klimatyzatory typu Split (28)Komory (2)Komory chłodnicze (3)Lady witrynowe (3)Meble chłodnicze (2)Pojemniki (1)Regały (3)Sprężarki (0)
 
listaIkonka listaIkonka listaIkonka
Abis - Chłodnictwo, Klimatyzacja - Natryskowe Systemy Poliuretanowe
04-247 Warszawa, Chełmżyńska 10b 22 610 95 35
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381429 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
ALIAR
31-619 Kraków, Wawelska 16 507 300 360
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381491 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
AVICOLD
43-400 Cieszyn, Bielska 61c 33 856 74 44
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381372 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
Delta - Klimatyzacje
87-100 Toruń, Warszawska 4 668 292 720
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381288 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
An error occured in: Query: SELECT * FROM banner_zone WHERE bz_abr='C' An error occured in: Query: SELECT banner.b_id, b_weight, b_ext, b_name, b_url FROM banner, banner_state WHERE bz_id= AND (b_string_match='cat42052' OR b_string_match='') AND banner_state.st_id=0 AND banner_state.b_id=banner.b_id ORDER BY b_weight DESC An error occured in: Query: SELECT banner.b_id, b_weight, b_ext, b_name, b_url FROM banner, banner_state WHERE bz_id= AND (b_string_match='' OR b_string_match='') AND banner_state.st_id=0 AND banner_state.b_id=banner.b_id ORDER BY b_weight DESC
 
listaIkonka listaIkonka listaIkonka
Klimacold Montaż i Sprzedaż Klimatyzacji
43-608 Jaworzno, Sulinskiego 10 515 336 798
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381493 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
klimado
02-202 Warszawa, drawska 10 602 798 686
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381391 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
Klima Dragun
32-800 Brzesko, Wiejska 73 668 426 073
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381346 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
Klima Projekt
08-110 Siedlce, Akacjowa 18 505 832 552
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381495 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
Klima System Radosław Daniszewski
62-300 Września, Jeziorna 34 NOWY FOLWARK 609 448 626
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381445 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
 
listaIkonka listaIkonka listaIkonka
Klimatech - Roman Pikuła
66-400 Gorzów Wielkopolski, Czereśniowa 15 883 760 200
Bran�e: An error occured in: Query: SELECT ic.cat_id as idkategoria, cat_name as kategoria, cat_seo as cat_seo, ic.subcat_id as idpodkategoria, subcat.subcat_name as podkategoria, subcat.subcat_seo as subcat_seo, speccat.speccat_id as idspeckategoria, speccat.speccat_name as speckategoria, speccat.speccat_seo as speccat_seo, ics.cs_id FROM ip_card_cs ics, ip_category cat, ip_subcategory subcat, ip_cs ic LEFT JOIN ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id ) WHERE ics.cs_id=ic.cs_id AND ics.card_id=381470 AND ic.cat_id=cat.cat_id AND ic.subcat_id=subcat.subcat_id ORDER BY kategoria, podkategoria, speckategoria Zobacz wi�cej
«« « 1 2 3 » »»