menu
close
Search Trades

Find a Extension 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=49)) 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.
We are a family firm based in Cheltenham. We specialise... read more »
Bromsgrove, Worcestershire.
RandR building services are a Bromsgrove based business... read more »
Worcester, Worcestershire.
Bradlow building and landscaping are a Worcester based... 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 »
Hereford, Herefordshire.
RaD building are a Hereford based business offering... read more »
Hereford, Herefordshire.
James Partridge Building LTD are a Hereford based business... read more »
Worcester, Worcestershire.
D smith are a Worcester based business offering Extension... read more »
Gloucester, Gloucestershire.
Mountjoy & son is a family run business with over 30 years... read more »
Worcester, Worcestershire.
B R Construction serves as a leading contractor in the... read more »
Gloucester, Gloucestershire.
Silk brick and stone work are a Gloucester based business... read more »
Cheltenham, Gloucestershire.
JBJ Electrical Ltd are a Cheltenham based business offering... read more »
Cheltenham, Gloucestershire.
Hi, we are a local company with over 30+ years experience... read more »
Worcester, Worcestershire.
BABuilding solution are a Worcester based business... read more »
Evesham, Worcestershire.
I have been plastering for 31 years since I left school.... read more »
Gloucester, Gloucestershire.
Jason Ward Services Ltd are a Gloucester based business... read more »
Tetbury, Gloucestershire.
Elliott brothers are a Tetbury based business offering... read more »
Worcester, Worcestershire.
Small family run company taking on small and large jobs... read more »
Ludlow, Shropshire.
p&c millington are a Ludlow based business offering... read more »
Ludlow, Shropshire.
High quality of work and very reliable,22 years of... read more »
Bromsgrove, Worcestershire.
DMBuild.co.ukltd are a Bromsgrove based business offering... read more »
Gloucester, Gloucestershire.
Fully qualified, insured carpenter and general builder... read more »
Hereford, Herefordshire.
Collett Carpentry are a Hereford based business offering... read more »
Gloucester, Gloucestershire.
MJA CONSTRUCTION LTD are a Gloucester based business... read more »
Stroud, Gloucestershire.
E Partridge Building Services ltd are a Stroud based... read more »
Abbey Dore, Herefordshire.
Laurentiu Maintenance is a¬†general building¬†firm covering... read more »
Droitwich Spa, Worcestershire.
Hi been around for 18 years have Facebook page if wish... read more »
Abberley, Worcestershire.
BODA HOLDINGS are a Abberley based business offering... read more »
Ab Lench, Worcestershire.
Family construction business been established over 25... read more »
Gloucester, Gloucestershire.
KMS Construction are a Gloucester based business offering... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.