Direct: 978-847-0800 • Toll Free: 800-743-1161 
Fax: 978-840-1287 

info@propertypromotions.net
  Home - Contact Us - About Our Office - Meet Our Agents - Open Houses - Free Information
   
     JOIN REMAX
   • Cala Claret
   • Susan Clark
   • April Cover
   • Brenda and David Cormier
   • RaeDeane Garcia
   • Reg Haughton
   • Jay Johnson
   • Marina Kotlyar
   • Victoria Marble
   • James Shadd
   • Susan Thibeault
   • Pat Thompson
   • Maria Tolman
   • John Vedoe
   • Nancy Whitehouse-Bain
 

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 = '404449' and (((select team_id from tblagent where agent_id = '104203') is null) or ((select team_id from tblagent where agent_id = '104203') is not null and team_id in (select team_id from tblagent where agent_id = '104203'))) and vwagent.main_office_number in (select main_office_number from vwagent where agent_id = '104203')


RE/MAX Property Promotions   RE/MAX Property Promotions
975 Merriam Ave #212 • Leominster, MA 01453 Map it
Direct: 978-847-0800 • Toll Free: 800-743-1161 
Fax: 978-840-1287 
info@propertypromotions.net

Login | Privacy Policy | Log in to MLS Property Finder
Copyright © 2016 RLS2000.com, Inc. All rights reserved.
Equal Housing Opportunity