home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

812 rows where Mail City = 25

View and edit SQL

Suggested facets: City, Business End Date, Mail Zipcode, NAICS Code, NAICS Code Description, Transient Occupancy Tax, LIC Code, LIC Code Description, Supervisor District, Neighborhoods - Analysis Boundaries

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
177 0140622-03-999 Mcnely Construction Co Inc Mcnely Construction Co Inc 1040 Davis St San+leandro 15 CA 1 94577 36 05/29/2012   05/29/2012   1040 Davis St Suite 203 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1040 DAVIS ST SAN LEANDRO, CA 94577 (37.722144, -122.166437)
746 0049753-01-001 Griffith Donald/marjorie Trust 1650 Pacific Av Bldg 1650 Pacific Ave San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1267 Sherry Court San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1650 PACIFIC AVE San Francisco, CA 94109 (37.794901, -122.422539)
751 0049753-03-001 Griffith Donald/marjorie Trust 1275 Folsom Bldg 1275 Folsom St San Francisco 1 CA 1 94103 25 10/01/1968   10/01/1968   1267 Sherry Court San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1275 FOLSOM ST San Francisco, CA 94103 (37.774131, -122.411166)
1173 0141841-01-001 Chin Calvin Lee Hom Furnishings 825 Pacific Ave San Francisco 1 CA 1 94133 11 04/12/1983   04/12/1983 04/30/2011 137 Accolade Drive San Leandro 25 94577 49 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   825 PACIFIC AVE San Francisco, CA 94133 (37.796641, -122.408955)
1188 0141841-02-001 Chin Calvin Lee Home Furnishings Of Sf 825 Pacific Ave San Francisco 1 CA 1 94133 11 04/12/1983   05/01/1995 04/30/2011 137 Accolade Drive San Leandro 25 94577 49 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   825 PACIFIC AVE San Francisco, CA 94133 (37.796641, -122.408955)
1616 0142265-02-999 Bay Area Installations Inc Bay Area Installations Inc 2481 Verna Ct San+leandro 15 CA 1 94577 36 07/13/1983   07/01/2002   2481 Verna Ct San Leandro 25 94577 49 CA     0 0           2481 VERNA CT SAN LEANDRO, CA 94577 (37.706942, -122.172143)
2268 0002647-01-001 Bearing Engineering Co Bearing Engineering Co 901 25th St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   667 Mccormick St San Leandro 25 94577 49 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Bayview Hunters Point 4   901 25TH ST San Francisco, CA 94107 (37.752791, -122.388262)
2639 0062540-01-999 Testing Engineers Inc Testing Engineers Inc 2811 Teagarden St San+leandro 15 CA 1 94577 36 10/01/1968   10/01/1968   2811 Teagarden St San Leandro 25 94577 49 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2811 TEAGARDEN ST SAN LEANDRO, CA 94577 (37.705425, -122.157605)
2649 0003743-01-999 Brayer Electric Co Brayer Electric Co 15095 Wicks Blvd San+leandro 15 CA 1 94577 36 10/01/1968   04/02/2000   15095 Wicks Blvd San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           15095 WICKS BLVD SAN LEANDRO, CA 94577 (37.690374, -122.162791)
3314 0030619-01-999 Roofing Constructors Inc Western Roofing Service 15002 Wicks Blvd San+leandro 15 CA 1 94577 36 10/01/1968   11/01/2008   15002 Wicks Blvd San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids       15002 WICKS BLVD SAN LEANDRO, CA 94577 (37.691037, -122.162944)
5120 0054025-01-999 Anderson Eric F Inc Anderson Eric F Inc 1066 Beecher St San+leandro 15 CA 1 94577 36 01/01/1969   01/01/1969   1066 Beecher Street San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1066 BEECHER ST SAN LEANDRO, CA 94577 (37.71951, -122.183442)
5244 0077381-01-999 Kegg Terry United Acoustics 826 Montague St San+leandro 15 CA 1 94577 36 06/01/1972   06/01/1972   826 Montague St San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           826 MONTAGUE ST SAN LEANDRO, CA 94577 (37.710884, -122.15621)
5477 0120586-01-999 Bowen H A Electric Inc Bowen H A Electric Inc 2055 Williams St San+leandro 15 CA 1 94577 36 10/15/1979   10/15/1979   2055 Williams St San Leandro 25 94577 49 CA 8100-8139 5 Certain Services 5 0 0           2055 WILLIAMS ST SAN LEANDRO, CA 94577 (37.709987, -122.178136)
7392 0066906-01-999 Settlemier B R Bigge Crane & Rigging Co P O Box 1657 San Leandro Ca Brisbane+q4068 3   0 5 12/31/1998   12/31/1998   Po Box 1657 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0            
8201 0024142-01-999 Robinson Meier Juilly & Assoc Robinson Meier Juilly & Assoc 103 Linden Av Brisbane+q4068 3   0 5 10/01/1968   10/01/1968   241 Joaquin Avenue San Leandro 25 94577 49 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           103 LINDEN AV 00000 (39.932726, -84.026853)
9199 1084658-07-161 Zemikael Tesfamakiam Tesfamakiam Zemikael 1601 165th Ave 143 San+leandro 15 CA 1 94578 293 07/22/2016   07/22/2016   1601 165th Ave 143 San Leandro 25 94578 562 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9300 0010850-01-001 Ghirardelli Chocolate Co. Ghirardelli Chocolate Co 900 North Point St San Francisco 1 CA 1 94109 24 12/31/1991   12/31/1991   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0 H09 H24 H26 Multiple 2 Russian Hill 5   900 NORTH POINT ST San Francisco, CA 94109 (37.805393, -122.422944)
9324 0010850-01-003 Ghirardelli Chocolate Co. Ghirardelli Chocolate Co 42 Stockton St San Francisco 1 CA 1 94108 9 12/31/1991   04/25/2007 08/04/2016 1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0 H03 Retail Mkts W/o Prep (Under 5,001) 3 1 Financial District/South Beach 1   42 STOCKTON ST San Francisco, CA 94108 (37.78623, -122.406328)
9326 0010850-01-004 Ghirardelli Chocolate Co. Ghirardelli Chocolate Co 24 Wllie Mays Pl San+francisco 8 CA 1 94107 22 12/31/1991   04/01/2011   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0           24 WLLIE MAYS PL San Francisco, CA 94107 (37.778093, -122.391064)
9335 0010850-03-002 Ghirardelli Chocolate Co. Ghirardelli Chocolate Co 900 North Point St 142 San Francisco 1 CA 1 94109 24 12/31/1991   04/01/1997   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0     2 Russian Hill 5   900 NORTH POINT ST San Francisco, CA 94109 (37.805393, -122.422944)
9364 0010850-03-003 Ghirardelli Chocolate Co. Ghirardelli Chocolate Co 44 Stockton St San Francisco 1 CA 1 94108 9 12/31/1991   04/01/1997 08/04/2016 1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Financial District/South Beach 1   44 STOCKTON ST San Francisco, CA 94108 (37.786248, -122.406332)
9378 0010850-04-001 Ghirardelli Chocolate Co. Ghiradelli Chocolate 801 Beach St San Francisco 1 CA 1 94109 24 12/31/1991   01/01/2008   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0 H24 Restaurant Less Than 1,000 Sqft 2 Russian Hill 5   801 BEACH ST San Francisco, CA 94109 (37.806454, -122.422273)
9393 0010850-05-001 Ghirardelli Chocolate Co. Ghirardelli Westfield 845 Market St 014 San Francisco 1 CA 1 94103 25 12/31/1991   04/12/2012   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0 H07 Retail Food Market W/food Prep. Lt 5001 Sqft 6 3 South of Market 15   845 MARKET ST San Francisco, CA 94103 (37.784972, -122.406844)
9440 0010850-06-001 Ghirardelli Chocolate Co. Ghiradelli Marketplace 900 North Point St 301 San Francisco 1 CA 1 94109 24 12/31/1991   09/12/2012   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0 D04 Places Of Public Assembly & Open-Air Assembly 2 Russian Hill 5   900 NORTH POINT ST San Francisco, CA 94109 (37.805393, -122.422944)
9505 0010850-07-001 Ghirardelli Chocolate Co. Ghiradelli Chocolate Co 2 New Montgomery St San Francisco 1 CA 1 94105 7 12/31/1991   09/26/2012   1111 139th Avenue San Leandro 25 94578 562 CA 4400-4599 3 Retail Trade 3 0 0 H25 Restaurant 1,000 - 2,000 Sqft 3 1 Financial District/South Beach 1   2 NEW MONTGOMERY ST San Francisco, CA 94105 (37.788352, -122.401603)
9636 1114392-08-161 Tao Wang Tao Wang 1539 Hays St San+leandro 15 CA 1 94577 36 08/26/2016   08/26/2016   1539 Hays St San Leandro 25 94577 49 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9696 0111146-02-999 Ransome Company Ransome Company 1933 Williams St San+leandro 15 CA 1 94577 36 02/03/1998   02/03/1998   Po Box #2177 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1933 WILLIAMS ST SAN LEANDRO, CA 94577 (37.711035, -122.175618)
9949 1123212-10-161 Eduardo Peralta Merced Food Servcie 766 Martin Blvd San+leandro 15 CA 1 94571 332 10/10/2016   10/10/2016   766 Martin Blvd San Leandro 25 94571 605 CA     0 0            
10147 0060478-01-001 Thomas Richard E 1316-1322 Mariposa Apts 1316 Mariposa St San Francisco 1 CA 1 94107 22 08/15/1969   08/15/1969   Po Box 877 San Leandro 25 94577 49 CA     0 0     10 4 Potrero Hill 28   1316 MARIPOSA ST San Francisco, CA 94107 (37.763838, -122.397044)
10149 0060478-02-001 Thomas Richard E 1460-1462 Page Apts 1460 Page St San Francisco 1 CA 1 94117 33 08/15/1969   06/27/1972   Po Box 877 San Leandro 25 94577 49 CA     0 0     5 7 Haight Ashbury 32   1460 PAGE ST San Francisco, CA 94117 (37.77123, -122.444852)
10153 0060478-03-001 Thomas Richard E 1458 Page St Apts 1458 Page St San Francisco 1 CA 1 94117 33 08/15/1969   06/20/1973   Po Box 877 San Leandro 25 94577 49 CA     0 0     5 7 Haight Ashbury 32   1458 PAGE ST San Francisco, CA 94117 (37.771246, -122.444734)
10157 0060478-04-001 Thomas Richard E 738-744 Divisadero Apts 738 Divisadero St San Francisco 1 CA 1 94117 33 08/15/1969   04/09/1975   Po Box 877 San Leandro 25 94577 49 CA     0 0     5 7 Hayes Valley 10   738 DIVISADERO ST San Francisco, CA 94117 (37.776499, -122.438065)
10167 0060478-05-001 Thomas Richard E 410 Shrader St Apts 410 Shrader St San Francisco 1 CA 1 94117 33 08/15/1969   02/01/1974   Po Box 877 San Leandro 25 94577 49 CA     0 0     5 7 Haight Ashbury 32   410 SHRADER ST San Francisco, CA 94117 (37.770813, -122.452161)
10171 0025733-44-003 San Francisco Parking Inc City Park 900 North Point St San Francisco 1 CA 1 94109 24 10/01/1968 12/31/2015 08/01/2011 12/31/2015   San Leandro 25 94578 562   8100-8139 5 Certain Services 5 0 0     2 Russian Hill 5   900 NORTH POINT ST San Francisco, CA 94109 (37.805393, -122.422944)
10176 0060478-06-001 Thomas Richard E 3574-3590 San Bruno Av Apts 3574 San Bruno Ave San Francisco 1 CA 1 94134 26 08/15/1969   09/29/1976   Po Box 877 San Leandro 25 94577 49 CA     0 0     10 4 Visitacion Valley 37   3574 SAN BRUNO AVE San Francisco, CA 94134 (37.716853, -122.399884)
10179 0060478-07-001 Thomas Richard E 653-657 Bay St Apts 653 Bay St San Francisco 1 CA 1 94133 11 08/15/1969   07/19/1983   Po Box 877 San Leandro 25 94577 49 CA     0 0     2 Russian Hill 5   653 BAY ST San Francisco, CA 94133 (37.805047, -122.418223)
10183 0060478-08-001 Thomas Richard E 3556-64 San Bruno Av Apts 3556 San Bruno Ave San Francisco 1 CA 1 94134 26 08/15/1969   01/01/1992   Po Box 877 San Leandro 25 94577 49 CA     0 0     10 4 Visitacion Valley 37   3556 SAN BRUNO AVE San Francisco, CA 94134 (37.717066, -122.399937)
11543 0162881-01-999 Leung James & Chan Mei Mei Design 949 Portola Dr San+leandro 15 CA 1 94578 293 04/17/1987   04/17/1987   949 Portola Dr San Leandro 25 94578 562 CA     0 0           949 PORTOLA DR SAN LEANDRO, CA 94578 (37.702237, -122.151961)
11582 0163378-01-999 Bay Point Control Inc Bay Point Control Inc 799 Thorton St San+leandro 15 CA 1 94577 36 01/01/1995   01/01/1995   799 Thornton St San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           799 THORTON ST SAN LEANDRO, CA 94577 (37.71829, -122.160948)
11793 0133140-02-001 Triple C Foods Inc 1116 Quesada Av Building 1116 Quesada Ave San Francisco 1 CA 1 94124 8 12/16/1981   01/01/1988   1465 Factor Ave San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1116 QUESADA AVE San Francisco, CA 94124 (37.727179, -122.380578)
11991 0166891-03-999 Carrier Corporation Carrier Building Systems-Svcs 600 Mccormick St Suite B San+leandro 15 CA 1 94577 36 01/01/1987   12/01/2010   600 Mccormick Street Suite B San Leandro 25 94577 49 CA     0 0           600 MCCORMICK ST SUITE B SAN LEANDRO, CA 94577 (37.724155, -122.18892)
12247 0064206-01-999 Allied Painters Inc Allied Painters Inc 99 Oakland Ca Brisbane Q4068 65   0 5 10/01/1968   10/01/1968   2067 Adams Ave San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           99 OAKLAND 00000
12465 0059845-01-999 Concrete Wall Sawing Co Inc Concrete Wall Sawing Co Inc 2419 Po Box San+leandro 15 CA 1 94577 36 09/01/1970   09/01/1970   Po Box 2419 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0            
12789 0149468-01-001 Tap Plastics Inc Tap Plastics Inc 154 S Van Ness Ave San Francisco 1 CA 1 94103 25 01/11/1985   01/01/1995   3011 Alvarado St A San Leandro 25 94577 49 CA 4400-4599 3 Retail Trade 3 0 0     6 3 Mission 12   154 S VAN NESS AVE San Francisco, CA 94103 (37.771349, -122.41817)
12911 0180515-01-001 Gutierrez Samuel S & A Construction 205 13th St 3020 San Francisco 1 CA 1 94103 25 02/01/1988   11/29/1994   655 Lewelling Blvd #122 San Leandro 25 94579 719 CA     0 0     9 8 Mission 12   205 13TH ST San Francisco, CA 94103 (37.76979, -122.41858)
12912 0180515-02-001 Gutierrez Samuel S & A Construction 331 Santa Rosa St San+francisco 8 CA 1 94112 28 02/01/1988   10/06/2006   655 Lewelling Blvd #122 San Leandro 25 94579 719 CA     0 0           331 SANTA ROSA ST San Francisco, CA 94112 (35.288779, -120.66542)
13229 0182524-01-999 Flory Construction Inc Flory Construction Inc 2325 Verna Ct San+leandro 15 CA 1 94577 36 06/04/2002   06/05/2002   2325 Verna Ct San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           2325 VERNA CT SAN LEANDRO, CA 94577 (37.707706, -122.172863)
13242 0182646-01-999 Nor-Cal Supply Co Nor-Cal Supply Co 840 Doolittle Dr San+leandro 15 CA 1 94577 36 12/31/1988   01/01/1990   840 Doolittle Dr San Leandro 25 94577 49 CA     0 0           840 DOOLITTLE DR SAN LEANDRO, CA 94577 (37.719586, -122.191109)
13824 0185809-03-999 Nsset Nsset 1635 Neptune Dr San+leandro 15 CA 1 94577 36 01/01/1994   02/07/2012   1635 Neptune Drive San Leandro 25 94577 49 CA     0 0           1635 NEPTUNE DR SAN LEANDRO, CA 94577 (37.707659, -122.191704)
13983 0186920-04-999 Perez David L D P Elctric Co 15114 Norton St San+leandro 15 CA 1 94579 402 12/10/2013   12/10/2013   15114 Norton St San Leandro 25 94579 719 CA     0 0           15114 NORTON ST SAN LEANDRO, CA 94579 (37.689385, -122.145465)
14545 0189903-01-001 Field 1987 Living Trust The 135 Townsend St Rental Bldg 135 Townsend St San Francisco 1 CA 1 94107 22 07/13/1989   07/13/1989   2360 Teagarden St San Leandro 25 94577 49 CA     0 0     6 3 Mission Bay 25   135 TOWNSEND ST San Francisco, CA 94107 (37.780084, -122.391215)
14953 0192419-03-999 Vignoles Mark H Service West 2054 Burroughs Ave San+leandro 15 CA 1 94577 36 10/30/1989   12/28/2009   2054 Burroughs Ave San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           2054 BURROUGHS AVE SAN LEANDRO, CA 94577 (37.697818, -122.167892)
17514 0300819-01-001 Wycen Foods Inc Ying N Yang Gourmet Specialtie 625 Clement St San Francisco 1 CA 1 94118 6 12/08/1996   12/08/1996 01/01/2011 560 Estabrook Street San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           625 CLEMENT ST San Francisco, CA 94118 (37.78289, -122.465907)
17515 0300819-02-001 Wycen Foods Inc Wycen Foods Inc 903 Washington Street San Francisco 1 CA 1 94108 9 12/08/1996   12/01/2005 06/01/2012 560 Estabrook Street San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   903 WASHINGTON STREET San Francisco, CA 94108 (37.794898, -122.408433)
17516 0300819-02-002 Wycen Foods Inc Wycen Foods Inc 832 Stockton St San Francisco 1 CA 1 94108 9 12/08/1996   01/10/2012   560 Estabrook Street San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 H07 Retail Food Market W/food Prep. Lt 5001 Sqft 3 1 Chinatown 7   832 STOCKTON ST San Francisco, CA 94108 (37.793517, -122.407798)
17609 0301223-01-999 Koffler Electrical Mechanical Koffler Electrical Mechanical 527 Whitney St San+leandro 15 CA 1 94577 36 01/04/1997   01/04/1997   527 Whitney St San Leandro 25 94577 49 CA     0 0           527 WHITNEY ST SAN LEANDRO, CA 94577 (37.723709, -122.191473)
17793 0302068-01-999 Sayo Zoilo M Z M Sayo Constr Repairs 585 Blossom Way San+leandro 15 CA 1 94577 36 01/01/2003   01/01/2003   585 Blossom Way San Leandro 25 94577 49 CA     0 0           585 BLOSSOM WAY SAN LEANDRO, CA 94577 (37.718578, -122.144478)
18003 1146979-05-171 Fnu Abdullah Uber And Lyft Driver 164 Ave Apt 50 San+leandro 15 CA 1 94578 293 05/18/2017   05/18/2017   1570 164th Avenu 164 Ave 50 Apt San Leandro 25 94578 562 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
18065 0303134-01-001 Seneca Family Of Agencies Sf Alternatives Program 887 Potrero Ave L-Unit San Francisco 1 CA 1 94110 18 11/01/1995   11/01/1995 04/27/2017 2275 Arlington Dr San Leandro 25 94578 562 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Potrero Hill 28   887 POTRERO AVE L-UNIT San Francisco, CA 94110 (37.757844, -122.406728)
18166 0303538-01-001 Nelson Jean Jean M Nelson 160 Belvedere St A San Francisco 1 CA 1 94117 33 03/01/1997   03/01/1997   390 Toler Ave San Leandro 25 94577 49 CA     0 0     5 7 Haight Ashbury 32   160 BELVEDERE ST A San Francisco, CA 94117 (37.767539, -122.449222)
18994 0306656-01-999 Lakers Jeffrey P Blue Cat 737 Camino Ricardo Moraga 267 CA 1 94556 416 06/05/1997   11/01/1999 06/30/2015 814 Castro Street San Leandro 25 94577 49 CA 4200-4299 7 Wholesale Trade 7 0 0           737 CAMINO RICARDO MORAGA, CA 94556 (37.849283, -122.13497)
19052 0150751-01-001 Independent Electric Supp Inc Independent Electric Supp Inc 1575 Burke Ave San Francisco 1 CA 1 94124 8 04/29/1985   01/01/2008   2001 Marina Boulevard San Leandro 25 94577 49 CA 4200-4299 7 Wholesale Trade 7 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 10 4 Bayview Hunters Point 4   1575 BURKE AVE San Francisco, CA 94124 (37.744644, -122.386386)
19338 0308365-02-999 First Rate Renovations Inc First Rate Renovations Inc 2701 Merced St San+leandro 15 CA 1 94577 36 09/21/2009   09/21/2009   2701 Merced St San Leandro 25 94577 49 CA     0 0           2701 MERCED ST SAN LEANDRO, CA 94577 (37.702754, -122.166985)
19647 0309863-01-001 Bustillos Lorenzo C R & L Plumbing And Heating 372 29th St San Francisco 1 CA 1 94131 14 09/28/1997   09/28/1997 03/31/2014 1759 View Dr San Leandro 25 94577 49 CA     0 0     8 5 Noe Valley 33   372 29TH ST San Francisco, CA 94131 (37.743603, -122.428273)
19648 0309863-03-999 Bustillos Lorenzo C R & L Plumbing And Heating 1759 View Dr San Leandro 208 CA 1 94577 36 09/28/1997   04/01/2014   1759 View Dr San Leandro 25 94577 49 CA     0 0           1759 VIEW DR SAN LEANDRO, CA 94577 (37.727559, -122.129417)
19649 0309863-04-999 Bustillos Lorenzo C Plumber Man 1759 View Dr San+leandro 15 CA 1 94577 36 09/28/1997   04/01/2014   1759 View Dr San Leandro 25 94577 49 CA     0 0           1759 VIEW DR SAN LEANDRO, CA 94577 (37.727559, -122.129417)
19757 0310379-01-999 Access Hardware Supply Inc Access Hardware Supply Inc 14359 Catalina St San+leandro 15 CA 1 94577 36 07/01/1997   07/01/1997   1660 Factor Ave San Leandro 25 94577 49 CA 4200-4299 7 Wholesale Trade 7 0 0           14359 CATALINA ST SAN LEANDRO, CA 94577 (37.695078, -122.17181)
19887 0310896-01-001 21st Amendment Brewery Cafellc 21st Amendment 563 2nd St San Francisco 1 CA 1 94107 22 11/01/1997   07/12/1999   2010 Williams St San Leandro 25 94577 49 CA 7220-7229 8 Food Services 8 0 0 D04 H26 P23 Multiple 6 3 Financial District/South Beach 1   563 2ND ST San Francisco, CA 94107 (37.782295, -122.392653)
19888 0310896-03-001 21st Amendment Brewery Cafellc 21st Amendment Brewery 563 2nd St San Francisco 1 CA 1 94107 22 11/01/1997   05/24/2013   2010 Williams St San Leandro 25 94577 49 CA 7220-7229 8 Food Services 8 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 6 3 Financial District/South Beach 1   563 2ND ST San Francisco, CA 94107 (37.782295, -122.392653)
20059 0311781-01-999 Koontz Michael R Keen Electric 554 Fortuna Ave San+leandro 15 CA 1 94577 36 12/02/1997   12/02/1997   554 Fortuna Ave San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           554 FORTUNA AVE SAN LEANDRO, CA 94577 (37.735274, -122.141485)
20407 0309863-02-001 Bustillos Lorenzo C Plumber Man 372 29th St San Francisco 1 CA 1 94131 14 09/28/1997   07/19/2000 03/31/2014 1759 View Dr San Leandro 25 94577 49 CA     0 0     8 5 Noe Valley 33   372 29TH ST San Francisco, CA 94131 (37.743603, -122.428273)
20636 0314197-01-001 Chan Albert & Chan Andy 2801 Sacramento St Apts 2801 Sacramento St San Francisco 1 CA 1 94115 4 01/01/1998   01/01/1998 01/01/2014 1543 Hays St San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2801 SACRAMENTO ST San Francisco, CA 94115 (37.789177, -122.439221)
21785 0319305-01-999 Azevedo Electric Co Inc Azevedo Electric Co Inc 1968 Alvarado St San+leandro 15 CA 1 94577 36 07/01/1998   07/01/1998   1968 Alvarado St San Leandro 25 94577 49 CA     0 0           1968 ALVARADO ST SAN LEANDRO, CA 94577 (37.71596, -122.159093)
23106 0324416-01-999 Lee Song Yang Bamboo Green Electric Ind Co 16255 Liberty St San+leandro 15 CA 1 94578 293 01/31/2000   01/31/2000   16255 Liberty St San Leandro 25 94578 562 CA 2300-2399 6 Construction 6 0 0           16255 LIBERTY ST SAN LEANDRO, CA 94578 (37.700886, -122.111045)
23476 0325937-03-999 Milestone Contractors Inc Milestone Contractors Inc 1155 Beecher St San+leandro 15 CA 1 94577 36 04/01/1999   02/09/2001   1155 Beecher St San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1155 BEECHER ST SAN LEANDRO, CA 94577 (37.719247, -122.183366)
23477 0325937-04-999 Milestone Contractors Inc N V Heathorn Co 1155 Beecher St San Leandro 208 CA 1 94577 36 04/01/1999   10/15/2005   1155 Beecher St San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1155 BEECHER ST SAN LEANDRO, CA 94577 (37.719247, -122.183366)
25307 0333233-01-001 Rdg Concessions Llc Rdg Concessions Llc 200 International Bldg Aw20/30 San+francisco 8 CA 1 94128 59 02/01/2000   02/01/2000   2104 Adams Ave San Leandro 25 94577 49 CA 4400-4599 3 Retail Trade 3 0 0           200 INTERNATIONAL San Francisco, CA 94128 (37.240042, -121.799382)
25749 0314197-02-001 Chan Albert & Chan Andy 4543 Lincoln Way Apts 4543 Lincoln Way San Francisco 1 CA 1 94122 19 01/01/1998   01/01/1998 08/04/2017 1543 Hays St San Leandro 25 94577 49 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   4543 LINCOLN WAY San Francisco, CA 94122 (37.764103, -122.506782)
26049 0335784-01-999 Tam Kam P Ping Kee Electric 2077 Juneau St San+leandro 15 CA 1 94577 36 04/11/2000   04/11/2000   2077 Juneau St San Leandro 25 94577 49 CA     0 0           2077 JUNEAU ST SAN LEANDRO, CA 94577 (37.705954, -122.182078)
26167 0336018-01-999 Comfort Dynamics Inc Comfort Dynamics Inc 823 Estabrook St San+leandro 15 CA 1 94577 36 04/12/2000   04/12/2000   823 Estabrook St San Leandro 25 94577 49 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           823 ESTABROOK ST SAN LEANDRO, CA 94577 (37.714793, -122.158583)
26461 0337406-02-999 Office Relief Inc Office Relief 516 Mccormick St San+leandro 15 CA 1 94577 36 01/01/2000   01/30/2006   516 Mccormick St San Leandro 25 94577 49 CA     0 0           516 MCCORMICK ST SAN LEANDRO, CA 94577 (37.724362, -122.189375)
27070 0339705-02-999 Chase Contracting Quality Air Services Inc. 29229 Pacific Street Hayward 38 CA 1 94544 90 09/21/2000   01/06/2004 12/31/2012 14551 Griffith St San Leandro 25 94577 49 CA     0 0           29229 PACIFIC STREET HAYWARD, CA 94544 (37.629679, -122.055764)
27316 0340687-03-999 Moreno Raul A Moreno Electric Co 650 Broadmoor Blvd San+leandro 15 CA 1 94577 36 05/10/2002   09/16/2007   650 Broadmoor Blvd San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           650 BROADMOOR BLVD SAN LEANDRO, CA 94577 (37.738512, -122.152604)
30494 0351923-01-999 Jl Gutierrez Corporation Jl Construction Company 14720 Pepperdine St San+leandro 15 CA 1 94579 402 01/01/2002   01/01/2002   14720 Pepperdine St San Leandro 25 94579 719 CA     0 0           14720 PEPPERDINE ST SAN LEANDRO, CA 94579 (37.69918, -122.151337)
31957 0352042-02-999 Resolve Digital Llc Homobilia 318 Melven Ct San+leandro 15 CA 1 94577 36 01/01/2002   01/01/2007   318 Melven Ct San Leandro 25 94577 49 CA 5100-5199 15 Information 15 0 0           318 MELVEN CT SAN LEANDRO, CA 94577 (37.739645, -122.148825)
32342 0358027-01-999 Ncmg Inc New Century Marble 2500 Teagarden St B San+leandro 15 CA 1 94577 36 07/24/2002   07/24/2002   2500 Teagarden St #B San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           2500 TEAGARDEN ST B SAN LEANDRO, CA 94577 (37.70949, -122.160617)
32486 0358567-01-999 State Roofing Systems Inc State Roofing Systems Inc 15444 Hesperian Blvd San+leandro 15 CA 1 94578 293 08/16/2002   08/16/2002   15444 Hesperian Blvd San Leandro 25 94578 562 CA 2300-2399 6 Construction 6 0 0           15444 HESPERIAN BLVD SAN LEANDRO, CA 94578 (37.69156, -122.129987)
34280 0364058-02-999 Towne Randell C Towne Electric Company 14558 Wick Blvd. San+leandro 15 CA 1 94577 36 02/25/2003   11/09/2006   14558 Wicks Blvd San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           14558 WICK BLVD SAN LEANDRO, CA 94577 (37.694467, -122.163425)
34592 0364811-01-999 Olson & Co Steel Olson & Co Steel 1941 Davis St San+leandro 15 CA 1 94577 36 11/01/2002   11/01/2002   1941 Davis Street San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1941 DAVIS ST SAN LEANDRO, CA 94577 (37.717492, -122.182335)
35614 0352042-01-999 Resolve Digital Llc Resolve Digital 318 Melven Ct San Leandro 208 CA 1 94577 36 01/01/2002   01/01/2007   318 Melven Ct San Leandro 25 94577 49 CA 5100-5199 15 Information 15 0 0           318 MELVEN CT SAN LEANDRO, CA 94577 (37.739645, -122.148825)
36060 0369087-03-001 Chen Ze Wei Jasmine Beauty Spa 3085 24th St 203 San Francisco 1 CA 1 94110 18 06/28/2011   06/28/2011   1952 North Blvd. San Leandro 25 94577 49 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0 H70 Solo Practitioner Massage Establishment 9 8 Mission 12   3085 24TH ST San Francisco, CA 94110 (37.752523, -122.413639)
36465 0359849-01-999 Sure Engineers Inc Sure Engineers 640 Bancroft Ave San+leandro 15 CA 1 94577 36 10/01/2002   10/15/2009   640 Bancroft Ave San Leandro 25 94577 49 CA     0 0           640 BANCROFT AVE SAN LEANDRO, CA 94577 (37.733111, -122.150636)
36634 1116382-09-161 Karma Lopsang Sherpa Karma Lopsang Sherpa 544 Millstream Dr San+leandro 15 CA 1 94578 293 04/15/2016   08/29/2016   544 Millstream Dr San Leandro 25 94578 562 CA     0 0            
37329 0372924-04-999 Byc Construction Inc Byc Construction Inc 635 143rd Ave San+leandro 15 CA 1 94578 293 06/20/2013   06/20/2013   635 143rd Avenue San Leandro 25 94578 562 CA 2300-2399 6 Construction 6 0 0           635 143RD AVE SAN LEANDRO, CA 94578 (37.707241, -122.142874)
37410 0373165-02-999 Roberts Kyle T Precision Air Systems 381 Cherrywood Ave San+leandro 15 CA 1 94577 36 01/07/2004   02/01/2011 03/03/2014 10804 Bigge St San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           381 CHERRYWOOD AVE SAN LEANDRO, CA 94577 (37.729843, -122.165511)
38783 0376778-01-999 Eng Patrick P J Electric Co 15549 Faris St San+leandro 15 CA 1 94579 402 04/23/2004   04/23/2004   15549 Faris St San Leandro 25 94579 719 CA     0 0           15549 FARIS ST SAN LEANDRO, CA 94579 (37.680864, -122.14615)
38795 0376833-02-999 Cordova Martina Mc Professional Cleaning Serv 13730 E 14th St 205 San+leandro 15 CA 1 94578 293 04/26/2004   03/01/2012   13495 Bancroft Ave 315 San Leandro 25 94578 562 CA     0 0           13730 E 14TH ST SAN LEANDRO, CA 94578 (37.715156, -122.142455)
38796 0376833-03-999 Cordova Martina Mc Professional Cleaning Serv 900 143rd Av 147 San+leandro 15 CA 1 94578 293 04/26/2004   09/26/2012   13495 Bancroft Ave 315 San Leandro 25 94578 562 CA     0 0           900 143RD AV SAN LEANDRO, CA 94578 (37.708485, -122.141418)
38862 0376986-01-999 American Home Craft Inc American Home Craft Inc 20986 Corsair Blvd Hayward 38 CA 1 94545 64 05/15/2004   05/15/2004 10/01/2015 2235 Polvorosa Ave # 230 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           20986 CORSAIR BLVD HAYWARD, CA 94545 (37.656578, -122.124869)
38863 0376986-02-999 American Home Craft Inc Sungate Energy Solutions 6335 Ferris Sq B San+diego 126 CA 1 92121 515 05/15/2004   01/01/2010 01/01/2014 2235 Polvorosa Ave # 230 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           6335 FERRIS SQ B SAN DIEGO, CA 92121 (32.890701, -117.182274)

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