menu
close
Search Trades

Find a Gardener in Colchester, Essex

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=72)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(51.89234) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(0.89787) ) + sin( radians(51.89234) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=62) 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 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
Rq Services logo
Pro member badge
Fobbing, Essex.
2 Stage Interview
Signed Code of Conduct
We are a family run business Over 30yrs of experience in this industries very polite and reliable workforce 
Egidijus Rackevicius logo
Pro member badge
Linford, Essex.
Identity Checked
2 Stage Interview
Signed Code of Conduct
Egidijus Rackevicius are a Linford based business offering Landscaping Contractors, Garden Services, Garden Rooms, Decking Contractors, Patio... read more »
Stutton landscapes and maintenance services logo
Pro member badge
Belstead, Suffolk.
Public Liability
Identity Checked
Proof of Address
2 Stage Interview
Signed Code of Conduct
Stutton maintenance and landscapes services offer hard and soft landscaping and garden maintenance landscape design, painting and decorating... read more »
Jungle E'scapes from unique work trades ltd logo
Lite member badge
Crays Hill, Essex.
Identity Checked
2 Stage Interview
Signed Code of Conduct
Jungle E'scapes from unique work trades ltd are a Crays Hill based business offering Tree Surgeons, Property Maintenance, Landscaping... read more »
Loughton, Essex.
Andy the Handy Man Gardens are a Loughton based business... read more »
Brentwood, Essex.
Mchpaving LTD are a Brentwood based business offering... read more »
Wickford, Essex.
besuredrivesandpatios are a Wickford based business... read more »
Saffron Walden, Essex.
Saffron Shutters & Awnings are a Saffron Walden based... read more »
Clacton-On-Sea, Essex.
Worked in gardening for the past 4 years. Mainly deal... read more »
Basildon, Essex.
Loveable lawns are a Basildon based business offering... read more »
Loughton, Essex.
Cutting Edge Gardening Services are a Loughton based... read more »
Witham, Essex.
Hello my name is John I own and run Here 2 there we do... read more »
Chelmsford, Essex.
Tribe Property are a Chelmsford based business offering... read more »
Chelmsford, Essex.
Eden Horticultural was set up to showcase a higher level... read more »
London Beach, Kent.
-
- are a London Beach based business offering Builders,... read more »
Little London, Essex.
To Me To You Landscaping Ltd are a Little London based... read more »
Barking & Dagenham, London.
A.M Giants LTD are a Barking & Dagenham based business... read more »
Canvey Island, Essex.
We provide a profesional,friendly&punctual garden... read more »
Colchester, Essex.
Our comprehensive services include: artifical... read more »
Redbridge, London.
Our comprehensive services include: Design, construction... read more »
Colchester, Essex.
Our comprehensive services include: Design, construction... read more »
Basildon, Essex.
Sid's Landscaping is your local trustworthy, reliable and... read more »
Colchester, Essex.
I have over 20 years experience in this field & have... read more »
Baldock, Hertfordshire.
If you looking for a one-off job, then our Landscaping... read more »
Stowmarket, Suffolk.
We offer a wide range of services in the Suffolk/Essex/Cambs/Norfolk... read more »
Little London, Essex.
D&D BUILD LTD are a Little London based business offering... read more »
Colchester, Essex.
MAH Garden Services are a Colchester based business... read more »
Southend-on-Sea, Essex.
RS MAINTENANCE SERVICES are a Southend-on-Sea based... read more »
Burnt Mills, Essex.
At A&G gardening and tree care we pride ourselves on being... read more »
Abbey Field, Essex.
O & O gardening services are a Abbey Field based business... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.