home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Ownership Name

View and edit SQL

Suggested facets: NAICS Code Description, Supervisor District

Business Corridor

Link rowid Location Id Ownership Name ▼ DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
45395 0393138-01-001 #10 Sports Llc #10 Sports Llc 444 Townsend St 2nd Floor San Francisco 1 CA 1 94107 22 10/31/2005 09/01/2014 10/31/2005 09/01/2014             0 0     6 3 Mission Bay 25   444 TOWNSEND ST San Francisco, CA 94107 (37.774537, -122.398244)
134667 1024282-03-151 'Ana Home Care Assist Llc Caring For Healing Home Assistance 54 Edgar Place San+francisco 8 CA 1 94112 28 01/27/2015   01/27/2015   54 Edgar Place San Francisco 1 94112 20 CA     0 0           54 EDGAR PLACE SAN FRANCISCO, CA 94112 (37.721663, -122.452123)
196522 1145042-05-171 'Looly's Pbc' - Which Will Do Business In Ca As 'Le Cupboard' Le Cupboard 1298 Church St San Francisco 1 CA 1 94114 34 05/02/2017   05/02/2017   1298 Church St San Francisco 1 94114 43 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft 8 5 Noe Valley 33    
192424 1137571-02-171 (Eg) Ventures (Eg) Ventures 1519 Masonic Avenue Apt A San Francisco 1 CA 1 94117 33 02/24/2017   02/24/2017   1519 Masonic Avenue A Apt San Francisco 1 94117 80 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     8 5 Haight Ashbury 32    
175690 1103925-08-161 (Lyft) Joevie Estoesta Lyft San Francisco 15 Cross St San Francisco 1 CA 1 94112 28 03/25/2016 05/27/2017 03/25/2016 05/27/2017             0 0     11 Excelsior 23    
184206 1121475-09-161 (Mary)paige Koch Paige Koch Interiors 2829 Clay Street Apt 8 San Francisco 1 CA 1 94115 4 09/15/2016   09/15/2016   2829 Clay Street 8 Apt San Francisco 1 94115 2 CA     0 0     2 Pacific Heights 16    
167983 1085186-07-161 (Mo) Mebrrhatu Berhe Mo Mebrhatu Berhe 1706 Monroe St Apt 3 Santa+clara 88 CA 1 95050 141 07/26/2016   07/26/2016   1706 Monroe St 3 Apt Santa Clara 188 95050 277 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
186747 1126057-11-161 (Sole Proprietors, Edna Butler) Edna Butler 1625 Alum Rock Ave Apt 5 San+jose 26 CA 1 95116 322 11/01/2016   11/01/2016   0000 Undeliverable Mail San Francisco 1 99999 12 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
35116 0366254-01-999 (Tmi)telecom Management Inc. Pioneer Telephone 27 Gorham Rd Scarborough 543 ME 42 4074 855 03/01/2003   03/01/2003 01/01/2011 242 Rangeline Road Longwood 88 32750 133 FL 5100-5199 15 Information 15 0 0           27 GORHAM RD SCARBOROUGH, ME 04074 (43.591323, -70.334681)
35117 0366254-02-999 (Tmi)telecom Management Inc. Pioneer Telephone 39 Darling Ave Boston 89 MA 15 4106 856 03/01/2003   02/11/2009 10/02/2015 242 Rangeline Road Longwood 88 32750 133 FL 5100-5199 15 Information 15 0 0           39 DARLING AVE BOSTON, MA 04106 (43.642182, -70.330837)
35118 0366254-03-999 (Tmi)telecom Management Inc. Pioneer Telephone 39 Darling Avenue Me Boston 89 ME 42 4106 856 03/01/2003   09/30/2012 10/02/2015 242 Rangeline Road Longwood 88 32750 133 FL 5100-5199 15 Information 15 0 0           39 DARLING AVENUE ME BOSTON, ME 04106 (43.642182, -70.330837)
144779 1041367-10-151 (Tmi)telecom Management Inc. Pioneer Telephone 39 Darling Ave South+portland 1607 ME 42 4106 856 03/01/2003   10/02/2015   242 Rangeline Road Longwood 88 32750 133 FL 5100-5199 15 Information 15 0 0           39 DARLING AVE SOUTH PORTLAND, ME 04106 (43.642182, -70.330837)
222580 1091921-08-161 -Justin R Hamrick -Justin R Hamrick 6506 Simson St Oakland 16 CA 1 94605 325 11/09/2015   11/09/2015   6506 Simson St Oakland 27 94605 469 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
181699 1116668-09-161 -Maj. Jeffrey S. Grant Uber Driver 71 Garibaldi St Daly+city 40 CA 1 94014 97 09/01/2016   09/01/2016   71 Garibaldi St Daly City 11 94014 26 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
97508 0475336-01-001 03 Bistro & Lounge Inc 03 Bistro & Lounge Inc 524 Van Ness Ave San Francisco 1 CA 1 94102 16 01/01/2013 08/26/2016 01/01/2013 08/26/2016         7220-7229 8 Food Services 8 0 0     6 3 Tenderloin 11   524 VAN NESS AVE San Francisco, CA 94102 (37.780263, -122.420202)
50225 0403147-02-001 1 800 Radiator Of S F Inc 1 800 Radiator Of S F Inc 418 Bayshore Blvd San Francisco 1 CA 1 94124 8 10/23/2006   01/01/2012   418 Bayshore Boulevard San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0     9 8 Bernal Heights 19   418 BAYSHORE BLVD San Francisco, CA 94124 (37.740697, -122.406894)
21210 0316520-01-001 1 Big Man&truck Moving Co Inc 1 Big Man&truck Moving Co Inc 401 Terry A. Francois St Box 12 126 San+francisco 8 CA 1 94107 22 01/01/1998   01/01/1998   401 Terry Francois St Box 12 Suite 126 San Francisco 1 94158 319 CA 4800-4999 12 Transportation and Warehousing 12 0 0           401 TERRY A FRANCOIS ST San Francisco, CA 94107 (37.77219, -122.386967)
162575 1076211-06-161 1 Clarence Place 17 Llc 1 Clarence Place 17 Llc 1 Clarence Pl 17 San Francisco 1 CA 1 94107 22 10/31/2014   10/31/2014   610 El Camino Del Mar San Francisco 1 94121 17 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   1 CLARENCE PL SAN FRANCISCO, CA 94107 (37.779911, -122.393)
204118 1161629-09-171 1 Design Construction Corp. 1 Design Construction Corp. 2511 Beverly Blvd Los+angeles 33 CA 1 90057 2516 09/20/2017   09/20/2017   2511 Beverly Blvd Los Angeles 3 90057 2808 CA 2300-2399 6 Construction 6 0 0            
133082 1021534-03-151 1 Franklin Street Llc 1 Franklin Street Llc 2044 Fillmore St 3rd Fl San Francisco 1 CA 1 94115 4 08/19/2014   08/19/2014   2044 Fillmore St 3rd Floor San Francisco 1 94115 2 CA 2300-2399 6 Construction 6 0 0           2044 FILLMORE ST SAN FRANCISCO, CA 94115 (37.788384, -122.433732)
219593 0452074-01-001 1 Light Media Inc 1 Light Media Inc 801 Silver Ave San Francisco 1 CA 1 94134 26 09/01/2010   09/01/2010   801 Silver Ave San Francisco 1 94134 23 CA 7100-7199 7210-7219 246 Multiple 13 0 1     9 8 Portola 18   801 SILVER AVE San Francisco, CA 94134 (37.729032, -122.418407)
56613 0415252-01-001 1 Production S F Llc 1 Production S F Llc 3140 Mission St San Francisco 1 CA 1 94110 18 03/21/2007 02/29/2012 03/21/2007 02/29/2012             0 0     9 8 Bernal Heights 19   3140 MISSION ST San Francisco, CA 94110 (37.747048, -122.418943)
190350 1133799-01-171 1 San Antonio I5, Llc 1 San Antonio I5, Llc 1 San Antonio Pl San Francisco 1 CA 1 94133 11 10/07/2016   10/07/2016   600 California St 20th Fl San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
172704 1097618-08-161 1 Shipdirect Us Llc 1 Shipdirect Us Llc 2362 Paloma Ct Apt 4 Pinole 176 CA 1 94564 280 08/18/2016   08/18/2016   2362 Paloma Ct 4 Apt Pinole 361 94564 552 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
33949 0363157-01-999 1 Stop Rental Inc 1 Stop Rental Inc 6201 Coliseum Way J Oakland 16 CA 1 94621 205 01/01/2002   01/01/2002   Po Box 2467 Martinez 46 94553 73 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           6201 COLISEUM WAY J OAKLAND, CA 94621 (37.757757, -122.207985)
99505 0477391-01-001 1,2,3 Express Moving Llc 1,2,3 Express Moving Llc 31 Duboce Ave 31a San Francisco 1 CA 1 94103 25 03/11/2013   03/11/2013   31 Duboce Ave #31a San Francisco 1 94103 32 CA     0 0     9 8 Mission 12   31 DUBOCE AVE San Francisco, CA 94103 (37.769939, -122.421016)
11245 0160602-01-001 1-2-3 Deli, Inc. 1-2-3 Deli 123 Mission St San Francisco 1 CA 1 94105 7 01/20/1986   01/20/1986   1645 Clay St Apt 2 San Francisco 1 94109 7 CA     0 0     6 3 Financial District/South Beach 1   123 MISSION ST San Francisco, CA 94105 (37.792099, -122.39462)
73039 0444499-01-999 1-800-Pack-Rat Llc 1-800-Pack-Rat Llc 44340 Osgood Rd Fremont 64 CA 1 94539 140 12/15/2009   12/15/2009   11640 Northpark Dr 200 Ste Wake Forest 1267 27587 2244 NC 4800-4999 12 Transportation and Warehousing 12 0 0           44340 OSGOOD RD FREMONT, CA 94539 (37.509422, -121.939526)
138666 1031140-06-151 1-888-4-Abatement Inc 1-888-4-Abatement Inc 3158 Luyung Dr Rancho+cordova 392   95742 552 06/18/2015   06/18/2015   3158 Luyung Dr Rancho Cordova 171 95742 254 CA 2300-2399 6 Construction 6 0 0           3158 LUYUNG DR RANCHO CORDOVA 95742 (38.588558, -121.256382)
198586 1149359-06-171 10 6th St. Llc The Rumpus Room 10 6th St San Francisco 1 CA 1 94103 25 06/01/2017   06/01/2017   620 Treat Ave San Francisco 1 94110 37 CA 7220-7229 8 Food Services 8 0 0            
92010 0469309-01-001 10 Glendale Llc 10 Glendale Llc 10 Glendale St San Francisco 1 CA 1 94114 34 07/15/2011 07/30/2015 07/15/2011 07/30/2015             0 0     8 5 Castro/Upper Market 30   10 GLENDALE ST San Francisco, CA 94114 (37.75645, -122.442501)
89745 0466665-01-001 10 Minute Fitness Inc Zaaz Studios Kiosk #5002 3251 20th Ave 6511 San Francisco 1 CA 1 94132 32 03/01/2012   03/01/2012   599b Bridgeway Sausalito 84 94965 125 CA     0 0     7 9 Lakeshore 31   3251 20TH AVE San Francisco, CA 94132 (37.727905, -122.475605)
130533 1016933-01-151 100 Brannan Llc Caputo 100 Brannan St San Francisco 1 CA 1 94107 22 01/23/2015 04/22/2016 01/23/2015 04/22/2016   San Francisco 1 94102 16   7220-7229 8 Food Services 8 0 0     6 3 Financial District/South Beach 1   100 BRANNAN ST SAN FRANCISCO, CA 94107 (37.784238, -122.38906)
130536 1016937-01-151 100 Brannan Llc Caputo Trattoria 100 Brannan St San Francisco 1 CA 1 94107 22 01/23/2015 04/22/2016 01/23/2015 04/22/2016   San Francisco 1 94102 16   7220-7229 8 Food Services 8 0 0     6 3 Financial District/South Beach 1   100 BRANNAN ST SAN FRANCISCO, CA 94107 (37.784238, -122.38906)
84186 0460049-01-001 100 Broderick Llc 100 Broderick Llc 100 Broderick St San Francisco 1 CA 1 94104 1 02/09/2011   02/09/2011   600 California St Fl 20 San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           100 BRODERICK ST San Francisco, CA 94104 (37.771293, -122.438782)
84187 0460049-01-002 100 Broderick Llc 100 Broderick Llc 100 Broderick St San Francisco 1 CA 1 94117 33 02/09/2011   05/01/2013   600 California St Fl 20 San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     5 7 Haight Ashbury 32   100 BRODERICK ST San Francisco, CA 94117 (37.771293, -122.438782)
18260 0303721-01-001 100 Bush Corporation Shell Building 100 Bush St San Francisco 1 CA 1 94104 1 02/18/1997   02/18/1997   100 Bush St 218 Ste San Francisco 1 94104 1 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D26 Station Tanks - Above Ground 3 1 Financial District/South Beach 1   100 BUSH ST SAN FRANCISCO, CA 94104 (37.79128, -122.39995)
48513 0397455-01-001 100 California St Property Llc 100 California St Property Llc 100 California St San Francisco 1 CA 1 94111 35 08/09/2005   08/09/2005   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     3 1 Financial District/South Beach 1   100 CALIFORNIA ST SAN FRANCISCO, CA 94111 (37.793501, -122.398002)
135579 1025895-04-151 100 California Street Llc 100 California Street Llc 100 California St #1400 San+francisco 8 CA 1 94111 35 09/05/2014   09/05/2014   100 California St #250 San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D02 D03 D26 D29 D39 Multiple       100 CALIFORNIA ST SAN FRANCISCO, CA 94111 (37.793501, -122.398002)
49619 0401917-01-001 100 First Plaza Property Llc 100 First Plaza Property Llc 100 1st St San Francisco 1 CA 1 94105 7 12/07/2005 11/10/2010 12/07/2005 11/10/2010             0 0     6 3 Financial District/South Beach 1   100 1ST ST San Francisco, CA 94105 (37.789685, -122.397439)
49620 0401917-02-001 100 First Plaza Property Llc 600 California St Property Llc 600 California St 510 San Francisco 1 CA 1 94108 9 12/07/2005 11/10/2010 02/07/2007 02/07/2007             0 0     3 1 Chinatown 7   600 CALIFORNIA ST San Francisco, CA 94108 (37.792593, -122.404814)
183642 1120376-09-161 100 Montgomery Sf Llc 100 Montgomery Sf Llc 100 Montgomery St Ste 1420 San Francisco 1 CA 1 94104 1 07/07/2016   07/07/2016   100 Montgomery St 1420 Ste San Francisco 1 94104 1 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1    
198451 1149044-06-171 100 Pine Owner, L.l.c. 100 Pine Street 3953 Maple Ave Ste 300 Dllas 2196 TX 26 75219 3236 02/08/2017   02/08/2017   3953 Maple Ave 300 Ste Dallas 194 75219 1497 TX 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
86963 0463466-01-001 100 Pine Street Investment Gro 100 Pine Street Investment Gro 100 Pine St 325 San Francisco 1 CA 1 94111 35 01/01/2011 02/08/2017 01/01/2011 02/08/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   100 PINE ST San Francisco, CA 94111 (37.792382, -122.398959)
28337 0344195-01-001 100 Pine Street Lp 100 Pine St Lp 100 Pine St San Francisco 1 CA 1 94111 35 11/21/2000 05/22/2006 11/21/2000 05/22/2006   Pittsburgh 377 15258 679       0 0 D26 Station Tanks - Above Ground 3 1 Financial District/South Beach 1   100 PINE ST San Francisco, CA 94111 (37.792382, -122.398959)
135155 1025161-04-151 100 Post St A Tenancy In Common Ownership 100 Post St 100 Post St San Francisco 1 CA 1 94108 9 12/01/2003 02/01/2017 12/01/2003 02/01/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           100 POST ST SAN FRANCISCO, CA 94108 (37.788854, -122.403979)
190874 1134761-02-171 100 Post Street-A Tenancy In Common Partnership 100 Post Street A Tenancy In Common Agreement 100 Post St San Francisco 1 CA 1 94108 9 02/01/2017   02/01/2017   121 Elsie St San Francisco 1 94110 37 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
11200 0159913-01-001 100 Spear St Owners Corp 100 Spear St Building 100 Spear St 330 San Francisco 1 CA 1 94105 7 08/01/1986   08/02/1986   100 Spear St #330 San Francisco 1 94105 5 CA     0 0     6 3 Financial District/South Beach 1   100 SPEAR ST San Francisco, CA 94105 (37.792355, -122.393839)
187569 1126311-11-161 100 Terra Vista Llc 100 Terra Vista Llc 2083 Timberlane Way San+mateo 61 CA 1 94402 158 01/28/2015   01/28/2015   519 Oak Park Dr San Francisco 1 94131 14 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1            
130444 1016780-01-151 100 Van Ness Associates Llc 100 Van Ness Associates Llc 100 Van Ness Ave San Francisco 1 CA 1 94102 16 01/23/2015   01/23/2015   235 Montgomery St 27th Floor San Francisco 1 94104 1 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D03 D26 Multiple 6 3 Tenderloin 11   100 VAN NESS AVE SAN FRANCISCO, CA 94102 (37.776651, -122.419485)
144450 1040786-09-151 100 Van Ness Llc Corridor 100 Van Ness Ave San Francisco 1 CA 1 94102 16 09/28/2015   09/28/2015   1770 Post St #188 San Francisco 1 94115 2 CA 7220-7229 8 Food Services 8 0 0 D04 H26 Multiple 6 3 Tenderloin 11   100 VAN NESS AVE SAN FRANCISCO, CA 94102 (37.776651, -122.419485)
144452 1040792-09-151 100 Van Ness Llc Corridor Cafe 100 Van Ness Ave San Francisco 1 CA 1 94102 16 09/28/2015   09/28/2015   1770 Post St #188 San Francisco 1 94115 2 CA 7220-7229 8 Food Services 8 0 0 H28 Take-Out Establishment 6 3 Tenderloin 11   100 VAN NESS AVE SAN FRANCISCO, CA 94102 (37.776651, -122.419485)
138462 1030781-06-151 100-120 Powell Owner Lp Hotel Union Square 100 Powell St San Francisco 1 CA 1 94102 16 05/13/2015   05/13/2015   114 Powell St San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1           100 POWELL ST SAN FRANCISCO, CA 94102 (37.785723, -122.407913)
147997 1047099-12-151 1000 Channel Street (Sf) Owner Llc 1000 Channel Street 4700 Wilshire Blvd Los+angeles 33 CA 1 90010 2730 12/15/2015   12/15/2015 11/01/2017 4700 Wilshire Blvd Los Angeles 3 90010 913 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           4700 WILSHIRE BLVD LOS ANGELES, CA 90010 (34.062001, -118.332611)
206771 1165717-11-171 1000 Channel Street (Sf) Owner Llc 1000 Channel Street 1000 3rd St Unit 101 San Francisco 1 CA 1 94158 58 12/15/2015   11/01/2017   4700 Wilshire Blvd Los Angeles 3 90010 913 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission Bay 25    
153338 1058734-03-161 1000 Jump Shooters 1000 Jump Shooters 4317 21st St #1 San+francisco 8 CA 1 94114 34 03/01/2016 08/31/2016 03/01/2016 08/31/2016             0 0           4317 21ST ST SAN FRANCISCO, CA 94114 (37.755335, -122.439515)
160036 1071604-05-161 1000 Post Street Partners Llc The Saratoga 1000 Larkin St San Francisco 1 CA 1 94109 24 05/18/2016   05/19/2016   3450 3rd St 1b Bldg San Francisco 1 94124 6 CA 7220-7229 8 Food Services 8 0 0 D04 H26 Multiple       1000 LARKIN ST SAN FRANCISCO, CA 94109 (37.787205, -122.418321)
203110 1159003-08-171 100offer, Llc 100offer 2 Embarcadero Ctr Fl 7 San+francisco 8 CA 1 94111 35 03/01/2017   03/01/2017   2 Embarcadero Ctr 7 Fl San Francisco 1 94111 11 CA     0 0            
95703 0473337-01-001 101 Broderick Llc 101 Broderick Llc 1040 Steiner St San Francisco 1 CA 1 94115 4 09/22/2012   09/22/2012   4247 18th St San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Western Addition 29   1040 STEINER ST San Francisco, CA 94115 (37.778907, -122.433519)
95704 0473337-02-001 101 Broderick Llc 101 Broderick Llc 1329 Grove St San Francisco 1 CA 1 94117 33 09/22/2012   09/22/2012   4247 18th St San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10   1329 GROVE ST San Francisco, CA 94117 (37.775858, -122.438633)
95705 0473337-03-001 101 Broderick Llc 101 Broderick Llc 1327 Lyon/2 Leona Terrace San+francisco 8 CA 1 94115 4 09/22/2012   09/22/2012   4247 18th St San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1327 LYON 2 LEONA TERRACE San Francisco, CA 94115
171011 1090988-08-161 101 Broderick Llc 1040 Steiner Street 4247 18th St San Francisco 1336 CA 1 94114 34 01/01/2015   01/01/2015   4247 18th St San Francisco 1270 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
174046 1100369-08-161 101 Broderick Llc 1327-1333 Lyon Street 4267 18th St San Francisco 1 CA 1 94114 34 01/01/2015   01/01/2015   4267 18th St San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30    
195579 1143272-04-171 101 Broderick Llc 1329-1339 Grove St 4247 18th St San Francisco 1 CA 1 94114 34 01/01/2016   01/01/2016   4247 18th St San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30    
101702 0479671-01-001 101 Cyril Magnin Street Llc 101 Cyril Magnin Street Llc 3520 Broderick St San Francisco 1 CA 1 94123 3 11/10/2009   11/10/2009   3520 Broderick St San Francisco 1 94123 48 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3520 BRODERICK ST San Francisco, CA 94123 (37.802824, -122.445149)
138142 1030237-06-151 101 Frederick Apartments 101 Frederick Street Apartments 101 Frederick Ave San+francisco 8 CA 1 94102 16 12/31/2014   01/01/2015   714 Van Ness Ave San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           101 FREDERICK AVE SAN FRANCISCO, CA 94102 (37.767411, -122.445003)
102303 0480241-01-001 101 Frederick Street Llc 101 Frederick Street Llc 101 Frederick St San Francisco 1 CA 1 94117 33 05/23/2013   05/23/2013   714 Van Ness Avenue San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     8 5 Haight Ashbury 32   101 FREDERICK ST San Francisco, CA 94117 (37.767411, -122.445003)
143380 1038830-09-151 101 Luxury Transportation 101 Luxury Transportation 3410 Geary Blvd #211 San+francisco 8 CA 1 94118 6 07/25/2015   07/25/2015   3410 Geary Blvd # 211 San Francisco 1 94118 28 CA 4800-4999 12 Transportation and Warehousing 12 0 0           3410 GEARY BLVD SAN FRANCISCO, CA 94118 (37.781475, -122.455741)
69463 0438313-01-001 101 New Montgomery Building Ti 101 New Montgomery Building Ti 101 New Montgomery St San Francisco 1 CA 1 94105 7 01/01/2009   01/01/2009   27 Maiden Lane #250 San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   101 NEW MONTGOMERY ST San Francisco, CA 94105 (37.787457, -122.400492)
138865 1031508-06-151 101 Sanchez Associates Llc 101-111 Sanchez St./781-797 14th St. 101-111 Sanchez St/781-797 14th St San+francisco 8 CA 1 94114 34 05/29/2015   05/29/2015   1717 Powell St Ste 300 San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           101 111 SANCHEZ ST 781-797 14TH ST SAN FRANCISCO, CA 94114
132617 1020751-02-151 101 Second Street Inc 101 Second Street Inc 101 2nd Street #325 San+francisco 8 CA 1 94105 7 01/07/2014 02/18/2016 01/07/2014 02/18/2016             0 0           101 2ND STREET SAN FRANCISCO, CA 94105 (37.787733, -122.399452)
81361 0456563-01-001 101 Super Mart Inc 101 Super Mart Inc 517 Clement St San Francisco 1 CA 1 94118 6 02/22/2011   02/22/2011   517 Clement St San Francisco 1 94118 28 CA     0 0     1 6 Inner Richmond 21   517 CLEMENT ST San Francisco, CA 94118 (37.782949, -122.464601)
119618 0947070-01-002 101 Telegraph Hill Bl Homeowne 101 Telegraph Hill Bl Homeowne 47 Kearny St San Francisco 1 CA 1 94108 9 01/01/1996 07/27/2017 09/01/2010 07/27/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           47 KEARNY ST San Francisco, CA 94108 (37.788551, -122.403604)
168417 1085924-07-161 1010 Fell St. 1010 Fell St. 1010 Fell St San Francisco 1 CA 1 94117 33 01/01/2014   01/01/2014   Po Box 590206 San Francisco 1 94159 4 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
43405 0388449-01-001 1011 Howard St Llc Raymond Hotel 1011 Howard St San Francisco 1 CA 1 94103 25 04/15/2002   04/15/2002   402 8th Avenue 207 Suite San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   1011 HOWARD ST San Francisco, CA 94103 (37.779477, -122.407503)
67625 0434998-01-001 1013 Media Llc 1013 Media Llc 179 11th St 3rd Fl San Francisco 1 CA 1 94103 25 12/01/2007 07/01/2014 04/17/2009 07/01/2014             0 0     6 3 South of Market 15   179 11TH ST San Francisco, CA 94103 (37.773356, -122.415913)
67626 0434998-02-001 1013 Media Llc 1013 Media Llc 166 Glenview Dr San Francisco 1 CA 1 94131 14 12/01/2007 07/01/2014 02/01/2014 07/01/2014             0 0     8 5 Twin Peaks 20   166 GLENVIEW DR San Francisco, CA 94131 (37.74867, -122.44722)
148542 1048034-01-161 1014 Mission Llc 1014 Mission Llc 1014 Mission St San Francisco 1 CA 1 94103 25 01/01/2016   01/01/2016   2045 Dorsch Rd Walnut Creek 4 94598 243 CA     1 0           1014 MISSION ST SAN FRANCISCO, CA 94103 (37.780666, -122.409095)
66512 0433015-01-001 1015 Masonic Ave Apartment Llc 1015 Masonic Ave Apartment Llc 1015 Masonic Ave San Francisco 1 CA 1 94117 33 09/18/2008   09/18/2008   325 Corey Way Ste 102 S San Fran 29 94080 13 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Haight Ashbury 32   1015 MASONIC AVE San Francisco, CA 94117 (37.77186, -122.445687)
169126 1087260-08-161 1015 Pierce Apartments Llc 1015 Pierce Apartments, Llc 390 Arkansas St San Francisco 1 CA 1 94107 22 08/01/2016   08/01/2016   390 Arkansas St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28    
190241 1133586-01-171 1016 Washington Street, Llc 1016 Washington Street, Llc 1016 Washington St San Francisco 1 CA 1 94109 24 05/26/2016   05/26/2016   600 California St 20th Fl San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
130755 1017367-01-151 1019 Market Street Lp 1019 Market Street 1019 Market St San Francisco 1 CA 1 94103 25 10/01/2014   10/01/2014   1390 Market St 316 Ste San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1019 MARKET ST SAN FRANCISCO, CA 94103 (37.781916, -122.410694)
49769 0402204-01-001 1020 Inc 1020 184 Rose St 94102 San Francisco 1 CA 1 94102 16 08/01/2006   02/24/2009   184 Rose Street San Francisco 1 94102 16 CA 5100-5199 15 Information 15 0 0     5 7 Hayes Valley 10   184 ROSE ST San Francisco, CA 94102 (37.773462, -122.423564)
49770 0402204-02-001 1020 Inc Placecast 165 Page St San Francisco 1 CA 1 94102 16 08/01/2006   11/22/2010   184 Rose Street San Francisco 1 94102 16 CA 5100-5199 15 Information 15 0 0     5 7 Hayes Valley 10   165 PAGE ST San Francisco, CA 94102 (37.773952, -122.423499)
94341 0471890-01-001 1020 Post Street Llc 1020 Post 1020 Post St San Francisco 1 CA 1 94102 16 09/22/2011   09/22/2011   600 California St Fl 20 San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1020 POST ST San Francisco, CA 94102 (37.78697, -122.418696)
143897 1039723-09-151 1025 Steiner I2 Llc 1025 Steiner Street 1025 Steiner St San Francisco 1 CA 1 94115 4 06/26/2015   06/26/2015   600 California St 20th Fl San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Western Addition 29   1025 STEINER ST SAN FRANCISCO, CA 94115 (37.778841, -122.433506)
190335 1133773-01-171 1025 Sutter I5, Llc 1025 Sutter I5, Llc 1025 Sutter St San Francisco 1 CA 1 94109 24 08/23/2016   08/23/2016   600 California St 20th Fl San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17    
143780 1039533-09-151 1025 Sutter Street Partners Lp 1025 Sutter Street 1025 Sutter St San Francisco 1 CA 1 94109 24 05/20/2015 08/01/2016 05/20/2015 08/01/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1025 SUTTER ST SAN FRANCISCO, CA 94109 (37.788127, -122.417245)
145302 1042273-10-151 1028 Guerrero Street Llc 1028 Guerrero Street Llc 1028 Guerrero St San Francisco 1 CA 1 94110 18 01/01/2015   01/01/2015   720 York St Ste #106 San Francisco 1 94110 37 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     8 5 Mission 12   1028 GUERRERO ST SAN FRANCISCO, CA 94110 (37.754714, -122.423182)
94382 0471925-01-001 1029 Geary Street Llc 1029 Geary St 1029 Geary St San Francisco 1 CA 1 94109 24 05/31/2012 08/11/2014 05/31/2012 08/11/2014             0 0     6 3 Tenderloin 11   1029 GEARY ST San Francisco, CA 94109 (37.785825, -122.420339)
123425 1004335-08-141 1029 Geary Street Property Llc 1029 Geary St Apartment 1029 Geary St San Francisco 1 CA 1 94109 24 08/08/2014   08/08/2014   308 Jessie St San Francisco 1 94103 32 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1029 GEARY ST SAN FRANCISCO, CA 94109 (37.785825, -122.420339)
136483 1027480-05-151 1029 Geary Street Property Llc 1029 Geary Street -Commercial 1029 Geary St San Francisco 1 CA 1 94109 24 05/01/2015   05/01/2015   308 Jessie St San Francisco 1 94103 32 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1029 GEARY ST SAN FRANCISCO, CA 94109 (37.785825, -122.420339)
165859 1081609-07-161 1030 Polk Associates Lp 2000 Oakdale Ave / 1030 Polk Associates Lp 2000 Oakdale Ave San Francisco 1 CA 1 94124 8 11/14/2014   11/14/2014   1167 Mission St Flr 4 San Francisco 1 94103 32 CA 4800-4999 5300-5399 7220-7229 93 Multiple 13 0 0            
143715 1039411-09-151 1030 Polk L1 Llc 1030 Polk L1 Llc 1030 Polk St San Francisco 1 CA 1 94109 24 11/03/2014   11/03/2014   600 California St 20th Fl San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1030 POLK ST SAN FRANCISCO, CA 94109 (37.786555, -122.419882)
198348 1132328-01-171 1030 Taraval Inc Smile House Cafe 1030 Taraval St San Francisco 1 CA 1 94116 23 01/01/2017 08/31/2017 01/01/2017 08/31/2017         7220-7229 8 Food Services 8 0 0            
160125 1071764-05-161 1030 Washington Apt 3 1030 Washington Apt 3 1030 Washington St Apt 3 San Francisco 1 CA 1 94108 9 05/20/2016   05/20/2016   1030 Washington St 3 Apt San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1     3 1 Chinatown 7   1030 WASHINGTON ST SAN FRANCISCO, CA 94108 (37.794666, -122.410267)
207749 1167428-11-171 1031 Scott Partners 1031 Scott Partners Lp 1031 Scott St San Francisco 1 CA 1 94115 4 06/21/2017   06/21/2017   Po Box 170296 San Francisco 1 94117 80 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
94540 0472086-01-001 1033-1037 Washington Street Ll 1033-1037 Washington Street Ll 1033-37 Washington St San Francisco 1 CA 1 94110 18 08/15/2012 06/30/2013 08/15/2012 06/30/2013             0 0     3 1 Nob Hill 17   1033 37 WASHINGTON ST San Francisco, CA 94110 (37.794655, -122.410353)
29753 0349484-01-001 1035 Market St Llc 1035 Market St Bldg 1035 Market St San Francisco 1 CA 1 94103 25 06/06/2000   06/06/2000   One Towne Square #1913 Southfield 706 48076 1158 MI 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D26 Station Tanks - Above Ground       1035 MARKET ST San Francisco, CA 94103 (37.781595, -122.411106)
131023 1017864-02-151 1035 Market St Llc 1043-1045 Market St Bldg 1043-1045 Market St San Francisco 1 CA 1 94103 25 06/06/2000   06/06/2000   One Towne Square #1913 Southfield 706 48076 1158 MI 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   1043 1045 MARKET ST SAN FRANCISCO, CA 94103 (37.781517, -122.411206)

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