menu
close
Search Trades

Find a Scaffolder in Coventry, West Midlands

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(52.40349) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.50902) ) + sin( radians(52.40349) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=155) 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
Northampton, Northamptonshire.
Over 20yrs experience within the scaffolding industry.Full... read more »
Coventry, West Midlands.
Djsscaffolding are a Coventry based business offering... read more »
Birmingham, West Midlands.
Mr Scaffolding uk are a Birmingham based business offering... read more »
Birmingham, West Midlands.
low cost scaffolding are a Birmingham based business... read more »
Birmingham, West Midlands.
About Us Easy Fix Scaffolding Ltd is a UK based access... read more »
Weedon Bec, Northamptonshire.
DV Access Solutions are a Weedon Bec based business... read more »
Birmingham, West Midlands.
Goldline Scaffolding Ltd are a Birmingham based business... read more »
Birmingham, West Midlands.
LUKE SCAFFOLDING BIRMINGHAM LTD are a Birmingham based... read more »
Sandwell, West Midlands.
I'm an advanced scaffolder with almost 20 years experience... read more »
Tamworth, Staffordshire.
welcome to Goldline scaffolding .over 20 years experience... read more »
Birmingham, West Midlands.
G
G are a Birmingham based business offering Scaffolders... read more »
Coventry, West Midlands.
We are a CHAS accredited contractor and we are fully... read more »
Fritwell, Oxfordshire.
A and R Scaffolding Services are a Fritwell based business... read more »
Leicester, Leicestershire.
Total Scaffold Services are a Leicester based business... read more »
Birmingham, West Midlands.
Tubez Scaffolding Services Ltd are a Birmingham based... read more »
Aston, West Midlands.
"Scaffold Hire and Erection Services Based in the West... read more »
Cossington, Leicestershire.
Aspire Scaffolding are a Cossington based business offering... read more »
Wednesbury Oak, West Midlands.
Hi-Towerscaffolding are a Wednesbury Oak based business... read more »
Shenstone, Staffordshire.
MAP SCAFFOLDING LTD. Access solutions. Domestic, private,... read more »
Abington Vale, Northamptonshire.
AVS are a family run business providing scaffolding... read more »
Leicester Forest East, Leicestershire.
A fresh rebranded scaffolding service with backing with... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.