Search Trades

Find a Tree Surgeon in the UK

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.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, d.secondStageInterview FROM ( SELECT memberID, memberName, memberURL2, memberImage, memberDescr, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched FROM members WHERE isActive=1 AND memberID IN (SELECT memberID FROM listings WHERE expiryDate>NOW() AND listingID IN (SELECT listingID FROM listingcats WHERE categoryID=59)) ) a INNER JOIN areas b ON LEFT JOIN ( SELECT memberID, 1 AS isPaid, MAX(listingType) AS listingType, MAX(expiryDate) AS expiryDate FROM listings WHERE listingType>=0 AND expiryDate>NOW() GROUP BY memberID ) c ON a.memberID=c.memberID LEFT JOIN ( SELECT memberID, 1 AS secondStageInterview FROM listings WHERE listingType>=0 AND upgrdSpokenTo=1 GROUP BY memberID ) d ON a.memberID=d.memberID GROUP BY a.memberID ORDER BY isVerified DESC, listingType DESC
Book a free wren kitchen design
Stourport-on-Severn, Worcestershire.
We are a family run business, we offer landscaping and... read more »
Otley, West Yorkshire.
Kendall are a Otley based business offering Tree Surgeons... read more »
Cheltenham, Gloucestershire.
Town & Country Gardens are a Cheltenham based business... read more »
Evesham, Worcestershire.
Brett's Tree care and garden services are a Evesham based... read more »
Evesham, Worcestershire.
Hi my name's Brett,. We are new to book my builder!!.Here... read more »
Cirencester, Gloucestershire.
Cotswold tree and gardening is a company with many years... read more »
Waltham Forest, London.
We Do Treework without the retail talk and our knowledge... read more »
Rochford, Essex.
We are a Tree care company who deal with anything from... read more »
Swindon, Wiltshire.
Oakleaftreeandlandscapes are a Swindon based business... read more »
Bournemouth, Dorset.
Ace landscapes are a Bournemouth based business offering... read more »
Coventry, West Midlands.
Stump Removal Services are established tree cutting, stump... read more »
Sheffield, South Yorkshire.
arbco is a family run company with over 25 years in the... read more »
Bedford, Bedfordshire.
We offer a wide range of tree and gardening work from... read more »
Shoreham-By-Sea, West Sussex.
J.D Property Maintenance are a Shoreham-By-Sea based... read more »
Watford, Hertfordshire.
Our services: Our tree Pruning options: Crown... read more »
Kirkham, Lancashire.
Branch Out Tree Care are a Kirkham based business offering... read more »
Blackpool, Lancashire.
Local TreeCare And Landscapes are a Blackpool based... read more »
Newcastle upon Tyne, Tyne and Wear.
We are a northeast based garden maintenance company we... read more »
Havering, London.
D are a Havering based business offering Landscaping... read more »
Folkestone, Kent.
Pg landscaping & property maintenance, will always deliver... read more »
Sunderland, Tyne and Wear.
J are a Sunderland based business offering Tree Surgeons... read more »
Burntwood, Staffordshire.
We specialise in all aspects of flooring all supplied,... read more »
Billingshurst, West Sussex.
Wilson Groundworks are a Billingshurst based business... read more »
Wolverhampton, West Midlands.
The Property Service Specialists! We offer a wide... read more »
Havering, London.
"Mackay Tree Surgery are based in Hornchurch, Essex, and... read more »
Swanley, Kent.
Ab 247 Contractors are a Swanley based business offering... read more »
Central London
Dj Garden And Landscaping Services Ltd are a City of... read more »
Hillingdon, London.
Greengage Garden Maintenance are a Hillingdon based... read more »
Brent, London.
Hi, Thanks for taking 2 minutes of your time to read my... read more »
Cardiff/Caerdydd, Cardiff.
Jay And Z Maintenance are a Cardiff/Caerdydd based... read more »
© Copyright. 2023. All Rights Reserved.