menu
close
Search Trades

Find a Landscaping Contractor 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.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 CONCAT(',', categoryIDs, ',') LIKE ',%50%,' 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, 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
Book a free wren kitchen design
Havering, London.
LJ Designs and Landscapes Ltd offer a wide variety of... read more »
Lewisham, London.
We offer upto 20% discount if used through... read more »
Central London
rea construction ltd are a City of London based business... read more »
Abingdon-on-Thames, Oxfordshire.
Introducing Woodbörd: a truly unique decking material... read more »
Southend-on-Sea, Essex.
1st Class Driveways are a reliable Driveway specialist... read more »
Hillingdon, London.
We offer all aspects of Roofing services. From a complete... read more »
Wickford, Essex.
All Seasons Landscaping and Tree Care are located in... read more »
Basildon, Essex.
Churchill Roofing and Building are a Basildon based... read more »
Woodbridge, Suffolk.
D J Moyse Surfacing are a Woodbridge based business... read more »
Billericay, Essex.
Essex Driveways & Resin Ltd are a Billericay based business... read more »
Havering, London.
Britannia Contractors are a Havering based business... read more »
Harlow, Essex.
TML Construction Ltd are a Harlow based business offering... read more »
Canvey Island, Essex.
King landscape solutions are a Canvey Island based... read more »
Basildon, Essex.
T Poole Brickwork & Building Contractors Ltd are a Basildon... read more »
Havering, London.
AJ Construction south Ltd specialise in all aspects of... read more »
Colchester, Essex.
Welcome to Just Trees Limited We cover all aspects of... read more »
Basildon, Essex.
Grange landscaping are a Basildon based business offering... read more »
Basildon, Essex.
Profile Photos Reviews About Grange Landscaping -... read more »
St Neots, Cambridgeshire.
Well Built Ltd offer a wide range of Building services... read more »
Brentwood, Essex.
Loren landscaping Ltd are a Brentwood based business... read more »
Havering, London.
Spenwell General Builders offer a wide range of Building... read more »
Waltham Abbey, Essex.
Home Counties Driveways & Patios ltd... read more »
Chelmsford, Essex.
LJ Landscapes are a Chelmsford based business offering... read more »
Harpenden, Hertfordshire.
Marshalls Paving & Landscaping are a Harpenden based... read more »
Halstead, Essex.
Welcome to JCL Contracts, your local Landscape Specialists! We... read more »
Harlow, Essex.
Local Landscape Services are a small company based in... read more »
Havering, London.
Capricorn Landscapes are a Havering based business... read more »
Woodbridge, Suffolk.
General builder. Roofing. Painting. Carpentry. Kitchens.... read more »
Ipswich, Suffolk.
HS Carpentry are a Ipswich based business offering... read more »
Haverhill, Suffolk.
Gk Building and Landscaping Services are a Haverhill... read more »

Helping you find Landscaping Contractors in Colchester, Essex

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

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