menu
close
Search Trades

Find a Landscaping Contractor in Newcastle upon Tyne, Tyne and Wear

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=50)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(54.97447) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.60316) ) + sin( radians(54.97447) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=149) 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
TPS logo
Pro member badge
Darlington, County Durham.
TPS
Public Liability
Identity Checked
2 Stage Interview
Signed Code of Conduct
Here at TPS LTD we are a fully licensed & insured limited company based in bishop Auckland county durham. We specialise in all aspects of... read more »
RDugdale Groundworks logo
Pro member badge
Brierton, County Durham.
Identity Checked
2 Stage Interview
Signed Code of Conduct
We are an Hartlepool based company that covers a 50 miles radius including Sunderland, Newcastle, Yarm and surrounding areas. We specialise... read more »
Dead Centre Ltd logo
Pro member badge
Lobley Hill, Tyne and Wear.
Signed Code of Conduct
Dead Centre Ltd are a Lobley Hill based business offering Builders, Kitchen Installation, Bathroom Installation, Landscaping Contractors,... read more »
Adw gardening services & property maintenance logo
Pro member badge
Denton Burn, Tyne and Wear.
Signed Code of Conduct
Adw gardening services & property maintenance are a Denton Burn based business offering Builders, Landscaping Contractors, Driveway Contractors,... read more »
JB GROUNDWORKS (NORTHEAST) LTD logo
Pro member badge
Castleside, County Durham.
Public Liability
Identity Checked
2 Stage Interview
Signed Code of Conduct
JB GROUNDWORKS (NORTHEAST) LTD Provides customers with quality services around the northeast. We offer a wide range of services in this... read more »
A & J Crawford Construction logo
Pro member badge
Lemington, Tyne and Wear.
2 Stage Interview
Signed Code of Conduct
Welcome to A & J Crawford Construction We carry out all aspects of building work in Newcastle Please call 07932 161796
CB Paving And Driveways Ltd logo
Pro member badge
Roseworth, County Durham.
Identity Checked
2 Stage Interview
Signed Code of Conduct
We have over 10 years experience working on different projects throughout the country working for large building contractors and after been... read more »
Adapt Your Home For Life Ltd logo
Pro member badge
Newcastle upon Tyne, Tyne and Wear.
Identity Checked
2 Stage Interview
Signed Code of Conduct
Adapt your home for life offers a personalised home improvement service in the North East ensuring you and your family continue living in... read more »
Sunderland, Tyne and Wear.
We are a honest, reliable, friendly company, providing... read more »
Newcastle upon Tyne, Tyne and Wear.
We operate throughout northeast England, we offer a range... read more »
Hartlepool, County Durham.
Robinson’s landscapes NE are a Hartlepool based business... read more »
Newcastle upon Tyne, Tyne and Wear.
Rynopave home improvements are a Newcastle upon Tyne... read more »
Hexham, Northumberland.
the tarmac and paving company are a Hexham based business... read more »
Newcastle upon Tyne, Tyne and Wear.
We cater for all your interior and exterior work.we... read more »
Gateshead, Tyne and Wear.
We are a family run property maintenance business and... read more »
Washington, Tyne and Wear.
Small, friendly and professional fencing company based... read more »
Durham, County Durham.
Ar landscaping and groundwork’s are a Durham based... read more »
Hartlepool, County Durham.
DL Building services are a Hartlepool based business... read more »
Hartlepool, County Durham.
Lawn"n"order are a Hartlepool based business offering... read more »
Stockton-on-Tees, County Durham.
KG STAR SERVICES are a Stockton-on-Tees based business... read more »
Durham, County Durham.
Self employed landscape gardener est since 2009 We take... read more »
Ponteland, Northumberland.
we are a family run company and pride our selfs on the... read more »
Durham, County Durham.
dpslandscaping are a Durham based business offering... read more »
Newcastle upon Tyne, Tyne and Wear.
Pavecraft Northeast are a Newcastle upon Tyne based... read more »
Gateshead, Tyne and Wear.
Advanced Property Maintenance are a Gateshead based... read more »
Newcastle upon Tyne, Tyne and Wear.
Sdb
Sdb are a Newcastle upon Tyne based business offering... read more »
Peterlee, County Durham.
Here at Blueprint we provide a quality professional service... read more »
Esh Winning, County Durham.
A.C.G.ltd. are a Esh Winning based business offering... read more »
Gateshead, Tyne and Wear.
STN Engineering Services Ltd are a Gateshead based business... read more »
Gateshead, Tyne and Wear.
After beginning my working life as an apprentice fabricator... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.