Search Trades

Find a Builder in Derby, Derbyshire

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(52.91576) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.47351) ) + sin( radians(52.91576) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=46) 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
Coalville, Leicestershire.
A To Z Construction Leicester are a Coalville based... read more »
Tamworth, Staffordshire.
For all your property needs give S&S a call, from the... read more »
South Wigston, Leicestershire.
Peace Construction & Carpentry are a South Wigston based... read more »
Swanwick, Derbyshire.
Tj Armour are a Swanwick based business offering Bricklayers,... read more »
Sketchley, Leicestershire.
Westwey Developments Ltd are a Sketchley based business... read more »
Hinckley, Leicestershire.
TC Bricklaying Services are a Hinckley based business... read more »
Clifton, Nottinghamshire.
Hi L&J property maintenance. We carry out 99% of property... read more »
Newton, Derbyshire.
Father and son general builders. 30+ years experience in... read more »
Stretton, Staffordshire.
Ncrockfordconstruction are a Stretton based business... read more »
Nottingham, Nottinghamshire.
Bm General Building Ltd are a Nottingham based business... read more »
© Copyright. 2023. All Rights Reserved.