menu
close
Search Trades

Find a Tradesperson in Great Chell

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(53.06959) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-2.18801) ) + sin( radians(53.06959) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=139 ) ) 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 Great Chell
Operates in Great Chell
Our services encompass a wide spectrum of outdoor solutions.... read more »
Operates in Great Chell
All aspects of painting and decorating. Family run business... read more »
Operates in Great Chell
Left full time job too go self employed too do what I... read more »
Operates in Great Chell
R&R Developments are a based business offering Extension... read more »
Operates in Great Chell
Marshall Lancaster Plastering are a based business... read more »
Operates in Great Chell
Preston Plumbing And Heating Ltd are a based business... read more »
Operates in Great Chell
Jsm Projects are a based business offering Carpenters,... read more »
Operates in Great Chell
Family run business been running for 12 years we specialise... read more »
Operates in Great Chell
Alec Trawford Building Services are a based business... read more »
Operates in Great Chell
At Stoke on Trent Roofers, we specialize in providing... read more »
Operates in Great Chell
Arpropertyservices-ta Fixerly are a based business... read more »
Operates in Great Chell
Wildwood Tree Care are a based business offering Tree... read more »
Operates in Great Chell
Hi,we are a small company based in Tamworth. We are... read more »
Operates in Great Chell
R A Installations are a based business offering Plumbers,... read more »
Operates in Great Chell
Ashton General Maintenance are a based business offering... read more »
Operates in Great Chell
Draper Roofing are a based business offering Roofers... read more »
Operates in Great Chell
European PCB are a based business offering Flooring,... read more »
Operates in Great Chell
Hi my name is Tom, here at Rusty Horseshoe we pride... read more »
Operates in Great Chell
V&l Roofing are a based business offering Roofers services... read more »
Operates in Great Chell
As a local professional family business, TD Construction... read more »
Operates in Great Chell
Matt Terry are a based business offering Plumbers,... read more »
Operates in Great Chell
Dream Home Renovations are a based business offering... read more »
Operates in Great Chell
We do all types of landscaping...patios,astro turf you... read more »
Operates in Great Chell
Bebuddy Group LTD are a based business offering Builders,... read more »
Operates in Great Chell
Mf Carpentry And Construction are a based business... read more »
Operates in Great Chell
Firstchoice Landscapes Gardening Services are a based... read more »
Operates in Great Chell
I have 39 years experience in the Plastering trade and... read more »
Operates in Great Chell
Tl Painter are a based business offering Painters &... read more »
Operates in Great Chell
Stoke-on-trent are a based business offering Extension... read more »
Operates in Great Chell
D&F Safe And Secure are a based business offering Roofers... read more »

Helping you find Tradespeople in Great Chell

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

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