Search Trades

Find a Driveway Contractor in Birmingham, West Midlands

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=64)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(52.48534) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.86153) ) + sin( radians(52.48534) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=155) 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
Bromley, West Midlands.
Akw Brickwork are a Bromley based business offering... read more »
Stockland Green, West Midlands.
My self and partner specialise in two area's of building... read more »
Bretforton, Worcestershire.
MC Gardens are a Bretforton based business offering... read more »
Quarry Hill, Staffordshire.
TNR LTD are a Quarry Hill based business offering Property... read more »
Bentley, West Midlands.
Jt’s Home And Building Maintenance are a Bentley based... read more »
Coal Pool, West Midlands.
L&k Fencing And Paving are a Coal Pool based business... read more »
Lee Bank, West Midlands.
Pro Fix Home Drives And Gardens are a Lee Bank based... read more »
Lawley, Shropshire.
J Kirwan Landscapes are a Lawley based business offering... read more »
Alcester Lane's End, West Midlands.
Spade Builders are a Alcester Lane's End based business... read more »
Birchills, West Midlands.
We Do Everything From Top To Bottom And Our Prices Are... read more »
Soho, West Midlands.
A flegling business that brings over 40 years experience... read more »
Low Town, Shropshire.
With years of GROUNDWORKS experience we offer lots of... read more »
Littleworth, Staffordshire.
Many years of experience in carpentry, flooring, green... read more »
Falcon Lodge, West Midlands.
A trustworthy and reliable Landscaping, Gardening and... read more »
Castle Bromwich, West Midlands.
Small Landscaping are a Castle Bromwich based business... read more »
Red Lake, Shropshire.
MRG Construction And Landscape Services LTD are a Red... read more »
Wombourne, Staffordshire.
Hi I’m Craig I have many years of experience within the... read more »
Summer Hill, West Midlands.
Tsg Transport Ltd are a Summer Hill based business offering... read more »
St Nicolas Park, Warwickshire.
Wakefield Landscape And Building Society are a St Nicolas... read more »
Ab Lench, Worcestershire.
K&k landscaping. Family run business for 25 years . We... read more »
Pheasey, West Midlands.
Jones Brothers Groundwork’s are a Pheasey based business... read more »
Leicester Forest East, Leicestershire.
Marson Gardens are a Leicester Forest East based business... read more »
Ashby-de-la-Zouch, Leicestershire.
here at jlt brickwork we have reliable and competent... read more »
Wetmore, Staffordshire.
Designer Landscapes are a Wetmore based business offering... read more »
Tower Hill, West Midlands.
Swift Pressure Washing are a Tower Hill based business... read more »
Soho, West Midlands.
BHD Builders Limited are a Soho based business offering... read more »
Catchems End, Worcestershire.
MDTM Property Services are a Catchems End based business... read more »
Chase Terrace, Staffordshire.
General Maintenance Services are a Chase Terrace based... read more »
Woodgate, West Midlands.
At Kings We pride ourselves on a 5 Star award winning... read more »
Great Bridge, West Midlands.
Toll End Builders are a Great Bridge based business... read more »
© Copyright. 2023. All Rights Reserved.