menu
close
Search Trades

Find a Tradesperson in Alstonefield, 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.09654) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.79985) ) + sin( radians(53.09654) ) * 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 Alstonefield, Staffordshire
Stafford, Staffordshire.
Sherwin s builders ltd are a Stafford based business... read more »
Nottingham, Nottinghamshire.
Jmr roofing are a Nottingham based business offering... read more »
Hull End, Derbyshire.
Allen builders are a Hull End based business offering... read more »
Stafford, Staffordshire.
AK building & restoration limited are a Stafford based... read more »
Tamworth, Staffordshire.
eco flow plumbing and heating ltd are a Tamworth based... read more »
Nottingham, Nottinghamshire.
Eddy ltd are a Nottingham based business offering Painters... read more »
Nottingham, Nottinghamshire.
Ibl plastering services are a Nottingham based business... read more »
Burton Manor, Staffordshire.
Cresco Heating Services Ltd are a Burton Manor based... read more »
Burntwood, Staffordshire.
AD Building Services are a Burntwood based business... read more »
Sheffield, South Yorkshire.
South Yorkshire Pro Tiling are a Sheffield based business... read more »
Coalville, Leicestershire.
East Midlands cladding&roofing are a Coalville based... read more »
Derby, Derbyshire.
B&h Roofing And Building are a Derby based business... read more »
Nantwich, Cheshire.
Wrenbury Joiner are a Nantwich based business offering... read more »
Lichfield, Staffordshire.
Lichfield home and garden are a Lichfield based business... read more »
Stockport, Greater Manchester.
JS PAINTING DECORATING are a Stockport based business... read more »
Abbey Hey, Greater Manchester.
Pj.joinery are a Abbey Hey based business offering Kitchen... read more »
Sheffield, South Yorkshire.
Plastering designs are a Sheffield based business offering... read more »
Burntwood, Staffordshire.
Smr carpentry and home renovations are a Burntwood based... read more »
Nottingham, Nottinghamshire.
Smart attack roofing are a Nottingham based business... read more »
Nottingham, Nottinghamshire.
Here at all aspects roofing company Nottingham We thrive... read more »
Beeston, Nottinghamshire.
Hi , at SAB Property Services i strive to keep the customers... read more »
Nottingham, Nottinghamshire.
BRS
BRS are a Nottingham based business offering Plasterers,... read more »
Derby, Derbyshire.
A & N home and business improvements are a Derby based... read more »
Mansfield, Nottinghamshire.
Hi, my name is Jordan and I am a self employed plasterer.... read more »
Dronfield, Derbyshire.
Mark Gray Security are a Dronfield based business offering... read more »
Sheffield, South Yorkshire.
Peal construction are a Sheffield based business offering... read more »
Sheffield, South Yorkshire.
B B Plumbing services are a Sheffield based business... read more »
Sandbach, Cheshire.
J K Roofline offer all Roofing services in Manchester and... read more »
Derby, Derbyshire.
Hi I'm a fully qualified Domestic Installer & Electrical... read more »
Mansfield, Nottinghamshire.
S bullimore construction are a Mansfield based business... read more »

Helping you find Tradespeople in Alstonefield, Staffordshire

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

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