menu
close
Search Trades

Find a Tradesperson in Mavesyn Ridware

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(52.74606) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-1.87552) ) + sin( radians(52.74606) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=139 ) ) 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 Mavesyn Ridware
Operates in Mavesyn Ridware
A P Getley Installations are a based business offering... read more »
Operates in Mavesyn Ridware
Stansbie Building are a based business offering Builders,... read more »
Operates in Mavesyn Ridware
Painting And Decorating By Kirsty are a based business... read more »
Operates in Mavesyn Ridware
TJB Plastering Staffs are a based business offering... read more »
Operates in Mavesyn Ridware
DJE Joinery & Developments Ltd are a based business... read more »
Operates in Mavesyn Ridware
WRS Builders are a based business offering Builders,... read more »
Operates in Mavesyn Ridware
Miki are a based business offering Electricians, Painters... read more »
Operates in Mavesyn Ridware
Riccoh Paving are a based business offering services... read more »
Operates in Mavesyn Ridware
MK Servises are a based business offering Carpenters... read more »
Operates in Mavesyn Ridware
KN Electrical Services has been running for over 15 years.... read more »
Operates in Mavesyn Ridware
Allbuild Contractors are a based business offering... read more »
Operates in Mavesyn Ridware
Rangescapes is known for its eco-friendly, quality... read more »
Operates in Mavesyn Ridware
We are a family run business with over 35 years of... read more »
Operates in Mavesyn Ridware
S S Maintenance are a based business offering Kitchen... read more »
Operates in Mavesyn Ridware
Sd Property Maintenance are a based business offering... read more »
Operates in Mavesyn Ridware
Multi-Men Building are a based business offering Plasterers,... read more »
Operates in Mavesyn Ridware
Dave Howard Plastering Services are a based business... read more »
Operates in Mavesyn Ridware
Raven is family run business dedicated to roofing services... read more »
Operates in Mavesyn Ridware
J & B Property Services are a based business offering... read more »
Operates in Mavesyn Ridware
SEB PLASTERING are a based business offering Plasterers... read more »
Operates in Mavesyn Ridware
Alpha home improvements are a based business offering... read more »
Operates in Mavesyn Ridware
M J TILING are a based business offering Tiling... read more »
Operates in Mavesyn Ridware
First class roofing been doing it for 15 years making... read more »
Operates in Mavesyn Ridware
E.k.r Construction & Double Glazing Ltd are a based... read more »
Operates in Mavesyn Ridware
Hi I'm Tristan I have over 10-years experience .with full... read more »
Operates in Mavesyn Ridware
Fitzgeralds Electrical are a based business offering... read more »
Operates in Mavesyn Ridware
Rafiu05 are a based business offering Property Maintenance... read more »
Operates in Mavesyn Ridware
Newly qualified and looking to build my portfolio. Plumbing... read more »
Operates in Mavesyn Ridware
Elite roofers and landscapes at ure service we like to... read more »
Operates in Mavesyn Ridware
EXPERT ROOF CLEANING IN THE STOKE ON TRENT AREA &... read more »

Helping you find Tradespeople in Mavesyn Ridware

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

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