Robert,
I wanted to follow up on my initial question with an answer of "yes, it is possible to do what I want!" I, however, also have a quirky issue with the process that I am hoping you can shed some light on.
Reference the attached images for visual reference, but in short form:
1. Select the parcel(s) you want to buffer using graphical or attribute search.
2. Buffer said parcel(s) by desired distance.
3. Intersect the parcels with the buffer.
4. Clear the buffer.
5. Intersect the site address points with the parcels selected from the buffer.
(6.) Bring up data grid and export results to .csv for your mailing list!
Perfect! Except that sometimes the query fails (see step 5 fail image) using the same datasets (different areas of the city). At first I thought it had something to do with the joins on the data, but I just ran a test with some map services set up with all of the joined data embedded in the layer itself, so the actual join is not the smoking gun.
Any ideas? In case you ask, my server is completely behind the firewall, so I cannot give you a link, but I am at a loss as to why it is inconsistent with the same datasets.
Thanks for your help.
Brian