home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5,790 rows where Mail Zipcode = 47

View and edit SQL

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

State

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
163 0025833-02-001 Soha Engineers Soha Engineers 48 Colin P Kelly St San+francisco 8 CA 1 94107 22 09/03/1997   06/01/2004   48 Colin P Kelly Street San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           48 COLIN P KELLY ST San Francisco, CA 94107 (37.781852, -122.39053)
185 0112731-01-002 Leslie A. Hennessy Inc Leslie A. Hennessy Inc 545 2nd St San Francisco 1 CA 1 94107 22 06/01/1978   10/04/2004   545 2nd St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 H07 H31 H73 Multiple       545 2ND ST San Francisco, CA 94107 (37.782483, -122.392898)
225 0026377-01-001 Slovenian Progressive Home Inc Slovenian Progresive Home 2101 Mariposa St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   2101 Mariposa St San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D04 P23 Multiple 10 4 Potrero Hill 28   2101 MARIPOSA ST San Francisco, CA 94107 (37.763382, -122.404376)
231 0009552-29-001 Fiore Richard A Fiore & Company 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
738 0012716-06-001 Paul's Stores Inc Paul Stores Inc Pier 70 Bldg #2 San+francisco 8 CA 1 94107 22 12/31/1987   12/31/1987   Pier 70 Bldg 2 San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0           2 San Francisco, CA 94107
1080 0061811-01-001 Speedway Copy Systems Inc Speedway Copy Systems Inc 227 Front St San Francisco 1 CA 1 94111 35 04/21/1970   04/21/1970   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   227 FRONT ST San Francisco, CA 94111 (37.793841, -122.398886)
1091 0061811-01-002 Speedway Copy Systems Inc Speedway Copy Systems Inc 475 4th St San Francisco 1 CA 1 94107 22 04/21/1970   01/01/1985   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   475 4TH ST San Francisco, CA 94107 (37.779819, -122.398409)
1095 0061811-01-013 Speedway Copy Systems Inc Speedway Copy Systems Inc 300 Pine St San Francisco 1 CA 1 94104 1 04/21/1970   05/06/2011   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   300 PINE ST San Francisco, CA 94104 (37.792105, -122.400958)
1284 0475760-02-001 Iaconi Mauro Iaconi Construction 695 Minnesota St San Francisco 1 CA 1 94107 22 01/15/2013   05/03/2013 05/03/2013 695 Minnesota Street San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Potrero Hill 28   695 MINNESOTA ST San Francisco, CA 94107 (37.761999, -122.390597)
1292 0100947-02-001 Parrish Susan J Susan Parrish Designs 200 Brannan St 416 San Francisco 1 CA 1 94107 22 02/06/1998   02/23/2007   200 Brannan St #416 San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     6 3 Financial District/South Beach 1   200 BRANNAN ST San Francisco, CA 94107 (37.783191, -122.390388)
1311 0013211-01-001 Hosoda Satoru Etal Hosoda Bros Inc 1444 Tennessee St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   1444 Tennessee Street San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0 D19 H21 Multiple 10 4 Potrero Hill 28   1444 TENNESSEE ST San Francisco, CA 94107 (37.753565, -122.388842)
1353 0050253-01-001 Maillard John & Laiola, Et Al 53-69 Bluxome Bldg 63 Bluxome St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   63 Bluxome San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   63 BLUXOME ST San Francisco, CA 94107 (37.776606, -122.39717)
1427 0127976-01-001 Metropolitan Elec Constr Inc Metropolitan Elec Constr Inc 2400 3rd St San Francisco 1 CA 1 94107 22 01/13/1981   01/13/1981   2400 3rd St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Potrero Hill 28   2400 3RD ST San Francisco, CA 94107 (37.759285, -122.388523)
1441 0028914-01-001 Trayer Engineering Corp Trayer Engineering Corp 898 Pennsylvania Ave San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   898 Pennsylvania Av San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0 D03 D10 D19 D39 Multiple 10 4 Potrero Hill 28   898 PENNSYLVANIA AVE San Francisco, CA 94107 (37.755723, -122.392931)
1474 0128024-01-002 Hansen Fontana Inc-A Cal Corp Hansen Fontana Inc 536 Bryant St San Francisco 1 CA 1 94107 22 09/11/1980   12/01/1991   536 Bryant St San Francisco 1 94107 47 CA 4200-4299 4400-4599 8100-8139 25 Multiple 13 0 0     6 3 South of Market 15   536 BRYANT ST San Francisco, CA 94107 (37.780641, -122.396687)
1528 0001190-01-001 Anderson Rowe & Buckley Inc Anderson Rowe & Buckley Inc 2833 3rd St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   2833 3rd St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0 D02 D19 Multiple 10 4 Potrero Hill 28   2833 3RD ST San Francisco, CA 94107 (37.75374, -122.387764)
1564 0073643-01-001 Pang Fred S Sin Ma 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   11/15/1972   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1576 0073643-02-001 Pang Fred S 1425 Minnesota Building 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   06/01/1987   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1578 0073643-03-001 Pang Fred S Lucky Foods Products Co 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   01/01/2002   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1587 0073643-04-001 Pang Fred S Sin Ma Imports Co 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   01/01/2002   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1610 0073643-05-001 Pang Fred S San Francisco Oils 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   12/09/2011   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1665 0028977-01-001 Tropical California Inc Tropical California Inc 666 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   666 Brannan St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   666 BRANNAN ST San Francisco, CA 94107 (37.775367, -122.400291)
1683 0128314-01-001 Martin M Ron Associates Inc Martin M Ron Associates Inc 859 Harrison St #200 San+francisco 8 CA 1 94107 22 10/01/1999   10/01/1999   859 Harrison St Ste #200 San Francisco 1 94107 47 CA     0 0           859 HARRISON ST San Francisco, CA 94107 (37.779705, -122.401009)
1690 0001341-04-001 Antonio Mariani Inc Antonio's Antiques Custom & Re 701 Bryant St San Francisco 1 CA 1 94107 22 10/01/1968   01/01/2013   701 Bryant Street San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     6 3 South of Market 15   701 BRYANT ST San Francisco, CA 94107 (37.777683, -122.400452)
1696 0013910-01-001 Hundley E M Hardware Co Hundley E M Hardware Co 617 Bryant St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   617 Bryant St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     6 3 South of Market 15   617 BRYANT ST San Francisco, CA 94107 (37.779257, -122.39847)
1820 0029694-01-001 Venetian Natural Marble Co In Venetian Natural Marble Co Inc 991 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   991 Harrison St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   991 HARRISON ST San Francisco, CA 94107 (37.777614, -122.40366)
1830 0014439-02-001 Konce Allan A Md Inc Connecticut Street Medical Grp 2 Connecticut St 2nd Fl San Francisco 1 CA 1 94107 22 06/19/2009   06/19/2009   2 Connecticut St 2nd Fl San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Mission Bay 25   2 CONNECTICUT ST San Francisco, CA 94107 (37.765982, -122.397837)
1859 0014503-01-001 Jackson He Co Jackson H E Co 334 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   334 Brannan St San Francisco 1 94107 47 CA 5210-5239 11 Financial Services 11 0 0     6 3 Financial District/South Beach 1   334 BRANNAN ST San Francisco, CA 94107 (37.781226, -122.392869)
1911 0128379-01-001 Dow Carter Carter Dow Photography 1041 25th St San Francisco 1 CA 1 94107 22 01/01/1981   01/01/1981   1041 25th St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Bayview Hunters Point 4   1041 25TH ST San Francisco, CA 94107 (37.752719, -122.389467)
2058 0387854-02-001 Pyramind Inc Pyramind Music 880 Folsom St San Francisco 1 CA 1 94107 22 01/27/2004   01/27/2004   880 Folsom St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   880 FOLSOM ST San Francisco, CA 94107 (37.780658, -122.402909)
2156 0128910-01-001 Cheung Chi-Kong Hong Kong Printing 755 Pennsylvania Ave San Francisco 1 CA 1 94107 22 03/15/1981   02/18/1997   755 Pennsylvania Ave San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   755 PENNSYLVANIA AVE San Francisco, CA 94107 (37.756388, -122.392995)
2219 0074290-01-001 Farnan William T Farnan Studios 2339 Third St 21 San Francisco 1 CA 1 94107 22 08/01/1972   12/01/2009   2339 3rd Street Suite 21 San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     10 4 Potrero Hill 28   2339 THIRD ST San Francisco, CA 94107 (37.760275, -122.388434)
2248 0142920-01-001 Woo Mary & Edmund Potrero Terrace Market 990 Wisconsin St San Francisco 1 CA 1 94107 22 07/02/1983   07/02/1983   990 Wisconsin St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 H03 H31 H73 Multiple 10 4 Potrero Hill 28   990 WISCONSIN ST San Francisco, CA 94107 (37.754861, -122.3987)
2267 0143046-01-001 Michael Stanton Michael Stanton Architecture 555 De Haro St 300 San Francisco 1 CA 1 94107 22 06/01/1983   06/30/2006 10/31/2014 1501 Mariposa Street 328 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Potrero Hill 28   555 DE HARO ST San Francisco, CA 94107 (37.762628, -122.401399)
2282 0143046-02-001 Michael Stanton Stanton Architecture 555 De Haro St 300 San Francisco 1 CA 1 94107 22 06/01/1983   05/01/2006 10/31/2014 1501 Mariposa Street 328 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Potrero Hill 28   555 DE HARO ST San Francisco, CA 94107 (37.762628, -122.401399)
2419 0143285-02-001 Thomas I Pendergast Inc Coast Truck Rental 2955 3rd St San Francisco 1 CA 1 94107 22 05/01/1983   05/01/1983   2955 3rd St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   2955 3RD ST San Francisco, CA 94107 (37.752045, -122.387607)
2434 0143285-03-001 Thomas I Pendergast Inc Rent-A-Wreck Of Sf 2955 3rd St San Francisco 1 CA 1 94107 22 05/01/1983   10/01/1992   2955 3rd St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0 P02 Driverless Auto Rent 10 4 Bayview Hunters Point 4   2955 3RD ST San Francisco, CA 94107 (37.752045, -122.387607)
2466 0143285-07-001 Thomas I Pendergast Inc Coast Truck And Auto Rental 2955 3rd St San Francisco 1 CA 1 94107 22 05/01/1983   10/01/2004   2955 3rd St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   2955 3RD ST San Francisco, CA 94107 (37.752045, -122.387607)
2479 0118186-02-999 Cross Link Inc Westar Marine Services 1441 N Northlake Way Seattle 69 WA 11 98103 107 06/07/1978   05/01/2012   Po Box 78100 San Francisco 1 94107 47 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1441 N NORTHLAKE WAY SEATTLE, WA 98103 (47.646918, -122.338756)
2509 0074496-02-001 Woo Harvey J & Sandy 155-157 Clara St Apartments 155 Clara St San Francisco 1 CA 1 94107 22 12/05/1972   01/01/1982 11/01/2014 210 Shipley St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   155 CLARA ST San Francisco, CA 94107 (37.780082, -122.401606)
2516 0074496-03-001 Woo Harvey J & Sandy 154 10th St Apts. 154 10th St San Francisco 1 CA 1 94103 25 12/05/1972   08/05/1993 11/01/2014 210 Shipley St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   154 10TH ST San Francisco, CA 94103 (37.774623, -122.415108)
2529 0003530-01-002 Books Inc Books Inc 3515 California St (Laurel Village) San Francisco 1 CA 1 94118 6 03/01/1977   01/01/1978   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     2 Presidio Heights 3   3515 CALIFORNIA ST (LAUREL VILLAGE San Francisco, CA 94118
2531 0003530-01-006 Books Inc Books Inc 601 Van Ness Ave San Francisco 1 CA 1 94102 16 03/01/1977   09/27/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0           601 VAN NESS AVE San Francisco, CA 94102 (37.781471, -122.420616)
2536 0003530-04-001 Books Inc Books Inc 2275 Market St (Mkt Village Mall) San Francisco 1 CA 1 94105 7 03/01/1977   07/01/2000   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     8 5 Castro/Upper Market 30   2275 MARKET ST (MKT VILLAGE MALL San Francisco, CA 94105
2539 0003530-05-001 Books Inc Books Inc 2251 Chestnut St San Francisco 1 CA 1 94123 3 03/01/1977   05/15/1998   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     2 Marina 2   2251 CHESTNUT ST San Francisco, CA 94123 (37.800296, -122.440317)
2553 0102351-01-001 The Rosebud Agency Inc The Rosebud Agency 636 Shrader St San Francisco 1 CA 1 94117 33 01/01/1977   01/01/1977 05/12/2015 650 Delancey St Ste 309 San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     5 7 Haight Ashbury 32   636 SHRADER ST San Francisco, CA 94117 (37.76885, -122.451769)
2559 0074534-01-001 Grenier Ronald & Michael 1500 Tennessee Bldg 1500 Tennessee St San Francisco 1 CA 1 94107 22 01/01/1972   01/01/1972   1500 Tennessee St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1500 TENNESSEE ST San Francisco, CA 94107 (37.75229, -122.388725)
2564 0003530-12-001 Books Inc Compass Books 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   10/03/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2566 0003530-13-001 Books Inc Compass Books Inc 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   10/03/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2573 0003530-14-001 Books Inc Compass Books & Cafe 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   10/03/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2589 0003530-15-001 Books Inc Books Inc 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   01/01/2005   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2654 0003778-01-001 Bressie & Company Bressie Property Mgmt-Lesng Co 500 3rd St #505 San+francisco 8 CA 1 94107 22 10/01/1968   01/02/2002   500 3rd Street #505 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           500 3RD ST SAN FRANCISCO, CA 94107 (37.781326, -122.395835)
2872 0015662-01-001 Bart-Bek Plus 4, Inc. Kca Engineers Inc 318 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   318 Brannan St, 2nd Floor San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   318 BRANNAN ST San Francisco, CA 94107 (37.78143, -122.392607)
2961 0118683-01-001 Lam Emilio & Felisa Patricia Trans Bay Printing 555 Bryant St San Francisco 1 CA 1 94107 22 07/09/1979   07/09/1979   Po Box 77265 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   555 BRYANT ST San Francisco, CA 94107 (37.780242, -122.397187)
3537 0016922-01-001 Lewis & Taylor, Llc Lewis & Taylor Inc 440 Bryant St San Francisco 1 CA 1 94107 22 12/31/2008   12/31/2008   440 Bryant St San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   440 BRYANT ST San Francisco, CA 94107 (37.782295, -122.394584)
3539 0089722-01-001 Taylor Marnee Ann & Paul Taylor Marnee Ann & Paul 1135 Kansas St San Francisco 1 CA 1 94107 22 03/28/1975   03/28/1975   1135 Kansas St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1135 KANSAS ST San Francisco, CA 94107 (37.75532, -122.402646)
3554 0052274-01-001 Louie Walter W Etal 835-841 Pacific Bldg 835 Pacific Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1001 16th St San Francisco 1 94107 47 CA 5300-5399 7210-7219 19 Multiple 13 0 0     3 1 Chinatown 7   835 PACIFIC AVE San Francisco, CA 94133 (37.79662, -122.409118)
3611 0004739-01-001 Cammisa & Wipf Cammisa-Wipf Consltng Engnrs 642 Harrison St 4th Floor San Francisco 1 CA 1 94107 22 10/01/1968   08/01/2010   642 Harrison St. 4th Floor San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   642 HARRISON ST San Francisco, CA 94107 (37.783522, -122.396184)
3760 0438867-01-001 Le Charm Inc Le Charm Inc 315 5th St San Francisco 1 CA 1 94107 22 01/01/2009   01/01/2009   315 5th St San Francisco 1 94107 47 CA 7220-7229 8 Food Services 8 0 0     6 3 South of Market 15   315 5TH ST San Francisco, CA 94107 (37.779961, -122.403017)
3782 0075314-01-001 Vanderbyl Michael Vanderbyl Design Inc 171 2nd St 2nd Fl San Francisco 1 CA 1 94105 7 08/01/1972   01/01/1999   2415 3rd Street 267 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   171 2ND ST San Francisco, CA 94105 (37.787093, -122.398655)
3991 0432672-02-001 Zheng Xiaojie New Era Art 1250 Missouri St 201 San Francisco 1 CA 1 94107 22 09/26/2008   01/09/2012   1250 Missouri St #201 San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1250 MISSOURI ST San Francisco, CA 94107 (37.750616, -122.395346)
4017 0063320-01-001 Mitchell-Michael Properties 1051 26th St Bldg 1051 26th St San Francisco 1 CA 1 94107 22 04/01/1974   04/01/1974 10/26/2014 1580 Indiana St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1051 26TH ST San Francisco, CA 94107 (37.751434, -122.389901)
4021 0063320-02-001 Mitchell-Michael Properties 1500-1580 Indiana Bldg 1580 Indiana St San Francisco 1 CA 1 94107 22 04/01/1974   04/01/1974   1580 Indiana St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1580 INDIANA ST San Francisco, CA 94107 (37.750349, -122.390464)
4025 0005189-01-001 Center Hardware &Supply Co Inc Center Hardware & Supply Co In 999 Mariposa St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968 12/31/2016 3003 Third St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 10 4 Potrero Hill 28   999 MARIPOSA ST San Francisco, CA 94107 (37.764036, -122.393749)
4044 0090492-01-001 Eisen Joni Eisen Joni 592 Pennsylvania Ave San Francisco 1 CA 1 94107 22 01/01/1974   01/01/1974   592 Pennsylvania Av San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     10 4 Potrero Hill 28   592 PENNSYLVANIA AVE San Francisco, CA 94107 (37.759019, -122.393258)
4054 0098989-01-001 Bressie / Et Al 220 Sansome St Associates 220 Sansome St San Francisco 1 CA 1 94104 1 06/04/1976   06/04/1976   500 3rd Street #505 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   220 SANSOME ST San Francisco, CA 94104 (37.792334, -122.401004)
4257 0090754-01-001 Multipearl Import Co Inc Multipearl Import Co Inc 601 4th St 314 San Francisco 1 CA 1 94107 22 07/01/1975   07/01/1975   601 4th St #314 San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     6 3 South of Market 15   601 4TH ST San Francisco, CA 94107 (37.777896, -122.39599)
4293 0075628-02-001 Kings Asian Gourmet Inc Kings Asian Gourmet Inc 651 Brannan St 100 San Francisco 1 CA 1 94107 22 06/01/1970   12/01/2002 01/31/2015 683 Brannan St 304 San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     6 3 Mission Bay 25   651 BRANNAN ST San Francisco, CA 94107 (37.775635, -122.399951)
4317 0145639-01-001 Wong Clifford & Bernice 444-446 Warren Dr Apartments 444 Warren Dr San Francisco 1 CA 1 94131 14 01/01/1984   01/01/1984   899 Kansas St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   444 WARREN DR San Francisco, CA 94131 (37.757558, -122.461939)
4401 0075867-01-001 Cal Pac Bulletins Cal Pac Bulletins/media 476 5th St San Francisco 1 CA 1 94107 22 03/01/1972   03/01/1972   476 5th St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   476 5TH ST San Francisco, CA 94107 (37.778127, -122.400714)
4439 0455152-01-001 Prosetta Inc Prosetta Inc 6705 5th St San+francisco 8 CA 1 94107 22 01/04/2011   01/04/2011   670 5th St San Francisco 1 94107 47 CA     0 0           6705 5TH ST San Francisco, CA 94107
4613 0036833-01-001 Speyer Stanley A 720 Haight St Apts 720 Haight St San Francisco 1 CA 1 94117 33 10/01/1968   10/01/1968   665 3rd St #408 San Francisco 1 94107 47 CA     0 0     5 7 Haight Ashbury 32   720 HAIGHT ST San Francisco, CA 94117 (37.771619, -122.434251)
5054 0064300-01-001 Edmondson John R Inc Ciarlo Bros 765 Bryant St San Francisco 1 CA 1 94107 22 06/01/1971   06/01/1971   765 Bryant St San Francisco 1 94107 47 CA     0 0 D10 Application Of Flammable Finishes 6 3 South of Market 15   765 BRYANT ST San Francisco, CA 94107 (37.776742, -122.401642)
5071 0131999-01-001 Hoctel Patrick-Elhauge Edward Lever Industries 1100 Tennessee St San Francisco 1 CA 1 94107 22 09/01/2007   09/01/2007   1100 Tennessee St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1100 TENNESSEE ST San Francisco, CA 94107 (37.757768, -122.389214)
5148 0092537-03-001 Jomira Advance Corp Haverhills 470 3rd St 211 San Francisco 1 CA 1 94107 22 10/09/2012   10/10/2012   470 3rd St 211 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   470 3RD ST San Francisco, CA 94107 (37.78166, -122.396243)
5348 0146684-02-001 Shami Abdallah & Ester 1525 Sutter St 1525 Sutter St San Francisco 1 CA 1 94109 24 01/01/1984   01/01/1984   1200 19th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Japantown 22   1525 SUTTER ST San Francisco, CA 94109 (37.786995, -122.426166)
5358 0132443-01-001 Wang Revocable Trust 1750 Beach St Apts 1750 Beach St San Francisco 1 CA 1 94123 3 01/01/1981   03/31/1986 01/01/2014 328 Missouri St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1750 BEACH ST San Francisco, CA 94123 (37.804225, -122.438218)
5397 0132443-02-001 Wang Revocable Trust 315-317 Sutter St Bldg 315 Sutter St San Francisco 1 CA 1 94108 9 01/01/1981   09/06/1983   328 Missouri St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   315 SUTTER ST San Francisco, CA 94108 (37.789575, -122.405777)
5399 0132443-03-001 Wang Revocable Trust 255 Grant Av Building 255 Grant Ave San Francisco 1 CA 1 94108 9 01/01/1981   09/06/1983   328 Missouri St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   255 GRANT AVE San Francisco, CA 94108 (37.78945, -122.405369)
5402 0132443-04-001 Wang Revocable Trust 249 Grant Av Building 249 Grant Ave San Francisco 1 CA 1 94108 9 01/01/1981   09/06/1983   328 Missouri St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   249 GRANT AVE San Francisco, CA 94108 (37.789192, -122.405321)
5407 0132443-13-001 Wang Revocable Trust 743 Taraval Street Apts 743 Taraval San+francisco 8 CA 1 94132 32 01/01/1981   03/01/2007 01/01/2014 328 Missouri St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           743 TARAVAL San Francisco, CA 94132 (37.743119, -122.474299)
5527 0138284-01-001 Ayoob & Peery Plumbing Co Inc Ayoob & Peery Plumbing Co Inc 975 Indiana St San Francisco 1 CA 1 94107 22 12/31/1995   02/26/2003   975 Indiana St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Potrero Hill 28   975 INDIANA ST San Francisco, CA 94107 (37.758153, -122.391223)
5570 0325688-04-001 Cunningham David A David Cunningham Projects 855 Folsom St 126 San Francisco 1 CA 1 94107 22 08/01/2003 08/30/2015 08/24/2007 08/30/2015 855 Folsom St #126 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   855 FOLSOM ST San Francisco, CA 94107 (37.781073, -122.402384)
5577 0093208-01-001 Field R N Construction Inc Field R N Construction Inc 515 Folsom St 2nd Fl San Francisco 1 CA 1 94105 7 08/01/1975   10/01/2003 03/07/2017 490 2nd St 100 Ste San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     6 3 Financial District/South Beach 1   515 FOLSOM ST San Francisco, CA 94105 (37.786971, -122.394912)
5585 0093477-01-001 Holzmueller Corp Holzmueller Corp 1000 25th Street San Francisco 1 CA 1 94107 22 10/01/1975   10/01/1975   1000 25th Street San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1000 25TH STREET San Francisco, CA 94107 (37.752732, -122.389249)
5617 0147083-01-001 A G S Inc A G S Inc 5 Freelon St San Francisco 1 CA 1 94107 22 02/01/1984   05/23/2010   5 Freelon St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 South of Market 15   5 FREELON ST San Francisco, CA 94107 (37.779537, -122.396067)
5641 0044904-01-001 Joseph Bruno Sheetmetal Co.inc Standard Sheet Metal Etc 366 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   366 Brannan St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0 D03 D19 Multiple 6 3 Financial District/South Beach 1   366 BRANNAN ST San Francisco, CA 94107 (37.780628, -122.393624)
5731 0478322-01-001 Hind Nicola Bateau Hair Salon 2 Townsend 4b San+francisco 8 CA 1 94107 22 05/01/2013   05/01/2013   2 Townsend #4b San Francisco 1 94107 47 CA     0 0           2 TOWNSEND San Francisco, CA 94107 (37.78163, -122.389225)
5813 0147450-01-001 Kuzich John R Kuzich & Associates 350 Townsend St San Francisco 1 CA 1 94107 22 01/01/1984   01/01/1984   350 Townsend St Ste#304 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           350 TOWNSEND ST SAN FRANCISCO, CA 94107 (37.776048, -122.396335)
5918 0020930-01-001 Nuckton Co Nuckton Co 668 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   668 Brannan St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   668 BRANNAN ST San Francisco, CA 94107 (37.775346, -122.400318)
6046 0147708-01-001 Clover Garments Inc Clover Garments Inc 2565 3rd St 102 San Francisco 1 CA 1 94107 22 06/29/1984   06/29/1984   2565 3rd Street Rm 102 San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Potrero Hill 28   2565 3RD ST San Francisco, CA 94107 (37.757073, -122.388101)
6073 0333187-02-001 Jensen Kris W The Brand New Step 1230 De Haro St San Francisco 1 CA 1 94107 22 01/27/2014   01/27/2014 01/27/2014 1230 De Haro St San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     10 4 Potrero Hill 28   1230 DE HARO ST San Francisco, CA 94107 (37.754164, -122.400605)
6109 0121610-02-001 Nasser Ahmad Kansas Food Market 2250 23rd St San Francisco 1 CA 1 94107 22 01/01/1980   01/01/1980   2250 23rd St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 H03 H31 H73 Multiple 10 4 Potrero Hill 28   2250 23RD ST San Francisco, CA 94107 (37.754549, -122.402079)
6126 0333897-03-002 Deharo Ramirez Corp De Haro Ramirez Group 1250 Missouri St 202 San Francisco 1 CA 1 94107 22 02/01/2000   08/01/2011   1250 Missouri St #202 San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Bayview Hunters Point 4   1250 MISSOURI ST San Francisco, CA 94107 (37.750616, -122.395346)
6140 0106790-01-001 Lawson Roofing Co Inc Lawson Roofing Co Inc 1495 Tennessee St San Francisco 1 CA 1 94107 22 04/01/1977   04/01/1977   1495 Tennessee St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 10 4 Potrero Hill 28   1495 TENNESSEE ST San Francisco, CA 94107 (37.753146, -122.388806)
6285 0133880-01-001 Hart Gerald K Hart Productions 780 Bryant St San Francisco 1 CA 1 94107 22 02/01/1982   02/01/1982   780 Bryant St San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     6 3 South of Market 15   780 BRYANT ST San Francisco, CA 94107 (37.776375, -122.402109)
6421 0021703-01-001 Paganini Electric Corp Paganini Electric Corp 190 Hubbell St San Francisco 1 CA 1 94107 22 10/01/1968   10/22/1996   190 Hubbell St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Mission Bay 25   190 HUBBELL ST San Francisco, CA 94107 (37.766887, -122.397897)
6813 0134460-01-001 Waterfront Automobili Inc Waterfront Automobili Inc 1127 Mission St San Francisco 1 CA 1 94103 25 01/01/1981   01/01/1981 01/05/2015 1301 17th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   1127 MISSION ST San Francisco, CA 94103 (37.778737, -122.411537)
6869 0108040-01-001 Wine House Ltd Wine House The 129 Carolina St San Francisco 1 CA 1 94103 25 12/31/2013   02/28/2001 03/25/2014 829 26th Street San Francisco 1 94107 47 CA     0 0     10 4 Mission Bay 25   129 CAROLINA ST San Francisco, CA 94103 (37.765506, -122.400626)
6873 0108040-02-001 Wine House Ltd Wine House The 829 26th St San Francisco 1 CA 1 94107 22 12/31/2013   03/26/2014   829 26th Street San Francisco 1 94107 47 CA     0 0 H03 H73 Multiple 10 4 Bayview Hunters Point 4   829 26TH ST San Francisco, CA 94107 (37.75153, -122.388647)

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