Search Center

windows
types of windows
tilt & turn
energy-efficient
soundproof
anti-burglary
revolving
barn & storage building
serving
sliding
antique & custom
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,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 = '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, random, R.pub_time DESC, A.akolej LIMIT 0, 21
Okna IGLO ENERGY
DRUTEX S.A.
IGLO ENERGY
A perfect solution for demanding Clients! Modern design, innovative...
Kömmerling InVitra
OKNO-POL Sp. z o.o.
Kömmerling InVitra
KÖMMERLING InVitra windows are...

DOMEL Sp. z o.o.
Energetic
Robust profile 83 mm in width; Energy-saving 6-chamber profile, a section...
Kömmerling 76 MD
OKNO-POL Sp. z o.o.
Kömmerling 76 MD
System Kömmerling 76 MD, was...

DOMEL Sp. z o.o.
Infinity Passive
Massive, durable profile having 83 mm in width; 6-chamber profile; Super heat...
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...
Okna IGLO ENERGY CLASSIC
DRUTEX S.A.
IGLO ENERGY CLASSIC
Modern design, innovative technology and high energy efficiency that...
Reysol
Hensfort
  Hensfort Reysol:  King of the Sun on Hensfort offer. The...
PASSIV-LINE ULTRA
AdamS Sp. z o.o. Sp.k
PASSIV-LINE ULTRA Passiv-Line ULTRA ist ein für den Passivbau...

« previous   | 1 | 2 | 3 |