menu
close
Search Trades

Find a Scaffolder in Sheffield, South Yorkshire

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=58)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.38316) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.46776) ) + sin( radians(53.38316) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=137) ORDER BY distance) z)) ) a INNER JOIN areas b ON a.townID=b.id 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
Batley Carr, West Yorkshire.
Phil davison scaffolding are a Batley Carr based business... read more »
Leeds, West Yorkshire.
B&W Scaffolding are a Leeds based business offering... read more »
Macclesfield, Cheshire.
Silk town scaffolding are a Macclesfield based business... read more »
Morley, West Yorkshire.
West Yorkshire access solutions are a Morley based... read more »
Leeds, West Yorkshire.
Bramley scaffolding are a Leeds based business offering... read more »
Doncaster, South Yorkshire.
Clegg&Son scaffolding are a Doncaster based business... read more »
Leeds, West Yorkshire.
We are a family run scaffolding company based in leeds... read more »
Leeds, West Yorkshire.
Scaffold company based in Leeds. 15 years experience in... read more »
Oldham, Greater Manchester.
RCA Scaffolding Services Ltd are a Oldham based business... read more »
Sheffield, South Yorkshire.
Damo's Scaffolding are a Sheffield based business offering... read more »
Doncaster, South Yorkshire.
J Walker Scaffolding Ltd are a Doncaster based business... read more »
Leeds, West Yorkshire.
Dunnrite Scaffolding are a Leeds based business offering... read more »
Glossop, Derbyshire.
Established over 20 years ago, Numark Scaffolding is a... read more »
Gainsborough, Lincolnshire.
Aegir Access LTD are a Gainsborough based business offering... read more »
Nottingham, Nottinghamshire.
M M scaffolding service‚Äôs Our number is sbove on our... read more »
Sheffield, South Yorkshire.
Best quotes on scaffolding based at Sheffield. Give... read more »
Doncaster, South Yorkshire.
ASAP scaffolding is a family run business, we offer free... read more »
Rotherham, South Yorkshire.
Parvaiz ghani are a Rotherham based business offering... read more »
South Anston, South Yorkshire.
HLR scaffolding Ltd are a South Anston based business... read more »
Garden Village, West Yorkshire.
S.A.L Scaffolding and Netting Services Ltd is a family... read more »
Monkhill, West Yorkshire.
A-Z Scaffolding Services Ltd are a Monkhill based business... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.