Search Trades

Find a Builder in Southend-on-Sea, 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.54624) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(0.70272) ) + sin( radians(51.54624) ) * 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
Istead Rise, Kent.
We are a small company providing building services to... read more »
Greenwich, London. are a Greenwich based business offering... read more »
Kingswood, Essex.
We are small independent family run business with over... read more »
Redbridge, London.
White Lion Construction are a Redbridge based business... read more »
Mill Hill, Essex.
We are a Building & Maintenance company We specialise... read more »
Bexley, London.
RJ Projects Essex are a Bexley based business offering... read more »
Redbridge, London.
Prime construction specialises in all areas of refurbishment... read more »
Greenstead, Essex.
Premier Carpentry & Construction are a Greenstead based... read more »
Troy Town, Kent.
Ark Timber Solutions provides expert timber solutions for... read more »
Barking & Dagenham, London.
Axiniei LTD are a Barking & Dagenham based business... read more »
Greenwich, London.
Dan Jackaman are a Greenwich based business offering... read more »
Basildon, Essex.
Bettis Carpentry And Build Ltd are a Basildon based... read more »
Greenwich, London.
1st & 2nd Fix Installations of Bathroom Suites WC’s... read more »
Wayfield, Kent.
D.L Carpentry are a Wayfield based business offering... read more »
Maldon, Essex.
Ab Builders are a Maldon based business offering Extension... read more »
Gillingham, Kent.
Sw Plumbing And Heating are a Gillingham based business... read more »
Borstal, Kent.
Richard Mills are a Borstal based business offering... read more »
Stone, Kent.
A professional English building company since 1984. All... read more »
Havering, London.
With 15 years experience we undertake all types of... read more »
Redbridge, London.
Welcome, we are a company with extensive experience, the... read more »
Waltham Forest, London.
Muka are a Waltham Forest based business offering Builders,... read more »
© Copyright. 2023. All Rights Reserved.