CENTURY 21 CUDDY

 

Access Error

You have reached this page without specifying an agent. Please use your browser's back button to return to the previous page.
select vwagent.agent_id, team_id, office_id, office_name, case when ltrim(rtrim(cast(agent_bio as varchar(6)))) = '
' then null else agent_bio end as agent_bio, DontShowBioOnMySiteOptIn, IDX_link, WSTreatOfficeAsCorp, Template_Type from vwagent join tblagent_security on (vwagent.agent_id = tblagent_security.agent_id) where vwagent.agent_id = 'CN208289' and (((select team_id from tblagent where agent_id = '105144') is null) or ((select team_id from tblagent where agent_id = '105144') is not null and team_id in (select team_id from tblagent where agent_id = '105144'))) and vwagent.main_office_number in (select main_office_number from vwagent where agent_id = '105144')
© 2017 CENTURY 21 Cuddy, CENTURY21® and the CENTURY 21 Logo are registered service marks owned by Century 21 Real Estate LLC.
Equal Housing Opportunity. Each office is independently owned and operated.