Interested in advertising on allAgents? Contact our Business Development Team on 07531 860 637
- You are here:
- Home >
- Estate & Letting Agents >
- Agents in SE7
Estate Agents & Letting Agents in SE7
SELECT b.*, a.transparency, a.link, a.name, cb.*
FROM branches b
JOIN agents a
ON b.agent = a.aid
LEFT JOIN branch_checkboxes cb
ON b.bid = cb.branchid
WHERE aid IN(1235,1818,2188,3715,9690,9817)
AND postcode1 IN ('SE7')
AND a.view = 1
AND b.view = 1
GROUP BY b.bid
ORDER BY cb.featured_branch DESC, cb.featured_postcode DESC, a.name ASC LIMIT -60, 60
