Search Trades

Find a Builder 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=48)) 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
Jaywick, Essex.
Cooper Construction are a Jaywick based business offering... read more »
Matching, Essex.
Casey Construction are a Matching based business offering... read more »
Upshire, Essex.
D G Brede are a Upshire based business offering Builders,... read more »
Westbourne, Suffolk.
Parr plumbing & property ltd trading as RMH are a Westbourne... read more »
Pilgrims Hatch, Essex.
Any Scaffolding work taken on whether it’s a small... read more »
Tiptree, Essex.
Richard Bewers are a Tiptree based business offering... read more »
Buckhurst Hill, Essex.
OBM Properties are a Buckhurst Hill based business offering... read more »
Saxon Street, Cambridgeshire.
JBT Building And Maintenance are a Saxon Street based... read more »
Manuden, Essex.
Hello guys!!! My name is Mantas ( MU Maintenance) We... read more »
Southchurch, Essex.
L P Brickwork are a Southchurch based business offering... read more »
Barstable, Essex.
Allen Construction Ltd are a Barstable based business... read more »
Potter Street, Essex.
Pjc Tiling And Bathrooms are a Potter Street based business... read more »
Pilgrims Hatch, Essex.
Olive Rose Contractors Ltd are a Pilgrims Hatch based... read more »
Kingswood, Essex.
SL building and landscaping are a friendly local company... read more »
Prittlewell, Essex.
Max's Bricklaying&landscape are a Prittlewell based... read more »
Bury St Edmunds, Suffolk.
At Orvis Brickwork we take pride in delivering your project... read more »
Chafford Hundred, Essex.
Fixon are a Chafford Hundred based business offering... read more »
Widford, Essex.
Terry Hutton are a Widford based business offering Builders... read more »
Willingale, Essex.
Richmond Construction are a Willingale based business... read more »
Colchester, Essex.
G Leigh Roofing are a Colchester based business offering... read more »
Kingswood, Essex.
We are small independent family run business with over... read more »
Lavenham, Suffolk.
Day And Brown Brickwork are a Lavenham based business... read more »
Mill Hill, Essex.
We are a Building & Maintenance company We specialise... read more »
Greenstead, Essex.
Premier Carpentry & Construction are a Greenstead based... read more »
Basildon, Essex.
Bettis Carpentry And Build Ltd are a Basildon based... read more »
Maldon, Essex.
Ab Builders are a Maldon based business offering Extension... read more »
© Copyright. 2023. All Rights Reserved.