menu
close
Search Trades

Find a Tradesperson in Mayford

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(51.29894) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-0.57421) ) + sin( radians(51.29894) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=143 ) ) 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 Mayford
Operates in Mayford
RS Carpentry are a based business offering Kitchen... read more »
Operates in Mayford
Here at t's handy services our aim is to offer a great... read more »
Operates in Mayford
Mac Francis Building And Paving are a based business... read more »
Operates in Mayford
Home maintenance has always been time-consuming and... read more »
Operates in Mayford
Palkovics are a based business offering Painters &... read more »
Operates in Mayford
Quality Guaranteed are a based business offering Extension... read more »
Operates in Mayford
Rightways is a family company that has been going for... read more »
Operates in Mayford
MD Roofing Services are a based business offering Roofers... read more »
Operates in Mayford
Alpha 1 Drainage are a based business offering Drainage... read more »
Operates in Mayford
I have over 10 years experience from main roofs to minor... read more »
Operates in Mayford
Down To Earth Property Maintenance are a based business... read more »
Operates in Mayford
Raw Roofing are a based business offering Roofers... read more »
Operates in Mayford
Aspire Electrical Services Ltd are a based business... read more »
Operates in Mayford
Alma Construct Ltd are a based business offering Bathroom... read more »
Operates in Mayford
OJ Properties Services are a based business offering... read more »
Operates in Mayford
Weatherguard are a based business offering Roofers,... read more »
Operates in Mayford
Paradise G W L Internal And External Painting Decorating... read more »
Operates in Mayford
Belview Homes are a based business offering Bathroom... read more »
Operates in Mayford
S
S are a based business offering Kitchen Installation,... read more »
Operates in Mayford
Lake Prospects are a based business offering Landscaping... read more »
Operates in Mayford
Rosedeep Ltd are a based business offering Property... read more »
Operates in Mayford
ANGLIAN HOME IMPROVEMENTS are a based business offering... read more »
Operates in Mayford
Any building project should only be entrusted to professional... read more »
Operates in Mayford
HMD Painting are a based business offering Painters &... read more »
Operates in Mayford
JGP Developments is my company, specialising in brickwork... read more »
Operates in Mayford
We have impeccable attention to detail, priding ourself... read more »
Operates in Mayford
Cj Fencing Limited are a based business offering... read more »
Operates in Mayford
Armitage Landscapes are a based business offering... read more »
Operates in Mayford
DBG Groundwork / Landscape are a based business offering... read more »
Operates in Mayford
Dram are a based business offering Plumbers services... read more »

Helping you find Tradespeople in Mayford

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

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