Search Center

doors
types of doors
accessories
windows
suppliers & accessories
facades & winter gardens
window coverings & gates
machines & surface processing
glass
assembly

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 |  
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,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 = '64' OR (A.mcat6 & 16)) AND (R.status = 1 AND (A.opisen !='' || A.nazwaen !='')) AND A.status = 1 ) AND (A.perms & 1) AND A.date_end >= NOW() AND A.date_start <= NOW() GROUP BY A.id ORDER BY R.xstatus DESC, R.pub_time ASC, (A.foto != '') DESC, A.akolej LIMIT 0, 21

EKO-OKNA S.A.
Duo Slide
An economic system that can successfully substitute traditional windows. A...
Drzwi tarasowe IGLO ENERGY PSK
DRUTEX S.A.
IGLO ENERGY PSK
Perfect solution, that ensures  big access to daylight both in small...
Drzwi tarasowe podnoszono-przesuwne Iglo-HS
DRUTEX S.A.
Iglo-HS
Perfect solution for the trendy large-size terrace and balcony glazing that...

EKO-OKNA S.A.
PSK doors (Aluplast, EkoSun, Salamander)
PSK doors are an interesting alternative to balcony doors as they can be...
Drzwi tarasowe DUOLINE PSK
DRUTEX S.A.
DUOLINE PSK
Elegant, durable tilt and slide doors in wood and aluminium technology....
Drzwi tarasowe IGLO 5 PSK
DRUTEX S.A.
IGLO 5 PSK
Perfect solution that ensures  big access to daylight both in small...

EKO-OKNA S.A.
HST85
Energy efficient sliding door system. Enables you to create large glazed...
Drzwi MB-45
DRUTEX S.A.
MB-45
Slim and modern door structure.     Features   The...

EKO-OKNA S.A.
Harmonia
The reliable system providing a panoramic view. The use of the folding...

EKO-OKNA S.A.
Notus
Functional and impressive balcony and patio doors – a solution that...
Drzwi IGLO 5
DRUTEX S.A.
IGLO 5
A perfect combination of modern looks and rounded profile lines....
Drzwi MB-70
DRUTEX S.A.
MB-70
The modern and resistant aluminum doors that represent elegant design and...

EKO-OKNA S.A.
HST70
Sliding doors provide the highest level of functionality and aesthetics....

EKO-OKNA S.A.
EkoLine Panels
A collection of EkoLine door panels is an aesthetic complement to every...
Drzwi tarasowe IGLO LIGHT PSK
DRUTEX S.A.
IGLO LIGHT PSK
A unique design providing great light exposure inside the house and...
Drzwi MB-86 SI
DRUTEX S.A.
MB-86 SI
Modern and resistant aluminum doors that stand out with high durability....

EKO-OKNA S.A.
MB-Slide
Provides additional thermal insulation. Intended for the construction of...
Drzwi harmonijkowe MB-70 / MB-70HI
DRUTEX S.A.
MB-70 / MB-70HI
Above-average durability and innovative design ensure long-lasting usage and...
Drzwi MB-70HI
DRUTEX S.A.
MB-70HI
The modern and resistant aluminum doors stand out for high durability and...
Drzwi tarasowe podnoszono-przesuwne DUOLINE HS
DRUTEX S.A.
HS DUOLINE
Elegant, durable lift and slide doors in wood and aluminum technology....

« previous   | 1 | 2 | 3 | 4 |