Search Center

windows
types of windows
accessories
decorative elements
window handles and openers
window sills
extended functionality
all roof windows
doors
suppliers & accessories
facades & winter gardens
window coverings & gates
machines & surface processing
glass
assembly

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 = '725' OR (A.mcat15 & 256)) 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
Moskitiera ramkowa stała do zlicowanych okien aluminiowych MRSZ
ALUPROF S.A.
MRSZ fly insect screen for aluminium windows
This product is a solution designed for use on flushed aluminium windows. The...
MOSKITIERA RAMKOWA PRZESUWNA (MRP)
ALUPROF S.A.
MRP sliding fly screen
Sliding fly screen system protects the interiors against insects and are used...
MOSKITIERA RAMKOWA STAŁA (MRS)
ALUPROF S.A.
MRS fixed fly screen
The fixed frame fly screen system is a perfect protection against insects....
Moskitiera plisowana okienna MPH HARMONY VERTI
ALUPROF S.A.
MPH HARMONY VERTI pleated insect screen
The pleated insect screen system MPH HARMONY VERTI complements the offer of...
Moskitiera plisowana MPH Harmony
ALUPROF S.A.
MPH HARMONY pleated insect screen
Pleated insect screen system MPH is a solution primarily designed with the...
Klamki MACO Unity
MACO POLSKA Sp. z o.o.
MACO UNITY handles
High-quality window handles made of stainless steel, available in the...
Moskitiera zwijana MZN
ALUPROF S.A.
MZN Roll-up insect screen
The independent roll-up insect screen system is an excellent and extremely...
Moskitiera plisowana MPH DUAL
ALUPROF S.A.
MPH DUAL pleated insect screen
MPH DUAL is a pleated insect screen system, which belong to the HARMONY...
Moskitiera zwijana - MZH
ALUPROF S.A.
MZH Roll-up insect screen
The system MZH for roll-up insect screen is a modern and fully functional...
MOSKITIERA RAMKOWA OTWIERANA (MRO)
ALUPROF S.A.
MRO hinged fly screen
The hinged fly screen system protects the interiors against insects and is...

« previous   | 1 | 2 | 3 |