menu
close
Search Trades

Find a Roofer in Edinburgh, City of Edinburgh

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(55.94904) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-3.16250) ) + sin( radians(55.94904) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=34) 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
Shaun Elder Roofing Contractors logo
Pro member badge
Chapel, Fife.
2 Stage Interview
Signed Code of Conduct
Shaun Elder Roofing Contractors are a Chapel based business offering Builders, Roofers, Renovations, Property Maintenance services across... read more »
Vertex Scaffolding Ltd logo
Pro member badge
Brunstane, City of Edinburgh.
Public Liability
Identity Checked
2 Stage Interview
Signed Code of Conduct
Hi guys, We are a local scaffolding company, looking to tender for any upcoming works you may have. We offer a very competitive rate. Please... read more »
Kirkcaldy, Fife.
Reid roofing and builders are a Kirkcaldy based business... read more »
Kirkcaldy, Fife.
Direct Response Roofing & Groundworks are a Kirkcaldy... read more »
Kirkcaldy, Fife.
Welcome to Rowan Roofing and Painting, We are roofers in... read more »
Kirkcaldy, Fife.
Blair roofing are a Kirkcaldy based business offering... read more »
Falkirk, Falkirk.
A & J Property Care are a Falkirk based business offering... read more »
Falkirk, Falkirk.
J Harvey Roofing are a Falkirk based business offering... read more »
Edinburgh, City of Edinburgh.
Master craft roofing are a Edinburgh based business... read more »
Dunfermline, Fife.
Reliable roofing solutions based in Dunfermline, Fife... read more »
Buckhaven, Fife.
This is a local family business been established for... read more »
Kirkcaldy, Fife.
Affordable Roofing are a Kirkcaldy based business offering... read more »
Falkirk, Falkirk.
Helixroofing are a Falkirk based business offering Roofers,... read more »
Inverkeithing, Fife.
LMD Home Improvements are a Inverkeithing based business... read more »
Livingston Village, West Lothian.
Broch Construction Ltd are a Livingston Village based... read more »
Fauldhouse, West Lothian.
Fine Line Property Care are a Fauldhouse based business... read more »
Bow of Fife, Fife.
Grubb Roofing Ltd are a Bow of Fife based business offering... read more »
Edinburgh, City of Edinburgh.
LawRoofing are a Edinburgh based business offering Roofers... read more »
Edinburgh, City of Edinburgh.
We undertake all building & joinery Structural walls... read more »
Shotts, North Lanarkshire.
Golden Oak Property Care are a Shotts based business... read more »
Edinburgh, City of Edinburgh.
R A Contractor are a Edinburgh based business offering... read more »
Glenrothes, Fife.
JSJ Building Contracts are a Glenrothes based business... read more »
Kirkcaldy, Fife.
Kingdom Roofing are a Kirkcaldy based business offering... read more »
Alloa, Clackmannanshire.
Forth Valley Roofing is a local, family run business who... read more »
Cupar, Fife.
A.Millar Roofing are a Cupar based business offering... read more »
Edinburgh, City of Edinburgh.
Lasswade Roofing And Building are a Edinburgh based... read more »
Edinburgh, City of Edinburgh.
The Edinburgh Flooring Company are a Edinburgh based... read more »
North Berwick, East Lothian.
Direct Roofing Services are a North Berwick based business... read more »
Falkirk, Falkirk.
M R CONTRACTORS are a Falkirk based business offering... read more »
Kirkcaldy, Fife.
Armour Roofing and Slating Services in Fife, is an... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.