menu
close
Search Trades

Find a Tradesperson in Great Moor

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.39326) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-2.12928) ) + sin( radians(53.39326) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=69 ) ) 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 Moor
Operates in Great Moor
We are a painting and decorating company, incorporated... read more »
Operates in Great Moor
Homeslea Construction are a based business offering... read more »
Operates in Great Moor
Lee James are a based business offering Bathroom... read more »
Operates in Great Moor
Laroiuse Ltd are a based business offering Garden Services,... read more »
Operates in Great Moor
At polybuild we are a family running firm for over 10... read more »
Operates in Great Moor
Steve’s Painting & Decorating Services are a based... read more »
Operates in Great Moor
Optimize your electrical planning to make informed decisions... read more »
Operates in Great Moor
JRI Decorating Services are a based business offering... read more »
Operates in Great Moor
M60 Brickwork are a based business offering Property... read more »
Operates in Great Moor
PrecisionTile Co are a based business offering Flooring,... read more »
Operates in Great Moor
DB ELECTRICAL SERVICES are a based business offering... read more »
Operates in Great Moor
Just ask and if I can do it I will!! Multiple job... read more »
Operates in Great Moor
We are a small building company who cover all aspects of... read more »
Operates in Great Moor
J N L Roofing are a based business offering Roofers,... read more »
Operates in Great Moor
Jb Interiors are a based business offering Renovations,... read more »
Operates in Great Moor
DNFD Property Maintenance LTD are a based business... read more »
Operates in Great Moor
Prestige Plastering & Rendering are a based business... read more »
Operates in Great Moor
JM Plumbing are a based business offering Plumbers... read more »
Operates in Great Moor
Adrianltd are a based business offering Plasterers,... read more »
Operates in Great Moor
Dar
Dar are a based business offering Electricians, Plumbers... read more »
Operates in Great Moor
We pride ourselves on accommodating all customer needs... read more »
Operates in Great Moor
Vp Plastering are a based business offering Renovations,... read more »
Operates in Great Moor
Sk Joinery are a based business offering Kitchen... read more »
Operates in Great Moor
SMB
SMB are a based business offering Kitchen Installation,... read more »

Helping you find Tradespeople in Great Moor

If you are looking for Tradespeople in Great Moor 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 Moor 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 Moor today.

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