menu
close
Search Trades

Find a Plumber 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=47)) 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
Post your job to find the right tradesperson in Norwich, Norfolk
Brampton, Suffolk.
AUSTIN'S Plumbing And Drainage And Property Services are... read more »
Hunstanton, Norfolk.
CPMS are a Hunstanton based business offering Landscaping... read more »
Norwich, Norfolk.
Ljw plumbing&bathrooms are a Norwich based business... read more »
Walcott, Norfolk.
Coleman contracting are a Walcott based business offering... read more »
Gunton, Suffolk.
T.B Plumbing Services are a Gunton based business offering... read more »
Wymondham, Norfolk.
Wymtek Heating and Plumbing are a Wymondham based business... read more »
Melton Constable, Norfolk.
Star construction and landscaping are a Melton Constable... read more »
Carlton, Suffolk.
M S Property Services are a Carlton based business offering... read more »
Southtown, Norfolk.
All-Pro Plastering are a Southtown based business offering... read more »
Swardeston, Norfolk.
Heat Control Ltd are a Swardeston based business offering... read more »
Carlton Colville, Suffolk.
Fully Insured Domestic Plumbing Services Bathroom... read more »
Thorpe St Andrew, Norfolk.
Simmons Plumbing / Handyman are a Thorpe St Andrew based... read more »
Sporle, Norfolk.
L J Bathrooms are a Sporle based business offering Bathroom... read more »
Bloodman's Corner, Suffolk.
T Molloy Services are a Bloodman's Corner based business... read more »
Harleston, Norfolk.
M And J Home Improvements are a Harleston based business... read more »
Walpole Cross Keys, Norfolk.
B.A.K Plumbing & Heating are a Walpole Cross Keys based... read more »
Earlham, Norfolk.
Plumbing NR are a Earlham based business offering Plumbers... read more »
Thetford, Norfolk.
Hi I have been a self employed Plumbing & Heating engineer... read more »
Thetford, Norfolk.
We are a domestic and commercial plumbing and heating... read more »
Tilney St Lawrence, Norfolk.
Fountain Construction And Drainage LTD are a Tilney St... read more »
Downham Market, Norfolk.
Bovic Services are a Downham Market based business offering... read more »
King's Lynn, Norfolk.
I have been a plumber both domestic and commercial over... read more »
Tungate, Norfolk.
Evo Heat Services Ltd are a Tungate based business offering... read more »
Thorpe St Andrew, Norfolk.
Gas, Heating and plumbing services. Boileer installs ,... read more »
Earlham, Norfolk.
BD Plumbing are a Earlham based business offering Plumbers,... read more »
Wattisfield, Suffolk.
A G Heating Services are a Wattisfield based business... read more »
Keswick, Norfolk.
Norfolk Landscape Gardener are a Keswick based business... read more »
Oulton, Suffolk.
Over the last two years the majority of the work that I... read more »
West Lynn, Norfolk.
J&H Property Maintenance & Handyman Services are a West... read more »
Dereham, Norfolk.
M turner maintenance the one stop shop for landlord,... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.