Search Trades

Find a Tradesperson in Glasgow, Glasgow City

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 listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(55.86214) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-4.24650) ) + sin( radians(55.86214) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=67) ORDER BY distance) z)) ) 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
Post your job to find the right tradesperson in Glasgow, Glasgow City
Priesthill, Glasgow City.
Londcalli Ltd are a Priesthill based business offering... read more »
Kirkshaw, North Lanarkshire.
Professional Painting and decorating 15+ years of... read more »
Galston, East Ayrshire.
Specialising in soft wash for any external surface, gutter... read more »
Guildiehaugh, West Lothian.
Phoenix Energy Services are a Guildiehaugh based business... read more »
Kirkmuirhill, South Lanarkshire.
Relible 18th edition Electrician Cover all aspects of... read more »
Cathcart, Glasgow City.
Boiler service repair upgrade heating smart timer's... read more »
Scotstoun, Glasgow City.
Stevies Plumbing And Heating are a Scotstoun based business... read more »
Renton, West Dunbartonshire.
Cmc Home Improvement are a Renton based business offering... read more »
Glasgow, Glasgow City.
Stewart Construction Limited are a Glasgow based business... read more »
Balloch, West Dunbartonshire.
Donaldson & Sons Roofing And Building Services are a... read more »
Kennishead, Glasgow City.
MH Joinery are a Kennishead based business offering... read more »
Hutchesontown, Glasgow City.
J & D Roofing are a Hutchesontown based business offering... read more »
Muirhouse, North Lanarkshire.
Castaway Roughcasters are a Muirhouse based business... read more »
East Kilbride, South Lanarkshire.
IAS GROUP LTD are a East Kilbride based business offering... read more »
Summerston, Glasgow City.
MF ROOFING AND BUILDING MAINTENANCE LTD are a Summerston... read more »
Salsburgh, North Lanarkshire.
Pro Oil And Gas are a Salsburgh based business offering... read more »
Thornly Park, Renfrewshire.
We are a fixed price building maintenance company who... read more »
Carstairs, South Lanarkshire.
Oakover Developments are a Carstairs based business... read more »
Thornliebank, East Renfrewshire.
Koreaworld are a Thornliebank based business offering... read more »
Kirkshaw, North Lanarkshire.
M&J Home Improvements are a Kirkshaw based business... read more »
Linwood, Renfrewshire.
Ross Decorating are a Linwood based business offering... read more »
West Calder, West Lothian.
West Lothian Feature Walls are a West Calder based business... read more »
Johnstone, Renfrewshire.
Instagram Roofingservices24 Phone number 07305863739 Facebook... read more »
Crosshouse, East Ayrshire.
We are a Civils company based in Kilmarnock East Ayrshire,... read more »
Knightsridge, West Lothian.
Dear customers If You are looking for a professional... read more »
Glensburgh, Falkirk.
Mihai Nicolaescu are a Glensburgh based business offering... read more »
Condorrat, North Lanarkshire.
No Job To Small are a Condorrat based business offering... read more »
Earnock, South Lanarkshire.
Mackenzie Decorators Ltd are a Earnock based business... read more »
Bellside, North Lanarkshire.
We are a local company specialising in Cctv and alarm... read more »
Pollokshaws, Glasgow City.
From new builds to extensions, and from kitchens to... read more »
© Copyright. 2023. All Rights Reserved.