menu
close
Search Trades

Find a Tradesperson in Ham Green

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 ( SELECT *, MIN( ( 3959 * acos( cos( radians(51.38555) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(0.65012) ) + sin( radians(51.38555) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=89 ) ) 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 Ham Green
Operates in Ham Green
Pl Construction are a based business offering Builders,... read more »
Operates in Ham Green
GF New Building Style Ltd are a based business offering... read more »
Operates in Ham Green
TPE Groundwork & construction If you are thinking of... read more »
Operates in Ham Green
Spiller Electrical Services are a based business offering... read more »
Operates in Ham Green
No job too big or too small. Fully insured and specialise... read more »
Operates in Ham Green
We are a small company able to carry out all types of... read more »
Operates in Ham Green
Committed to Excellence Introducing AJ Roofing... read more »
Operates in Ham Green
Welcome to Skinners decorating here to provide a professional... read more »
Operates in Ham Green
Bwise Builders Ltd undertake all building work in... read more »
Operates in Ham Green
Prestige driveways are a based business offering... read more »
Operates in Ham Green
Futurahouse LTD are a based business offering Extension... read more »
Operates in Ham Green
We are a family run Plumbing and Heating company, we... read more »
Operates in Ham Green
Whether you require domestic, industrial or commercial... read more »
Operates in Ham Green
E R Property Services are a based business offering... read more »
Operates in Ham Green
Welcome to Kent Heating & Cooling LTD. We are a plumbing... read more »
Operates in Ham Green
Mark tillbrook are a based business offering Painters... read more »
Operates in Ham Green
K t property development are a based business offering... read more »
Operates in Ham Green
Alpha Walls Construction Ltd are a based business offering... read more »
Operates in Ham Green
Welcome to RWD Electrical Ltd I have many years... read more »
Operates in Ham Green
Fishers gardens are a based business offering Landscaping... read more »
Operates in Ham Green
Austin Design build maintain LTD are a based business... read more »
Operates in Ham Green
The door and window company are a based business offering... read more »
Operates in Ham Green
We are a family run business hard dedicated workers that... read more »
Operates in Ham Green
C & P Construction are a based business offering Builders,... read more »
Operates in Ham Green
A F Glass are a based business offering Double Glazing... read more »
Operates in Ham Green
CLE Heating are a based business offering Plumbers... read more »
Operates in Ham Green
CLE Heating are a based business offering Plumbers... read more »
Operates in Ham Green
Ashford Building And Carpenty are a based business... read more »
Operates in Ham Green
Pristine Painters are a based business offering Painters... read more »
Operates in Ham Green
Marshall's Building Contractors Ltd are a based business... read more »

Helping you find Tradespeople in Ham Green

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

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