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
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 »
Ibstock, Leicestershire.
Professional sole trader with over 10 years experience... read more »
Redditch, Worcestershire.
Gsp Construction Redditch Ltd are a Redditch based business... read more »
Birmingham, West Midlands.
HEARTLAND CONSTRUTION LTD are a Birmingham based business... read more »
Worcester, Worcestershire.
Family set up Any type brick work / block work... read more »
Broseley, Shropshire.
Pryce Landscapes And Building are a Broseley based business... read more »
Birmingham, West Midlands.
Kdc Construction are a Birmingham based business offering... read more »
Kidderminster, Worcestershire.
Solutions Specalists are a Kidderminster based business... read more »
Worcester, Worcestershire.
Dcj Building Services are a Worcester based business... read more »
Kidderminster, Worcestershire.
All types of garden work done from patios, slabing,... read more »
Solihull, West Midlands.
Ark Trees are a Solihull based business offering Driveway... read more »
Stafford, Staffordshire.
Gwyther Maintenance Services are a Stafford based business... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.