menu
close
Search Trades

Find a Tradesperson in Hoop

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, 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, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched, categoryString FROM members WHERE isActive=1 AND memberID IN ( SELECT memberID FROM ( SELECT *, MIN( ( 3959 * acos( cos( radians(51.76407) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-2.70417) ) + sin( radians(51.76407) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=104 ) ) 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 Hoop
Operates in Hoop
ED Plumbing are a based business offering Bathroom... read more »
Operates in Hoop
Jd Flooring are a based business offering Flooring... read more »
Operates in Hoop
IR Heating And Cooling LTD are a based business offering... read more »
Operates in Hoop
Welcome to A&P construction we are happy to assist you... read more »
Operates in Hoop
King's Groundwork Services are a based business offering... read more »
Operates in Hoop
James Kelley are a based business offering Builders,... read more »
Operates in Hoop
Goode Property Solutions "Established in 2015, Goode... read more »
Operates in Hoop
ASF Ltd are a based business offering Driveway Contractors,... read more »
Operates in Hoop
J.G Heating And Plumbing are a based business offering... read more »
Operates in Hoop
Ross On Wye Flooring are a based business offering... read more »
Operates in Hoop
Dragon Valley Electrical are a based business offering... read more »
Operates in Hoop
Wyebuildersandlandscaping Ltd are a based business... read more »
Operates in Hoop
Thomas Roofing Flat Roofing Specialist are a based... read more »
Operates in Hoop
I am a retired General builder having been in the trade... read more »
Operates in Hoop
Kerf Collection is a small furniture manufacturer based... read more »
Operates in Hoop
Rc Home Installations are a based business offering... read more »
Operates in Hoop
C Thomas Contracting Ltd are a based business offering... read more »
Operates in Hoop
Jones Gas And Heating are a based business offering... read more »
Operates in Hoop
JT Carpentry & Maintenance are a based business offering... read more »
Operates in Hoop
DL Home Improvements are a based business offering... read more »
Operates in Hoop
My business covers all aspects of building from landscaping... read more »
Operates in Hoop
Mike Probert Gas And Electrical Services are a based... read more »
Operates in Hoop
We are a family run general building firm with over 30... read more »
Operates in Hoop
Excel Group Bristol Ltd are a based business offering... read more »
Operates in Hoop
Southwest Tree Services And Landscaping are a based... read more »
Operates in Hoop
Seren Property Maintenance are a based business offering... read more »
Operates in Hoop
Lp Carpentry are a based business offering Builders,... read more »
Operates in Hoop
Belle Partnership creates dreams for clients who aspire... read more »
Operates in Hoop
We're a family run business we've been active since 1999... read more »

Helping you find Tradespeople in Hoop

If you are looking for Tradespeople in Hoop then Book a Builder UK is here to connect you with a local trade in your area. Search our pages to find local Tradespeople Hoop 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 Hoop today.

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