Search Center

machines & surface processing
machines
tools & manufacturing logistics
machines & services
surface treatment
coating technologies
profile wrapping technologies
surface treatment services
industrial halls
windows
doors
suppliers & accessories
facades & winter gardens
window coverings & gates
glass
assembly

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 |  
SELECT SQL_CALC_FOUND_ROWS A.* ,R.logo as R_logo,R.nazwa as R_nazwa,R.id as R_id,R.xstatus as R_xstatus,R.symbol as R_symbol,R.status as R_status,R.woj as R_woj,R.opis as R_opis , Z.woj as Z_woj, Z.powiat as Z_powiat, A.opisen as opis,RAND() random,0 as __search_priority FROM act_base_asortyment as A LEFT JOIN act_base_firmy as R ON R.id = A.firma LEFT JOIN act_base_siec as Z ON R.id = Z.firma AND Z.status = 1 WHERE ((A.menu_id = '602' OR (A.mcat9 & 32768)) AND (R.status = 1 AND A.hide = 0 AND R.xstatus >= 1) AND A.status = 1 ) AND (A.perms & 1) AND A.lang & 4 AND A.date_end >= NOW() AND A.date_start <= NOW() GROUP BY A.id ORDER BY R.xstatus DESC, (A.foto != '') DESC, random, R.pub_time DESC, A.akolej LIMIT 0, 21
F4703001 woodec Turner Oak malt
Konrad Hornschuch AG
F4703001 woodec Turner Oak malt
Conti®  Woodec //NEW     genuine wood look like...
Zowo-plast® 1120
Berger-Zobel GmbH  Coating Systems
Zowo-plast® 1120
Zowo-plast® 1120 Hydro-Cleaner  ...
F4703002 woodec Sheffield Oak alpine
Konrad Hornschuch AG
F4703002 woodec Sheffield Oak alpine
Conti®  Woodec //NEW Genuine wood look like never before...
F4361012 Alux anthrazit Techprofil
Konrad Hornschuch AG
F4361012 Alux anthrazit Techprofil
Metallic Range –  Conti®  Alux   So far,...
Zowo-plast®1490
Berger-Zobel GmbH  Coating Systems
Zowo-plast®1490
Zowo-plast®1490 1C-PUR PVC-Single-Layer-Textured Coating...
Zowo-tec® 200
Berger-Zobel GmbH  Coating Systems
Zowo-tec® 200
Zowo-tec® 200 Glazing Primer even spreading for...
Zowo-plast®1480
Berger-Zobel GmbH  Coating Systems
Zowo-plast®1480
Zowo-plast®1480 1C-PUR PVC-Metallic-Single-Layer Coating...
F4367048 basaltgrau SFTN Techprofil
Konrad Hornschuch AG
F4367048 basaltgrau SFTN Techprofil
PLAIN range – SFTN fine sand embossing     A window...
Zowo-tec® 430
Berger-Zobel GmbH  Coating Systems
Zowo-tec® 430
Zowo-tec® 430 Wood-Aluminum Clear Coat the...
F4363077 Newcastle Oak khaki Techprofil
Konrad Hornschuch AG
F4363077 Newcastle Oak khaki Techprofil
Life-like range     Thanks to a special effect pore, the...
Zowo-tec® 420
Berger-Zobel GmbH  Coating Systems
Zowo-tec® 420
Zowo-tec® 420 Thick-layered Glaze outstanding transparency and...
F4703003 woodec Sheffield Oak concrete
Konrad Hornschuch AG
F4703003 woodec Sheffield Oak concrete
Conti®  Woodec //NEW Genuine wood look like never before...
F4361001 Metbrush aluminium Techprofil
Konrad Hornschuch AG
F4361001 Metbrush aluminium Techprofil
Metallic Range –  Conti®  Metbrush    ...
Środek czyszczący 5101
Berger-Zobel GmbH  Coating Systems
ZOBEL Cleaner 5101
ZOBEL Cleaner 5101 for coated wood and plastic surfaces...
F4362007 Montana Eiche tabak Techprofil
Konrad Hornschuch AG
F4362007 Montana Eiche tabak Techprofil
Classic range     Designs like Staufereiche colonial or...
Zowo-tec 485
Berger-Zobel GmbH  Coating Systems
Zowo-tec 485
Zowo-tec® 485   Top Coat white RAL 9016 or...

« previous   | 1 | 2 | 3 | 4 |