Search Trades

Find a Builder in Manchester, Greater Manchester

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.48296) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.25011) ) + sin( radians(53.48296) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=69) 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
Padiham, Lancashire.
Buildscape are a Padiham based business offering Builders... read more »
Hapsford, Cheshire.
C & J Construction are a Hapsford based business offering... read more »
Langley, Greater Manchester.
RJ Brickwork are a Langley based business offering Extension... read more »
Prestwich, Greater Manchester.
Mykhailo Hrynyk are a Prestwich based business offering... read more »
Bollington Cross, Cheshire.
JNR Construction are a Bollington Cross based business... read more »
Scholes, Greater Manchester.
Ukperaj Construction are a Scholes based business offering... read more »
Collyhurst, Greater Manchester.
B & M Keshwala Properties Ltd are a Collyhurst based... read more »
Barton Upon Irwell, Greater Manchester.
Worsley Renovations LTD are a Barton Upon Irwell based... read more »
Grimsargh, Lancashire.
Small family-run builder and joinery company. Installing... read more »
Broughton Park, Greater Manchester.
Asbestos Builder are a Broughton Park based business... read more »
Gillmoss, Merseyside.
EKH Brickwork are a Gillmoss based business offering... read more »
© Copyright. 2023. All Rights Reserved.