menu
close
Search Trades

Find a Builder in Staffordshire

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 expiryDate>NOW() AND listingID IN (SELECT listingID FROM listinglocations WHERE countyID=139)) ) a INNER JOIN areas b ON a.townID=b.id 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
Tittensor, Staffordshire.
Gareth Milner are a Tittensor based business offering... read more »
Porthill, Staffordshire.
AWC Builders are a Porthill based business offering... read more »
Gorstey Ley, Staffordshire.
Being bricklaying for 30 years..have built small extensions... read more »
Wombourne, Staffordshire.
Norbury Builder are a Wombourne based business offering... read more »
Shelton, Staffordshire.
Hdhs are a Shelton based business offering Builders,... read more »
Oak Hill, Staffordshire.
R Builder are a Oak Hill based business offering Property... read more »
Whitehill, Staffordshire.
W&H Builders are a Whitehill based business offering... read more »
Talke Pits, Staffordshire.
Eaton Brickwork are a Talke Pits based business offering... read more »
Seabridge, Staffordshire.
Jd Joinery are a Seabridge based business offering Builders,... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.