I've talked to some friends about finding a job like this,
i was just wondering if there are any real estate agents who
know how i can go about finding a job as a photographer for
an agency.

I was thinking about this too but I think most agents photograph their own stuff! I do know a guy who goes out with his plane and randomly shoots aerial photos of houses then contacts the home owner and sells to them an aerial photo of their house. Maybe you could take pics of people's houses then offer it back to them? Just a thought bro!

a photographer in another state shoots for agencies because he can get nice wide angle shots for the large mansions, but then in SF we don't have that many large houses, only in st. francis, sea cliff aand the ocasional inner sunset areas

You'd need a nice airplane too to boot!

ha, all i'd need is a super wide angle lens and a couple of flashes