Search Trades

Find a Builder in Leeds, West Yorkshire

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.80591) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.53835) ) + sin( radians(53.80591) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=157) 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
Hillsborough, South Yorkshire.
SC Building Services are a Hillsborough based business... read more »
Allerton, West Yorkshire.
Experts at new builds and house extension work. We pride... read more »
Balby, South Yorkshire.
A Force Salutation are a Balby based business offering... read more »
Holme, West Yorkshire.
AJ Buildings Service LTD are a Holme based business... read more »
Hadfield, Derbyshire.
We're a dedicated family business with more than 30... read more »
Hanging Heaton, West Yorkshire.
RSB CONTRACTS LTD are a Hanging Heaton based business... read more »
Leeds, West Yorkshire.
JB refurbishment are a Leeds based business offering... read more »
Harecroft, West Yorkshire.
.. are a Harecroft based business offering Builders,... read more »
Green Side, West Yorkshire.
AR BUILDING MANAGEMENT SERVICES LTD are a Green Side based... read more »
Hole Bottom, West Yorkshire.
SShepherdlandscaping are a Hole Bottom based business... read more »
Marsden, West Yorkshire.
A.m Building And Landscapes are a Marsden based business... read more »
Broomhill, South Yorkshire.
I am a self employed builder, bricklayer by trade but... read more »
Burngreave, South Yorkshire.
Nik Dar Construction LTD are a Burngreave based business... read more »
Outwood, West Yorkshire.
We set a very high standard for our quality of work. We... read more »
Clayton West, West Yorkshire.
CRS Bricklayers Ltd are a Clayton West based business... read more »
Cleckheaton, West Yorkshire.
general building company specialising in new builds ,... read more »
West Park, West Yorkshire.
A-Z Building Maintenance Ltd are a West Park based business... read more »
Fagley, West Yorkshire.
Jf Plastering are a Fagley based business offering... read more »
Wrenthorpe, West Yorkshire.
PPD are a Wrenthorpe based business offering Builders,... read more »
Lockwood, West Yorkshire.
Golden are a Lockwood based business offering Extension... read more »
Byram, North Yorkshire.
Kiwi Damp And Render are a Byram based business offering... read more »
Hill Top, South Yorkshire.
JC Worktops are a Hill Top based business offering Kitchen... read more »
Black Moor, West Yorkshire.
We are a small company who has taken the leap to go solo... read more »
Grimethorpe, South Yorkshire.
Inscape Construction Ltd are a Grimethorpe based business... read more »
Spotland Bridge, Greater Manchester.
Hassan are a Spotland Bridge based business offering... read more »
Shiregreen, South Yorkshire.
A*star Construction are a Shiregreen based business... read more »
Batley, West Yorkshire.
Wyvern Construction are a Batley based business offering... read more »
Intake, South Yorkshire.
Hi,my company is a construction business with more than... read more »
Burmantofts, West Yorkshire.
EC Quality Construction are a Burmantofts based business... read more »
Bierley, West Yorkshire.
MMK Builders 786 are a Bierley based business offering... read more »
© Copyright. 2023. All Rights Reserved.