Direct: 978-502-8288 • Cell: 978-502-8288 
Vm/Pager: 978-482-3917 • Toll Free: 800-839-3299 
Fax: 978-482-3917 
 
Main Navigation
» Home
» My Listings
» 1000's of Listings
» Check New Listings
» Contact Me
 
 
Property Search Property Search
Min $:
Max $:
MLS #:

 
 
Helpful Links
» Free Market Analysis
» Mortgage Calculator
» Buying/Selling Tips
» Schools/Community
» Local Business
 

    
 

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


RE/MAX Partners   Pam Lebowitz, Esq., Realtor/Attorney
RE/MAX Partners
44 Park St • Boston, MA 02210 Map it
Direct: 978-502-8288 • Cell: 978-502-8288 
Vm/Pager: 978-482-3917 • Toll Free: 800-839-3299 
Fax: 978-482-3917 
pamela5100@aol.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