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 |  
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
F4367048 basaltgrau SFTN Techprofil
Konrad Hornschuch AG
F4367048 basaltgrau SFTN Techprofil
PLAIN range – SFTN fine sand embossing     A window...
F4565057 brillant weiss TP 60
Konrad Hornschuch AG
F4565057 brillant weiss TP 60
PLAIN range – TP 60 films       White window...
F4361014 Alux DB 703 Techprofil
Konrad Hornschuch AG
F4361014 Alux DB 703 Techprofil
Metallic Range – skai® Alux   So far, the new...
F4366003 anthrazitgrau SFTN matt Techprofil
Konrad Hornschuch AG
F4366003 anthrazitgrau SFTN matt Techprofil
PLAIN range – SFTN matt fine sand embossing     As in...
F4703004 woodec Turner Oak toffee //NEW
Konrad Hornschuch AG
F4703004 woodec Turner Oak toffee //NEW
Also new: Conti® woodec in Turner Oak Toffee   Our...
F4703001 woodec Turner Oak malt
Konrad Hornschuch AG
F4703001 woodec Turner Oak malt
Conti®  Woodec //NEW     genuine wood look like...
mattex
Konrad Hornschuch AG
mattex
Mattex: the mattest matte ever created   With Mattex, Continental...
F4361001 Metbrush aluminium Techprofil
Konrad Hornschuch AG
F4361001 Metbrush aluminium Techprofil
Metallic Range –  Conti®  Metbrush    ...
F4565053 altweiss TP 60
Konrad Hornschuch AG
F4565053 altweiss TP 60
PLAIN range – TP 60 films     White window profiles are...
F4362036 Staufereiche kolonial Techprofil
Konrad Hornschuch AG
F4362036 Staufereiche kolonial Techprofil
Classic range           Designs like...
F4363077 Newcastle Oak khaki Techprofil
Konrad Hornschuch AG
F4363077 Newcastle Oak khaki Techprofil
Life-like range     Thanks to a special effect pore, the...
F4362007 Montana Eiche tabak Techprofil
Konrad Hornschuch AG
F4362007 Montana Eiche tabak Techprofil
Classic range     Designs like Staufereiche colonial or...

« previous   | 1 | 2 | 3 |