Property Search
Advanced Search
Helpful Links


MLSPropertyFinder.com
 

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, tblagent_security.ShowUAGOnMyListingsOptIn from vwagent join tblagent_security on (vwagent.agent_id = tblagent_security.agent_id) where vwagent.agent_id = '414639' and (((select team_id from tblagent where agent_id = '117741') is null) or ((select team_id from tblagent where agent_id = '117741') is not null and team_id in (select team_id from tblagent where agent_id = '117741'))) and vwagent.main_office_number in (select main_office_number from vwagent where agent_id = '117741')



Fudge Properties   Fudge Properties
11 Middlesex Ave, Suite 5 • Wilmington, MA 01887 Map it
Direct: 978-658-7300 • Fax: 978-658-7333
office@fudgeproperties.com

Login | DMCA Notice | Privacy Policy | Terms of Service | Log in to MLS Property Finder
Copyright © 2018 RLS2000.com, Inc. All rights reserved.
Equal Housing Opportunity