Search Trades

Find a Stained Glass Business in the UK

Post your job and get free quotes from tradespeople near you! Post your job
SELECT a.memberID, a.memberName, a.memberURL2, a.memberImage, a.memberDescr, a.townID, b.countyID, COALESCE(c.isPaid, 0) AS isPaid, c.listingType, a.isVerified AS premierMember, b.place_name, b.county, a.liabilityFile, a.liabilityExpiry, a.idFile, a.addressMatched, d.secondStageInterview FROM ( SELECT memberID, memberName, memberURL2, memberImage, memberDescr, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched FROM members WHERE isActive=1 AND memberID IN (SELECT memberID FROM listings WHERE expiryDate>NOW() AND listingID IN (SELECT listingID FROM listingcats WHERE categoryID=101)) ) a INNER JOIN areas b ON LEFT JOIN ( SELECT memberID, 1 AS isPaid, MAX(listingType) AS listingType, MAX(expiryDate) AS expiryDate FROM listings WHERE listingType>=0 AND expiryDate>NOW() GROUP BY memberID ) c ON a.memberID=c.memberID LEFT JOIN ( SELECT memberID, 1 AS secondStageInterview FROM listings WHERE listingType>=0 AND upgrdSpokenTo=1 GROUP BY memberID ) d ON a.memberID=d.memberID GROUP BY a.memberID ORDER BY isVerified DESC, listingType DESC
Book a free wren kitchen design
Deal, Kent.
Cutting edge glass designs are a Deal based business... read more »
Kingston upon Thames, London.
Visiontech Glass and Glazing Ltd A specialist glass and... read more »
Brent, London.
interfusionglass gives us access to a very large selection... read more »
Stamford, Lincolnshire.
30 years experience in repairing old and manufacturing... read more »
Stourbridge, West Midlands.
Trading for nearly 40 years in the restoration and making... read more »
Ealing, London.
We Supply & fit quality Double/ Triple glazed Thermally... read more »
Reading, Berkshire.
Glazed Windows & Doors LTD are a Reading based business... read more »
Irvine, North Ayrshire.
Matthew Donnelly Glassworks is an architectural glass... read more »
Central London
At Figaro's glass we restore and manufacture stained glass... read more »
Leicester, Leicestershire.
Best Glass & Glazing Ltd supply & install custom made... read more »
Cardiff/Caerdydd, Cardiff.
Adco Glazing is best known for its exceptional installation... read more »
Wolverhampton, West Midlands.
MyWallPrinted knows how to decorate public spaces, by... read more »
Preston, Lancashire.
Welcome to Staywarm Energy. We are an award-winning energy... read more »
Northwich, Cheshire.
34 Years experience in stained glass design and manufacture.... read more »
Walsall, West Midlands.
Balustrade Express Ltd. are a Walsall based business... read more »
Kent Street, West Sussex.
Your Local, Friendly Architectural Glass Specialists.... read more »
Bolton, Greater Manchester.
We are a specialist stained and decorative glass studio... read more »
Bath, Somerset.
Great Panes are a Bath based business offering Stained... read more »
Whiteknights, Berkshire.
Glass and glazing. A traditional and freindly service... read more »
Sunnyhurst, Lancashire.
WebDevelopmentIndia is top website development... read more »
Caerphilly/Caerffil, Caerphilly.
Fairway Window Systems Ltd are a Caerphilly/Caerffil based... read more »
Londonderry, West Midlands.
Jamal is a freelance artist and maker of stained glass.... read more »
Central London
Bermondsey glass LTD are a City of London based business... read more »
© Copyright. 2023. All Rights Reserved.