Search Trades

Find a Scaffolder in Colchester, Essex

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(51.89234) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(0.89787) ) + sin( radians(51.89234) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=62) 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
Book a free wren kitchen design
Wickford, Essex.
All Secure Scaffolding Ltd are a Wickford based business... read more »
Corringham, Essex.
J&R Scaffolding Services Limited are a Corringham based... read more »
East Tilbury, Essex.
Thurrock Scaffolding are a East Tilbury based business... read more »
Basildon, Essex.
At JFT scaffolding we cover all areas we will not be... read more »
Basildon, Essex.
HQ Scaffolding: Professional scaffolding services. We... read more »
Waltham Abbey, Essex.
Scaffolding Inc Ltd are a Waltham Abbey based business... read more »
Chelmsford, Essex.
iQ Scaffolding LTD ensure safety first, we work to the... read more »
Chelmsford, Essex.
All Routes Scaffolding are a Chelmsford based business... read more »
Chelmsford, Essex.
We are a scaffolding firm with over 13 years in the trade.... read more »
Southminster, Essex.
SPARTA SCAFFOLDING LTD are a Southminster based business... read more »
Canvey Island, Essex.
EES Scaffolding Limited have over 40 Years experience... read more »
Chelmsford, Essex.
We are a very reliable scaffolding company with over 20... read more »
Colchester, Essex.
Sure Scaffolding Ltd are a Colchester based business... read more »
South Ockendon, Essex.
Watts Scaffolding Service Ltd are a South Ockendon based... read more »
Saffron Walden, Essex.
Saffron Scaffold is a leading scaffolding provider in... read more »
South Ockendon, Essex.
SOME OF OUR SERVICES INCLUDE: - Scaffolding erection and... read more »
Witham, Essex.
Here at ssl scaffolding contracts we aim to provide... read more »
Basildon, Essex.
5S.SCAFFOLDING are a Basildon based business offering... read more »
Chelmsford, Essex.
Sweeney Scaffolding Services are a Chelmsford based... read more »
Harwich, Essex.
Direct Access offer a professional service for both... read more »
Ipswich, Suffolk.
Ipswich Scaffolding are a Ipswich based business offering... read more »
© Copyright. 2023. All Rights Reserved.