select broker_office_name, BROKER_STREET_ADDRESS, BROKER_STREET_ADDRESS2, BROKER_CITY, BROKER_STATE, BROKER_ZIP, BROKER_AREACODE, BROKER_PHONE_NUMBER, BROKER_FAX_AREACODE, BROKER_FAX_NUMBER from tblBrokerOffices with (nolock) where broker_id =