menu
close
Search Trades

Find a Roofer in Warrington, Cheshire

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=57)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.39185) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.59542) ) + sin( radians(53.39185) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=32) 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
St Helens, Merseyside.
Trade point are a St Helens based business offering Roofers... read more »
Chester, Cheshire.
quality roofing are a Chester based business offering... read more »
Middleton, Greater Manchester.
JJN Roofing Services are a Middleton based business... read more »
Abbey Village, Lancashire.
A.O'Donnell Roofing Limited are a Abbey Village based... read more »
Standish, Greater Manchester.
B & B Roofing are a Standish based business offering... read more »
Accrington, Lancashire.
Property care are a Accrington based business offering... read more »
Manchester, Greater Manchester.
Lightfoot’s roofing are a Manchester based business... read more »
Chorley, Lancashire.
Premier Roofing NW are a Chorley based business offering... read more »
Leyland, Lancashire.
A & G Roofing are a Leyland based business offering Roofers... read more »
Woodnook, Lancashire.
Lancashire Roofing Services is a Lancashire based company... read more »
Manchester, Greater Manchester.
All types ov roofing Re-roofs/ Re-pairs Slate Tile Firestone... read more »
Wigan, Greater Manchester.
Pnr roofing are a Wigan based business offering Roofers... read more »
St Helens, Merseyside.
Diamond roofing and property management are a St Helens... read more »
Blackburn, Lancashire.
the Rubber Roofing Company are a Blackburn based business... read more »
Birkenhead, Merseyside.
Varney roofing services ltd are a Birkenhead based business... read more »
Leigh, Greater Manchester.
We take all types of roofing work, flat roof, chimney... read more »
Blackburn, Lancashire.
Hi, We are a family run business and aim to please with... read more »
Manchester, Greater Manchester.
Newton and Sons Roofing Ltd cover Manchester and the... read more »
Manchester, Greater Manchester.
The roofing company are a Manchester based business... read more »
Southport, Merseyside.
New wave are a Southport based business offering Roofers... read more »
Birkenhead, Merseyside.
D Graham Roofing Specialists are a Birkenhead based... read more »
Burscough, Lancashire.
Jv Roofing Solution are a Burscough based business offering... read more »
Birkenhead, Merseyside.
Ray the roofer are a Birkenhead based business offering... read more »
Manchester, Greater Manchester.
Dean price limited are a Manchester based business... read more »
Oldham, Greater Manchester.
Roofworx Ltd is an independent roofing contractor. With... read more »
Sandbach, Cheshire.
Precision roofing & property maintenance strive for 100%... read more »
Manchester, Greater Manchester.
T&G roofers are a Manchester based business offering... read more »
Winsford, Cheshire.
Archie Repairs are a Winsford based business offering... read more »
Accrington, Lancashire.
Abbey Park Roofing Services9 are a Accrington based... read more »
Warrington, Cheshire.
D&k roofing are a Warrington based business offering... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.