menu
close
Search Trades

Find a Driveway Contractor in Liverpool, Merseyside

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=64)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.41658) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.94183) ) + sin( radians(53.41658) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=100) 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
Hall i' th' Wood, Greater Manchester.
QUALITY & COMMITMENT TO SEE THE JOB THROUGH General... read more »
Manchester, Greater Manchester.
Perfect Home Improvements are a Manchester based business... read more »
Manchester, Greater Manchester.
Ogc Building Services Ltd are a Manchester based business... read more »
Liverpool, Merseyside.
K
K are a Liverpool based business offering Driveway... read more »
Bromborough, Merseyside.
Smc Builders are a Bromborough based business offering... read more »
Blackburn, Lancashire.
ForeverFix are a Blackburn based business offering Extension... read more »
Winsford, Cheshire.
E P Property Services are a Winsford based business... read more »
Chorley, Lancashire.
Small family run groundworking business, covers Chorley... read more »
Birkenhead, Merseyside.
Consider It Done are a Birkenhead based business offering... read more »
Oldham, Greater Manchester.
Enhanced paving & landscapes is a family run Business... read more »
Manchester, Greater Manchester.
Astley Fencing And Supplies are a Manchester based business... read more »
Astley, Greater Manchester.
We supply and fit heavy duty fencing. : concrete basis... read more »
Wigan, Greater Manchester.
JD Groundworks are a Wigan based business offering Driveway... read more »
St Helens, Merseyside.
WA9 Building Services are a St Helens based business... read more »
Manchester, Greater Manchester.
Hello welcome to Allen Surfacing Ltd, Here on our page... read more »
Manchester, Greater Manchester.
J
Hi we are j and Sons paving we do all types of groundwork... read more »
Liverpool, Merseyside.
Doran are a Liverpool based business offering Driveway... read more »
Manchester, Greater Manchester.
A Stearn Roofing are a Manchester based business offering... read more »
Southport, Merseyside.
P D Bricks are a Southport based business offering Extension... read more »
Abergele, Conwy.
Advanta Construction are a Abergele based business offering... read more »
Preston, Lancashire.
Wall2wall Property Solutions are a Preston based business... read more »
Manchester, Greater Manchester.
Lowe Landscapes are a Manchester based business offering... read more »
Preston, Lancashire.
Ribble Valley Resin Ltd are a Preston based business... read more »
Manchester, Greater Manchester.
Davies Construction are a Manchester based business... read more »
Manchester, Greater Manchester.
Progress Brickwork are a Manchester based business offering... read more »
Manchester, Greater Manchester.
SK Drives And Gardens are a Manchester based business... read more »
Inskip, Lancashire.
John Ronson Builders are a Inskip based business offering... read more »
Bolton, Greater Manchester.
AJ's Handyman Services are a Bolton based business offering... read more »
Moordown, Dorset.
Garfield David Construction is a full-service building &... read more »
Wigan, Greater Manchester.
Messrs Fairhurst are a Wigan based business offering... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.