menu
close
Search Trades

Find a Tradesperson in Coven Lawn, 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.64715) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.14185) ) + sin( radians(52.64715) ) * 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 Coven Lawn, Staffordshire
Birmingham, West Midlands.
DJG Heating & Plumbing Services LTD are a Birmingham based... read more »
Stoke-on-Trent, Staffordshire.
Staffs property maintenance ltd are a Stoke-on-Trent based... read more »
Stafford, Staffordshire.
Trigg Roofing Specialists are a Stafford based business... read more »
Birmingham, West Midlands.
We are four peoples running our business together as... read more »
Birmingham, West Midlands.
Mobac services are a Birmingham based business offering... read more »
Dudley, West Midlands.
PDP plastering and property services are a Dudley based... read more »
Kidderminster, Worcestershire.
Full flow plumbing offers services from a leaky tap to... read more »
Wolverhampton, West Midlands.
CC Carpentry are a Wolverhampton based business offering... read more »
Birmingham, West Midlands.
Nh electrical are a Birmingham based business offering... read more »
Stourbridge, West Midlands.
At Stourbridge Decorators we can offer a solution to all... read more »
Stafford, Staffordshire.
TRF Building LTD are a Stafford based business offering... read more »
Birmingham, West Midlands.
P&T Roofing provides high quality roofing systems couting... read more »
London Fields, West Midlands.
Kls services ltd are a London Fields based business... read more »
Birmingham, West Midlands.
We are an established Building and Civil engineering... read more »
Blurton, Staffordshire.
CEF Property Solutions ltd are a Blurton based business... read more »
Redditch, Worcestershire.
M J building services are a Redditch based business... read more »
Rugeley, Staffordshire.
A 24 hour emergency locksmith covering Rugeley, Stafford,... read more »
Newtown, West Midlands.
Running for over 10 years now, Extensions, Outhouses,... read more »
Sutton Coldfield, West Midlands.
We are a Family run company that has built a solid... read more »
Wolverhampton, West Midlands.
JoNick are a Wolverhampton based business offering... read more »
Birmingham, West Midlands.
Angus Solutions Handyman Services & Home Improvements -... read more »
Walsall Wood, West Midlands.
A Sall Plumbing and Gas are a Walsall Wood based business... read more »
Telford, Shropshire.
Ukhousemaintenance are a Telford based business offering... read more »
Birmingham, West Midlands.
Philcush builders are a Birmingham based business offering... read more »
Swadlincote, Derbyshire.
HeatSource Services Limited are a Swadlincote based... read more »
Walsall, West Midlands.
Decorating painting are a Walsall based business offering... read more »
Dudley, West Midlands.
J T Decorators Ltd are a Dudley based business offering... read more »
Birmingham, West Midlands.
We are a newly formed decorating company who are based... read more »
Bewdley, Worcestershire.
We offer professional services such as; block paving,... read more »
Shrewsbury, Shropshire.
Steve Bebb Building Services offers a wide rang of building... read more »

Helping you find Tradespeople in Coven Lawn, Staffordshire

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

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