menu
close
Search Trades

Find a Tradesperson in Lanjew

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(50.44566) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-4.83942) ) + sin( radians(50.44566) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=40 ) ) 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 Lanjew
Operates in Lanjew
Southwest driveways limited are a based business offering... read more »
Operates in Lanjew
Southwest driveways are a based business offering Builders... read more »
Operates in Lanjew
Professional Property Maintenance are a based business... read more »
Operates in Lanjew
At plan it build we take our clients ideas and turn them... read more »
Operates in Lanjew
SH2 Limited based in Hayle, Cornwall We are a family run... read more »
Operates in Lanjew
construction company in London, providing Serve Me Anytime... read more »
Operates in Lanjew
JD Services are a based business offering Builders... read more »
Operates in Lanjew
James Brown are a based business offering Carpenters,... read more »
Operates in Lanjew
Resin Your Roof are a based business offering Builders,... read more »
Operates in Lanjew
JG Building and Roofing are a based business offering... read more »
Operates in Lanjew
20 years experience in the building trade, fully insured,... read more »
Operates in Lanjew
Building company based in North Cornwall. We undertake... read more »
Operates in Lanjew
Property solutions SW are a based business offering... read more »
Operates in Lanjew
Pitched & Flat Roofing Specialists covering Falmouth and... read more »
Operates in Lanjew
Property solutions SW are a based business offering... read more »
Operates in Lanjew
Revive Domestic Cleaning Ltd are a based business offering... read more »
Operates in Lanjew
Here at DSP plumbing we cover all aspects of plumbing... read more »
Operates in Lanjew
Here at g and d surfaces we cover drives patios walkways... read more »
Operates in Lanjew
We are a small local business who cater for all types of... read more »
Operates in Lanjew
We are a family run business and pride ourself in having... read more »
Operates in Lanjew
Daisy Herdman Carpentry are a based business offering... read more »
Operates in Lanjew
BATM scaffolding ltd are a based business offering... read more »
Operates in Lanjew
Ruslan are a based business offering Carpenters, Builders... read more »
Operates in Lanjew
I am an experienced floor layer. Professional fitting... read more »
Operates in Lanjew
Jack blackburn electrical ltd are a based business... read more »
Operates in Lanjew
When it comes to property services in Launceston, make... read more »
Operates in Lanjew
Ben Brown Carpentry and Construction are a based business... read more »
Operates in Lanjew
Setan plumbing, heating & electrical are a based business... read more »
Operates in Lanjew
C&J Removals has been providing removal services in... read more »
Operates in Lanjew
Friendly and honest aproach i cover most repairs. From... read more »

Helping you find Tradespeople in Lanjew

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

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