680 Mechanic St
Leominster, MA 01453
Office: (978) 860-3623 
Cell: (978) 833-3569 
Fax: (978) 860-3723 

Helpful Links

Member Sign In
Email:
Pass:

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

KELLER WILLIAMS REALTY / North Central
680 Mechanic St Leominster, MA 01453

Kurt Thompson 978-833-3569 Kurt@HomesJustForYou.com
Diane Guercio 978-602-6354 DianeG@HomesJustForYou.com
Elise Martin  978-602-2230 Elise@HomesJustForYou.com
Your Questions Answered  978-716-2915 Info@HomesJustForYou.com

Update Website | Privacy Policy | Agent Help Menu
Copyright © 2017 RLS2000.com, Inc. All rights reserved.