string(1515) "SELECT r.*, CONCAT(a.first_name,' ',a.last_name) AS 'agent_name', a.agent_phone, a.agent_email, a.photo AS 'agent_photo', a.url AS 'agent_url', a.office_id AS 'agent_office_id' , o.office_name AS 'agent_office_name', o.office_phone AS 'agent_office_phone', o.office_address AS 'agent_office_address', o.office_city AS 'agent_office_city', o.office_state AS 'agent_office_state', o.office_zip AS 'agent_office_zip', o.office_website AS 'agent_office_url' , CONCAT(c.first_name,' ',c.last_name) AS 'co_agent_name', c.agent_phone as 'co_agent_phone', c.agent_email AS 'co_agent_email', c.photo AS 'co_agent_photo', c.url AS 'co_agent_url', c.office_id AS 'co_agent_office_id' , co.office_name AS 'co_agent_office_name', co.office_phone AS 'co_agent_office_phone', co.office_address AS 'co_agent_office_address', co.office_city AS 'co_agent_office_city', co.office_state AS 'co_agent_office_state', co.office_zip AS 'co_agent_office_zip', co.office_website AS 'co_agent_office_url' , SUBSTRING_INDEX(r.address,' ', 1) as 'house_number' FROM `agentsites`.`all_RElistingdata` r LEFT JOIN agentsites.all_agents a on r.mls_id=a.mls_id AND r.agent_code=a.agent_id LEFT JOIN agentsites.all_offices o ON a.mls_id=o.mls_id AND a.office_id=o.office_id LEFT JOIN agentsites.all_agents c on r.mls_id=c.mls_id AND r.co_agent_code=c.agent_id LEFT JOIN agentsites.all_offices co ON c.mls_id=co.mls_id AND c.office_id=co.office_id WHERE 1=1 AND r.mls_id in ('361') HAVING 1=1 ORDER BY price DESC LIMIT 50"

Map Search

 

Type

Price

Area

Beds & Baths

More

Search

'
Refine Search
Clear Search
Hide Detail
 
 
 
Existing user sign in: 
Forgot Password?