menu
close
Search Trades

Find a Loft Conversion Business in Derby, Derbyshire

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(52.91576) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.47351) ) + sin( radians(52.91576) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=46) 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
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 »
Nuneaton, Warwickshire.
We offer a professional and a high standard of work We... read more »
Nuneaton, Warwickshire.
Coopers Carpentry And Building Services are a Nuneaton... read more »
Nottingham, Nottinghamshire.
Aurora Install Limited are Electrical Contractors based... read more »
Nuneaton, Warwickshire.
25 yrs experience in all aspects of carpentry & shopfitting,... read more »
Lowdham, Nottinghamshire.
Country-scape are a Lowdham based business offering... read more »
Leicester, Leicestershire.
TCKW Building Services are a Leicester based business... read more »
Nottingham, Nottinghamshire.
Crown Cut Interiors are a Nottingham based business... read more »
Leicester, Leicestershire.
Leicester home improvements New builds... read more »
Ab Kettleby, Leicestershire.
Save-R-us Ltd are a Ab Kettleby based business offering... read more »
Hazelgrove, Nottinghamshire.
We are a small based company that undertakes all aspects... read more »
Nottingham, Nottinghamshire.
Mb joinery and building maintenance has over 25 years... read more »
Derby, Derbyshire.
Derby Brickwork Limited are a Derby based business offering... read more »
Nottingham, Nottinghamshire.
We’ve been trading now for 5 years and have built up a... read more »
Alvaston, Derbyshire.
New Builds.. Extensions.. Walls.. Repairs.. Re-Pointing.. Knock... read more »
Nottingham, Nottinghamshire.
Better Homes are a Nottingham based business offering... read more »
Leicester, Leicestershire.
Hi everyone contact me for anything building work... read more »
Leicester, Leicestershire.
Abc Building And Joinery Ltd are a Leicester based business... read more »
Nottingham, Nottinghamshire.
I'm a NICEIC Approved local electrical contractor looking... read more »
Cannock, Staffordshire.
Qualis Projects Ltd are a Cannock based business offering... read more »
Fulford, Staffordshire.
Oakes Building are a Fulford based business offering... read more »
Burntwood Green, Staffordshire.
S fox plastering services. Over 25 years experience and... read more »
Chesterfield, Derbyshire.
Cp Landscapes are a Chesterfield based business offering... read more »
Leicester, Leicestershire.
All Checked Limited are a Leicester based business offering... read more »
Stoney Stanton, Leicestershire.
Northwood Property are a Stoney Stanton based business... read more »
Nottingham, Nottinghamshire.
JN BUILDING are a Nottingham based business offering... read more »
Nottingham, Nottinghamshire.
We are an ambitious and growing building contractor based... read more »
Nuneaton, Warwickshire.
MW Smith Ceramics are a Nuneaton based business offering... read more »
Pinxton, Derbyshire.
P ALowe Home Improvements are a Pinxton based business... read more »
© Copyright. BookaBuilderUK.com. 2023. All Rights Reserved.