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
F4361012 Alux anthrazit Techprofil
Konrad Hornschuch AG
F4361012 Alux anthrazit Techprofil
Metallic Range –  Conti®  Alux   So far,...
F4366003 anthrazitgrau SFTN matt Techprofil
Konrad Hornschuch AG
F4366003 anthrazitgrau SFTN matt Techprofil
PLAIN range – SFTN matt fine sand embossing     As in...
F4362075 Eiche mocca Techprofil
Konrad Hornschuch AG
F4362075 Eiche mocca Techprofil
Classic range   Designs like Staufereiche colonial or Sapele have...

Konrad Hornschuch AG
F4701031 Conti® mattex Shine grey aluminium
The attractive matt-sandy surface of Conti® mattex significantly enhances...

Konrad Hornschuch AG
F4703007 Conti® woodec Tropea Oak coffee
Conti® woodec is the result of a development process that has formulated...
F4703002 woodec Sheffield Oak alpine
Konrad Hornschuch AG
F4703002 woodec Sheffield Oak alpine
Conti®  Woodec //NEW Genuine wood look like never before...

Konrad Hornschuch AG
F4701028 Conti® mattex Shine beige
The attractive matt-sandy surface of Conti® mattex significantly enhances...
F4565053 altweiss TP 60
Konrad Hornschuch AG
F4565053 altweiss TP 60
PLAIN range – TP 60 films     White window profiles are...
F4362002 Sapeli Techprofil
Konrad Hornschuch AG
Classic range     Designs like Staufereiche colonial or...
F4703001 woodec Turner Oak malt
Konrad Hornschuch AG
F4703001 woodec Turner Oak malt
Conti®  Woodec //NEW     genuine wood look like...
Conti® techprofil cool colors plus
Konrad Hornschuch AG
Conti® techprofil cool colors plus
  skai® cool colors plus   A further development of...
F4565015 beige TP 60
Konrad Hornschuch AG
F4565015 beige TP 60
PLAIN range – TP 60 films     White window profiles...

Konrad Hornschuch AG
F4701033 Conti® mattex Shine dark graphite
The attractive matt-sandy surface of Conti® mattex significantly enhances...

« previous   | 1 | 2 | 3 | 4 |