Search Center

suppliers & accessories
profile systems
window accessories
door accessories
conservatories & facades accessories
semi-finished products
mounting material
chemicals & maintenance
services
software
ventilation
fire protection
windows
doors
facades & winter gardens
window coverings & gates
machines & surface processing
glass

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,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 = '18' OR (A.mcat4 & 1024)) AND (R.status = 1 AND (A.opisen !='' || A.nazwaen !='')) AND A.status = 1 ) AND (A.perms & 1) AND A.date_end >= NOW() AND A.date_start <= NOW() GROUP BY A.id ORDER BY R.xstatus DESC, R.pub_time ASC, (A.foto != '') DESC, A.akolej LIMIT 0, 21

HOPPE s.r.o.
HOPPE Quick-FitPlus
HOPPE Quick-FitPlus is the logical further development of the tried and...
TUNAL 75
EWTG KRZYSZTOF OSTROWSKI
TUNAL 75
Tunal 75ep ZR its termostatic ventylation system ( self regulating in...
KOENIG - SYSTEM NAPRAWY POWIERZCHNI
EWTG KRZYSZTOF OSTROWSKI
SURFACE REPAIR - KOENING
We offer komplete range of products from company Koening : - Correction...
TUNAL TOP
EWTG KRZYSZTOF OSTROWSKI
TUNAL TOP
Tunal Top ep-ZR ( dynamic and manual ) - it1`s a termic system of...
KLAMKI OKIENNE I DRZWIOWE
EWTG KRZYSZTOF OSTROWSKI
HANDLES FOR WINDOWS AND DOORS
We have in our offer few types of handles , starting from our models and...
MACO - OKUCIA DO OKIEN
EWTG KRZYSZTOF OSTROWSKI
MACO - HARDWARE FOR WINDOWS
We have in our offer full program of Maco products like : - TREND -...
NAWIEWNIK DO SKRZYNEK ROLETOWYCH TUNAL FIT ZR
EWTG KRZYSZTOF OSTROWSKI
VENTYLATION TO ROLLER SHUTTER BOX
Ventylator Tunal FIT ZR is used to decomprese roller shutter boxes but also...
OKUCIA SPECJALNE
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
Special hardware
Romb system includes hardware for differently shaped windows, for example:...
OKUCIE ROMB DYNAMIC
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
ROMB DYNAMIC hardware
New hardware, which emerged as a response to market demand, designed...
OKUCIE OBWODOWE ROMB
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
PERIPHERAL HARDWARE ROMB
PERIPHERAL HARDWARE ROMB – hardware system designed for PVC-U and...
ZAMKI DRZWIOWE ROMB
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
ROMB DOOR LOCKS
Depending on the location where the door joinery is applied, applicable...
ROMB DYNAMIC ALU
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
ROMB DYNAMIC ALU hardware
New hardware, which emerged as a response to market demand, designed...
OKUCIA ROMB ALU
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
ROMB ALU hardware
ROMB ALU hardware is used in order to close, turn and tilt sashes of...
ROMB ALU EURO
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
ROMB ALU EURO hardware
ROMB ALU EURO hardware is used in aluminium windows with V.01 groove (so...
ZAMYKACZ NAŚWIETLI TAKT-150
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
TAKT-150 FANLIGHT OPENER
Fanlight opener TAKT-150 is used in vertically mounted rectangular tilt...
INTERKOM KASOWY Z PĘTLĄ INDUKCYJNĄ DLA OSÓB NIEDOSŁYSZĄCYCH
KAS-SYSTEM sc Wiesław Bednarek, Adam Iwański
STOLCAD 12.4
SADOWSKI SOFTWARE
STOLCAD 12.4
  Stolcad® 12.4 is an established software trusted by a great...
STOLCAD PROFESSIONAL
SADOWSKI SOFTWARE
STOLCAD PROFESSIONAL
  Stolcad® Professional is a high-quality and innovative software...
DEALER MANAGER
SADOWSKI SOFTWARE
DEALER MANAGER
  Dealer Manager is software that supports an effective salesperson....

« previous   | 1 | 2 | 3 |