menu
close
Search Trades

Find a Builder in Preston, Gloucestershire

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=48)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(52.00797) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.47489) ) + sin( radians(52.00797) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=68) 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
Gloucester, Gloucestershire.
Welcome to FullFix We have been working in the building... read more »
Tenbury Wells, Worcestershire.
J R Bridges are a Tenbury Wells based business offering... read more »
Bromsgrove, Worcestershire.
RandR building services are a Bromsgrove based business... read more »
Cheltenham, Gloucestershire.
Dj construction are a Cheltenham based business offering... read more »
Worcester, Worcestershire.
Bradlow building and landscaping are a Worcester based... read more »
Lydney, Gloucestershire.
T'BUILDING & ROOFING SERVICES LTD are a Lydney based... read more »
Moreton-in-Marsh, Gloucestershire.
Westons Builders Ltd are a Moreton-in-Marsh based business... read more »
Cheltenham, Gloucestershire.
WRG Developments are a Cheltenham based business offering... read more »
Gloucester, Gloucestershire.
K O Developments are a Gloucester based business offering... read more »
Hereford, Herefordshire.
JWC carpentry are a Hereford based business offering... read more »
Hereford, Herefordshire.
JWC carpentry are a Hereford based business offering... read more »
Hereford, Herefordshire.
Paragon Carpentry & Building are a Hereford based business... read more »
Gloucester, Gloucestershire.
Halford builders are a Gloucester based business offering... read more »
Hereford, Herefordshire.
VPD Renovations LTD are a Hereford based business offering... read more »
Evesham, Worcestershire.
The Builders Cotswolds Ltd are a Evesham based business... read more »
Ludlow, Shropshire.
Hi we’re based in Ludlow Shropshire, we take care of... read more »
Hereford, Herefordshire.
RaD building are a Hereford based business offering... read more »
Evesham, Worcestershire.
T. Beard Roofing and Building are a Evesham based business... read more »
Hereford, Herefordshire.
AMG Construction & Maintenance are a Hereford based... read more »
Cirencester, Gloucestershire.
Mizon Builders.com are a Cirencester based business... read more »
Malvern Link, Worcestershire.
Welcome to our profile.. We at Priority Property Care... read more »
Ryall, Worcestershire.
Handyman Upton on Severn are a Ryall based business... read more »
Cheltenham, Gloucestershire.
All About Building are a Cheltenham based business offering... read more »
Thornbury, Gloucestershire.
Severnside Design & Build LTD has been involved within... read more »
Hereford, Herefordshire.
DCL
DCL are a Hereford based business offering Property... read more »
Hereford, Herefordshire.
James Partridge Building LTD are a Hereford based business... read more »
Dursley, Gloucestershire.
ko roofing are a Dursley based business offering Builders... read more »
Cheltenham, Gloucestershire.
Gloucestershire vintage lime are a Cheltenham based... read more »
Wychbold, Worcestershire.
Callums Joinery are a Wychbold based business offering... read more »
Abbot's Salford, Warwickshire.
Corbel building services are a Abbot's Salford based... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.