Search Center - 4353 products

SELECT A.* , R.symbol, A.nazwaen as nazwa FROM act_base_asortyment as A left join act_base_firmy as R on A.firma = R.id WHERE (A.menu_id = '260' OR (A.mcat4 & 256)) AND (A.foto != '' AND R.xstatus = 2 AND A.nazwaen !='') AND A.status = 1 AND (A.perms & 1) AND A.date_end >= NOW() AND A.date_start <= NOW() AND A.lang & 4 ORDER BY rand() LIMIT 32

Newsletter



exlabesa plus - software designed to create offers and bills of materials

exlabesa plus - software designed to create offers and bills of materials

The number of users of the exlabesa plus software designed to create offers and bills of materials continues to grow. This is flexible and constantly updated software including all the latest products...

latest news (windows)
Spectus triples the choices with a new 36mm triple glazing beadSpectus triples the choices with a new 36mm triple glazing bead

Spectus customers now have more choices than ever in triple glazing...

WinDoorEx + Glass & Aluminum Middle East 2017 HighlightsWinDoorEx + Glass & Aluminum Middle East 2017 Highlights

WinDoorEx Middle East + Glass & Aluminum is one of the largest trade fairs...

Dekko’s windows to wow show-goers at FITDekko’s windows to wow show-goers at FIT

Award-winning Dekko Window Systems are adding stylish aluminium windows to...

Dale quality ensures Part Q classificationDale quality ensures Part Q classification

The new mandatory Part Q classification, seeks to ensure high security...

Promotional Lottery for 25th anniversary!
Promotional Lottery for 25th anniversary!

Buy FAKRO products and win the grand prize - Skoda Superb!

An introduction to sound controlAn introduction to sound control

Sound control is an increasing issue for professionals and homeowners....

Primed and ready to Apeer at FIT ShowPrimed and ready to Apeer at FIT Show

After the success of last year’s FIT Show, Apeer are already gearing up for...

Top 5 home improvement trends for 2017Top 5 home improvement trends for 2017

Are you thinking that 2017 is the year you will perfect your home? Here are...

Innovative technology in Drutex windowsInnovative technology in Drutex windows

Drutex is the first Polish company to have introduced a modern Maco...

FAKRO innovations at MADE Expo 2017FAKRO innovations at MADE Expo 2017

FAKRO, the second largest manufacturer of roof windows and loft ladders...



RSS