menu
close
Search Trades

Find a Tradesperson in Newstead, Staffordshire

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(52.96176) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.15776) ) + sin( radians(52.96176) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=139) 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 Newstead, Staffordshire
Wolverhampton, West Midlands.
Lukes brickwork are a Wolverhampton based business... read more »
Telford, Shropshire.
Hi I'm Miley, owner & Director of Intercounties Paving... read more »
Derby, Derbyshire.
I have 13 years experience in the roofing trade I am... read more »
Wolverhampton, West Midlands.
The Home Hero are a Wolverhampton based business offering... read more »
Wolverhampton, West Midlands.
Taylord Services are a Wolverhampton based business... read more »
Telford, Shropshire.
friendly and reliable self employed bricklayer/builder... read more »
Wolverhampton, West Midlands.
B&C Construction are a Wolverhampton based business... read more »
Tamworth, Staffordshire.
KB Services are a Tamworth based business offering... read more »
Cannock, Staffordshire.
Plumbing, Heating & Maintenance 10 Years experience in... read more »
Telford, Shropshire.
Magic shine are a Telford based business offering... read more »
Stafford, Staffordshire.
Taylormade tiling and plastering are a Stafford based... read more »
Stoke-on-Trent, Staffordshire.
G L T construction are a Stoke-on-Trent based business... read more »
Cannock, Staffordshire.
Rooftrim ltd are a Cannock based business offering Roofers... read more »
Cannock, Staffordshire.
Rooftrim ltd are a Cannock based business offering Roofers... read more »
Stafford, Staffordshire.
Shawsdecor are a Stafford based business offering Painters... read more »
Sandbach, Cheshire.
a1gassafety are a Sandbach based business offering... read more »
Audley, Staffordshire.
Steve davis carpentry are a Audley based business offering... read more »
Oxford, Staffordshire.
Sash windows repair & decorating are a Oxford based... read more »
Winsford, Cheshire.
U.K. Damp Solutions are a Winsford based business offering... read more »
Stafford, Staffordshire.
waste away are a Stafford based business offering Waste... read more »
Crewe, Cheshire.
Barton Property Services are a Crewe based business... read more »
Stafford, Staffordshire.
All power electrical are a Stafford based business offering... read more »
Cannock, Staffordshire.
Cannock Aerials & Satellite are a Cannock based business... read more »
Rolleston on Dove, Staffordshire.
Westwood Ground Maintenance are a Rolleston on Dove based... read more »
Willenhall, West Midlands.
Fastrac are a West Midlands based company who are experts... read more »
Walsall, West Midlands.
Inside Out Property Management Ltd are a Walsall based... read more »
Alsager, Cheshire.
J&R Home Improvement are a Alsager based business offering... read more »
Crewe, Cheshire.
Harlbrook Driveway, Garden & Property Maintenance are a... read more »
Silverdale, Staffordshire.
HJS Jionery & Property Maintenance are a Silverdale based... read more »
Longton, Staffordshire.
K.s.s property maintenance are a Longton based business... read more »

Helping you find Tradespeople in Newstead, Staffordshire

If you are looking for Tradespeople in Newstead, Staffordshire 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, Staffordshire 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, Staffordshire today.

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