Search Center

wooden
PVC
aluminium
steel

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 | 5 | . . . . | 58 |  
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 = '487' OR (A.mcat0 & 4)) 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
Jubileuszowe okno Perllo 82 mm
FRAMEX sp. z o.o. sp. komandytowa
Perllo 82 mm - an anniversary window
A premium product at a standard price!Windows with the profile width of 82 mm...

EKO-OKNA S.A.
Ideal 4000
This universal system proves it's function in both modern architecture...
Okna IGLO 5 CLASSIC
DRUTEX S.A.
IGLO 5 CLASSIC
Very good thermal insulation parameters in attractive price that allow to...
MT 256 Frezarka do słupków (6 profili)
Schtec Makine San. ve Tic. A.Ş.
MT 256 End Milling Machine (6 Piece of the profile)
Functions:  End milling of the PVC and Aluminium transom profiles with...
Drzwi tarasowe IGLO ENERGY PSK
DRUTEX S.A.
IGLO ENERGY PSK
Perfect solution, that ensures  big access to daylight both in small...

EKO-OKNA S.A.
EkoSun 7
An innovative system of energy efficient window profiles, designed for...

AdamS A. Pędzich Sp. K
PASSIV-LINE S
PASSIV-LINE S  - direct link to our website Passiv-line S...
Frezarko kopiarka do frezowania profili z alumium M100
LGF CNC MASZYNY
M 100 COPY ROUTER ALUMINIUM
Copy router with vertical milling unit. Base in steel, suitable for template...
Lakierowane okna PCV
OKNO-POL Sp. z o.o.
Painted uPVC windows
The painting technology offered at...

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