Search Center

suppliers & accessories
profile systems
window accessories
fittings
decorative elements
seals/gaskets
end caps & packers
reinforcement profiles
release sheets
drip profiles & aluminium cladding
window sills
muntin bars
mullion connectors
cash scoops
sill blocks/sub-window profiles
door accessories
chemicals & maintenance
services
fire protection
conservatories & facades accessories
semi-finished products
software
ventilation
windows
doors
facades & winter gardens
window coverings & gates
machines & surface processing
glass
assembly

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 | 5 | . . . . | 12 |  
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 = '378' OR (A.mcat5 & 8388608)) 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
Smart Line S+
AXOR INDUSTRY EU
Smart Line S+
Smart Line S+ hardware is AXOR INDUSTRY’s conceptual solution...
Okucia otwierane na zewnątrz MACO Espags
MACO POLSKA Sp. z o.o.
MACO Espags espagnolettes
A wide variety of open-out casement window solutions enabling a vast range...
Okucia do okien MACO MULTI-MATIC
MACO POLSKA Sp. z o.o.
MACO MULTI-MATIC hardware
MACO MULTI-MATIC is the new line of window hardware for the most exigent...
ROMB DYNAMIC ALU
ROMB S.A. (dawniej Metalplast Karo Złotów S. A.)
ROMB DYNAMIC ALU hardware
New hardware, which emerged as a response to market demand, designed...
Okucie MACO-MULTI Komfort
MACO POLSKA Sp. z o.o.
MACO MULTI Comfort fittings
Easy-to-operate windows should be a given. Sometimes, we all find it...

« previous   | 1 | 2 | 3 | 4 | 5 | . . . . | 12 |