menu
close
Search Trades

Tradespeople in Unthank

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.categoryString, a.townID, b.countyID, a.town, a.county, 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, CASE WHEN c.upgrdSpokenTo=1 THEN 1 ELSE 0 END AS secondStageInterview FROM ( SELECT memberID, memberName, memberURL2, memberImage, memberDescr, town, county, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched, categoryString FROM members WHERE isActive=1 AND memberID IN ( SELECT memberID FROM ( SELECT *, MIN( ( 3959 * acos( cos( radians(53.28460) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-1.54398) ) + sin( radians(53.28460) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=46 ) ) 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, MAX(upgrdSpokenTo) AS upgrdSpokenTo FROM listings WHERE listingType>=0 AND expiryDate>NOW() GROUP BY memberID ) c ON a.memberID=c.memberID GROUP BY a.memberID ORDER BY isVerified DESC, listingType DESC
Post your job to find the right tradesperson in Unthank
Operates in Unthank
Branching Out Tree Services are a based business offeri... read more »
Operates in Unthank
Hallam are a based business offering Roofers services... read more »
Operates in Unthank
DW Plastering are a based business offering Plasterers... read more »
Operates in Unthank
KRB Carpet & Flooring Contractors are a based business... read more »
Operates in Unthank
ACJ Builders are a based business offering Builders, Ex... read more »
Operates in Unthank
Rob Staley Plumbing are a based business offering Plum... read more »
Operates in Unthank
Johnson roofing services are a based business offering... read more »
Operates in Unthank
CJ Plumbing We specialise in local call outs to be with... read more »
Operates in Unthank
JCS Plumbing and Heating are a based business offering... read more »
Operates in Unthank
L-A-B-S Damp Proofing & Basement Conversion are a based... read more »
Operates in Unthank
Derbyshire Property Services ltd are a based business o... read more »
Operates in Unthank
DR Building Solutions are a based business offering Pr... read more »
Operates in Unthank
We are family run company offering every aspect of Paint... read more »
Operates in Unthank
C w roofing are a based business offering Roofers servi... read more »
Operates in Unthank
JBarnsley plastering are a based business offering Plas... read more »
Operates in Unthank
Friendly and honest electrician, who strives to provide... read more »
Operates in Unthank
D I A are a based business offering Builders services a... read more »
Operates in Unthank
S.Greaves Roofing are a based business offering Roofer... read more »
Operates in Unthank
Clancy subcontractors are a based business offering Br... read more »
Operates in Unthank
We are electrical engineers and contractors with over 40... read more »
Operates in Unthank
LPS
LPS are a based business offering Plumbers services acr... read more »
Operates in Unthank
JBTiling Solutions are a based business offering Tilin... read more »
Operates in Unthank
Scottys Plastering Services are a based business offeri... read more »
Operates in Unthank
Countryside Services are a based business offering Grou... read more »
Operates in Unthank
NDH Joinery solutions are a based business offering Joi... read more »
Operates in Unthank
Roofnglass are a based business offering Fascias, Soff... read more »
Operates in Unthank
David Firth plumbing and heating are a based business... read more »
Operates in Unthank
GCLS paving and landscaping are a based business offeri... read more »
Operates in Unthank
At m&n property services we are very customer focused an... read more »
Operates in Unthank
Oakenstone Design Planning Build are a based business o... read more »

Helping you find Tradespeople in Unthank

If you are looking for Tradespeople in Unthank then Book a Builder UK is here to connect you with a local trade in your area. Search our pages to find local Tradespeople Unthank where you can view profiles, reviews and photographs of previous work before choosing to contact them.

For the best results, post your job to receive competitive quotes from specialist local trades that are looking for your type of work. Book a Builder UK is a proven and highly successful system used by 1000's of customers to find a tradesperson every month.

Our system ensures that each project is only matched with relevant and suitable suppliers, so post your job with confidence and Find Tradespeople in Unthank today.

© Copyright. BookaBuilderUK.com. 2024. All Rights Reserved.