Armistead Maupin based Mrs Madrigal's house in the Tales of the City books on this SF street.