menu
close
Search Trades

Find a Tradesperson in Newstead

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.96176) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-2.15776) ) + sin( radians(52.96176) ) * 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 Newstead
Operates in Newstead
We are a small business who pride ourselves on personal... read more »
Operates in Newstead
Fully insured walls and floor tiling specialists Full... read more »
Operates in Newstead
We are a fencing company with over 10 years of experience... read more »
Operates in Newstead
Place Lift Property Renovations are a based business... read more »
Operates in Newstead
Jack Smithson are a based business offering Painters &... read more »
Operates in Newstead
A PARRISH PLASTERING are a based business offering... read more »
Operates in Newstead
Gas Mark are a based business offering Boiler/Heating... read more »
Operates in Newstead
As a self-employed person with 3 years experience , I and... read more »
Operates in Newstead
KAB Gardens And Landscaping are a based business offering... read more »
Operates in Newstead
Steve Ferneyhough Plumbing Services are a based business... read more »
Operates in Newstead
P Allen Decorating Services are a based business offering... read more »
Operates in Newstead
Welcome to R.E Roofing & Property Maintenance. We... read more »
Operates in Newstead
Banks Gardening Services are a based business offering... read more »
Operates in Newstead
Render UK are a based business offering Plasterers... read more »
Operates in Newstead
NB Joinery are a based business offering Kitchen... read more »
Operates in Newstead
Covering The Midlands. Damp Proofing Experts For Rising... read more »
Operates in Newstead
Here at staffs building solutions we offer full packages... read more »
Operates in Newstead
I'm Staffordshire based home improvement company , that's... read more »
Operates in Newstead
Biddulph Home And Garden are a based business offering... read more »
Operates in Newstead
Rose Renovations are a based business offering Kitchen... read more »
Operates in Newstead
Hi, I’m Steve from SB Painters & Decorators and run our... read more »
Operates in Newstead
Kgs Gas Services are a based business offering Boiler/Heating... read more »
Operates in Newstead
Carvel Exclusive are a based business offering Extension... read more »
Operates in Newstead
None are a based business offering Renovations services... read more »
Operates in Newstead
Nick’s Plastering & Home Improvements are a based... read more »
Operates in Newstead
Select-A-Service Property Maintenance Handyman Services... read more »
Operates in Newstead
HD Roofing are a based business offering Builders,... read more »
Operates in Newstead
At Home Energy Save Ltd we are specialists in all fields... read more »
Operates in Newstead
Argyle Cross are a based business offering Painters &... read more »
Operates in Newstead
One Way Electrical are a based business offering... read more »

Helping you find Tradespeople in Newstead

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

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