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 |  
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 = '70' OR (A.mcat1 & 16)) 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

EKO-OKNA S.A.
Notus
Functional and impressive balcony and patio doors – a solution that...

EKO-OKNA S.A.
MB-77 HS
Exclusive lift and slide doors, characterised by large dimensions and top...

EKO-OKNA S.A.
Panorama
A technologically advanced system intended for production of accordion...

EKO-OKNA S.A.
Multi Slide
In small room where there is no space to install balcony windows with a leaf...

EKO-OKNA S.A.
Duo Slide
An economic system that can successfully substitute traditional windows. A...
Drzwi harmonijkowe MB-86 Fold Line
DRUTEX S.A.
MB-86 Fold Line
The system with enhanced thermal insulation, ensuring a perfect solution...

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

EKO-OKNA S.A.
MB-Slide
Provides additional thermal insulation. Intended for the construction of...

EKO-OKNA S.A.
Folding system
An interesting way to provide a passage to your garden, terrace, or balcony....

EKO-OKNA S.A.
MB-59HS
A state of the art solution for doors and windows. MB-59 HS lift and slide...

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

EKO-OKNA S.A.
HST85
Energy efficient sliding door system. Enables you to create large glazed...
Drzwi harmonijkowe SOFTLINE 68
DRUTEX S.A.
SOFTLINE 68
Original and classic design with advanced technical solutions ensure maximal...

EKO-OKNA S.A.
Modernslide
A state-of-the-art system of light-weight, energy-efficient sliding doors....

EKO-OKNA S.A.
Visoglide Plus
A system of sliding doors recommended for energy-efficient constructions....

« previous   | 1 | 2 |