menu
close
Search Trades

Find a Tradesperson in Alsagers Bank, 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(53.03342) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.29223) ) + sin( radians(53.03342) ) * 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 Alsagers Bank, Staffordshire
Warrington, Cheshire.
We supply and fit all types of high quality flooring... read more »
Warrington, Cheshire.
Ashtons plastering provide a professional and reliable... read more »
Wolverhampton, West Midlands.
Damp proofing specialists basement conversions garage... read more »
Telford, Shropshire.
Hello, we do an array of domestic electrical work from... read more »
Congleton, Cheshire.
15 years experience in the gas/heating industry. Covering... read more »
Stockport, Greater Manchester.
Complete plastering and general joinery service we cover... read more »
Ellesmere Port, Cheshire.
LD Northwest Ltd are a Ellesmere Port based business... read more »
Kidsgrove, Staffordshire.
Gms
Gms are a Kidsgrove based business offering Clearance... read more »
Stretford, Greater Manchester.
Keith Paterson building services are a Stretford based... read more »
Lichfield, Staffordshire.
As small outfit that provides big results. Here at JIW... read more »
Lichfield, Staffordshire.
JIW ELECTRICAL LTD are a Lichfield based business offering... read more »
Widnes, Cheshire.
Hi I’m walter winter my business is a small family firm... read more »
Rugeley, Staffordshire.
Pendleton Bespoke are a Rugeley based business offering... read more »
Telford, Shropshire.
N and G Landscaping are a Telford based business offering... read more »
Stoke on Tern, Shropshire.
Electroking are a Stoke on Tern based business offering... read more »
Boughton Heath, Cheshire.
Lb heating & property maintenance are a Boughton Heath... read more »
Widnes, Cheshire.
MP Refurbishments are a Widnes based business offering... read more »
Lichfield, Staffordshire.
Fradley Roofing Services Ltd are a Lichfield based... read more »
Stockport, Greater Manchester.
Delux decor8 (mcr) ltd are a Stockport based business... read more »
Telford, Shropshire.
We are a company with 30 years experience with all types... read more »
Furness Vale, Derbyshire.
KRB Carpet & Flooring Contractors are a Furness Vale based... read more »
Lichfield, Staffordshire.
Jp property maintenance are a Lichfield based business... read more »
Ashbourne, Derbyshire.
Rob Staley Plumbing are a Ashbourne based business... read more »
Crewe, Cheshire.
DNA Home Improvements are a Crewe based business offering... read more »
Winsford, Cheshire.
D. E building are a Winsford based business offering... read more »
Gatley, Greater Manchester.
Expert floor and wall tilers since 1996 Factory and... read more »
Gnosall, Staffordshire.
Harris roofing are a Gnosall based business offering... read more »
Tamworth, Staffordshire.
Local driveways and landscapes are a Tamworth based... read more »
Crewe, Cheshire.
AJ Building Service are a Crewe based business offering... read more »
Nether Stowe, Staffordshire.
Established in 2010, L.A Roofing specialises in traditional... read more »

Helping you find Tradespeople in Alsagers Bank, Staffordshire

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

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