menu
close
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 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
Birmingham, West Midlands.
Welcome to Flamboyant Home & Garden LTD. We Install... read more »
Redditch, Worcestershire.
Over 18 years experience in construction and landscaping.... read more »
Solihull, West Midlands.
Woodlands Driveways And Landscapes are a Solihull based... read more »
Stafford, Staffordshire.
Jrw Builders are a Stafford based business offering... read more »
Birmingham, West Midlands.
Troy Crowton are a Birmingham based business offering... read more »
Coventry, West Midlands.
AW'S HOME IMPROVEMENTS are a Coventry based business... read more »
Royal Leamington Spa, Warwickshire.
A.R.Builders are a Royal Leamington Spa based business... read more »
Lutterworth, Leicestershire.
Welcome to JC style drives we provide many services... read more »
Telford, Shropshire.
Superior Paving Services are a Telford based business... read more »
Wolverhampton, West Midlands.
Hi welcome to Multi Trade Construction. We are a LOCAL... read more »
Kidderminster, Worcestershire.
BCF Paving are a Kidderminster based business offering... read more »
Dudley, West Midlands.
Hudson Construction are a Dudley based business offering... read more »
Birmingham, West Midlands.
G C And Sons Property Maintenance are a Birmingham based... read more »
Coventry, West Midlands.
Eco Pave And Design.co.uk are a Coventry based business... read more »
Birmingham, West Midlands.
Please feel free to check out our Google, Bark, Freeindex... read more »
Nuneaton, Warwickshire.
Alphascapes are a Nuneaton based business offering... read more »
Nuneaton, Warwickshire.
We are an extremely friendly team with years of experience. To... read more »
Stafford, Staffordshire.
Cheadle Landscapes are a Stafford based business offering... read more »
Birmingham, West Midlands.
Fix A Leak Roofing are a Birmingham based business offering... read more »
Coventry, West Midlands.
New Vision Driveways are experts in the supply and... read more »
Aqueduct, Shropshire.
We are a family run business who offer a wide range of... read more »
Tamworth, Staffordshire.
Jd Just Driveways Ltd are a Tamworth based business... read more »
Birmingham, West Midlands.
Greenacres contractors ltd Greenacres contractors Ltd... read more »
Worcester, Worcestershire.
The company "KR Building" offers a wide range of renovation,... read more »
Solihull, West Midlands.
JAGO'S PROPERTY MAINTENANCE are a Solihull based business... read more »
Coalville, Leicestershire.
Paving Force are a Coalville based business offering... read more »
Coventry, West Midlands.
Forget Me Not Gardenscape are a Coventry based business... read more »
Clayhanger, West Midlands.
JAP Building Services are a Clayhanger based business... read more »
Telford, Shropshire.
Roberts Landscaping are a Telford based business offering... read more »
Birmingham, West Midlands.
Accurate Contractors Limited are a Birmingham based... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.