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
  | 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,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 20, 21

HOPPE s.r.o.
HOPPE Quick-FitPlus
HOPPE Quick-FitPlus is the logical further development of the tried and...
ISO³-SYSTEM USZCZELNIEŃ ELEWACJI
ISO-Chemie GmbH
ISO³-FACADE SEALING SYSTEM
The product range for extreme demands The product range for extreme...
ISOM-SYSTEM USZCZELNIEŃ W BUDOWNICTWIE METALOWYM
ISO-Chemie GmbH
ISOM-METAL BUILDING SEALING SYSTEM
All-round protection for joints in lightweight metal construction Joints...
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...
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...
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...
MACO - OKUCIA DO OKIEN
EWTG KRZYSZTOF OSTROWSKI
MACO - HARDWARE FOR WINDOWS
We have in our offer full program of Maco products like : - TREND -...
TUNAL 75
EWTG KRZYSZTOF OSTROWSKI
TUNAL 75
Tunal 75ep ZR its termostatic ventylation system ( self regulating in...
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...
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...
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...
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:...
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...
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...
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...
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...
INTERKOM KASOWY Z PĘTLĄ INDUKCYJNĄ DLA OSÓB NIEDOSŁYSZĄCYCH
KAS-SYSTEM sc Wiesław Bednarek, Adam Iwański

  | 1 | 2 | 3 | 4 |