menu
close
Search Trades

Find a Gardener in Norwich, Norfolk

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(52.62821) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(1.30099) ) + sin( radians(52.62821) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=113) 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
J & J Painting and Decorating logo
Pro member badge
Taverham, Norfolk.
Identity Checked
Proof of Address
2 Stage Interview
Signed Code of Conduct
We are painters and decorators who love our job doing all aspects of the job including: interior painting, exterior painting, minor wall and... read more »
King's Lynn, Norfolk.
Small landscaping company that specialises in tree and... read more »
Norwich, Norfolk.
T.L.P.C Services are a Norwich based business offering... read more »
Norwich, Norfolk.
For all your handyman and flat pack assembly needs! No... read more »
Norwich, Norfolk.
Gardening Plus are a Norwich based business offering... read more »
Downham Market, Norfolk.
Our comprehensive services include: Design, construction... read more »
Norwich, Norfolk.
Welcome to S.Postle Services Hello, I am Simon and I... read more »
Thetford, Norfolk.
Oakdale Construction & Maintenance are a Thetford based... read more »
King's Lynn, Norfolk.
Why choosers us We are a family run business with over... read more »
Whitwell Street, Norfolk.
Muddy Badger are a Whitwell Street based business offering... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.