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
Tettenhall Wood, West Midlands.
F&h Landscaping are a Tettenhall Wood based business... read more »
Winshill, Staffordshire.
Edit introduction Maguire Paving ltd are well established... read more »
Woodlane, Staffordshire.
WD Paving Direct are a Woodlane based business offering... read more »
Wolverhampton, West Midlands.
New Time Construction Ltd bring years of industry experience... read more »
Donnington, Shropshire.
SWH Construction Services are a Donnington based business... read more »
Tile Cross, West Midlands.
Liam Hunt Building And Maintenance are a Tile Cross based... read more »
Aqueduct, Shropshire.
Hawk Stone and Timber are a Aqueduct based business... read more »
Walsgrave on Sowe, West Midlands.
LMD Ltd are a Walsgrave on Sowe based business offering... read more »
Headless Cross, Worcestershire.
Hopkins Builders are a Headless Cross based business... read more »
St John's, Worcestershire.
Wonderwall Builders Worcester are a St John's based... read more »
Donnington Wood, Shropshire.
We are family run business with over 25 years experience... read more »
Gilbertstone, West Midlands.
Lux developments undertake all aspects of building... read more »
Summer Hill, West Midlands.
JJ’s Building Services are a Summer Hill based business... read more »
Mesty Croft, West Midlands.
we are a fully insured and qualified groundwork company... read more »
Parkside, Staffordshire.
Stratton Roofing is a family-owned business that has been... read more »
Aston, West Midlands.
A.G BRICKWORK are a Aston based business offering Builders,... read more »
Buckland End, West Midlands.
O Gorman Building & Construction are a Buckland End based... read more »
Woodcock Hill, West Midlands.
Lp Building Solutions are a Woodcock Hill based business... read more »
Kingstanding, West Midlands.
FTP Limited are a Kingstanding based business offering... read more »
Attleborough, Warwickshire.
Jaroslaw Romanski are a Attleborough based business... read more »
Lenchwick, Worcestershire.
Oakleaf are a Lenchwick based business offering Driveway... read more »
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 »
© Copyright. 2023. All Rights Reserved.