menu
close
Search Trades

Find a Loft Conversion Business in Sheffield, South Yorkshire

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=90)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.38316) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.46776) ) + sin( radians(53.38316) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=137) 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
Doncaster, South Yorkshire.
D H B Construction are a Doncaster based business offering... read more »
Wakefield, West Yorkshire.
Stav joinery limited are a Wakefield based business... read more »
Sheffield, South Yorkshire.
Our company offers all sorts of house improvement. Please... read more »
Macclesfield, Cheshire.
J & L Building & Design is a Macclesfield based construction... read more »
Alfreton, Derbyshire.
L.M Building & Maintenance are a Alfreton based business... read more »
Doncaster, South Yorkshire.
Bathrooms 4 u north ltd are a Doncaster based business... read more »
Doncaster, South Yorkshire.
xxx
xxx are a Doncaster based business offering Extension... read more »
Disley, Cheshire.
Polybuild north west limited are a Disley based business... read more »
Abbey Hey, Greater Manchester.
Lee's plastering are a Abbey Hey based business offering... read more »
Sheffield Park, South Yorkshire.
Acorn joinery are a Sheffield Park based business offering... read more »
Sheffield, South Yorkshire.
Bespoke Renovations Yorkshire Ltd are a Sheffield based... read more »
Castleford, West Yorkshire.
Hi Carleton construction as been operating for over 20... read more »
Doncaster, South Yorkshire.
Create are a well established family run business based... read more »
Doncaster, South Yorkshire.
Green-Gorilla Landscape and Design is a family run landscape... read more »
Oldham, Greater Manchester.
Cedarshield are a Oldham based business offering Loft... read more »
Stockport, Greater Manchester.
GNSDevelopers are a Stockport based business offering... read more »
Leeds, West Yorkshire.
Award winning family run building business covering North... read more »
Leeds, West Yorkshire.
S mcgrath tiling and plastering services are a Leeds... read more »
Barnsley, South Yorkshire.
Homecare developments are a Barnsley based business... read more »
Huddersfield, West Yorkshire.
RJB electrical installations Ltd established in 2000... read more »
Worksop, Nottinghamshire.
Worksop Building & Property Services Ltd are a Worksop... read more »
Byram, North Yorkshire.
Father and son business with a combined experience of... read more »
Cleckheaton, West Yorkshire.
West yorkshire renovations are a Cleckheaton based business... read more »
Oldham, Greater Manchester.
Professional and local building contractors specialising... read more »
Wakefield, West Yorkshire.
EA Wood And Son are a Wakefield based business offering... read more »
Leeds, West Yorkshire.
Rlplastering are a Leeds based business offering Extension... read more »
Ripley, Derbyshire.
A P Sharp Building Services are a Ripley based business... read more »
Chesterfield, Derbyshire.
KH Builders services. I have been up and running since... read more »
Leeds, West Yorkshire.
Cab And Son Property Solutions are a Leeds based business... read more »
Wakefield, West Yorkshire.
We are a small family friendly run company with giving... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.