Search Center

wooden
PVC
aluminium
steel

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 | 5 | . . . . | 44 |  
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 = '488' OR (A.mcat6 & 536870912)) 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

EKO-OKNA S.A.
Ferroline
An ideal solution for the renewal of historic buildings. The Ferroline...
Centrum obróbkowe do produkcji okien, drzwi i fasad RUMBA INOX
LGF CNC MASZYNY
RUMBA INOX - CNC Machining center
RUMBA INOX - CNC Machining center Floor-type vertical spindle machining...

ABAKUS OKNA S.A.
MB-104
The MB-104 Passive is a thermal break-equipped window & door system that...
Moduł Z-TS/G-TS
MACO POLSKA Sp. z o.o.
Z-TS/G-TS module
The Z-TS/G-TS MACO PROTECT module meets a wide range of requirements....
PRASA HYDRAULICZNA DO PRODUKCJI PŁYT WARSTWOWYCH DO DRZWI I BRAM
LGF CNC MASZYNY
HOT PRESSES FOR POLYURETHANE
Hot press for processing polyurethane. Different versions and sizes are...
Piła tarczowa automatyczna do cięcia profili alu - model: AUTOCUT 500
LGF CNC MASZYNY
Automatic sawing machine AUTOCUT 500
Automatic sawing machine with automatic feeding for cutting at 90°....
Drzwi MB-70
DRUTEX S.A.
MB-70
The modern and resistant aluminum doors that represent elegant design and...
MB-SR50N HI+  ściana słupowo-ryglowa o wysokiej izolacyjności termicznej
ALUPROF S.A.
MB-SR50N HI+
The MB-SR50N HI+ mullion and transom façade system has been designed...

« previous   | 1 | 2 | 3 | 4 | 5 | . . . . | 44 |