Search Trades

Find a Builder in Stoke-on-Trent, 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 listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.02464) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.18781) ) + sin( radians(53.02464) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=139) 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
Book a free wren kitchen design
Brinnington, Greater Manchester.
Cheshire east Kitchens & Bathrooms are a Brinnington... read more »
Nether Stowe, Staffordshire.
C D BRICKWORK AND BUILDING SERVICES are a Nether Stowe... read more »
Hillcross, Derbyshire.
Edmond Spiro are a Hillcross based business offering... read more »
Lane Ends, Cheshire.
High Peak Design And Build are a Lane Ends based business... read more »
Green Heath, Staffordshire.
Pp Developments are a Green Heath based business offering... read more »
Godley Hill, Greater Manchester.
High quality painting and decorating undertaken at... 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 »
Stretford, Greater Manchester.
M Kelly Ltd are a Stretford based business offering... read more »
Maw Green, Cheshire.
Jonhperson are a Maw Green based business offering Extension... 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 »
Hapsford, Cheshire.
C & J Construction are a Hapsford based business offering... read more »
Bollington Cross, Cheshire.
JNR Construction are a Bollington Cross based business... read more »
Stretton, Staffordshire.
Ncrockfordconstruction are a Stretton based business... read more »
© Copyright. 2023. All Rights Reserved.