menu
close
Search Trades

Find a Tradesperson in Longham

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.78604) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-1.90916) ) + sin( radians(50.78604) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=49 ) ) 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 Longham
Operates in Longham
ProSparks Electrical Services Ltd are a based business... read more »
Operates in Longham
Mjs Carpentry are a based business offering Property... read more »
Operates in Longham
A family run business with over 55 years combined experience.... read more »
Operates in Longham
All drainage issues covered. 25 years experience, blocked... read more »
Operates in Longham
Elians Ltd are a based business offering Painters &... read more »
Operates in Longham
Jffjkk geeklmm are a based business offering Renovations,... read more »
Operates in Longham
J Clark Carpentertry are a based business offering... read more »
Operates in Longham
L.V.S Plastering are a based business offering Plasterers,... read more »
Operates in Longham
Reggie Pike Plastering are a based business offering... read more »
Operates in Longham
Home Improvement from inside out-CALL US-07387/293354... read more »
Operates in Longham
Henley Roberts limited has undertaken many challenging... read more »
Operates in Longham
Mass Foam Systems are a based business offering Insulation... read more »
Operates in Longham
T.T Plastering & Building are a based business offering... read more »
Operates in Longham
Many years of combined building experience, our team is... read more »
Operates in Longham
Fernfit are a based business offering Double Glazing... read more »
Operates in Longham
Hi, I am a Plumber with 20+ experience in the trade. I... read more »
Operates in Longham
I. S. Rosewood Property Maintenance are a based business... read more »
Operates in Longham
A. G. Dunn Building and Landscaping Services are a based... read more »
Operates in Longham
Paul Feirn, Fiberglassroofs Ltd.... read more »
Operates in Longham
Ccupontheroof.uk are a based business offering Roofers,... read more »
Operates in Longham
We Cut Any Hedge Dot Com are a based business offering... read more »
Operates in Longham
Arborisan are a based business offering Renovations,... read more »
Operates in Longham
A Family run business offering all construction and... read more »
Operates in Longham
Magna Services are a based business offering Boiler/Heating... read more »
Operates in Longham
The Man That Can are a based business offering Painters... read more »
Operates in Longham
1st Rate Roofing values reliability and craftsmanship,... read more »
Operates in Longham
AB Plastering are a based business offering Plasterers... read more »
Operates in Longham
Bridport Electrical Solutions Ltd are a based business... read more »
Operates in Longham
Total Flooring Dorset Ltd are a based business offering... read more »
Operates in Longham
Lee Claydon Landscaping are a based business offering... read more »

Helping you find Tradespeople in Longham

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

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