menu
close
Search Trades

Tradespeople in Publow

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, a.town, a.county, 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, town, county, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched, categoryString FROM members WHERE isActive=1 AND memberID IN ( SELECT memberID FROM ( SELECT *, MIN( ( 3959 * acos( cos( radians(51.37830) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-2.54019) ) + sin( radians(51.37830) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=134 ) ) 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 Publow
Operates in Publow
My name is matthew stone I’m 39 years old. I’ve been... read more »
Operates in Publow
We are the UK's leading portable appliance testing provi... read more »
Operates in Publow
Rafpok are a based business offering Builders services... read more »
Operates in Publow
Smart Plumbing & Heating (SPH) are a professional Gas Sa... read more »
Operates in Publow
Tue, 5 Mar 2019 18:41 Mike Jones (mjbrickwork@a... read more »
Operates in Publow
Hi, We are a leading scaffolding solutions provider of... read more »
Operates in Publow
REEDSPLUMBING are a based business offering Plumbers se... read more »
Operates in Publow
louicrewcarpentryandjoinery are a based business offeri... read more »
Operates in Publow
Mjfowler building services are a based business offerin... read more »
Operates in Publow
I T Builders Wells are a based business offering Builde... read more »
Operates in Publow
Amegan CCTV & Security Ltd are a based business offerin... read more »
Operates in Publow
Dmg mechanical services are a based business offering... read more »
Operates in Publow
elitedecorsouthwest.co.uk are a based business offering... read more »
Operates in Publow
Essential homes are a based business offering Builders... read more »
Operates in Publow
Jns plastering services are a based business offering P... read more »
Operates in Publow
Mike searle plastering are a based business offering P... read more »
Operates in Publow
Cleanline Plastering LTD are a professional reliable ser... read more »
Operates in Publow
M s Dunster groundwork’s ltd are a based business off... read more »
Operates in Publow
Robuild are a based business offering Property Maintena... read more »
Operates in Publow
We are a small professional company which is big enough... read more »
Operates in Publow
Caple are a based business offering Builders services a... read more »
Operates in Publow
Mr.
Mr. are a based business offering Fencing services acro... read more »
Operates in Publow
Workman Roofing and maintenance are a based business o... read more »
Operates in Publow
Dt plumbing and home improvements are a based business... read more »
Operates in Publow
Hi my name is Gary Williams & I have been in the plumbin... read more »
Operates in Publow
Direct home improvements are a based business offering... read more »
Operates in Publow
K middleton building contractor are a based business of... read more »
Operates in Publow
We r a family run business over 25 years of experience w... read more »
Operates in Publow
LH Roofing are a based business offering Roofers servic... read more »
Operates in Publow
Top Glaze windows are a based business offering Double... read more »

Helping you find Tradespeople in Publow

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

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