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
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 »
Bacon's End, West Midlands.
All things garden are a Bacon's End based business offering... 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 »
Great Bridge, West Midlands.
Toll End Builders are a Great Bridge based business... read more »
Ryton, Warwickshire.
Professional Garden Cares Services are a Ryton based... read more »
Brandwood End, West Midlands.
M&S Garden Landscapes are a Brandwood End based business... read more »
Linton Heath, Derbyshire.
Lifetime Roofing And Building are a Linton Heath based... read more »
Church Eaton, Staffordshire.
Topspec Homes are a Church Eaton based business offering... read more »
Milverton, Warwickshire.
At MSG construction and driveways we understand that your... read more »
Worcester, Worcestershire.
A.f.fencing are a Worcester based business offering... read more »
Hawkesbury, Warwickshire.
We are a ground works and civils company that undertakes... read more »
Brookside, Shropshire.
LM SOARE SERVICES LTD are a Brookside based business... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.