home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

606 rows where Mail City = 4

View and edit SQL

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

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
13 0042500-08-999 Brondello A & Crespi V Bbc Investments 251 Layayette Cir 250 Yountville 5 CA 1 94599 12 10/01/1968   01/02/2002   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           251 LAYAYETTE CIR YOUNTVILLE, CA 94599
1051 0001072-01-001 Basic American Inc Basic American Inc 600 Montgomery St 28th Flr San Francisco 1 CA 1 94111 35 10/01/1968   03/07/2005 04/30/2017 2999 Oak Rd 800 Ste Walnut Creek 4 94597 140 CA 3100-3399 10 Manufacturing 10 0 0     3 1 Chinatown 7   600 MONTGOMERY ST FLR San Francisco, CA 94111 (37.795131, -122.403236)
2365 0042077-01-001 Crespi/brondello/brondello C & B Properties 670 De Haro St A San Francisco 1 CA 1 94107 22 10/01/1968   06/11/1993   700 Ygnacio Valley Rd Ste 120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   670 DE HARO ST A San Francisco, CA 94107 (37.761424, -122.401253)
2399 0042077-01-002 Crespi/brondello/brondello C & B Properties 650 De Haro St San Francisco 1 CA 1 94107 22 10/01/1968   06/11/1993   700 Ygnacio Valley Rd Ste 120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   650 DE HARO ST San Francisco, CA 94107 (37.761643, -122.401276)
2405 0042077-01-003 Crespi/brondello/brondello C & B Properties 660 De Haro Ave San+francisco 8 CA 1 94107 22 10/01/1968   06/11/1993   700 Ygnacio Valley Rd Ste 120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           660 DE HARO AVE San Francisco, CA 94107 (37.761521, -122.401263)
2584 0062479-01-001 Basuino Joseph & Ann 4079-4085 19th St Apts 4079 19th St San Francisco 1 CA 1 94114 34 04/08/1969   04/08/1969   2003 Comistas Dr Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30   4079 19TH ST San Francisco, CA 94114 (37.759322, -122.434369)
2720 0042500-03-001 Brondello A & Crespi V 741 Kansas Apts 741 Kansas St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   741 KANSAS ST San Francisco, CA 94107 (37.760274, -122.403113)
2729 0042500-04-001 Brondello A & Crespi V 766 Kansas Apts 766 Kansas St San Francisco 1 CA 1 94107 22 10/01/1968   01/01/1977   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   766 KANSAS ST San Francisco, CA 94107 (37.760026, -122.403087)
2786 0042500-05-001 Brondello A & Crespi V 1736-1796 18th St Bldg 1736 18th St San Francisco 1 CA 1 94107 22 10/01/1968   12/14/1981   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   1736 18TH ST San Francisco, CA 94107 (37.762398, -122.399648)
2790 0042500-07-001 Brondello A & Crespi V 499 Carolina St Bldg 499 Carolina St San Francisco 1 CA 1 94107 22 10/01/1968   12/14/1981   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   499 CAROLINA ST San Francisco, CA 94107 (37.762685, -122.400449)
2792 0042500-09-001 Brondello A & Crespi V 789 Carolina St Apartments 789 Carolina St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2007   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   789 CAROLINA ST San Francisco, CA 94107 (37.758624, -122.400047)
3297 0004658-11-001 Aaa Of Northern Ca Nv & Ut Aaa 160 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   08/20/2006   1277 Treat Boulevard 1000 Ste Walnut Creek 4 94597 140 CA 5240-5249 20 Insurance 17 0 0     3 1 Financial District/South Beach 1   160 SUTTER ST San Francisco, CA 94102 (37.789906, -122.403269)
3342 0004658-11-002 Aaa Of Northern Ca Nv & Ut Aaa 2300 16th St 280 San Francisco 1 CA 1 94103 25 10/01/1968   11/05/2007   1277 Treat Boulevard 1000 Ste Walnut Creek 4 94597 140 CA 5240-5249 20 Insurance 17 0 0     10 4 Mission 12   2300 16TH ST San Francisco, CA 94103 (37.765632, -122.410113)
3358 0004658-12-001 Aaa Of Northern Ca Nv & Ut Aaa 1585 Sloat Blvd San Francisco 1 CA 1 94132 32 10/01/1968   09/01/2006   1277 Treat Boulevard 1000 Ste Walnut Creek 4 94597 140 CA 5240-5249 20 Insurance 17 0 0     7 9 Sunset/Parkside 14   1585 SLOAT BLVD San Francisco, CA 94132 (37.734007, -122.489837)
3369 0004658-14-001 Aaa Of Northern Ca Nv & Ut Aaa 599 Clement St San Francisco 1 CA 1 94118 6 10/01/1968   04/03/2008   1277 Treat Boulevard 1000 Ste Walnut Creek 4 94597 140 CA 5240-5249 20 Insurance 17 0 0     1 6 Inner Richmond 21   599 CLEMENT ST San Francisco, CA 94118 (37.782911, -122.465495)
3505 0004710-01-001 Caltool Indstl Supply Co Inc Caltool Indstl Supply Co Inc 47 Hester St San+francisco 8 CA 1 94134 26 10/01/1968   10/01/1968   2977 Ygnacio Valley Rd Walnut Creek 4 94598 243 CA     0 0           47 HESTER ST San Francisco, CA 94134 (37.714909, -122.398491)
3520 0004710-01-999 Caltool Indstl Supply Co Inc Caltool Indstl Supply Co Inc 470 Hester St San+leandro 15 CA 1 94577 36 10/01/1968   10/01/1968   2977 Ygnacio Valley Rd Walnut Creek 4 94598 243 CA     0 0           470 HESTER ST SAN LEANDRO, CA 94577 (37.721681, -122.190565)
3558 0145048-03-999 Hicks Consulting Group Inc Hicks Consulting Group Inc 2950 Buskirk Ave 120 Walnut+creek 32 CA 1 94597 139 12/22/2004   02/01/2010   1550 Parkside Drive Ste 150 Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2950 BUSKIRK AVE WALNUT CREEK, CA 94597 (37.928711, -122.059979)
4171 0474936-01-001 Tom Poylunyee Poylunyee Tom 1109 Montgomery St San Francisco 1 CA 1 94133 11 01/01/2013   01/01/2013   3275 Sugarberry Ln Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   1109 MONTGOMERY ST San Francisco, CA 94133 (37.79942, -122.404112)
4404 0303754-06-001 Gawfco Enterprises Inc Potrero 76 401 Potrero Ave San Francisco 1 CA 1 94110 18 06/29/2006   08/13/2007 08/13/2007 587 Ygnacio Valley Rd Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   401 POTRERO AVE San Francisco, CA 94110 (37.764252, -122.407407)
4638 0019117-01-001 Microbiz Service Company Microbiz 444 Jessie St San Francisco 1 CA 1 94103 25 10/01/1968   10/01/1968   2872 Acacia Road Walnut Creek 4 94595 359 CA 4400-4599 3 Retail Trade 3 0 0     6 3 South of Market 15 Central Market 2 444 JESSIE ST San Francisco, CA 94103 (37.782092, -122.408365)
5261 0092927-05-001 Fitzpatrick Neil J & Judith 1218-1220 2nd Av Bldg 1218 2nd Ave San Francisco 1 CA 1 94122 19 03/01/2007   03/01/2007 06/23/2015 3104 Ptarmigan Dr Apt 2 Walnut Creek 4 94595 359 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1218 2ND AVE San Francisco, CA 94122 (37.765889, -122.458924)
5650 0055300-01-001 Diana Dennin 684-688 Broadway Bldg 684 Broadway St San+francisco 8 CA 1 94133 11 10/01/1968   10/01/1968   1803 Burl Hollow Ct Walnut Creek 4 94596 10 CA 4400-4599 7210-7219 7220-7229 48 Multiple 13 0 0           684 BROADWAY ST San Francisco, CA 94133 (37.79766, -122.408332)
5657 0064486-13-001 Shirtique Inc Krazy Kaps #138 Pier 39 San Francisco 1 CA 1 94133 11 07/07/1971   01/01/1991   800 South Broadway #300 Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0           39 San Francisco, CA 94133 (37.799415, -122.406131)
5673 0064486-15-001 Shirtique Inc Its All Good By The Bay Pier 39 H-14 San+francisco 8 CA 1 94133 11 07/07/1971   06/01/2011 01/06/2014 800 South Broadway #300 Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0           14 San Francisco, CA 94133 (37.799341, -122.406246)
5842 0106561-01-001 Pelosi Juan P & Carmen A, Trs 25 Sharon Apts 25 Sharon St San Francisco 1 CA 1 94114 34 06/16/1976   06/16/1976   831 Kane Cr Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30   25 SHARON ST San Francisco, CA 94114 (37.7656, -122.429884)
5871 0106561-02-001 Pelosi Juan P & Carmen A, Trs 3935 Mission St Apts 3935 Mission St San Francisco 1 CA 1 94112 28 06/16/1976   01/01/1994 12/31/2013 831 Kane Cr Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Bernal Heights 19   3935 MISSION ST San Francisco, CA 94112 (37.734815, -122.425273)
6193 0148069-02-999 Mason-Mcduffie Real Estate In Mason-Mcduffie Real Estate Inc 5724 W Las Positas Blvd 100 Pleasanton 101 CA 1 94588 160 10/15/1984   04/01/2002 03/23/2012 1555 Riviera Ave Suite E Walnut Creek 4 94596 10 CA     0 0           5724 W LAS POSITAS BLVD PLEASANTON, CA 94588 (37.686148, -121.891278)
6202 0148069-03-001 Mason-Mcduffie Real Estate In Better Homes And Gardens Real 1427 Valencia St San Francisco 1 CA 1 94110 18 10/15/1984   09/01/2012   1555 Riviera Ave Suite E Walnut Creek 4 94596 10 CA     0 0     9 8 Mission 12   1427 VALENCIA ST San Francisco, CA 94110 (37.750013, -122.420457)
6253 0121675-01-999 Barcelon Assocs Mgmt. Corp. Barcelon Assocs Mgmt.corp. 590 Lennon Lane 110 Walnut+creek 32 CA 1 94598 219 08/30/1979   08/30/1979   590 Lennon Ln 110 Ste Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           590 LENNON LANE WALNUT CREEK, CA 94598 (37.929479, -122.031626)
6304 0055957-01-001 Belasco Josephine Etal 1530 Hyde Apts 1530 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   16 Hillview Ter Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1530 HYDE ST San Francisco, CA 94109 (37.794954, -122.418202)
7873 0008862-01-001 Ericksen, Arbuthnot Etal Inc Ericksen, Arbuthnot Etal Inc 100 Bush Street Ste #900 San+francisco 8 CA 1 94104 1 10/01/1968   09/13/2008   570 Lennon Ln Walnut Creek 4 94598 243 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           100 BUSH STREET San Francisco, CA 94104 (37.79128, -122.39995)
8129 0109935-01-001 Guillory Moses & Mabel Etal 35 Belvedere Apts 35 Belvedere St San Francisco 1 CA 1 94117 33 10/04/1977   10/04/1977   428 Wimbledon Rd Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Haight Ashbury 32   35 BELVEDERE ST San Francisco, CA 94117 (37.76914, -122.44955)
8138 0109935-02-001 Guillory Moses & Mabel Etal 520 Clayton Apts 520 Clayton St San Francisco 1 CA 1 94117 33 10/04/1977   02/10/1982 12/31/2013 428 Wimbledon Rd Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Haight Ashbury 32   520 CLAYTON ST San Francisco, CA 94117 (37.770338, -122.448696)
8152 0109935-03-001 Guillory Moses & Mabel Etal 675 Cole St Apts 675 Cole St San Francisco 1 CA 1 94117 33 10/04/1977   01/01/1984 06/01/2004 428 Wimbledon Rd Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Haight Ashbury 32   675 COLE ST San Francisco, CA 94117 (37.768768, -122.450565)
8778 0104658-01-001 Kdm Investment Co Fort Knox Self Storage 370 Turk St San Francisco 1 CA 1 94102 16 05/01/1977   05/01/1977   Po Box 459 Walnut Creek 4 94597 140 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   370 TURK ST San Francisco, CA 94102 (37.782631, -122.415341)
9140 0025554-01-999 Seven-Up Bottling Co Of Sf Seven-Up Bottling Co Of Sf 2009 Farallon Dr San+leandro 15 CA 1 94577 36 10/01/1968   09/01/2007   1981 N Broadway 215 Walnut Creek 4 94596 10 CA 4200-4299 7 Wholesale Trade 7 0 0           2009 FARALLON DR SAN LEANDRO, CA 94577 (37.692529, -122.166576)
9321 1088234-08-161 Haresh Idnani Haresh Idnani 521 Pimlico Ct Walnut+creek 32 CA 1 94597 139 08/15/2015   08/15/2015   521 Pimlico Ct Walnut Creek 4 94597 140 CA     0 0            
9497 0048063-01-001 Speyer & Schwartz Inc 1661/1663 Mission Bldg 1663 Mission St San Francisco 1 CA 1 94103 25 10/01/1968   10/01/1968   4517 Walnut Blvd Walnut Creek 4 94596 10 CA     0 0     6 3 Mission 12   1663 MISSION ST San Francisco, CA 94103 (37.771303, -122.419537)
9524 0395984-03-001 Buzzoni Marco J Juliano 1231a 40th Ave San Francisco 1 CA 1 94122 19 02/24/2006   10/13/2011   1330 Alma Ave Apt E210 Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0     4 10 Sunset/Parkside 14   1231A 40TH AVE San Francisco, CA 94122 (37.76382, -122.499718)
9590 1105650-08-161 Manuel Silva Driver 3119 Kirby Ln Walnut+creek 32 CA 1 94598 219 08/30/2016   08/30/2016   3119 Kirby Ln Walnut Creek 4 94598 243 CA     0 0            
9769 0111208-01-001 Episcopal Homes Foundation 1617-1619 Pine Apts 1617 Pine St San Francisco 1 CA 1 94109 24 11/14/1977 10/27/2011 11/14/1977 10/27/2011   Walnut Creek 4 94596 10       0 0 D26 Station Tanks - Above Ground 2 Western Addition 29   1617 PINE ST San Francisco, CA 94109 (37.789356, -122.422631)
10195 0111547-01-001 Edmond R Soulie Assocs Inc Soulie Edmond R Assocs Inc 2 Henry Adams St 359 San Francisco 1 CA 1 94103 25 02/15/1976   02/15/1976 02/28/2015 101 Ygnacio Valley Rd 110 Ste Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Mission Bay 25   2 HENRY ADAMS ST San Francisco, CA 94103 (37.769163, -122.403954)
10210 0111547-02-001 Edmond R Soulie Assocs Inc Ers Hospitality 2 Henry Adams St 359 San Francisco 1 CA 1 94103 25 02/15/1976   06/01/2001 02/28/2015 101 Ygnacio Valley Rd 110 Ste Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Mission Bay 25   2 HENRY ADAMS ST San Francisco, CA 94103 (37.769163, -122.403954)
10219 0111547-03-001 Edmond R Soulie Assocs Inc Contract Sources Ltd 2 Henry Adams St 359 San Francisco 1 CA 1 94103 25 02/15/1976   10/01/2004 02/28/2015 101 Ygnacio Valley Rd 110 Ste Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Mission Bay 25   2 HENRY ADAMS ST San Francisco, CA 94103 (37.769163, -122.403954)
11022 0158380-01-001 Barambani Joanne 910 Bay Apts 910 Bay St San Francisco 1 CA 1 94109 24 04/27/1981   04/27/1981   674 Monaco Ct Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Russian Hill 5   910 BAY ST San Francisco, CA 94109 (37.804523, -122.422171)
11488 0162430-01-001 Basuino Joseph E 1900 Turk St Apartments 1900 Turk St San Francisco 1 CA 1 94115 4 01/01/1987   01/01/1987   2003 Comistas Dr R Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Western Addition 29   1900 TURK ST San Francisco, CA 94115 (37.779417, -122.44062)
11828 0165443-01-001 Won Ji Hyung 414-424 3rd Av Apartments 414 3rd Ave San Francisco 1 CA 1 94118 6 01/01/1987   01/01/1987   1171 Rudgear Rd Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   414 3RD AVE San Francisco, CA 94118 (37.780635, -122.461046)
12232 0116546-02-001 Horn Maria Wang 1849 Page St 1849 Page St San Francisco 1 CA 1 94117 33 10/16/1978   04/01/1996 05/26/2017 1049 Rudgear Rd Walnut Creek 4 94596 10 CA 7210-7219 9 Accommodations 9 0 0     5 7 Haight Ashbury 32   1849 PAGE ST San Francisco, CA 94117 (37.770406, -122.451224)
12942 0116546-01-001 Horn Maria Wang 1849 Page Apts 1849 Page St San Francisco 1 CA 1 94117 33 10/16/1978   10/16/1978   1049 Rudgear Rd Walnut Creek 4 94596 10 CA 7210-7219 9 Accommodations 9 0 0     5 7 Haight Ashbury 32   1849 PAGE ST San Francisco, CA 94117 (37.770406, -122.451224)
13097 0181684-04-999 Computer Options Inc Convergent Computing 1450 Maria Lane 400 Walnut+creek 32 CA 1 94596 55 09/01/1986   02/18/2012   1450 Maria Lane, Suite 400 Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1450 MARIA LANE WALNUT CREEK, CA 94596 (37.892952, -122.056759)
13099 0181707-02-999 Pisoni Michael A A. Misson Construction 2124 Dover Ct Walnut+creek 32 CA 1 94598 219 11/29/2004   11/29/2004   2124 Dover Ct Walnut Creek 4 94598 243 CA 2300-2399 6 Construction 6 0 0           2124 DOVER CT WALNUT CREEK, CA 94598 (37.919563, -122.026426)
14669 0190521-01-001 Yuen Lai Ting Woo Etal 1502-1508 Mason St Apartments 1502 Mason St San Francisco 1 CA 1 94133 11 01/01/1989   01/01/1989   1788 Castle Hill Rd Walnut Creek 4 94595 359 CA     0 0     3 1 Chinatown 7   1502 MASON ST San Francisco, CA 94133 (37.79729, -122.411933)
14670 0190521-02-001 Yuen Lai Ting Woo Etal 894 Brodway Bldg 894 Broadway San Francisco 1 CA 1 94133 11 01/01/1989   01/01/1989   1788 Castle Hill Rd Walnut Creek 4 94595 359 CA     0 0     3 1 Chinatown 7   894 BROADWAY San Francisco, CA 94133 (37.79728, -122.411865)
14671 0190521-03-001 Yuen Lai Ting Woo Etal 591-595 11th Av Apts 591-595 11th Ave San Francisco 1 CA 1 94118 6 01/01/1989   01/01/1989   1788 Castle Hill Rd Walnut Creek 4 94595 359 CA     0 0     1 6 Inner Richmond 21   591 595 11TH AVE San Francisco, CA 94118 (37.777227, -122.469388)
15179 0194472-03-001 Cho Heng H & Rae Hyun We Care Optical 325 Mason St 5 San Francisco 1 CA 1 94102 16 04/15/1995   11/01/1996   207 Dantley Way Walnut Creek 4 94598 243 CA 4200-4299 7 Wholesale Trade 7 0 0     3 1 Tenderloin 11   325 MASON ST San Francisco, CA 94102 (37.786581, -122.409763)
15367 0195335-01-001 Todd Charles C Prints Alive 2948 20th St San Francisco 1 CA 1 94110 18 01/01/1990   01/01/1990   2060 Walnut Blvd Walnut Creek 4 94597 140 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   2948 20TH ST San Francisco, CA 94110 (37.759147, -122.41056)
15691 0197415-03-999 Systems Integration Solutions Systems Integration Solutions 1277 Treat Blvd 140 San+leandro 15 CA 1 94578 293 12/31/2013   09/28/2009 04/27/2014 1255 Treat Blvd 100 Ste Walnut Creek 4 94597 140 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1277 TREAT BLVD SAN LEANDRO, CA 94578
15692 0197415-04-999 Systems Integration Solutions Systems Integration Solutions 1255 Treat Blvd 100 Walnut+creek 32 CA 1 94597 139 12/31/2013   04/28/2014   1255 Treat Blvd 100 Ste Walnut Creek 4 94597 140 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1255 TREAT BLVD WALNUT CREEK, CA 94597 (37.926533, -122.059388)
16029 0200418-02-999 Terra Nova Industries Terra Nova Industries 1607 Tice Valley Bl Walnut+creek 32 CA 1 94595 459 10/15/1990   10/27/1992   1607 Tice Valley Bl Walnut Creek 4 94595 359 CA 2300-2399 6 Construction 6 0 0           1607 TICE VALLEY WALNUT CREEK, CA 94595 (37.88395, -122.0777)
16312 0159005-01-999 Crandell Rex L Cpa-Acct Corp Crandell Rex L Cpa-Acct Corp 99 Walnut Creek Ca Brisbane Q4068 65   0 5 09/25/1986   09/25/1986   Po Box 30305 Dept Sf Tax Walnut Creek 4 94598 243 CA 5210-5239 11 Financial Services 11 0 0           99 WALNUT CREEK 00000 (33.730607, -117.767192)
17185 0209294-01-001 Episcopal Senior Communities 1623 29th Ave Bldg 1661 Pine St San Francisco 1 CA 1 94109 24 01/01/1991   01/01/1997   2185 N California Blvd Ste 575 Walnut Creek 4 94596 10 CA     0 0           1661 PINE ST San Francisco, CA 94109 (37.789307, -122.423009)
17186 0209294-03-001 Episcopal Senior Communities 1617-1619 Pine St 1617 Pine St San Francisco 1 CA 1 94109 24 01/01/1991   01/01/1997 01/01/2014 2185 N California Blvd Ste 575 Walnut Creek 4 94596 10 CA     0 0     2 Western Addition 29   1617 PINE ST San Francisco, CA 94109 (37.789356, -122.422631)
17187 0209294-04-001 Episcopal Senior Communities Episcopal Senior Communities 1661 Pine St. San Francisco 1 CA 1 94109 24 01/01/1991   07/01/2012 07/06/2017 2185 N California Blvd Ste 575 Walnut Creek 4 94596 10 CA     0 0 D03 D19 D26 H56 Multiple 2 Western Addition 29   1661 PINE ST San Francisco, CA 94109 (37.789307, -122.423009)
17285 0209743-02-999 Wilcox & Company Inc Wilcox & Co Inc 101 Ygnacio Valley Blvd 105 Walnut Creek 314 CA 1 94596 55 11/27/1991   11/24/2012   101 Ygnacio Valley Blvd 105 Walnut Creek 4 94596 10 CA 2300-2399 6 Construction 6 0 0           101 YGNACIO VALLEY BLVD WALNUT CREEK, CA 94596 (37.903868, -122.068736)
18293 0303754-05-001 Gawfco Enterprises Inc Lombard Union 76 2498 Lombard St San Francisco 1 CA 1 94123 3 06/29/2006   06/29/2006   587 Ygnacio Valley Rd Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0 D08 D14 D19 H08 H31 Multiple 2 Marina 2   2498 LOMBARD ST San Francisco, CA 94123 (37.799093, -122.442371)
18294 0303754-06-002 Gawfco Enterprises Inc Potrero 76 401 Potrero Ave San Francisco 1 CA 1 94110 18 06/29/2006   08/23/2013   587 Ygnacio Valley Rd Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0 D08 D13 D19 H03 H31 Multiple 10 4 Potrero Hill 28   401 POTRERO AVE San Francisco, CA 94110 (37.764252, -122.407407)
18295 0303754-08-001 Gawfco Enterprises Inc Divisadero Union 76 443 Divisadero St San Francisco 1 CA 1 94117 33 06/29/2006   09/01/2011   587 Ygnacio Valley Rd Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 1 0 D08 D14 D24 H03 H31 Multiple 5 7 Hayes Valley 10   443 DIVISADERO ST San Francisco, CA 94117 (37.773794, -122.437609)
18701 0305433-01-001 Whitecliff I Apts Ltd / Et Al Post Street Towers 737 Post St San Francisco 1 CA 1 94109 24 04/23/1997   04/23/1997   1777 Botelho Dr Ste 300 Post Street Towers Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D26 Station Tanks - Above Ground 3 1 Tenderloin 11   737 POST ST San Francisco, CA 94109 (37.78756, -122.4141)
18702 0305433-02-001 Whitecliff I Apts Ltd / Et Al Tower 737 737 Post St San Francisco 1 CA 1 94109 24 04/23/1997   04/08/2009   1777 Botelho Dr Ste 300 Post Street Towers Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D03 Portable Containers 3 1 Tenderloin 11   737 POST ST San Francisco, CA 94109 (37.78756, -122.4141)
19070 0307067-01-001 Farrell Anthony P Draft Me Designs 269 Pope St San Francisco 1 CA 1 94112 28 06/09/1992   06/09/1992   205 Ginocchio Ct Walnut Creek 4 94598 243 CA     0 0     11 Excelsior 23   269 POPE ST San Francisco, CA 94112 (37.711813, -122.44025)
19136 0165311-01-001 Vonrusten Herbert 3560 Divisadero St Apartments 3560 Divisadero St San Francisco 1 CA 1 94123 3 01/01/1987   01/01/1987   1330 North Broadway #C Walnut Creek 4 94596 10 CA     0 0     2 Marina 2   3560 DIVISADERO ST San Francisco, CA 94123 (37.802592, -122.443383)
19511 0209743-03-999 Wilcox & Company Inc Wci-Gc 101 Ygnacio Valley Blvd 105 Pleasanton 101 CA 1 94566 204 11/27/1991   06/18/2013   101 Ygnacio Valley Blvd 105 Walnut Creek 4 94596 10 CA 2300-2399 6 Construction 6 0 0           101 YGNACIO VALLEY BLVD PLEASANTON, CA 94566 (37.903868, -122.068736)
19851 0310702-02-001 Lazarte Paul F Diamond Coin Laundromat 1300 Leavenworth St San Francisco 1 CA 1 94109 24 10/30/1997   04/01/2005   1125 Bont Ln Walnut Creek 4 94596 10 CA 7220-7229 8 Food Services 8 0 0 H46 Auto Laundry Mech/pay-To-Operate Washing/dyeing 3 1 Nob Hill 17   1300 LEAVENWORTH ST San Francisco, CA 94109 (37.793007, -122.416125)
20455 0303754-07-001 Gawfco Enterprises Inc Divisadero Spirit 443 Divisadero St San Francisco 1 CA 1 94117 33 06/29/2006   02/01/2008 08/31/2011 587 Ygnacio Valley Rd Walnut Creek 4 94596 10 CA 4400-4599 3 Retail Trade 3 0 0           443 DIVISADERO ST SAN FRANCISCO, CA 94117 (37.773794, -122.437609)
20486 0313583-02-999 Solares Kathleen J Bay Area Mobile Notary 279 Vernon St 1 Oakland 16 CA 1 94610 145 01/02/1998   03/02/2009   1710 Stanley Dollar Dr. 2b Walnut Creek 4 94595 359 CA     0 0           279 VERNON ST OAKLAND, CA 94610 (37.814892, -122.256836)
21404 0317503-01-001 Soga & Associates Archit Inc Soga & Albaugh Architects Inc 657 Mission St #504 San+francisco 8 CA 1 94105 7 06/15/1998   11/01/1998 12/31/2014 1231 Whyte Park Ave Walnut Creek 4 94595 359 CA     0 0           657 MISSION ST San Francisco, CA 94105 (37.787005, -122.40107)
21405 0317503-02-001 Soga & Associates Archit Inc Soga & Associates Archit Inc 657 Mission St 504 San Francisco 1 CA 1 94105 7 06/15/1998   06/16/2002 12/31/2014 1231 Whyte Park Ave Walnut Creek 4 94595 359 CA     0 0     6 3 Financial District/South Beach 1   657 MISSION ST San Francisco, CA 94105 (37.787005, -122.40107)
21822 0313583-01-999 Solares Kathleen J Bay Area Traveling Notary 279 Vernon St 1 Oakland 16 CA 1 94610 145 01/02/1998   01/02/1998   1710 Stanley Dollar Dr. 2b Walnut Creek 4 94595 359 CA     0 0           279 VERNON ST OAKLAND, CA 94610 (37.814892, -122.256836)
22272 0321212-01-001 Taylor Virginia/frances A 846 Harrison St Bldg 846 Harrison St San Francisco 1 CA 1 94107 22 10/01/1998   10/01/1998   1578 Pyrenees Place Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   846 HARRISON ST San Francisco, CA 94107 (37.779859, -122.400814)
23651 0326840-03-001 Rmc Water & Environment Rmc Water & Environment 222 Sutter St 700 San Francisco 1 CA 1 94108 9 01/01/1999   11/15/2006 04/07/2013 2175 N California Blvd #315 Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   222 SUTTER ST San Francisco, CA 94108 (37.789737, -122.404434)
23786 0319649-04-999 Lehane Kevin J Kevin Lehane Gnrl Contractor 143 Madison Ave San+bruno 6 CA 1 94066 13 06/10/2003   01/10/2007 06/30/2015 137 Arlene Dr Walnut Creek 4 94595 359 CA 2300-2399 6 Construction 6 0 0           143 MADISON AVE SAN BRUNO, CA 94066 (37.611057, -122.430755)
24497 0330385-01-001 Habitat Property Mgmt Group Habitat Property Mgmt Group 1890 Jefferson St 102 San Francisco 1 CA 1 94123 3 10/01/1999   08/01/2008   1520 Siskiyou Drive Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1890 JEFFERSON ST San Francisco, CA 94123 (37.804675, -122.443476)
24842 0321634-01-001 Dagen Janeece M Janeece M Dagen, Mfcc 23 Masonic Ave San Francisco 1 CA 1 94118 6 01/01/1990   01/01/1990 11/30/2015 P.o. Box 3618 Oak Grove Rd Walnut Creek 4 94598 243 CA 6100-6299 4 Private Education and Health Services 4 0 0     1 6 Lone Mountain/USF 24   23 MASONIC AVE San Francisco, CA 94118 (37.781493, -122.447587)
25654 0334397-01-999 San Carlos Telecom Inc Creative Interconnect Telecom 2999 Oak Rd 400 Walnut+creek 32 CA 1 94597 139 02/15/2000   02/15/2000 05/02/2017 2999 Oak Rd #400 Walnut Creek 4 94597 140 CA 2200-2299 29 Utilities 18 0 0           2999 OAK RD WALNUT CREEK, CA 94597 (37.928864, -122.057726)
25778 0334809-01-001 Fourcade Henry Fourcade Family Lp 585 Bryant St San Francisco 1 CA 1 94107 22 02/16/1999   02/16/1999   180 Bella Serra Ct Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   585 BRYANT ST San Francisco, CA 94107 (37.77998, -122.39754)
25779 0334809-02-001 Fourcade Henry 565 Bryant St Bldg 565 Bryant St San Francisco 1 CA 1 94107 22 02/16/1999   02/16/1999   180 Bella Serra Ct Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   565 BRYANT ST San Francisco, CA 94107 (37.78014, -122.397324)
25780 0334809-03-001 Fourcade Henry 80 Welsh St Bldg 80 Welsh St San Francisco 1 CA 1 94107 22 02/16/1999   02/16/1999   180 Bella Serra Ct Walnut Creek 4 94598 243 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   80 WELSH ST San Francisco, CA 94107 (37.779276, -122.397356)
26337 0336804-01-001 Fehr & Peers Associates Inc Fehr & Peers Associates Inc 332 Pine St 4th Fl San Francisco 1 CA 1 94104 1 03/01/2000   01/01/2007   100 Pringle Ave Suite 600 Walnut Creek 4 94596 10 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   332 PINE ST San Francisco, CA 94104 (37.79204, -122.401451)
26751 0323407-03-999 Yusupov Viktor K Yuco Electrical 350 N Civic Dr 406 Walnut+creek 32 CA 1 94596 55 01/11/1999   04/22/2009   350 N Civic Dr #406 Walnut Creek 4 94596 10 CA 2300-2399 6 Construction 6 0 0           350 N CIVIC DR WALNUT CREEK, CA 94596 (37.912713, -122.059905)
27103 1147236-05-171 Nguyen Thuy T Sweetie Body 2040 Union St Fl 2 San Francisco 1 CA 1 94213 695 09/17/2012   05/21/2017   120 Village Ct 4 Unit Walnut Creek 4 94596 10 CA     0 0     2 Marina 2    
28372 1145043-05-171 San Carlos Telecom Inc San Carlos Telecom Inc 2999 Oak Rd #400 Walnut+creek 32 CA 1 94597 139 02/15/2000   02/15/2000   2999 Oak Rd #400 Walnut Creek 4 94597 140 CA 2200-2299 29 Utilities 18 0 0            
28978 0346575-02-999 Busch Electric Inc Busch Electric Inc 903 Deer Pl Clayton 472 CA 1 94517 741 11/01/2007   11/01/2007   1541 Third Ave Walnut Creek 4 94597 140 CA 2300-2399 6 Construction 6 0 0           903 DEER PL CLAYTON, CA 94517 (37.950141, -121.91573)
28979 0346575-03-999 Busch Electric Inc Busch Electric Inc 5725 Lewis Wy Concord 20 CA 1 94521 98 11/01/2007   03/05/2012   1541 Third Ave Walnut Creek 4 94597 140 CA 2300-2399 6 Construction 6 0 0           5725 LEWIS WY CONCORD, CA 94521 (37.93862, -121.94724)
30144 0350888-01-001 Statler Stephen W Eureka Street Productions 511 Eureka St San Francisco 1 CA 1 94114 34 11/30/2001   11/30/2001   152 Arlene Dr Walnut Creek 4 94595 359 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     8 5 Noe Valley 33   511 EUREKA ST San Francisco, CA 94114 (37.754011, -122.437637)
30145 0350888-02-001 Statler Stephen W Eureka Street Legal Video 511 Eureka St San Francisco 1 CA 1 94114 34 11/30/2001   11/30/2001   152 Arlene Dr Walnut Creek 4 94595 359 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     8 5 Noe Valley 33   511 EUREKA ST San Francisco, CA 94114 (37.754011, -122.437637)
30976 0353475-02-999 It Ascent Services Group The Ascent Services Group 3000 Oak Rd 200 Walnut+creek 32 CA 1 94597 139 03/31/2009   03/31/2009   3000 Oak Rd #200 Walnut Creek 4 94597 140 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           3000 OAK RD WALNUT CREEK, CA 94597 (37.929744, -122.058063)
31129 0353793-01-999 All Environmental Inc Aei Consultants 2500 Camino Diablo 100 Walnut+creek 32 CA 1 94597 139 03/14/2002   03/14/2002   2500 Camino Diablo 100 Suite Walnut Creek 4 94597 140 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2500 CAMINO DIABLO 100 WALNUT CREEK CA 94597
32749 0359389-01-001 Lassen Housing Associates Lp Lassen Apartments 441 Ellis St San Francisco 1 CA 1 94102 16 11/20/2001   11/20/2001   2033 N Main St Suite 340 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   441 ELLIS ST San Francisco, CA 94102 (37.784784, -122.413491)
32877 0359812-01-001 Lamorinda Developement & Inv Lamorinda Developement & Inv 300 West Portal Ave San Francisco 1 CA 1 94127 31 12/28/1998   12/28/1998   1855 Olympic Blvd Ste 300 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           300 WEST PORTAL AVE San Francisco, CA 94127 (37.737866, -122.469314)

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