home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5,752 rows where Mail Zipcode = 7

View and edit SQL

Suggested facets: State, Mail City, Mail State, NAICS Code Description, Parking Tax, Transient Occupancy Tax, Supervisor District, Business Corridor

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
10 0015092-01-001 Jug Shop Inc Jug Shop Inc 1590 Pacific Ave San Francisco 1 CA 1 94108 9 10/01/1968   08/28/2006   1590 Pacific Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 H31 H73 H87 Multiple 3 1 Russian Hill 5   1590 PACIFIC AVE San Francisco, CA 94108 (37.79504, -122.421452)
67 0034315-01-001 Wong Lonnie 1533 Larkin Rentals 1533 Larkin St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1533 Larkin St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1533 LARKIN ST San Francisco, CA 94109 (37.792189, -122.419341)
83 0034320-01-001 Mah King Min 1534 Jackson Apts 1534 Jackson St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1534 Jackson St #3 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1534 JACKSON ST San Francisco, CA 94109 (37.794276, -122.420367)
135 0140506-01-001 Liang Hsung Ying Liang Dr Medical Office 2000 Van Ness Ave 607 San Francisco 1 CA 1 94109 24 04/01/1983   05/01/2008   2000 Van Ness Ave Ste 607 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Russian Hill 5   2000 VAN NESS AVE San Francisco, CA 94109 (37.794086, -122.423016)
147 0061067-01-001 Fortuin Floyd D Fortuin Floyd D 909 Hyde St 609 San Francisco 1 CA 1 94109 24 11/01/1970   02/09/2000   909 Hyde St #620 San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)
188 0011673-01-001 Stauffacher Jack W Greenwood Press 300 Broadway St 300 San+francisco 8 CA 1 94133 11 10/01/1968   10/01/1968   1945 Broadway #305 San Francisco 1 94109 7 CA     0 0           300 BROADWAY ST San Francisco, CA 94133 (37.798383, -122.4026)
238 0112931-01-001 Leix Construction Co Inc 1295 17th Ave Property 1295 17th Ave San Francisco 1 CA 1 94122 19 02/10/1992   02/10/1992   1465 Pine Street San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Inner Sunset 13   1295 17TH AVE San Francisco, CA 94122 (37.763733, -122.475028)
244 0112931-02-001 Leix Construction Co Inc 677 Valencia Apt 677 Valencia St San Francisco 1 CA 1 94110 18 02/10/1992   01/01/1995   1465 Pine Street San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   677 VALENCIA ST San Francisco, CA 94110 (37.762013, -122.421608)
260 0112931-03-001 Leix Construction Co Inc Leix Construction 1608 Irving St San Francisco 1 CA 1 94122 19 02/10/1992   01/01/2012   1465 Pine Street San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Inner Sunset 13   1608 IRVING ST San Francisco, CA 94122 (37.763662, -122.475112)
276 0112931-04-001 Leix Construction Co Inc Leix Construction Co 1465 Pine St San Francisco 1 CA 1 94109 24 02/10/1992   01/15/2014   1465 Pine Street San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1465 PINE ST San Francisco, CA 94109 (37.789694, -122.419865)
291 0113100-01-001 Chow Frank & Chow Roy Pinecrest Cleaners 1176 Pine St San Francisco 1 CA 1 94109 24 06/01/1973   06/01/1973   1176 Pine St San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 D30 Dry Cleaning Plant 3 1 Nob Hill 17   1176 PINE ST San Francisco, CA 94109 (37.790313, -122.415145)
304 0071662-01-001 Fontana West Apartment Corp Fontana West Apartments 1050 Point St San Francisco 1 CA 1 94109 24 10/01/1970   10/01/1970   1050 N Point St San Francisco 1 94109 7 CA     0 0 D26 H56 Multiple 2 Russian Hill 5   1050 POINT ST San Francisco, CA 94109 (37.805153, -122.424778)
341 0071948-03-001 Robert Grison-Living Trust 712-714 Montgomery Bldg 712 Montgomery St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   1333 Jones St #908 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   712 MONTGOMERY ST San Francisco, CA 94111 (37.795847, -122.403378)
342 0140983-01-001 Golden City Enterprise Inc Golden City Building Supply 1279 Pacific Ave San Francisco 1 CA 1 94109 24 02/12/1982   01/02/2002   1279 Pacific Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Nob Hill 17   1279 PACIFIC AVE San Francisco, CA 94109 (37.795731, -122.416224)
361 0141079-05-001 Portco Inc Cioppino's 400 Jefferson St San Francisco 1 CA 1 94109 24 12/31/1988   02/01/1998   496 Jefferson St San Francisco 1 94109 7 CA     0 0 H26 Restaurant Greater Than 2,000 Sqft 2 Russian Hill 5   400 JEFFERSON ST San Francisco, CA 94109 (37.807778, -122.419304)
379 0084492-04-001 Patel Mangiben & Ramesh Trust Francisco Bay Inn 1501 Lombard St San Francisco 1 CA 1 94123 3 06/01/1972   01/03/1995   1630 Pacific Ave San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     2 Marina 2   1501 LOMBARD ST San Francisco, CA 94123 (37.801014, -122.426448)
393 0084492-05-001 Patel Mangiben & Ramesh Trust Nob Hill Motor Inn 1630 Pacific Ave San Francisco 1 CA 1 94109 24 06/01/1972   03/30/2000   1630 Pacific Ave San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Russian Hill 5   1630 PACIFIC AVE San Francisco, CA 94109 (37.794944, -122.422194)
456 0084831-01-001 Land Sea & Air Corp Land Sea & Air Corp 5 3rd St #608 San+francisco 8 CA 1 94103 25 04/01/1974   02/12/2002 01/31/2015 2040 Franklin St Apt 605 San Francisco 1 94109 7 CA     0 0           5 3RD ST San Francisco, CA 94103 (37.787454, -122.403428)
457 0034419-01-001 Louie Ben Fong 1551 Hyde Apts 1551 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1551 Hyde St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1551 HYDE ST San Francisco, CA 94109 (37.795148, -122.41824)
515 0031829-01-001 Leong Do Yen 1026 Pine Rentals 1026 Pine St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1026 Pine St San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Nob Hill 17   1026 PINE ST San Francisco, CA 94109 (37.790603, -122.412832)
570 0113606-01-001 Camisa Madeline L Scribes Of The City P O Box 29382 San+francisco 8 CA 1 94129 42 07/01/1978   07/01/1978   1270 Chestnut St #6 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0            
598 0072075-01-001 Wong Jeffrey Etal 1821 Hyde Apts 1821 Hyde St 5 San Francisco 1 CA 1 94109 24 11/30/1970   11/30/1970   1821 Hyde St No 3 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1821 HYDE ST San Francisco, CA 94109 (37.797622, -122.418751)
744 0027869-01-001 Swensens Of San Francisco Inc Swensens Of San Francisco Inc 1999 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1999 Hyde St San Francisco 1 94109 7 CA 7220-7229 8 Food Services 8 0 0 H26 Restaurant Greater Than 2,000 Sqft 3 1 Russian Hill 5   1999 HYDE ST San Francisco, CA 94109 (37.799212, -122.419066)
778 0000668-01-001 Alioto F Co Inc F Alioto Fish Co 440 Jefferson St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   440 Jefferson St San Francisco 1 94109 7 CA 4200-4299 7 Wholesale Trade 7 0 0     2 Russian Hill 5   440 JEFFERSON ST San Francisco, CA 94109 (37.807739, -122.419621)
920 0061675-02-001 Stettler Marilyn 1175-1179 Vallejo Apts 1175 Vallejo St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1175 Vallejo St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1175 VALLEJO ST San Francisco, CA 94109 (37.797612, -122.416528)
1083 0086733-01-001 Choy Kai Foon & Sau Chun 1606-1612 Jones Apts 1606 Jones St San Francisco 1 CA 1 94109 24 05/15/1972   05/15/1972   1612 Jones St San Francisco 1 94109 7 CA     0 0     3 1 Nob Hill 17   1606 JONES ST San Francisco, CA 94109 (37.796145, -122.41506)
1086 0100508-01-001 Goldstein Jerome 451 Hayes St Apts 909 Hyde St Ste 322 San Francisco 1 CA 1 94109 24 08/31/1973   03/02/2000   909 Hyde St 228 Ste San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)
1090 0034764-01-001 Chan Kang 1645 Clay Apts 1645 Clay St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1645 Clay St. Apt.2 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1645 CLAY ST San Francisco, CA 94109 (37.792486, -122.420252)
1094 0012928-01-001 Hiura Ronald Hiura & Hiura 1418 Polk St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1418 Polk St San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   1418 POLK ST San Francisco, CA 94109 (37.789931, -122.420561)
1114 0100508-01-002 Goldstein Jerome 451 Hayes St Apts 451 Hayes St San Francisco 1 CA 1 94102 16 08/31/1973   01/01/1999   909 Hyde St 228 Ste San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10   451 HAYES ST San Francisco, CA 94102 (37.776778, -122.423811)
1132 0100508-02-001 Goldstein Jerome 1655-1661 Folsom Bldg 1655 Folsom St San Francisco 1 CA 1 94103 25 08/31/1973   01/01/1984   909 Hyde St 228 Ste San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission 12   1655 FOLSOM ST San Francisco, CA 94103 (37.770352, -122.41533)
1149 0100508-03-001 Goldstein Jerome 1235 Waller Apts 1235 Waller St San Francisco 1 CA 1 94117 33 08/31/1973   01/01/1978 12/31/2013 909 Hyde St 228 Ste San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 H57 Swimming Pools (Six-Month)       1235 WALLER ST San Francisco, CA 94117 (37.769433, -122.444101)
1151 0127644-02-001 Carper Shirley Faces Etcetera 2001 California St 207 San Francisco 1 CA 1 94109 24 09/08/2004   09/08/2004   2001 California St #207 San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     5 7 Pacific Heights 16   2001 CALIFORNIA ST San Francisco, CA 94109 (37.789713, -122.427528)
1246 0034792-01-001 Lee Donald Y 1650 Sacramento Apts 1650 Sacramento St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1522 Sacramento St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1650 SACRAMENTO ST San Francisco, CA 94109 (37.791594, -122.420154)
1321 0127717-01-001 Lee James M W Lee James M W-Law Offices Of 703 Market St 1606 San Francisco 1 CA 1 94103 25 01/01/1980   01/01/1980   951 Post Street San Francisco 1 94109 7 CA     0 0     6 3 Financial District/South Beach 1   703 MARKET ST San Francisco, CA 94103 (37.787558, -122.403576)
1328 0127778-01-001 Goldberg Ba Thi Nikkis Oriental Massages 1172 Sutter St San Francisco 1 CA 1 94109 24 02/15/1981   02/15/1981   1172 Sutter St San Francisco 1 94109 7 CA     0 0 H67 Massage Establishment 3 1 Nob Hill 17   1172 SUTTER ST San Francisco, CA 94109 (37.787813, -122.419687)
1329 0028598-01-001 Tom Family Assn Tom Family Assn 817 Clay St San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   817 CLAY ST San Francisco, CA 94108 (37.794203, -122.406697)
1336 0127887-02-001 Laforgia Brian N Brian Laforgia L.ac 2000 Van Ness Ave 708 San Francisco 1 CA 1 94109 24 06/04/2001   02/23/2007   2000 Van Ness Ave 708 Ste San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Russian Hill 5   2000 VAN NESS AVE San Francisco, CA 94109 (37.794086, -122.423016)
1341 0013290-01-001 Feinstein Dianne Etal Carlton Hotel 1075 Sutter St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1075 Sutter St San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Nob Hill 17   1075 SUTTER ST SAN FRANCISCO, CA 94109 (37.788035, -122.417968)
1342 0028598-02-001 Tom Family Assn 777 Clay Apts 777 Clay St San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   777 CLAY ST San Francisco, CA 94108 (37.794295, -122.40606)
1351 0028598-03-001 Tom Family Assn 817 Clay St Bldg 817 Clay St San Francisco 1 CA 1 94108 9 10/01/1968   01/01/1997   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   817 CLAY ST San Francisco, CA 94108 (37.794203, -122.406697)
1357 0028598-04-001 Tom Family Assn 777 Clay St Bldg 777 Clay St San Francisco 1 CA 1 94108 9 10/01/1968   01/01/1997   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   777 CLAY ST San Francisco, CA 94108 (37.794295, -122.40606)
1380 0115900-01-001 Bay Architects Associates Inc Bay Architects Associates Inc 1550 Pacific Ave San Francisco 1 CA 1 94109 24 02/12/1979   02/12/1979   1550 Pacific Av San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Russian Hill 5   1550 PACIFIC AVE San Francisco, CA 94109 (37.795125, -122.420834)
1404 0034816-01-001 Tong Kenneth G 1658 Washington Apts 1658 Washington St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1270 California St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1658 WASHINGTON ST San Francisco, CA 94109 (37.793355, -122.420536)
1458 0079861-03-001 Franklin Bowles Galleries Inc Franklin Bowles Galleries Inc 765 Beach St San Francisco 1 CA 1 94109 24 11/30/1973   12/04/1997   765 Beach St San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     2 Russian Hill 5   765 BEACH ST San Francisco, CA 94109 (37.806546, -122.421548)
1498 0116214-01-001 Yuen Kent & John Kent & John Union Service 999 Polk St San Francisco 1 CA 1 94109 24 03/05/1979   03/05/1979   999 Polk St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0 D24 H03 H31 Multiple 6 3 Tenderloin 11   999 POLK ST San Francisco, CA 94109 (37.785654, -122.419695)
1519 0062015-01-001 C E Ricci Etal 1599 Green Apts 1599 Green St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   1650 California St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1599 GREEN ST San Francisco, CA 94123 (37.797448, -122.425133)
1709 0001443-01-001 Haines Robert D Argonaut Book Shop 786-792 Sutter St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   786 Sutter St San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 P52 State 2nd Hand Dealer Jewelry/clothg/furn/books 3 1 Nob Hill 17   786 792 SUTTER ST San Francisco, CA 94109 (37.788631, -122.413364)
1717 0073725-01-001 Roderick P Bushnell Etal Bushnell-Caplan-Fielding 900 Kearny St 299 San Francisco 1 CA 1 94133 11 09/01/1971   01/09/2008 07/06/2017 1388 Sutter St 810 Ste San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   900 KEARNY ST San Francisco, CA 94133 (37.796334, -122.405188)
1747 0101482-01-001 Haas Herbert P & Eva L 675 Fell St Apartments 675 Fell St San Francisco 1 CA 1 94102 16 05/04/1976   05/04/1976   2001 Van Ness Av #409a San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10   675 FELL ST San Francisco, CA 94102 (37.775162, -122.4289)
1775 0101482-01-002 Haas Herbert P & Eva L 675 Fell St Apartments 675 Fell St San Francisco 1 CA 1 94102 16 05/04/1976   05/04/1976   2001 Van Ness Av #409a San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10   675 FELL ST San Francisco, CA 94102 (37.775162, -122.4289)
1796 0116892-01-001 Steele F B Md Steele F B Md-A Prof Corp 2540 California St San Francisco 1 CA 1 94115 4 07/01/1975   07/01/1975 05/01/2016 1801 Bush Street 131d San Francisco 1 94109 7 CA     0 0     2 Pacific Heights 16   2540 CALIFORNIA ST San Francisco, CA 94115 (37.788612, -122.436159)
1810 0101482-02-001 Haas Herbert P & Eva L 1247-1251 Fulton St Apartments 1247 Fulton St San Francisco 1 CA 1 94117 33 05/04/1976   04/14/1980   2001 Van Ness Av #409a San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10   1247 FULTON ST San Francisco, CA 94117 (37.776973, -122.43733)
1878 0117101-01-001 Mcardle John & Devra 2405 Octavia Apts 2405 Octavia St San Francisco 1 CA 1 94109 24 02/28/1979   02/28/1979   2405 Octavia Street San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Pacific Heights 16   2405 OCTAVIA ST San Francisco, CA 94109 (37.794713, -122.428268)
1921 0101540-01-001 Hirigoyen Martin 2355 Francisco Apts 2355 Francisco St San Francisco 1 CA 1 94123 3 11/01/1976   11/01/1976   1700 Jackson St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   2355 FRANCISCO ST San Francisco, CA 94123 (37.80079, -122.443946)
2015 0014726-01-001 Kenneth I. Light, Md., Inc. Jensen Watson & Light Mds Inc 1700 California St 340 San Francisco 1 CA 1 94109 24 10/01/1968   06/23/2008   1700 California St Suite 340 San Francisco 1 94109 7 CA     0 0     2 Pacific Heights 16   1700 CALIFORNIA ST San Francisco, CA 94109 (37.790288, -122.422996)
2021 0383584-03-001 Kumar Jogesh Jogesh Kumar 423 16th Ave San Francisco 1 CA 1 94118 6 12/01/2011   12/01/2011   3098 Polk St San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     1 6 Outer Richmond 9   423 16TH AVE San Francisco, CA 94118 (37.779991, -122.475068)
2060 0035169-01-001 Jung Joe Ling 1224 Taylor Apts 1224 Taylor St San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968 01/01/2015 1769 Hyde St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1224 TAYLOR ST San Francisco, CA 94108 (37.793774, -122.412899)
2064 0035169-02-001 Jung Joe Ling 1761-1773 Hyde Apts 1761 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968 01/01/2015 1769 Hyde St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1761 HYDE ST San Francisco, CA 94109 (37.797192, -122.418661)
2076 0035169-03-001 Jung Joe Ling 1112 Larkin St Apts 1112 Larkin St San Francisco 1 CA 1 94109 24 10/01/1968   12/20/1988   1769 Hyde St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1112 LARKIN ST San Francisco, CA 94109 (37.788165, -122.418503)
2079 0035169-04-001 Jung Joe Ling 1455 Leavenworth St Apartments 1455 Leavenworth St San Francisco 1 CA 1 94109 24 10/01/1968   09/23/1986 01/01/2015 1769 Hyde St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1455 LEAVENWORTH ST San Francisco, CA 94109 (37.794649, -122.416471)
2098 0035170-01-001 Hayman Jean 1761 Vallejo Apartments 1761 Vallejo St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   1999 Van Ness Ave San Francisco 1 94109 7 CA     0 0     2 Pacific Heights 16   1761 VALLEJO ST San Francisco, CA 94123 (37.79636, -122.426193)
2108 0117529-08-001 Raynal David 1550 Steiner St Apts 1550 Steiner St San Francisco 1 CA 1 94115 4 03/13/1979   01/01/2002   933 Geary Blvd San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Western Addition 29   1550 STEINER ST San Francisco, CA 94115 (37.78356, -122.434462)
2140 0015188-01-001 Zel R Kahn & Sons Inc Kahn Zel R & Sons 1200 Gough St 900 San Francisco 1 CA 1 94109 24 10/01/1968   10/21/2009   1200 Gough St Ste 900 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Western Addition 29   1200 GOUGH ST San Francisco, CA 94109 (37.784704, -122.424566)
2141 0073951-01-001 Harrison St Assoc 855 Harrison Bldg 855 Harrison St San Francisco 1 CA 1 94107 22 07/01/1970   07/01/1970   1929 Van Ness Ave San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   855 HARRISON ST San Francisco, CA 94107 (37.779772, -122.400924)
2148 0035218-01-001 Wong Yen F 178 12th Av Apts 178 12th Ave San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   1540 Sacramento St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   178 12TH AVE San Francisco, CA 94118 (37.784928, -122.47102)
2154 0015188-02-001 Zel R Kahn & Sons Inc 355 Brannan St Building 1200 Gough St 900 San Francisco 1 CA 1 94109 24 10/01/1968   10/21/2009   1200 Gough St Ste 900 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Western Addition 29   1200 GOUGH ST San Francisco, CA 94109 (37.784704, -122.424566)
2222 0035292-01-001 Est Of Joie Exnicios, M Jacob 1801 Broadway Apts 1801 Broadway St San+francisco 8 CA 1 94109 24 10/01/1968   10/01/1968   1801 Broadway St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1801 BROADWAY ST San Francisco, CA 94109 (37.795304, -122.426862)
2223 0074297-01-001 Ferrera Emil & Frank 4534 Mission Apts 4534 Mission St San Francisco 1 CA 1 94112 28 01/01/1972   01/01/1972   1999 Van Ness Ave San Francisco 1 94109 7 CA     0 0     11 Outer Mission 35   4534 MISSION ST San Francisco, CA 94112 (37.725281, -122.434359)
2227 0035344-01-001 Chiao James M & Constance 1815 Leavenworth Apts 1815 Leavenworth St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1815 Leavenworth St #2 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1815 LEAVENWORTH ST San Francisco, CA 94109 (37.797846, -122.417092)
2237 0074297-02-001 Ferrera Emil & Frank 4828 Mission Apts 4828 Mission St San Francisco 1 CA 1 94112 28 01/01/1972   01/01/1972   1999 Van Ness Ave San Francisco 1 94109 7 CA     0 0     11 Outer Mission 35   4828 MISSION ST San Francisco, CA 94112 (37.720801, -122.437744)
2243 0035344-03-001 Chiao James M & Constance 1455 Greenwich Apts 1455 Greenwich St San Francisco 1 CA 1 94109 24 10/01/1968   01/01/1982 12/31/2013 1815 Leavenworth St #2 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Russian Hill 5   1455 GREENWICH ST San Francisco, CA 94109 (37.800525, -122.423612)
2250 0142970-01-001 Zovickian David V Zovickian David V 1290 Chestnut St San Francisco 1 CA 1 94109 24 09/01/1983   09/01/1983   1290 Chestnut St San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     2 Russian Hill 5   1290 CHESTNUT ST San Francisco, CA 94109 (37.802315, -122.424415)
2345 0074368-01-001 Tai Loy Lau Etal 1950 Jones St Apts 1950 Jones St San Francisco 1 CA 1 94133 11 01/01/1972   01/01/1972   80 Glover St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1950 JONES ST San Francisco, CA 94133 (37.799258, -122.415701)
2356 0074368-02-001 Tai Loy Lau Etal 1620 Jones Apts 1620 Jones St San Francisco 1 CA 1 94109 24 01/01/1972   07/11/1973   80 Glover St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1620 JONES ST San Francisco, CA 94109 (37.796226, -122.415074)
2358 0143182-01-001 Stark J-A Med Corp Stark J-A Med Corp 909 Hyde St 432 San Francisco 1 CA 1 94109 24 01/01/1983   01/01/1983   909 Hyde St #432 San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)
2367 0035453-01-001 Scatena Marion & Snaider J 1845 Pacific Apts 1845 Pacific Ave San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   2128 Franklin St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Pacific Heights 16   1845 PACIFIC AVE San Francisco, CA 94109 (37.794514, -122.425607)
2372 0102235-01-001 Toy Mei Kin L 517 Minna Apts 517 Minna St A San Francisco 1 CA 1 94103 25 08/06/1976   08/06/1976   2815 Van Ness Ave 9 Apt San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     6 3 South of Market 15   517 MINNA ST A San Francisco, CA 94103 (37.780174, -122.408643)
2383 0143208-01-001 Harris Restaurant Llc Harris Restaurant 2100 Van Ness Ave San Francisco 1 CA 1 94109 24 07/07/1983   07/07/1983   2100 Van Ness Av San Francisco 1 94109 7 CA 7220-7229 8 Food Services 8 0 0 D04 D19 H26 P23 P48 Multiple 3 1 Russian Hill 5   2100 VAN NESS AVE San Francisco, CA 94109 (37.795017, -122.423195)
2384 0398246-01-001 La Cave D'amelie Inc Amelie 1754 Polk St San Francisco 1 CA 1 94109 24 07/01/2006   07/01/2006   1754 Polk St San Francisco 1 94109 7 CA 7220-7229 8 Food Services 8 0 0 H25 P54 Multiple 3 1 Russian Hill 5   1754 POLK ST San Francisco, CA 94109 (37.792865, -122.421166)
2387 0035477-01-001 Pun Joann, Et Al 1850 Larkin Apts 1850 Larkin St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1850 Larkin St #5 San Francisco 1 94109 7 CA     0 0     3 1 Russian Hill 5   1850 LARKIN ST San Francisco, CA 94109 (37.795029, -122.419904)
2524 0074516-01-001 Azala Enterprises Inc Geary Club 768 Geary St San Francisco 1 CA 1 94109 24 01/01/1973   01/01/1973   768 Geary St San Francisco 1 94109 7 CA     0 0 A45 H86 Multiple 6 3 Tenderloin 11   768 GEARY ST San Francisco, CA 94109 (37.786379, -122.415958)
2544 0088251-01-001 Gin Wee Sum & Suit Hon 1500-1510 Clay St Apartments 1500 Clay St San Francisco 1 CA 1 94109 24 09/22/1972   09/22/1972   1502 Clay St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1500 CLAY ST San Francisco, CA 94109 (37.792774, -122.418003)
2569 0143444-01-002 C & H Travel & Tours Inc C & H International 109 Stevenson St 300 San Francisco 1 CA 1 94105 7 10/04/1983   02/23/2009   1388 Sutter Street Ste 607 San Francisco 1 94109 7 CA     0 0     6 3 Financial District/South Beach 1   109 STEVENSON ST San Francisco, CA 94105 (37.788797, -122.400809)
2572 0143444-02-001 C & H Travel & Tours Inc C & H International 1388 Sutter St 607 San Francisco 1 CA 1 94109 24 10/04/1983   11/01/2013   1388 Sutter Street Ste 607 San Francisco 1 94109 7 CA     0 0     2 Western Addition 29   1388 SUTTER ST San Francisco, CA 94109 (37.787397, -122.423011)
2582 0154077-04-001 St Francis Memorial Hospital St Francis Hospital 900 Hyde St San Francisco 1 CA 1 94109 24 01/01/1986   01/01/1986   900 Hyde Street San Francisco 1 94109 7 CA     0 0 H26 Restaurant Greater Than 2,000 Sqft 3 1 Nob Hill 17   900 HYDE ST San Francisco, CA 94109 (37.789561, -122.417112)
2638 0042435-01-001 Chin Bing Suey & Ru Ju Trs 240/242 Ofarrell Bldg 240 Ofarrell St San Francisco 1 CA 1 94102 16 01/01/1970   01/01/1970   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   240 OFARRELL ST San Francisco, CA 94102 (37.786335, -122.408853)
2660 0042435-02-001 Chin Bing Suey & Ru Ju Trs 728/730 Washington Bldg 728 Washington St San Francisco 1 CA 1 94108 9 01/01/1970   01/01/1970   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   728 WASHINGTON ST San Francisco, CA 94108 (37.795262, -122.405536)
2663 0003842-08-001 British Motor Car Dist Ltd Bentley San Francisco 999 Van Ness Ave San Francisco 1 CA 1 94109 24 10/01/1968   09/01/2002   901 Van Ness Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 D23 D26 Multiple 5 7 Western Addition 29   999 VAN NESS AVE San Francisco, CA 94109 (37.78428, -122.42119)
2665 0042435-03-001 Chin Bing Suey & Ru Ju Trs 0730 Washington Apts 730 Washington St San Francisco 1 CA 1 94108 9 01/01/1970   01/01/1986   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   730 WASHINGTON ST San Francisco, CA 94108 (37.795262, -122.405536)
2667 0042435-04-001 Chin Bing Suey & Ru Ju Trs 240/242 Ofarrell Bldg. 240-242 Ofarell St San Francisco 1 CA 1 94102 16 01/01/1970   05/13/1994   1145 Bush St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   240 242 OFARELL ST San Francisco, CA 94102
2682 0074694-02-001 Quon Richard & Lorene 1550 Vallejo Apts 1550 Vallejo St San Francisco 1 CA 1 94109 24 06/14/1972   01/01/1974   1550 Vallejo St #4 San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     3 1 Russian Hill 5   1550 VALLEJO ST San Francisco, CA 94109 (37.796784, -122.42284)
2687 0003842-10-001 British Motor Car Dist Ltd Lamborghini San Francisco 999 Van Ness Ave San Francisco 1 CA 1 94109 24 10/01/1968   09/01/2002   901 Van Ness Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     5 7 Western Addition 29   999 VAN NESS AVE San Francisco, CA 94109 (37.78428, -122.42119)
2695 0003842-11-001 British Motor Car Dist Ltd Lotus San Francisco 999 Van Ness Ave San Francisco 1 CA 1 94109 24 10/01/1968   11/24/2003   901 Van Ness Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     5 7 Western Addition 29   999 VAN NESS AVE San Francisco, CA 94109 (37.78428, -122.42119)
2697 0003842-13-001 British Motor Car Dist Ltd Pagani San Francisco 999 Van Ness Ave San Francisco 1 CA 1 94109 24 10/01/1968   10/01/2013   901 Van Ness Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     5 7 Western Addition 29   999 VAN NESS AVE San Francisco, CA 94109 (37.78428, -122.42119)
2751 0130993-01-001 Owyeung Siu Mamie How-Haas U 3356-3360 16th St Apartme.ts 3356 16th St San Francisco 1 CA 1 94114 34 01/25/1980   01/25/1980   2132 Larkin St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30   3356 16TH ST San Francisco, CA 94114 (37.764546, -122.427843)
2752 0051451-01-001 Wong William 1350/1398 Grant Bldg 1350 Grant Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1637 Leavenworth St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   1350 GRANT AVE San Francisco, CA 94133 (37.799505, -122.407367)
2778 0129483-01-001 Paulson Jon W Dentrade International 2000 California St San Francisco 1 CA 1 94109 24 06/15/1980   06/15/1980   2000 California Street 102 San Francisco 1 94109 7 CA 4200-4299 7 Wholesale Trade 7 0 0     2 Pacific Heights 16   2000 CALIFORNIA ST San Francisco, CA 94109 (37.789706, -122.427586)
2794 0042529-01-001 Lee Edward F 740-746 Hyde Apts 740 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   746 Hyde St San Francisco 1 94109 7 CA     0 0     3 1 Nob Hill 17   740 HYDE ST San Francisco, CA 94109 (37.787779, -122.416757)
2814 0003983-01-001 Brownies Hardware Inc Brownies Hardware Inc 1563 Polk St San Francisco 1 CA 1 94109 24 10/01/1968   09/05/1998   1563 Polk St San Francisco 1 94109 7 CA     0 0     3 1 Nob Hill 17   1563 POLK ST San Francisco, CA 94109 (37.791164, -122.420806)

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "Registered_Business_Locations_-_San_Francisco" (
"Location Id" TEXT,
  "Business Account Number" INTEGER,
  "Ownership Name" TEXT,
  "DBA Name" TEXT,
  "Street Address" TEXT,
  "City" INTEGER,
  "State" INTEGER,
  "Source Zipcode" INTEGER,
  "Business Start Date" TEXT,
  "Business End Date" REAL,
  "Location Start Date" TEXT,
  "Location End Date" REAL,
  "Mail Address" TEXT,
  "Mail City" INTEGER,
  "Mail Zipcode" INTEGER,
  "Mail State" TEXT,
  "NAICS Code" INTEGER,
  "NAICS Code Description" INTEGER,
  "Parking Tax" INTEGER,
  "Transient Occupancy Tax" INTEGER,
  "LIC Code" REAL,
  "LIC Code Description" REAL,
  "Supervisor District" INTEGER,
  "Neighborhoods - Analysis Boundaries" INTEGER,
  "Business Corridor" INTEGER,
  "Business Location" TEXT
,
FOREIGN KEY ("Neighborhoods - Analysis Boundaries") REFERENCES [Neighborhoods - Analysis Boundaries](id),
    FOREIGN KEY ("NAICS Code Description") REFERENCES [NAICS Code Description](id),
    FOREIGN KEY ("NAICS Code") REFERENCES [NAICS Code](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("Mail Zipcode") REFERENCES [Mail Zipcode](id),
    FOREIGN KEY ("Source Zipcode") REFERENCES [Source Zipcode](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("Supervisor District") REFERENCES [Supervisor District](id),
    FOREIGN KEY ("Business Corridor") REFERENCES [Business Corridor](id),
    FOREIGN KEY ("Mail City") REFERENCES [Mail City](id))
Powered by Datasette · Query took 155.996ms · Data source: data.sfgov.org