menu
close
Search Trades

Find a Tradesperson in Joppa, South Ayrshire

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 listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(55.44332) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-4.52306) ) + sin( radians(55.44332) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=135) ORDER BY distance) 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 Joppa, South Ayrshire
Hamilton, South Lanarkshire.
Curb Appeal are a Hamilton based business offering Driveway... read more »
Irvine, North Ayrshire.
Jats Contracts Ltd are a Irvine based business offering... read more »
Dalry, North Ayrshire.
We are fencing & landscapes company based in north ayrshire... read more »
East Kilbride, South Lanarkshire.
Stevenson Plumbing & Bathrooms are a East Kilbride based... read more »
Ayr, South Ayrshire.
Newalls Garden Maintenance are a Ayr based business... read more »
Paisley, Renfrewshire.
With over 30 years of experience offering plumbing services... read more »
East Kilbride, South Lanarkshire.
J ROOFING AND BUILDING SERVICES. we are a family run... read more »
Paisley, Renfrewshire.
Auto Point Paisley are a Paisley based business offering... read more »
Dalry, North Ayrshire.
Jack McLaughlin Electrical Services Ltd are a Dalry based... read more »
Irvine, North Ayrshire.
Harley Home Improvements & Designs are a Irvine based... read more »
Hamilton, South Lanarkshire.
Here at kosher construction we are a small team of tradesmen... read more »
Irvine, North Ayrshire.
Walkers Electrical are a Irvine based business offering... read more »
Irvine, North Ayrshire.
Hi, I’m Bob your Scottish Based Local Electrician. I... read more »
Ayr, South Ayrshire.
At Artisan Coatings, we offer home improvement services... read more »
Paisley, Renfrewshire.
None are a Paisley based business offering Carpenters,... read more »
Ayr, South Ayrshire.
AirSafe Environmental are a Ayr based business offering... read more »
Irvine, North Ayrshire.
Matthew Donnelly Glassworks is an architectural glass... read more »
East Kilbride, South Lanarkshire.
Jw Assemblys are a East Kilbride based business offering... read more »
Catrine, East Ayrshire.
Catrine Handyman are a Catrine based business offering... read more »
Kilmarnock, East Ayrshire.
Hi we are an experienced team of roofing specialists in... read more »
Linwood, Renfrewshire.
HW Roofing are a Linwood based business offering Roofers... read more »
Ayr, South Ayrshire.
MI2 Builders are a Ayr based business offering Landscaping... read more »
Newmilns, East Ayrshire.
Zest Roofer Ayrshire provides local professional roofing... read more »
Darvel, East Ayrshire.
Rpdhandymanservices are a reliable and friendly local... read more »
Ayr, South Ayrshire.
Kingsway Custom Carpentry Ltd are a Ayr based business... read more »
Darvel, East Ayrshire.
Welcome to Z&J Gas services. We are a relatively new local... read more »
Kilmarnock, East Ayrshire.
Jacksons Joinery & Building Contractors are a Kilmarnock... read more »
New Cumnock, East Ayrshire.
Welcome to Ello Gas LTD At Ello Gas LTD we have over... read more »
Udston, South Lanarkshire.
Plans, conception, reality. Interiors, exteriors, domestic... read more »
Dalrymple, East Ayrshire.
Warm House Heating & Plumbing are a Dalrymple based... read more »

Helping you find Tradespeople in Joppa, South Ayrshire

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

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