Search Center

windows
types of windows
tilt & turn
energy-efficient
soundproof
anti-burglary
revolving
barn & storage building
serving
antique & custom
sliding
English (sash & casement)
fire-rated
smoke exhaust windows
specialty & special shape
display windows
partition walls
Nordic
Dutch
accessories
all roof windows
services
doors
suppliers & accessories
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, A.opisen as opis,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 = '792' OR (A.mcat17 & 1)) 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, R.pub_time DESC, A.akolej LIMIT 0, 21
Kömmerling InVitra
OKNO-POL Sp. z o.o.
Kömmerling InVitra
KÖMMERLING InVitra windows are...
Kömmerling 76 MD
OKNO-POL Sp. z o.o.
Kömmerling 76 MD
System Kömmerling 76 MD, was...
KÖMMERLING 76 AD
OKNO-POL Sp. z o.o.
KÖMMERLING 76 AD
KÖMMERLING 76 AD window system is appreciated for the highest...
PASSIV-LINE ULTRA
AdamS Sp. z o.o. Sp.k
PASSIV-LINE ULTRA Passiv-Line ULTRA ist ein für den Passivbau...
Okna IGLO ENERGY CLASSIC
DRUTEX S.A.
IGLO ENERGY CLASSIC
Modern design, innovative technology and high energy efficiency that...
Okna IGLO ENERGY
DRUTEX S.A.
IGLO ENERGY
A perfect solution for demanding Clients! Modern design, innovative...
Okna MB-86 SI
DRUTEX S.A.
MB-86 SI
The modern aluminum system used for production of exterior architectural...

« previous   | 1 | 2 | 3 |