Search Trades

Find a Builder in Bury St Edmunds, Suffolk

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(52.24741) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(0.71585) ) + sin( radians(52.24741) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=142) ORDER BY distance) z)) ) a INNER JOIN areas b ON 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
Oulton, Suffolk.
Frosdick Brickwork LTD are a Oulton based business offering... read more »
Silfield, Norfolk.
Breckland Builders Limited are a Silfield based business... read more »
Bury St Edmunds, Suffolk.
At Orvis Brickwork we take pride in delivering your project... read more »
Thetford, Norfolk.
ZIG-BUD are a Thetford based business offering Builders,... read more »
Saxmundham, Suffolk.
Ian Bridge Brickwork are a Saxmundham based business... read more »
Colchester, Essex.
G Leigh Roofing are a Colchester based business offering... read more »
Lavenham, Suffolk.
Day And Brown Brickwork are a Lavenham based business... read more »
Kirkley, Suffolk.
Kevin McInally Brickwork are a Kirkley based business... read more »
Hapton, Norfolk.
Welcome to Stag Landscapes UK. We take pride in offering... read more »
Greenstead, Essex.
Premier Carpentry & Construction are a Greenstead based... read more »
Sporle, Norfolk.
KDW Construction are a Sporle based business offering... read more »
Girton, Cambridgeshire.
Conserve, Protect, Restore This is the ethos we stand by;... read more »
Diss, Norfolk.
R D Farrow & Sons are a Diss based business offering... read more »
Gunton, Suffolk.
WS Construction are a Gunton based business offering... read more »
Cambridge, Cambridgeshire.
Finishers are a family run busines since 1995 we cover... read more »
Ipswich, Suffolk.
please let me introduce myself I am a fully qualified... read more »
© Copyright. 2023. All Rights Reserved.