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
window coverings & gates
glass
facades & winter gardens
machines & surface processing

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

DOMEL Sp. z o.o.
Energetic
Robust profile 83 mm in width; Energy-saving 6-chamber profile, a section...
Okna MB-86 SI
DRUTEX S.A.
MB-86 SI
The modern aluminum system used for production of exterior architectural...
Ecoreina
Hensfort
Hensfort Ecoreina : Queen of the environment caring for ecological...
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...

DOMEL Sp. z o.o.
Infinity Passive
Massive, durable profile having 83 mm in width; 6-chamber profile; Super heat...
PASSIV-LINE ULTRA
AdamS Sp. z o.o. Sp.k
PASSIV-LINE ULTRA Passiv-Line ULTRA ist ein für den Passivbau...

DOMEL Sp. z o.o.
MB-86
Description Offered in three varieties ST , SI and AERO...
Okna MB-70HI
DRUTEX S.A.
MB-70HI
The modern aluminum system used for production of exterior architectural...
Kömmerling InVitra
OKNO-POL Sp. z o.o.
Kömmerling InVitra
KÖMMERLING InVitra windows are...

« previous   | 1 | 2 | 3 |