Search Trades

Find a Builder in Nottingham, Nottinghamshire

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.96789) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.16019) ) + sin( radians(52.96789) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=119) 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
Stretton, Staffordshire.
Ncrockfordconstruction are a Stretton based business... read more »
Langold, Nottinghamshire.
Eco Roofing Uk are a Langold based business offering Loft... read more »
Radford, Nottinghamshire.
Ze Building Services are a Radford based business offering... read more »
Worksop, Nottinghamshire.
Malahat Group Ltd are a Worksop based business offering... read more »
Birdholme, Derbyshire.
Wide range of construction work over 25 yeas experience... read more »
Burton Joyce, Nottinghamshire.
D & S Developments are a Burton Joyce based business... read more »
Nottingham, Nottinghamshire.
We’re from Bm building ltd are proud of the good work... read more »
Wetmore, Staffordshire.
G9 Construction Ltd are a Wetmore based business offering... read more »
© Copyright. 2023. All Rights Reserved.