Search Center

wooden
PVC
aluminium
steel

Search:

Search:
material choice
  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | . . . . | 57 |  
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 60, 21
Piła dwugłowicowa RAPID DGS 200
STOLPEX Maszyny do Produkcji Okien
Double head saw RAPID DGS 200
Brand new double miter saw designed for cutting PVC and ALU profiles. 2x...
Drzwi harmonijkowe MB-70 / MB-70HI
DRUTEX S.A.
MB-70 / MB-70HI
Above-average durability and innovative design ensure long-lasting usage and...
FREZARKA DO SŁUPKÓW ALU / PCV PHOBOS 45°
LGF CNC MASZYNY
End milling machine PHOBOS 45°
End milling machine PHOBOS 45° Horizontal end milling machine with...

EKO-OKNA S.A.
MB-77 HS
Exclusive lift and slide doors, characterised by large dimensions and top...
Frez VHM  do profili 1-ostrzowy dwustronny
N-POL cutting tools
ALM101 - Solid carbide end mills
ALM101 - Solid carbide end mills, Z=1 Double-sided cuting. Special design for...
od 106,00

  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | . . . . | 57 |