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
Whitehill, Staffordshire.
DW Joinery are a Whitehill based business offering... read more »
Milton, Staffordshire.
Rjl Services are a Milton based business offering Builders,... read more »
Wilnecote, Staffordshire.
T&d Construction are a Wilnecote based business offering... read more »
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 »
Leadendale, Staffordshire.
W Leese Builder are a Leadendale based business offering... read more »
Nether Stowe, Staffordshire.
D&R Drainage are a Nether Stowe based business offering... read more »
Hassall Green, Cheshire.
Introduction to Genesis Roofing UK Genesis Roofing... read more »
Miles Green, Staffordshire.
Jack Lawler are a Miles Green based business offering... read more »
Cobridge, Staffordshire.
Building Services are a Cobridge based business offering... read more »
Primsland, Worcestershire.
With over 15 years of hands on experience in bricklaying... read more »
Nether Stowe, Staffordshire.
C D BRICKWORK AND BUILDING SERVICES are a Nether Stowe... read more »
Green Heath, Staffordshire.
Pp Developments are a Green Heath based business offering... read more »
Baswich, Staffordshire.
We are based in Stafford we work within a 25mile radius.we... read more »
Amington, Staffordshire.
TB Renovations are a Amington based business offering... read more »
Middle Hill, Staffordshire.
Ct Rendering are a Middle Hill based business offering... read more »
Heath Hayes, Staffordshire.
SophieMantle are a Heath Hayes based business offering... read more »
Burntwood, Staffordshire.
DBPLUMBIN are a Burntwood based business offering Builders,... read more »
Tamworth, Staffordshire.
For all your property needs give S&S a call, from the... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.