menu
close
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 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
York, North Yorkshire.
APM Contracts (York) Ltd undertake all Building works in... read more »
Sheffield, South Yorkshire.
Peal construction are a Sheffield based business offering... read more »
Leeds, West Yorkshire.
We cover fencing decking flagging block paving artificial... read more »
Keighley, West Yorkshire.
Smart Roofing & Joinery are a Keighley based business... read more »
Normanton, West Yorkshire.
Hambelton Property Services are a Normanton based business... read more »
Dewsbury, West Yorkshire.
Clan services are a Dewsbury based business offering... read more »
Huddersfield, West Yorkshire.
Clegg Joinery and Kitchens are a Huddersfield based... read more »
Ilkley, West Yorkshire.
New builds Refurbish Extensions Ground works Any... read more »
Leeds, West Yorkshire.
Stoneworks building and landscaping are a Leeds based... read more »
Bradford, West Yorkshire.
TGB Builders And Plumbing Services are a Bradford based... read more »
Sheffield, South Yorkshire.
Ghm Building Services LTD are a Sheffield based business... read more »
Knowle Park, West Yorkshire.
Woodpecker kitchen & joinery services are a Knowle Park... read more »
Sheffield, South Yorkshire.
Martin Staniforth cabinetmaker are a Sheffield based... read more »
York, North Yorkshire.
T and G Construction Services are a York based business... read more »
Barnoldswick, Lancashire.
M Mitchell Building Services are a Barnoldswick based... read more »
Leeds, West Yorkshire.
Prestige Building are a Leeds based business offering... read more »
Burnley, Lancashire.
local construction Ltd are a Burnley based business... read more »
Doncaster, South Yorkshire.
J.morris building ltd are a Doncaster based business... read more »
Halifax, West Yorkshire.
Shaw builders are a Halifax based business offering... read more »
Sheffield, South Yorkshire.
Waller are a Sheffield based business offering Extension... read more »
Sheffield, South Yorkshire.
George Handyman are a Sheffield based business offering... read more »
Barnsley, South Yorkshire.
A&C building Services are a Barnsley based business... read more »
Leeds, West Yorkshire.
Door Canopy are a Leeds based business offering Property... read more »
Leeds, West Yorkshire.
Taylors Joinery & Building is a well-established company... read more »
Doncaster, South Yorkshire.
Established over 10 years ago and with 25+ years experience... read more »
Huddersfield, West Yorkshire.
Walker installations are a Huddersfield based business... read more »
Bramley, West Yorkshire.
Loft conversion specialists Dormer conversions HIP... read more »
Harrogate, North Yorkshire.
JAR Radcliffe & Sons. Building and Joinery/ Bathrooms and... read more »
Sheffield, South Yorkshire.
Brookes builders are a Sheffield based business offering... read more »
Keighley, West Yorkshire.
Shield Building & Roofing Services are a Keighley based... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.