Search Trades

Find a New Development Builder in the UK

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=121)) ) 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
St James's End, Northamptonshire.
Codrean Service Limited are a St James's End based business... read more »
Goole, East Riding of Yorkshire.
L are a Goole based business offering Extension Builders,... read more »
Birchington, Kent.
Rivers Construction are a Birchington based business... read more »
Mill Hill, Greater Manchester.
Foundations Brickwork and construction Specialists in... read more »
Newham, London.
TAG LEVEL LTD are a Newham based business offering New... read more »
Hag Fold, Greater Manchester.
Moore Building Services are a Hag Fold based business... read more »
Brent, London.
A Class Ceilings and Partitions are a Brent based business... read more »
Rise Carr, County Durham.
JACK PATTISON BUILDERS are a Rise Carr based business... read more »
© Copyright. 2023. All Rights Reserved.