menu
close
Search Trades

Find a Builder 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=48)) 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
Newcastle upon Tyne, Tyne and Wear.
General Property Services are a Newcastle upon Tyne based... read more »
Whitley Bay, Tyne and Wear.
P.GREY BUILDING SERVICES are a Whitley Bay based business... read more »
Newcastle upon Tyne, Tyne and Wear.
Histon bathrooms and Renovations are a Newcastle upon... read more »
Morpeth, Northumberland.
Bathroom installers for Retail and Domestic. Previously... read more »
Newcastle upon Tyne, Tyne and Wear.
We cater for all your interior and exterior work.we... read more »
Newcastle upon Tyne, Tyne and Wear.
Metcalfe Home Improvements are a Checked & Vetted approved... read more »
Gateshead, Tyne and Wear.
We are a family run property maintenance business and... read more »
Washington, Tyne and Wear.
MTM Home Improvements are a Washington based business... read more »
Washington, Tyne and Wear.
My name is Michael my company name is MTM home improvement... read more »
Newcastle upon Tyne, Tyne and Wear.
We are a small size family company. Running for 20 years... read more »
Newcastle upon Tyne, Tyne and Wear.
Just Johnston Ltd are a Newcastle upon Tyne based business... read more »
Bowburn, County Durham.
Goldcrest developments are a Bowburn based business... read more »
Blaydon, Tyne and Wear.
Ncjworks are a Blaydon based business offering Property... read more »
Hebburn, Tyne and Wear.
Hartburn lofts are a Hebburn based business offering... read more »
Newcastle upon Tyne, Tyne and Wear.
Been a builder for 25years no job to small. Please ring... read more »
Bishop Auckland, County Durham.
TMT building services are a Bishop Auckland based business... read more »
Bellingham, Northumberland.
C banks building are a Bellingham based business offering... read more »
South Shields, Tyne and Wear.
Darren Hutchison joinery are a South Shields based business... read more »
Blyth, Northumberland.
Ross Turnbull plumbing and heating are a Blyth based... read more »
Washington, Tyne and Wear.
Small, friendly and professional fencing company based... read more »
Durham, County Durham.
GB properties are a Durham based business offering... read more »
Crook, County Durham.
Caile builders are a Crook based business offering... read more »
Hartlepool, County Durham.
Ib building and property maintenance are a Hartlepool... read more »
Newcastle upon Tyne, Tyne and Wear.
Northern property projects are a Newcastle upon Tyne based... read more »
Sunderland, Tyne and Wear.
Signature home improvements are a Sunderland based... read more »
Stanley, County Durham.
S.Y Electrical & Home Improvements are a Stanley based... read more »
Hartlepool, County Durham.
DL Building services are a Hartlepool based business... read more »
Tyne Dock, Tyne and Wear.
Abscot joinery are a Tyne Dock based business offering... read more »
Gateshead, Tyne and Wear.
A family run business of time served Joiners.Offering a... read more »
Blyth, Northumberland.
Evolution roofing and building services are a Blyth based... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.