home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

563 rows where Mail City = 17

View and edit SQL

Suggested facets: City, Business End Date, Mail Zipcode, NAICS Code, NAICS Code Description, Parking Tax, Transient Occupancy Tax, LIC Code, LIC Code Description, Supervisor District

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
96 0034354-01-001 Ternullo Eugenia 154 Portola Apts 154 Portola Dr San Francisco 1 CA 1 94131 14 10/01/1968   10/01/1968   710 Laurel Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Twin Peaks 20   154 PORTOLA DR San Francisco, CA 94131 (37.748417, -122.444236)
299 0140907-01-001 Fogarty James A Fogarty Construction 1659 41st Ave San Francisco 1 CA 1 94122 19 01/01/1983   01/01/1983   1016 Helen Dr Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0     4 10 Sunset/Parkside 14   1659 41ST AVE San Francisco, CA 94122 (37.755838, -122.500225)
415 0061254-01-001 Flahaven Thomas A & Rose 90 Cumberland St Apts 90 Cumberland St San Francisco 1 CA 1 94110 18 07/01/1969   07/01/1969   360 Vallejo Dr 115 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   90 CUMBERLAND ST San Francisco, CA 94110 (37.759065, -122.425513)
421 0061254-02-001 Flahaven Thomas A & Rose 88 Cumberland St Apts 88 Cumberland St San Francisco 1 CA 1 94110 18 07/01/1969   08/25/1978   360 Vallejo Dr 115 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   88 CUMBERLAND ST San Francisco, CA 94110 (37.759069, -122.425426)
466 0084924-01-001 Zucconi Guido & Ida 530 Bartlett Apts 530 Bartlett St San Francisco 1 CA 1 94110 18 04/10/1973   04/10/1973   209 Elder Millbrae 17 94030 34 CA     0 0     9 8 Mission 12   530 BARTLETT ST San Francisco, CA 94110 (37.748551, -122.419214)
1551 0087299-01-001 Vorperian Jerry & Knar 601 Taraval Bldg 601 Taraval St San Francisco 1 CA 1 94116 23 10/20/1972   10/20/1972   1339 Murchison Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   601 TARAVAL ST San Francisco, CA 94116 (37.743188, -122.472654)
1555 0087299-02-001 Vorperian Jerry & Knar 1430-1434 Taraval Bldg 1430 Taraval St San Francisco 1 CA 1 94116 23 10/20/1972   05/16/1979   1339 Murchison Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   1430 TARAVAL ST San Francisco, CA 94116 (37.742795, -122.481635)
1641 0101238-01-001 Woo, Stanley Et Al 696 36th Av Apts 696 36th Ave San Francisco 1 CA 1 94121 15 04/28/2004   04/28/2004   1141 Tuolumne Road Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   696 36TH AVE San Francisco, CA 94121 (37.776006, -122.496267)
1720 0373648-01-001 A & R Corporation Aamco - San Francisco 1545 Pine St San Francisco 1 CA 1 94109 24 02/01/2004   02/01/2004   444 Green Hills Dr Millbrae 17 94030 34 CA     0 0     3 1 Nob Hill 17   1545 PINE ST San Francisco, CA 94109 (37.789527, -122.42124)
1864 0101485-01-001 Marshall Carl F & Alcira 4115 Lincoln Apts 4115 Lincoln Way San Francisco 1 CA 1 94122 19 01/30/1976   01/30/1976   P O Box 1090 Po Box 1090 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   4115 LINCOLN WAY San Francisco, CA 94122 (37.764296, -122.502248)
1865 0101485-01-002 Marshall Carl F & Alcira 4115 Lincoln Apts 3350 Judah St San Francisco 1 CA 1 94122 19 01/30/1976   12/30/1998 05/26/2017 P O Box 1090 Po Box 1090 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   3350 JUDAH ST San Francisco, CA 94122 (37.760769, -122.498194)
1873 0101485-01-003 Marshall Carl F & Alcira 4115 Lincoln Apts 2015 Lincoln Way San Francisco 1 CA 1 94122 19 01/30/1976   01/12/2001 05/26/2017 P O Box 1090 Po Box 1090 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   2015 LINCOLN WAY San Francisco, CA 94122 (37.765313, -122.479681)
1886 0101485-02-001 Marshall Carl F & Alcira 696 27th Ave Apts 696 27th Ave San Francisco 1 CA 1 94121 15 01/30/1976   12/20/1995 05/26/2017 P O Box 1090 Po Box 1090 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   696 27TH AVE San Francisco, CA 94121 (37.77623, -122.486627)
1894 0101485-03-001 Marshall Carl F & Alcira 1711 Lake Apartments 1711 Lake St San Francisco 1 CA 1 94121 15 01/30/1976   02/03/1997 05/26/2017 P O Box 1090 Po Box 1090 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   1711 LAKE ST San Francisco, CA 94121 (37.786073, -122.477908)
1895 0101485-04-001 Marshall Carl F & Alcira 3648 Irving Apt 3648 Irving St San Francisco 1 CA 1 94122 19 01/30/1976   05/19/2000 05/26/2017 P O Box 1090 Po Box 1090 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   3648 IRVING ST San Francisco, CA 94122 (37.762695, -122.497245)
2245 0051174-01-001 Goldman Bruce Etal 2434/2440 Noriega Bldg 2434 Noriega St San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   Po Box 1417 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   2434 NORIEGA ST San Francisco, CA 94122 (37.753652, -122.489976)
2444 0118056-01-001 Drogitis Art & Mary Ann 948 South Van Ness Apts 948 Van Ness Ave San Francisco 1 CA 1 94109 24 06/27/1978   06/27/1978   1309 Murchison Dr Millbrae 17 94030 34 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   948 VAN NESS AVE San Francisco, CA 94109 (37.784423, -122.421056)
3384 0448061-02-999 Faber And Son Inc Faber And Son Inc Po Box 336 Millbrae 87 CA 1 94030 136 08/05/2013   08/05/2013   Po Box 336 Millbrae 17 94030 34 CA     0 0            
3455 0089542-01-001 Bruce Goldman Etal 744-756 Irving Bldg 744 Irving St San Francisco 1 CA 1 94122 19 05/01/1975   05/01/1975   Po Box 1417 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   744 IRVING ST San Francisco, CA 94122 (37.76408, -122.465451)
3555 0119331-01-001 Araj Admon & Vera 2151-2191 Irving Bldg 2151 Irving St San Francisco 1 CA 1 94122 19 09/20/1977   09/20/1977   1244 Toyon Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   2151 IRVING ST San Francisco, CA 94122 (37.7634, -122.481122)
3736 0017587-01-999 Lynch & Sons Van & Storage Co Lynch & Sons Van & Storage Co 408 Santa Florita Ave Millbrae 87 CA 1 94030 136 10/01/1968   01/01/2009   408 Santa Florita Ave Millbrae 17 94030 34 CA     0 0           408 SANTA FLORITA AVE MILLBRAE, CA 94030 (37.611612, -122.412654)
3804 0031446-01-001 Yong Kee Co Inc Yong Kee Co Inc 732 Jackson St San Francisco 1 CA 1 94133 11 05/31/2013   05/31/2013   930 Crestview Drive Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   732 JACKSON ST San Francisco, CA 94133 (37.795952, -122.407242)
3880 0031446-06-001 Yong Kee Co Inc Yong Kee Company Inc 916 Clement St San Francisco 1 CA 1 94121 15 05/31/2013   05/31/2013   930 Crestview Drive Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           916 CLEMENT ST San Francisco, CA 94121 (37.782737, -122.468882)
4558 0063541-01-001 Drogitis Joanna 1287-1291 Alabama Rentals 1287 Alabama St San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   943 Clearfield Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   1287 ALABAMA ST San Francisco, CA 94110 (37.751284, -122.410829)
4944 0076809-01-001 Loukas Andrew Loukas Andrew Dds 5248 Mission St San Francisco 1 CA 1 94112 28 04/02/1973   09/01/2007   Po Box 999 Millbrae 17 94030 34 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     11 Outer Mission 35   5248 MISSION ST San Francisco, CA 94112 (37.715046, -122.442166)
5157 0032504-01-001 Cash Henry L 1201/1207 5th Av Apts 1201 5th Ave San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   1094 Ridgewood Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1201 5TH AVE San Francisco, CA 94122 (37.765867, -122.46216)
5298 0132409-01-002 Wong Chick Chuen 638-644 Pacific Ave Apts 644 Pacific Ave San Francisco 1 CA 1 94133 11 10/21/1981   08/28/1997   800 Morningside Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   644 PACIFIC AVE San Francisco, CA 94133 (37.796954, -122.406455)
5676 0055342-01-001 Creighton John P/fiumara Alice 1201-1211 Geneva Bldg 1209 Geneva Ave San Francisco 1 CA 1 94112 28 07/01/1969   07/01/1969   1116 Fernwood Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Excelsior 23   1209 GENEVA AVE San Francisco, CA 94112 (37.714153, -122.435923)
5771 0064699-01-001 Vozaites Antonios D & Thalia 3898 24th St Bldg 3898 24th St San Francisco 1 CA 1 94114 34 01/01/1970   01/01/1970   870 Ahwahnee Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   3898 24TH ST San Francisco, CA 94114 (37.751566, -122.429669)
5777 0064699-02-001 Vozaites Antonios D & Thalia 942-946 Geneva St Bldg 942 Geneva Ave San Francisco 1 CA 1 94112 28 01/01/1970   01/01/1984   870 Ahwahnee Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Excelsior 23   942 GENEVA AVE San Francisco, CA 94112 (37.716079, -122.440471)
5873 0133103-01-001 Perez Miguel 928-940 Valencia Rentals 928 Valencia St San Francisco 1 CA 1 94110 18 01/01/1984   01/01/1984   906 Larkspur Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   928 VALENCIA ST San Francisco, CA 94110 (37.757926, -122.421227)
5878 0133103-02-001 Perez Miguel 14 Liberty St Apartments 14 Liberty St San Francisco 1 CA 1 94110 18 01/01/1984   01/01/1984   906 Larkspur Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   14 LIBERTY ST San Francisco, CA 94110 (37.757676, -122.421627)
5882 0133103-03-001 Perez Miguel 2261-2263 Mission Building 2261 Mission St San Francisco 1 CA 1 94110 18 01/01/1984   01/01/1984   906 Larkspur Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   2261 MISSION ST San Francisco, CA 94110 (37.760844, -122.419261)
5927 0037524-01-001 Pinfold Revocable Trust 2529 San Bruno Apts 2529 San Bruno Ave San Francisco 1 CA 1 94134 26 10/01/1968   10/01/1968   846 Pinon Av Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Portola 18   2529 SAN BRUNO AVE San Francisco, CA 94134 (37.729833, -122.404525)
6390 0094330-01-001 Johnson Ralph F & Carole E 189 Duncan St Apartments 189 Duncan St San Francisco 1 CA 1 94110 18 06/13/1975   06/13/1975   640 Hillcrest Bl Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   189 DUNCAN ST San Francisco, CA 94110 (37.746256, -122.424275)
6431 0094330-03-001 Johnson Ralph F & Carole E 5211 Mission St Apartments 5211 Mission St San Francisco 1 CA 1 94112 28 06/13/1975   01/01/1989 12/28/2015 640 Hillcrest Bl Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Excelsior 23   5211 MISSION ST San Francisco, CA 94112 (37.715179, -122.442028)
6571 0094330-06-999 Johnson Ralph F & Carole E Goalline Construction 640 Hillcrest Blvd Millbrae 87 CA 1 94030 136 06/13/1975   08/01/2005 01/30/2015 640 Hillcrest Bl Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           640 HILLCREST BLVD MILLBRAE, CA 94030 (37.596714, -122.397045)
7001 0033186-01-001 Holder Geary & Astrid 1319 10th Av Apts 1319 10th Ave San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   1275 Lower Vista Grande Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1319 10TH AVE San Francisco, CA 94122 (37.763586, -122.467362)
7029 0033230-01-001 Wong Fay 1325 Hyde Apts 1325 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1352 Millbrae Ave Millbrae 17 94030 34 CA 7210-7219 9 Accommodations 9 0 0     3 1 Russian Hill 5   1325 HYDE ST San Francisco, CA 94109 (37.793225, -122.417849)
7319 0080387-02-001 Shastri Subhash S 301-305 Turk Bldg 301 Turk St San Francisco 1 CA 1 94102 16 01/01/1974   01/01/1976   1280 Lasuen Ct Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   301 TURK ST San Francisco, CA 94102 (37.782802, -122.41406)
7500 0080668-01-001 Lilles Renato & Elvira R 51 Masonic Apts 51 Masonic Ave San Francisco 1 CA 1 94118 6 01/01/1973   01/01/1973   905 Millbrae Av Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Lone Mountain/USF 24   51 MASONIC AVE San Francisco, CA 94118 (37.781523, -122.447588)
7577 0080785-01-001 Dunn Laverne 355 Barneveld Property 355 Barneveld Ave San Francisco 1 CA 1 94124 8 01/01/1972   01/01/1972   1306 Murchison Dr Millbrae 17 94030 34 CA     0 0     10 4 Bayview Hunters Point 4   355 BARNEVELD AVE San Francisco, CA 94124 (37.742543, -122.403374)
7944 0081074-01-001 Yuen Clifford Etal 417 Lake Apts 417 Lake St San Francisco 1 CA 1 94118 6 11/14/1973   11/14/1973   5 Green Hills Ct Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Inner Richmond 21   417 LAKE ST San Francisco, CA 94118 (37.786707, -122.463974)
7953 0081074-02-001 Yuen Clifford Etal Cmy Financial 999 Sutter St San Francisco 1 CA 1 94109 24 11/14/1973   01/01/2000 12/30/2013 5 Green Hills Ct Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   999 SUTTER ST San Francisco, CA 94109 (37.78818, -122.416833)
8884 0039557-01-001 Ravaglia R & Caramatti C Etal 3640 26th St Apts 3640 26th St San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   1268 Toyon Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   3640 26TH ST San Francisco, CA 94110 (37.748811, -122.421979)
8941 0039420-01-001 Gin-Wong Deborah E Etal 355 21st Av Apts 355 21st Ave San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968   1180 Helen Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   355 21ST AVE San Francisco, CA 94121 (37.781189, -122.480532)
9204 1085188-07-161 Michael Wong Michael Wong 540 Scott St San Francisco 1 CA 1 94117 33 05/25/1999   05/25/1999   423 Broadway # 638 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10    
9865 0139501-03-001 Pak Leon & Isabel 2255 Mason St Bldg 2255 Mason St San Francisco 1 CA 1 94133 11 04/22/2008   04/22/2008   1034 Sequoia Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   2255 MASON ST San Francisco, CA 94133 (37.804532, -122.413391)
10213 0070352-01-001 Colabianchi Sebastian F 1851 8th Av Apts 1851 8th Ave San Francisco 1 CA 1 94122 19 10/01/1968   05/24/1974   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1851 8TH AVE San Francisco, CA 94122 (37.753809, -122.464552)
10275 0070352-03-001 Colabianchi Sebastian F 1310 12th Av Apts 1310 12th Ave San Francisco 1 CA 1 94122 19 10/01/1968   09/11/1975   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1310 12TH AVE San Francisco, CA 94122 (37.763709, -122.469502)
10281 1137686-02-171 Uber Uber 170 Lewis Ave Millbrae 87 CA 1 94030 136 02/17/2017   02/17/2017   170 Lewis Ave Millbrae 17 94030 34 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
10325 0070352-04-001 Colabianchi Sebastian F 276 8th Av Apartments 276 8th Ave San Francisco 1 CA 1 94118 6 10/01/1968   01/26/1978   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   276 8TH AVE San Francisco, CA 94118 (37.783381, -122.466614)
10335 0070352-05-001 Colabianchi Sebastian F 826-830 Greenwich St Apts 826 Greenwich St San Francisco 1 CA 1 94133 11 10/01/1968   08/29/1985   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   826 GREENWICH ST San Francisco, CA 94133 (37.801834, -122.413402)
10360 0070352-08-001 Colabianchi Sebastian F Wash Town Laundramat 4349 California St San Francisco 1 CA 1 94118 6 10/01/1968   01/01/1995   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 H46 Auto Laundry Mech/pay-To-Operate Washing/dyeing 1 6 Inner Richmond 21   4349 CALIFORNIA ST San Francisco, CA 94118 (37.785062, -122.464031)
10394 0070352-09-001 Colabianchi Sebastian F Waller St Laundramat 1663 Waller St San Francisco 1 CA 1 94117 33 10/01/1968   01/01/1995   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 H46 Auto Laundry Mech/pay-To-Operate Washing/dyeing 5 7 Haight Ashbury 32   1663 WALLER ST San Francisco, CA 94117 (37.76851, -122.451264)
10395 0070352-10-001 Colabianchi Sebastian F 5608 Mission St Apts 5608 Mission St San Francisco 1 CA 1 94112 28 10/01/1968   04/20/1995   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Outer Mission 35   5608 MISSION ST San Francisco, CA 94112 (37.711356, -122.446549)
10399 0070352-11-001 Colabianchi Sebastian F 828 Greenwich St Apts 828-830 Greenwich St San Francisco 1 CA 1 94133 11 10/01/1968   02/20/1995   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   828 830 GREENWICH ST San Francisco, CA 94133 (37.801841, -122.41333)
10401 0070352-12-001 Colabianchi Sebastian F 1633 Waller St Apts 1663 Waller St San Francisco 1 CA 1 94117 33 10/01/1968   01/01/1995   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Haight Ashbury 32   1663 WALLER ST San Francisco, CA 94117 (37.76851, -122.451264)
10408 0070352-13-001 Colabianchi Sebastian F Coin-Op Laundry 1659 Waller St. San Francisco 1 CA 1 94117 33 10/01/1968   01/01/1996   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Haight Ashbury 32   1659 WALLER ST San Francisco, CA 94117 (37.768516, -122.451217)
10411 0070352-14-001 Colabianchi Sebastian F 4345 California St Apts 4345 California St San Francisco 1 CA 1 94121 15 10/01/1968   01/01/1997   Po Box 419 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   4345 CALIFORNIA ST San Francisco, CA 94121 (37.785068, -122.463988)
10532 0140131-01-999 Alotis Philip A/c Construction 647 Santa Barbara Ave Millbrae 87 CA 1 94030 136 07/01/1982   12/10/1998   647 Santa Barbara Ave. Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0           647 SANTA BARBARA AVE MILLBRAE, CA 94030 (37.608923, -122.414252)
10818 0143657-04-001 Chu Yat Wa Y 2248-2250 Vicente St 2248 Vicente St San Francisco 1 CA 1 94116 23 05/17/2005   03/01/2007   888 Morningside Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   2248 VICENTE ST San Francisco, CA 94116 (37.738621, -122.491332)
11765 0165295-01-001 Leong Kirk And May 241 Cervantes Bl Apartments 241 Cervantes Blvd San Francisco 1 CA 1 94123 3 01/01/1987   01/01/1987 12/31/2013 748 Berkshire Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   241 CERVANTES BLVD San Francisco, CA 94123 (37.80531, -122.441482)
11766 0165295-02-001 Leong Kirk And May 600 25th Av Apartments 600 25th Ave San Francisco 1 CA 1 94121 15 01/01/1987   01/01/1988 12/31/2013 748 Berkshire Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   600 25TH AVE San Francisco, CA 94121 (37.777913, -122.484582)
11767 0165295-03-001 Leong Kirk And May Leong Kirk Realty 1532 Noriega St San Francisco 1 CA 1 94122 19 01/01/1987   03/01/1988 01/01/2000 748 Berkshire Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   1532 NORIEGA ST San Francisco, CA 94122 (37.754074, -122.480344)
11960 0166590-04-001 T & A Drolapas & Sons L.p. 598 Guerrero St Bldg 598 Guerrero St San Francisco 1 CA 1 94110 18 07/01/1987   05/01/1996   611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   598 GUERRERO ST SAN FRANCISCO, CA 94110 (37.761563, -122.423842)
11961 0166590-07-002 T & A Drolapas & Sons L.p. T & A Drolapas & Sons Lp 3608 18th St San Francisco 1 CA 1 94110 18 07/01/1987   07/01/1987 12/31/2013 611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   3608 18TH ST SAN FRANCISCO, CA 94110 (37.761552, -122.42403)
11962 0166590-07-003 T & A Drolapas & Sons L.p. T & A Drolapas & Sons Lp 485 Guerrero St San Francisco 1 CA 1 94110 18 07/01/1987   06/02/2010   611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   485 GUERRERO ST San Francisco, CA 94110 (37.763486, -122.423928)
11963 0166590-07-004 T & A Drolapas & Sons L.p. T & A Drolapas & Sons Lp 789 Valencia St San Francisco 1 CA 1 94110 18 07/01/1987   07/01/1987 12/31/2013 611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   789 VALENCIA ST SAN FRANCISCO, CA 94110 (37.760353, -122.421451)
11964 0166590-08-001 T & A Drolapas & Sons L.p. 1705 Church St Bldg 1705 Church St San Francisco 1 CA 1 94131 14 07/01/1987   01/01/2000   611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   1705 CHURCH ST San Francisco, CA 94131 (37.743447, -122.426638)
11965 0166590-09-001 T & A Drolapas & Sons L.p. 785-787 Valencia St 785 Valencia St San Francisco 1 CA 1 94110 18 07/01/1987   01/01/2000   611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   785 VALENCIA ST San Francisco, CA 94110 (37.760395, -122.421455)
11993 0167037-01-001 Tai Lam Mak T Mak Plumbing Electrical Cons 2234 42nd Av San Francisco 1 CA 1 94116 23 11/16/1987   01/01/1990   1310 Murchison Dr Millbrae 17 94030 34 CA     0 0     4 10 Sunset/Parkside 14   2234 42ND AV San Francisco, CA 94116 (37.744994, -122.500547)
12028 0167231-01-001 Noce Trust 2201-2213 Union St Building 2201 Union St San Francisco 1 CA 1 94123 3 01/01/1988   01/01/1988   776 Berkshire Dr. Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   2201 UNION ST San Francisco, CA 94123 (37.79706, -122.435726)
12519 0171193-01-001 Koski Alfred E & Sunny V 1609 Franklin St Apartments 1609 Franklin St San Francisco 1 CA 1 94109 24 05/24/1988   05/24/1988   1076 Sycamore Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Western Addition 29   1609 FRANKLIN ST San Francisco, CA 94109 (37.789554, -122.423857)
13016 0078443-01-001 Lieuw Victor J Georges Coffee Shop 2200 Oakdale Ave San Francisco 1 CA 1 94124 8 08/30/1973   08/30/1973   1041 Crestview Dr Millbrae 17 94030 34 CA     0 0     10 4 Bayview Hunters Point 4   2200 OAKDALE AVE San Francisco, CA 94124 (37.741069, -122.401746)
13541 0184475-01-999 Signum Visual Concepts Inc Signum Visual Concepts Inc 25 Corte Alegre Millbrae 87 CA 1 94030 136 01/01/1989   01/01/2008   25 Corte Alegre Millbrae 17 94030 34 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           25 CORTE ALEGRE MILLBRAE, CA 94030 (37.593664, -122.402142)
13996 0187029-02-999 Baus William E Web Electric 35 Michael Ln Millbrae 87 CA 1 94030 136 08/20/1993   06/13/2001   35 Michael Ln Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0           35 MICHAEL LN MILLBRAE, CA 94030 (37.601427, -122.404004)
14410 0166590-06-001 T & A Drolapas & Sons L.p. 3380 21st St Apts 3380 21st St San Francisco 1 CA 1 94110 18 07/01/1987   04/28/2000   611 Santa Florita Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   3380 21ST ST San Francisco, CA 94110 (37.756805, -122.422846)
14427 0189423-01-001 Wong Arthur Gee 947 Wisconsin St Apartments 947 Wisconsin St San Francisco 1 CA 1 94107 22 07/01/1989   07/01/1989   938 Larkspur Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   947 WISCONSIN ST San Francisco, CA 94107 (37.755525, -122.39876)
14464 0189597-01-001 Leung Fung-Sun & Ivy Man-Kin-S 1525 Chestnut St Apartments 1525 Chestnut St San Francisco 1 CA 1 94123 3 04/01/1988   04/01/1988   Po Box 163 Millbrae 17 94030 34 CA     0 0     2 Marina 2   1525 CHESTNUT ST San Francisco, CA 94123 (37.8018, -122.428517)
14592 0132409-02-001 Wong Chick Chuen 638-644 Pacific Ave Bldg 638-644 Pacific Ave San Francisco 1 CA 1 94133 11 10/21/1981   08/28/1997   800 Morningside Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   638 644 PACIFIC AVE San Francisco, CA 94133 (37.796969, -122.406325)
14679 0190587-02-999 Courcoumelis Nick Positive Electric 75 Chadbourne Ave Millbrae 87 CA 1 94030 136 02/16/2004   02/16/2004   75 Chadbourne Ave Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0           75 CHADBOURNE AVE MILLBRAE, CA 94030 (37.598921, -122.389193)
15865 0198985-01-001 Tam Celine Balboa Pre School 521 Balboa St San Francisco 1 CA 1 94118 6 08/01/1990   08/01/1990   1057 Sycamore Dr Millbrae 17 94030 34 CA 8100-8139 5 Certain Services 5 0 0     1 6 Inner Richmond 21   521 BALBOA ST San Francisco, CA 94118 (37.777219, -122.464236)
16058 0200565-01-999 Rooney Jim A Rooney Construction 627 Bayview Ave Millbrae 87 CA 1 94030 136 04/10/2001   04/10/2001   627 Bayview Ave Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0           627 BAYVIEW AVE MILLBRAE, CA 94030 (37.608408, -122.415335)
16651 0188585-01-999 Leung Sander Y Sander Electric 1200 Hillcrest Blvd Millbrae 87 CA 1 94030 136 06/02/1989   06/02/1989   1200 Hillcrest Blvd Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0           1200 HILLCREST BLVD MILLBRAE, CA 94030 (37.593812, -122.405341)
17152 0208937-01-999 Helen & Tac Khang Dang Thomas's 1321 40th St Emeryville 128 Oakland 16 CA 1 94608 29 01/01/1995   03/01/1998   1363 El Camino Real St Apt Millbrae 17 94030 34 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1321 40TH ST OAKLAND, CA 94608 (37.830225, -122.283467)
17153 0208937-02-999 Helen & Tac Khang Dang New Concepts 1321 40th St Emeryville 218 Emeryville 13 CA 1 94608 29 01/01/1995   03/01/1998   1363 El Camino Real St Apt Millbrae 17 94030 34 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1321 40TH ST EMERYVILLE, CA 94608 (37.830225, -122.283467)
17284 0209741-01-999 Mclaughlin Dave A Mclaughlin Dave Plumbing 508 Anita Lane Brisbane+q4068 3   0 5 07/01/2003   07/01/2003   508 Anita Lane Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0           508 ANITA LANE 00000 (37.599634, -122.405696)
17911 0302472-01-999 Paratore Const Co Inc Gc Paratore Const Co Inc Gc 820 Murchison Dr Millbrae 87 CA 1 94030 136 02/24/1998   02/25/1998   820 Murchison Dr Millbrae 17 94030 34 CA     0 0           820 MURCHISON DR MILLBRAE, CA 94030 (37.591551, -122.391828)
18052 0303044-01-001 Garcia John Ernest Nulook Construction 3657 Taraval St San Francisco 1 CA 1 94116 23 02/14/1997   03/01/1999   226 Cuardo Ave Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0     4 10 Sunset/Parkside 14   3657 TARAVAL ST San Francisco, CA 94116 (37.741744, -122.505407)
18053 0303044-02-001 Garcia John Ernest Nulook Window & Construction 3657 Taraval St San Francisco 1 CA 1 94116 23 02/14/1997   03/01/1999   226 Cuardo Ave Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0     4 10 Sunset/Parkside 14   3657 TARAVAL ST San Francisco, CA 94116 (37.741744, -122.505407)
18471 0158302-01-999 Leung Yiu P Tai Shan Construction 619 Guadalupe Av Millbrae 87 CA 1 94030 136 09/01/1986   01/01/2002   619 Guadalupe Ave Millbrae 17 94030 34 CA 7210-7219 9 Accommodations 9 0 0           619 GUADALUPE AV MILLBRAE, CA 94030 (37.60974, -122.411737)
18713 0305472-01-999 J C Property Investment J C Property Investment 270 Willow Ave Millbrae Millbrae 87 CA 1 94030 136 04/15/1997   01/01/2004   270 Willow Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           270 WILLOW AVE MILLBRAE MILLBRAE, CA 94030 (37.599169, -122.393413)
20180 0180869-04-999 Wong Danny Ho First Evergreen Construction 416 Richmond Dr 6 Millbrae 87 CA 1 94030 136 01/11/2001   02/01/2008   416 Richmond Dr #6 Millbrae 17 94030 34 CA 4200-4299 7 Wholesale Trade 7 0 0           416 RICHMOND DR MILLBRAE, CA 94030 (37.601118, -122.401625)
20547 0313809-01-001 Sun Eric/grace/tommy 190 8th Ave Apts 190 8th Ave 1 San Francisco 1 CA 1 94118 6 12/05/1983   12/05/1983   173 Poplar Avenue Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     1 6 Inner Richmond 21   190 8TH AVE San Francisco, CA 94118 (37.784968, -122.466735)
20888 0315134-02-999 Kuo Lana C Access Homes & Land Investment 180 El Camino Real 2 Millbrae 87 CA 1 94030 136 01/30/1998   07/01/2002   180 El Camino Real #2 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           180 EL MILLBRAE, CA 94030 (37.599992, -122.388886)
20968 0300888-01-999 Atlantis Fire Protection Inc Atlantis Fire Protection Inc 145 Del Centro Ave Millbrae 87 CA 1 94030 136 10/22/1997   10/22/1997   145 Del Centro Ave Millbrae 17 94030 34 CA     0 0           145 DEL CENTRO AVE MILLBRAE, CA 94030 (37.591004, -122.41129)
21102 0316091-02-001 Luo Simon Ten-Ten Construction Co 663 Silver Ave San Francisco 1 CA 1 94134 26 04/20/1998   02/06/2009 06/30/2009 639 Bonita Ave Millbrae 17 94030 34 CA 2300-2399 6 Construction 6 0 0     11 Excelsior 23   663 SILVER AVE San Francisco, CA 94134 (37.728835, -122.422332)
21124 0316211-01-001 Nasra R Nasra R Nasra H Et Al Eden Plaza Cafe 600 Harrison St San Francisco 1 CA 1 94107 22 08/01/1994   08/01/1994   800 Hacienda Way Millbrae 17 94030 34 CA 7220-7229 8 Food Services 8 0 0 H28 Take-Out Establishment 6 3 Financial District/South Beach 1   600 HARRISON ST San Francisco, CA 94107 (37.783888, -122.395721)
21125 0316211-02-001 Nasra R Nasra R Nasra H Et Al Mint 400 Mcallister St San Francisco 1 CA 1 94102 16 08/01/1994   08/01/2003   800 Hacienda Way Millbrae 17 94030 34 CA 7220-7229 8 Food Services 8 0 0 H24 Restaurant Less Than 1,000 Sqft 6 3 Tenderloin 11   400 MCALLISTER ST San Francisco, CA 94102 (37.780227, -122.418959)

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 84.394ms · Data source: data.sfgov.org