Search Center

doors
types of doors
interior
exterior
sliding/patio
bi-fold & accordion
security
fire-rated
glass doors
smoke-proof
cold storage doors
acoustic
automatic
specialty & special shape
accessories
windows
suppliers & accessories
facades & winter gardens
window coverings & gates
machines & surface processing
glass
assembly

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 | 5 | 6 |  
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 = '73' OR (A.mcat1 & 2)) 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
Drzwi tarasowe podnoszono-przesuwne Iglo-HS
DRUTEX S.A.
Iglo-HS
Perfect solution for the trendy large-size terrace and balcony glazing that...
Drzwi tarasowe MB-70/ MB-70HI PSK
DRUTEX S.A.
MB-70/ MB-70HI PSK
A perfect solution for modern aluminium structures that ensures great...
Drzwi tarasowe SOFTLINE PSK
DRUTEX S.A.
SOFTLINE PSK
Perfect solution for the modern balcony and terrace glazing for small and...
PremiDoor 76
OKNO-POL Sp. z o.o.
PremiDoor 76
Description:...
Drzwi tarasowe IGLO LIGHT PSK
DRUTEX S.A.
IGLO LIGHT PSK
A unique design providing great light exposure inside the house and...
duoPort SK
PAGEN SP. Z O.O.
DUOPORT SK
Large-format window elements are characteristic of modern architecture. They...

« previous   | 1 | 2 | 3 | 4 | 5 | 6 |