home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

719 rows where Mail City = 34

View and edit SQL

Suggested facets: City, Mail Zipcode, NAICS Code, NAICS Code Description, 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
239 0052887-03-001 Petersen Adele Etal 570 Green St 570-574 Green St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1320 Poplar Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   570 574 GREEN ST San Francisco, CA 94133 (37.79958, -122.408532)
3121 0088890-01-001 Ribay Leon V Jr & Estelita G 643-645 Oak Apts 643 Oak St San Francisco 1 CA 1 94117 33 08/23/1974   08/23/1974   626 Farallon Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10   643 OAK ST San Francisco, CA 94117 (37.774081, -122.429923)
3135 0088890-02-001 Ribay Leon V Jr & Estelita G 738 Treat Ave Apts 738 Treat Ave San Francisco 1 CA 1 94110 18 08/23/1974   08/23/1974   626 Farallon Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   738 TREAT AVE San Francisco, CA 94110 (37.758276, -122.413556)
4295 0052887-02-001 Petersen Adele Etal 505-507 Francisco St 505 Francisco St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1320 Poplar Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   505 FRANCISCO ST San Francisco, CA 94133 (37.804647, -122.413798)
4628 0131391-01-001 Biljac Associates 3201 Divisadero St Building 3201 Divisadero St San Francisco 1 CA 1 94123 3 01/01/1980   01/01/1980   371 Inverness Drive Dr Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3201 DIVISADERO ST San Francisco, CA 94123 (37.799345, -122.442728)
5693 0037275-01-001 Dilbeck Helyn M 2430 Francisco Apts 2430 Francisco St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   170 Blackburn Ter Pacifica 34 94044 60 CA 7210-7219 9 Accommodations 9 0 0     2 Marina 2   2430 FRANCISCO ST San Francisco, CA 94123 (37.800624, -122.445287)
5868 0120993-03-999 Tong Millard W Millard Tong Construction 1 Picardo Ranch Rd Pacifica 127 CA 1 94044 200 10/31/1979   11/23/2005   1 Picardo Ranch Rd Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1 PICARDO RANCH RD PACIFICA, CA 94044 (37.598111, -122.470068)
6139 0032716-01-001 Brown Jill 124 Rivoli Apts 124 Rivoli St San Francisco 1 CA 1 94117 33 07/01/2012   07/01/2012   Po Box 275 Pacifica 34 94044 60 CA 5300-5399 7210-7219 19 Multiple 13 0 0     5 7 Haight Ashbury 32   124 RIVOLI ST San Francisco, CA 94117 (37.762475, -122.449816)
6394 0107095-01-001 Kasnestis Alex N & Vasiliki 3336-3338 16th St Apts 3336 16th St San Francisco 1 CA 1 94114 34 01/01/1976   01/01/1976   15 Moon Gate Ct Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30   3336 16TH ST San Francisco, CA 94114 (37.764582, -122.427229)
6404 0032943-01-001 Ehni Bernice Margaret 1270 Funston Apts 1270 Funston Ave San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   1026 Grand Teton Dr Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1270 FUNSTON AVE San Francisco, CA 94122 (37.764396, -122.470629)
6621 0490192-01-001 Matthews,celene & Fagundes,leo Get A Leg Up Dog Walking 229 Judson Ave San Francisco 1 CA 1 94112 28 07/01/2011   07/01/2011   929 Regina Way Pacifica 34 94044 60 CA     0 0     7 9 West of Twin Peaks 26   229 JUDSON AVE San Francisco, CA 94112 (37.728255, -122.447136)
6649 0038231-01-001 Garbarino Fiore & Lena 2901 Cabrillo Apts 2901 Cabrillo St San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968   4 Sheridan Pl Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   2901 CABRILLO ST San Francisco, CA 94121 (37.774176, -122.489959)
6751 0107905-01-001 Rangaves Louis 224 12th St Bldg 224 12th St San Francisco 1 CA 1 94103 25 06/01/1977   06/01/1977   365 Coral Ridge Dr Pacifica 34 94044 60 CA 4400-4599 3 Retail Trade 3 0 0     6 3 Mission 12   224 12TH ST San Francisco, CA 94103 (37.771493, -122.416402)
6766 0915394-02-999 John A Diluzio J & D Electric 1272 Alvarado Ave Pacifica 127 CA 1 94044 200 08/25/1992   01/01/2006   1272 Alvarado Ave Pacifica 34 94044 60 CA     0 0           1272 ALVARADO AVE PACIFICA, CA 94044 (37.585078, -122.485498)
7461 0046573-01-001 Kwok May L 1216 Taylor Apts 1216 Taylor St San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   5 Hibbert Ct Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1216 TAYLOR ST San Francisco, CA 94108 (37.793692, -122.412883)
7686 0057048-01-002 Pagano David M Sf Towing 3012 16th St 210 San Francisco 1 CA 1 94103 25 04/15/1970   08/01/1998   Po Box 1293 Pacifica 34 94044 60 CA     0 0     9 8 Mission 12   3012 16TH ST San Francisco, CA 94103 (37.765017, -122.420138)
9126 0386725-02-001 Ho Peggy P Carpetland & Interior 1630 17th St San Francisco 1 CA 1 94107 22 04/01/2005   04/01/2005   111 Edgewood Dr Pacifica 34 94044 60 CA     0 0           1630 17TH ST San Francisco, CA 94107 (37.764977, -122.400138)
9360 1090219-08-161 Rodel Cabrera Rodel Cabrera 295 Waterford St Pacifica 127 CA 1 94044 200 05/25/2014   05/25/2014   295 Waterford St Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9371 1100341-08-161 Karooni Khaled Karooni 233 El Dorado Dr Apt Pacifica 127 CA 1 94044 200 08/29/2016   08/29/2016   233 El Dorado Dr Apt Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9595 1112526-08-161 Erick Martinez Dba Erick Martinez 690 Manor Dr Pacifica 127 CA 1 94044 200 01/11/2016   01/11/2016   690 Manor Dr Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
10189 1134615-01-171 Ma Jasmin In Salon 1642 Irving St A San Francisco 1 CA 1 94122 19 07/01/2011   01/30/2017   254 Crestmoor Cir Pacifica 34 94044 60 CA     0 0            
12815 0180085-03-999 P/m Power & Light Inc Peterson Power & Light Inc 1275 Danmann Ave Pacifica 127 CA 1 94044 200 01/02/1988   08/31/2009   1275 Danmann Avenue Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1275 DANMANN AVE PACIFICA, CA 94044 (37.595342, -122.509345)
13414 0183761-01-999 Blanchard Donald J Blanchards Sheet Metal 50 Tanforan Ave S+san+fran 9 CA 1 94080 17 01/01/1989   06/01/2006   971 Rio Vista Drive Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           50 TANFORAN AVE S SAN FRAN, CA 94080 (37.639983, -122.414956)
13482 0184098-01-001 Perez Eusebio 3227 Mission Apartments 3227 Mission St San Francisco 1 CA 1 94110 18 05/07/1976   01/01/1989   284 Piedmont Ave Pacifica 34 94044 60 CA     0 0     9 8 Bernal Heights 19   3227 MISSION ST San Francisco, CA 94110 (37.745051, -122.420244)
13929 0186614-01-999 Jmk Construction Inc Jmk Construction Inc 1305 Palmetto Ave Pacifica Pacifica 127 CA 1 94044 200 04/03/1989   05/31/2004   1305 Palmetto Ave #E Fax# 650-355-9585 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1305 PALMETTO AVE PACIFICA PACIFICA, CA 94044 (37.639561, -122.492443)
14077 0187688-02-999 Quan Michael E Michael E Quan 385 Beaumont Blvd Pacifica 127 CA 1 94044 200 07/17/2012   07/17/2012   385 Beaumont Boulevard Pacifica 34 94044 60 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           385 BEAUMONT BLVD PACIFICA, CA 94044 (37.654501, -122.485531)
14177 0057048-01-001 Pagano David M Sf Towing 19 Higuera Ave San Francisco 1 CA 1 94132 32 04/15/1970   04/15/1970   Po Box 1293 Pacifica 34 94044 60 CA     0 0     7 9 Lakeshore 31   19 HIGUERA AVE San Francisco, CA 94132 (37.718272, -122.483486)
14424 0166773-03-001 Whitaker Wanda K Anchored In Spirit 4530 18th St San Francisco 1 CA 1 94114 34 01/04/1993   10/18/2006   467 Gateway Dr #170 Pacifica 34 94044 60 CA     0 0     8 5 Castro/Upper Market 30   4530 18TH ST San Francisco, CA 94114 (37.760603, -122.44011)
14724 0190726-01-001 Paul & Carol Wong Etal 307 Capp St Apartments 307 Capp St San Francisco 1 CA 1 94110 18 01/01/1989   01/01/1989   1217 Glacier Av Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   307 CAPP ST San Francisco, CA 94110 (37.761652, -122.418245)
15559 0196569-01-999 Cowan Timothy W Daystar Plumbing 1015 Rio Vista Dr Pacifica 127 CA 1 94044 200 04/17/1990   04/17/1990   1015 Rio Vista Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1015 RIO VISTA DR PACIFICA, CA 94044 (37.585576, -122.494726)
16213 0201728-01-999 Berg Duane R Bergs Heating & Service Co 11 Banff Wy Brisbane+q4068 3   0 5 12/19/1990   12/19/1990   11 Banff Way Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           11 BANFF WY 00000 (37.589883, -122.466341)
16588 0204467-01-999 Sotello Edward I Sotello Graphic Associates 901a Palmetto Av Pacifica 127 CA 1 94044 200 02/01/1991   02/01/1991   901a Palmetto Av Pacifica 34 94044 60 CA     0 0           901A PALMETTO AV PACIFICA, CA 94044 (37.643376, -122.492628)
16607 0204639-01-999 Patrick David O'neill Patrick O'neill Plumbing Co 839 Linda Mar Blvd Daly+city 40 CA 1 94014 97 04/22/1991   01/13/2000   839 Linda Mar Blvd Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           839 LINDA MAR BLVD DALY CITY, CA 94014 (37.590672, -122.495673)
16833 0199990-01-001 Sin Charles & Sonia 800-806 Larkin Building 800 Larkin St San Francisco 1 CA 1 94109 24 09/23/1988   09/23/1988   1217 Glacier Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   800 LARKIN ST San Francisco, CA 94109 (37.78529, -122.417949)
18275 0199990-02-001 Sin Charles & Sonia 417 Hyde St Apartments 417 Hyde St San Francisco 1 CA 1 94109 24 09/23/1988   09/23/1988 01/01/2014 1217 Glacier Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   417 HYDE ST San Francisco, CA 94109 (37.784763, -122.416151)
19137 0180248-01-999 Muscio Rod C Muscio Rod Electrical Contr 901 Palmetto Av P Brisbane+q4068 3   0 5 09/12/1988   09/12/1988   901 Palmetto Ave #P Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           901 PALMETTO AV 00000 (41.039003, -81.494057)
19304 0161115-02-999 Salinas Rene F Rene Business Machines 266 Clifton Rd Pacifica 127 CA 1 94044 200 01/01/2001   11/20/2013   266 Clifton Rd Pacifica 34 94044 60 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           266 CLIFTON RD PACIFICA, CA 94044 (37.65305, -122.487704)
19424 0308885-01-999 Crug Robert P Fog City Fire 1495 Rosita Rd Pacifica 127 CA 1 94044 200 10/01/1997   10/01/1997   1495 Rosita Rd Pacifica 34 94044 60 CA     0 0           1495 ROSITA RD PACIFICA, CA 94044 (37.580577, -122.481329)
19463 0309011-04-999 Rodrigues Michael J Rosenberg Plumbing/r O Enterpr 1724 Palmetto Av Pacifica 127 CA 1 94044 200 03/07/2011   03/07/2011   1724 Palmetto Av Pacifica 34 94044 60 CA     0 0           1724 PALMETTO AV PACIFICA, CA 94044 (37.635738, -122.492108)
19905 0310995-03-999 Bleyle Elevator Inc Bleyle Elevator Inc 580 Crespi Dr A-3 Pacifica 127 CA 1 94044 200 03/31/2010   03/31/2010   580 Crespi Drive Unit A 3 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           580 CRESPI DR PACIFICA, CA 94044 (37.598588, -122.498536)
20183 0308873-01-999 Avila Martha Alicia Fresh Air Janitor & Hse Clng 32 Cadiz Ct Pacifica 127 CA 1 94044 200 08/21/1997   08/21/1997   Po Box 320 Pacifica 34 94044 60 CA     0 0           32 CADIZ CT PACIFICA, CA 94044 (37.592787, -122.494046)
20212 0312544-02-999 Szentkuti Shandor J Green Street Construction 315 Windwood Ave Pacifica 127 CA 1 94044 200 01/10/1998   02/01/2012   315 Winwood Ave Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           315 WINDWOOD AVE PACIFICA, CA 94044 (37.654436, -122.487264)
20868 0315030-01-999 Phelan Jim C J C Phelan Co 704 Cindy Wy Pacifica 127 CA 1 94044 200 03/23/1998   03/23/1998   704 Cindy Wy Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           704 CINDY WY PACIFICA, CA 94044 (37.621283, -122.482573)
21557 0318286-01-999 Ramos Virgilio Glorioso Ver Limo 73 Morton Dr Daly+city 40 CA 1 94015 67 07/17/1998   07/17/1998 05/10/2016 265 Gateway Dr Apt 109 Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0           73 MORTON DR DALY CITY, CA 94015 (37.66067, -122.474101)
22167 0320874-03-002 Prevett Jennifer L Jennifer L Prevett 350 West Portal San+francisco 8 CA 1 94127 31 11/01/2005   03/20/2013   443 Manor Dr Pacifica 34 94044 60 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           350 WEST PORTAL San Francisco, CA 94127 (37.73735, -122.469934)
22752 0301429-01-999 Brignoli John J Brignoli's Landscaping 76 Ridgefield Daly+city 40 CA 1 94015 67 04/12/1996   04/12/1996   Po Box 1338 Pacifica 34 94044 60 CA     0 0           76 RIDGEFIELD DALY CITY, CA 94015 (37.673298, -122.486598)
23097 0324362-02-999 Mayne Arlene Arlene Mayne Design 569 Loma Vista Ter Pacifica 127 CA 1 94044 200 02/08/2006   02/08/2006   569 Loma Vista Ter Pacifica 34 94044 60 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           569 LOMA VISTA TER PACIFICA, CA 94044 (37.635096, -122.483042)
23871 0327870-01-999 Johnstone Mcauliffe Const Inc Johnstone Mcauliffe Const Inc 100 Santa Rosa Pacifica 127 CA 1 94044 200 07/01/1999   07/01/1999   100 Santa Rosa Ave Suite 5 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           100 SANTA ROSA PACIFICA, CA 94044 (37.633384, -122.491991)
24090 0328775-01-999 Dominguez Marcos The Big Chill 58 Driftwood Cir Pacifica 127 CA 1 94044 200 08/04/1999   08/04/1999   58 Driftwood Cir Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           58 DRIFTWOOD CIR PACIFICA, CA 94044 (37.599703, -122.487221)
24387 0329928-02-001 Timberlake Forrest Inc Calif Convalescent Hospital 2704 California St San Francisco 1 CA 1 94115 4 10/01/1999   01/01/2001   580 Crespi Dr # R Pacifica 34 94044 60 CA     0 0     2 Pacific Heights 16   2704 CALIFORNIA ST San Francisco, CA 94115 (37.788224, -122.43922)
24509 0330437-02-999 Bellinger Stephen J Bellinger Research Services 1020 S Rosita Ct Pacifica 127 CA 1 94044 200 10/05/1999   01/01/2008   1020 S Rosita Ct Pacifica 34 94044 60 CA 5600-5699 16 Administrative and Support Services 16 0 0           1020 S ROSITA CT PACIFICA, CA 94044 (37.584119, -122.495552)
26029 0335712-01-002 Ream Shawn & Ramona Timberwood Tree Service 4032 Irving St San Francisco 1 CA 1 94122 19 04/15/2000   04/02/2005   495 Carmel Ave Pacifica 34 94044 60 CA     0 0     4 10 Sunset/Parkside 14   4032 IRVING ST San Francisco, CA 94122 (37.762496, -122.501328)
26732 0329928-03-001 Timberlake Forrest Inc Sheffield Convalescent Hsptl 1133 S Van Ness Ave San Francisco 1 CA 1 94110 18 10/01/1999   01/01/2001   580 Crespi Dr # R Pacifica 34 94044 60 CA     0 0     9 8 Mission 12   1133 S VAN NESS AVE San Francisco, CA 94110 (37.755024, -122.416517)
27075 0339727-01-999 Bossler David C Db Electric 1024 Banyan Wy Pacifica 127 CA 1 94044 200 09/19/2000   04/01/2010   580 Crespi Drive Suite A6 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1024 BANYAN WY PACIFICA, CA 94044 (37.590955, -122.481581)
27082 0333265-01-999 Caruso Mike J Caruso Construction 323 Genevieve Ave Pacifica 127 CA 1 94044 200 01/21/2000   01/21/2000   323 Genevieve Ave Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           323 GENEVIEVE AVE PACIFICA, CA 94044 (37.609949, -122.478728)
27552 0341488-01-999 Reidy Brothers Constrction Inc Reidy Brothers Constrction Inc 530 Ridgeway Dr Pacifica 127 CA 1 94044 200 01/01/2001   01/01/2001   530 Ridgeway Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           530 RIDGEWAY DR PACIFICA, CA 94044 (37.621413, -122.481788)
28123 0343394-04-001 Abu-Arafeh Anuar I A-Z Market 220 4th St San Francisco 1 CA 1 94103 25 01/01/2001   04/15/2007 11/15/2011 33 Barton Pl Pacifica 34 94044 60 CA 4400-4599 3 Retail Trade 3 0 0     6 3 South of Market 15   220 4TH ST SAN FRANCISCO, CA 94103 (37.783265, -122.402715)
28124 0343394-06-001 Abu-Arafeh Anuar I City Wine & Spirits 805 Howard St San Francisco 1 CA 1 94103 25 01/01/2001   07/15/2011   33 Barton Pl Pacifica 34 94044 60 CA 4400-4599 3 Retail Trade 3 0 0 H03 H31 H73 Multiple 6 3 South of Market 15   805 HOWARD ST San Francisco, CA 94103 (37.78311, -122.402911)
28151 0343497-01-999 Wilson Victor W Wilson Construction 831 Arguello Blvd Pacifica 127 CA 1 94044 200 02/21/2001   02/21/2001   831 Arguello Blvd Pacifica 34 94044 60 CA     0 0           831 ARGUELLO BLVD PACIFICA, CA 94044 (37.591376, -122.495413)
28220 0343801-01-999 Able Window Inc Able Window Inc 580c Crespi Dr Pacifica 127 CA 1 94044 200 01/01/2001   01/01/2001   580 Crespi Dr Ste C Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           580C CRESPI DR PACIFICA, CA 94044 (37.598588, -122.498536)
28684 0345480-02-999 Bradshaw Mathew J Bradshaw Construction 30 Malavear Ct Pacifica 127 CA 1 94044 200 03/14/2011   03/14/2011   30 Malavear Ct Pacifica 34 94044 60 CA     0 0           30 MALAVEAR CT PACIFICA, CA 94044 (37.586322, -122.488344)
28692 0345513-01-999 Cevasco Frank G Frank Cevasco 4 Barton Pl Pacifica 127 CA 1 94044 200 05/01/2001   05/01/2001   4 Barton Pl Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           4 BARTON PL PACIFICA, CA 94044 (37.582725, -122.470418)
29316 0331365-01-001 Richard C, K & L 940 San Jose Ave 940 San Jose San+francisco 8 CA 1 94110 18 10/01/1999   10/01/1999   530 Talbot Avenue Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1           940 SAN JOSE San Francisco, CA 94110 (37.740258, -122.424153)
29382 0348042-02-999 Louthan Robert D Oceana Construction 118 Santa Maria Ave Pacifica 127 CA 1 94044 200 10/15/2003   10/15/2003   118 Santa Maria Avenue Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           118 SANTA MARIA AVE PACIFICA, CA 94044 (37.635271, -122.491583)
29414 0348166-01-001 Andrews Mark R Mark Andrews 2511 26th Ave San Francisco 1 CA 1 94116 23 08/13/2001   08/13/2001   150 Bonita Avenue Pacifica 34 94044 60 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     4 10 Sunset/Parkside 14   2511 26TH AVE San Francisco, CA 94116 (37.740585, -122.483039)
29699 0349276-01-999 Morgan Richard N Morgan Construction 27 Idlewild Ct Pacifica 127 CA 1 94044 200 10/01/2001   10/07/2011   24 Idlewild Ct Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           27 IDLEWILD CT PACIFICA, CA 94044 (37.65341, -122.477042)
29961 0350221-02-999 Dueck Gerry Dueck Construction 491 Copeland St Pacifica 127 CA 1 94044 200 08/19/2002   08/19/2002   491 Copeland St Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           491 COPELAND ST PACIFICA, CA 94044 (37.606153, -122.493446)
30030 0350493-02-999 Rockaway Construction Inc Rockaway Construction Inc 400 Old County Rd 3 Pacifica 127 CA 1 94044 200 10/01/2000   08/25/2008   400 Old County Road #3 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           400 OLD COUNTY RD PACIFICA, CA 94044 (37.610055, -122.494275)
30626 0352345-01-001 Gil Jairo A Natalias Business 2 Geneva Ave 5 San Francisco 1 CA 1 94112 28 01/28/2002   01/28/2002 06/05/2017 439 Heathcliff Dr Pacifica 34 94044 60 CA     0 0     11 Oceanview/Merced/Ingleside 27   2 GENEVA AVE San Francisco, CA 94112 (37.722785, -122.45195)
31012 0353604-02-999 Mccord Jeffrey A Jeff Mccord Construction Co 205 Forest Park Dr Pacifica 127 CA 1 94044 200 08/29/2013   08/29/2013   205 Forest Park Dr Pacifica 34 94044 60 CA     0 0           205 FOREST PARK DR PACIFICA, CA 94044 (37.659365, -122.488561)
31154 0353887-01-001 Humbert Mcdonald Mueller&rico 1391-1395 Hampshire St Apts 1391 Hampshire St San Francisco 1 CA 1 94110 18 01/01/2002   01/01/2002   1259 Alvarado Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   1391 HAMPSHIRE ST San Francisco, CA 94110 (37.750089, -122.407041)
31341 0343394-07-001 Abu-Arafeh Anuar I Az Car & Truck Recondition 803 Howard St San Francisco 1 CA 1 94103 25 01/01/2001   07/15/2012   33 Barton Pl Pacifica 34 94044 60 CA 4400-4599 3 Retail Trade 3 0 0     6 3 South of Market 15   803 HOWARD ST San Francisco, CA 94103 (37.783197, -122.402801)
31346 0354467-02-999 Yee Salai Khin Maung Yes Construction 95 Midvale Dr Daly+city 40 CA 1 94015 67 04/01/2002   06/18/2013 09/08/2016 175 Sunshine Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           95 MIDVALE DR DALY CITY, CA 94015 (37.676864, -122.482928)
31800 0356283-02-001 Simpson Elizabeth F The Finishing Touch & Co 28 Shotwell St San Francisco 1 CA 1 94103 25 05/01/2002   02/25/2013   10 Malavear Ct Pacifica 34 94044 60 CA     0 0     9 8 Mission 12   28 SHOTWELL ST San Francisco, CA 94103 (37.767946, -122.416659)
32282 0357854-01-999 Snead John F A Ok Pest Elimination 431 Imperial Dr Pacifica 127 CA 1 94044 200 08/01/2002   08/01/2002   431 Imperial Dr Pacifica 34 94044 60 CA     0 0           431 IMPERIAL DR PACIFICA, CA 94044 (37.655291, -122.47675)
32399 0358257-01-999 Follner David M 4 F Group 2029 Palmetto Ave Pacifica 127 CA 1 94044 200 08/12/2002   08/12/2002   2029 Palmetto Ave Pacifica 34 94044 60 CA 2300-2399 5600-5699 54 Multiple 13 0 0           2029 PALMETTO AVE PACIFICA, CA 94044 (37.633828, -122.492093)
32620 0359000-01-001 Lembcke Rosanna Rissotto Lembcke Properties 2396 27th Ave San Francisco 1 CA 1 94116 23 09/04/2001   09/04/2001   1081 Everglades Dr Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   2396 27TH AVE San Francisco, CA 94116 (37.742912, -122.484306)
33115 0360609-01-999 Campagna Adamo A Lupo Development & Constructio 3 Gypsy Hill Rd Pacifica 127 CA 1 94044 200 10/25/2002   10/25/2002   Po Box 1009 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           3 GYPSY HILL RD PACIFICA, CA 94044 (37.629573, -122.478036)
33117 0360620-03-001 Lovoi Gina M Gina Lovoi Fitness 731 Bryant St San Francisco 1 CA 1 94107 22 10/25/2002   12/01/2011   484 Heathcliff Drive Pacifica 34 94044 60 CA     0 0     6 3 South of Market 15   731 BRYANT ST San Francisco, CA 94107 (37.777284, -122.400961)
33462 0351699-01-999 Bradford Cynthia B Cindy Bradford Garden Design 580 Ridgeway Drive Pacifica 127 CA 1 94044 200 12/18/2001   12/18/2001   580 Ridgeway Drive Pacifica 34 94044 60 CA     0 0           580 RIDGEWAY DRIVE PACIFICA, CA 94044 (37.621397, -122.480766)
33906 0362989-01-999 Slattery Paul L Paul Slattery Gen Contractor 1146 Mason Dr Pacifica 127 CA 1 94044 200 01/23/2003   01/23/2003   1146 Mason Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1146 MASON DR PACIFICA, CA 94044 (37.597304, -122.478418)
34694 0365087-01-001 Jordan Paul J Paul J Jordan 131 Precita Ave A San Francisco 1 CA 1 94110 18 03/17/2003   01/23/2008   648 Foothill Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0     9 8 Bernal Heights 19   131 PRECITA AVE A San Francisco, CA 94110 (37.747198, -122.417001)
34695 0365087-02-001 Jordan Paul J Htd Painting 131 Precita Ave A San Francisco 1 CA 1 94110 18 03/17/2003   04/28/2009   648 Foothill Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0     9 8 Bernal Heights 19   131 PRECITA AVE A San Francisco, CA 94110 (37.747198, -122.417001)
34801 0365423-01-999 Jackson Ian B Jackson Pacific Builders 232 Arroyo Dr Pacifica 127 CA 1 94044 200 04/03/2003   04/03/2003   232 Arroyo Drive Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           232 ARROYO DR PACIFICA, CA 94044 (37.646237, -122.488173)
34852 0365582-01-999 Freutel Sr Michael R Freutel Roofing 8 Desvio Ct Pacifica 127 CA 1 94044 200 04/09/2003   04/09/2003   Po Box #821 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids       8 DESVIO CT PACIFICA, CA 94044 (37.584349, -122.48451)
35061 0366063-02-999 Lee Kyung K Atgym Co 862 Skyridge Dr Pacifica 127 CA 1 94044 200 04/24/2003   02/01/2005   862 Skyridge Dr Pacifica 34 94044 60 CA 4200-4299 7 Wholesale Trade 7 0 0           862 SKYRIDGE DR PACIFICA, CA 94044 (37.639107, -122.46798)
35064 0366077-01-999 Green Paul T Green Construction 104 Lorry Ln Pacifica 127 CA 1 94044 200 04/25/2003   04/25/2003   104 Lorry Ln Pacifica 34 94044 60 CA     0 0           104 LORRY LN PACIFICA, CA 94044 (37.648273, -122.476668)
35198 0366427-02-999 Cruz Alfredo B Franmore Electric 1116 Crespi Dr Pacifica 127 CA 1 94044 200 05/07/2003   09/09/2004   1116 Crespi Dr Pacifica 34 94044 60 CA     0 0           1116 CRESPI DR PACIFICA, CA 94044 (37.590469, -122.488727)
35364 0366893-02-999 Barry M Nadell Const Inc Barry M Nadell Const Inc 520 San Pedro Ave Pacifica 127 CA 1 94044 200 05/14/2003   05/15/2003   520 San Pedro Ave Suite #1 Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           520 SAN PEDRO AVE PACIFICA, CA 94044 (37.593787, -122.507225)
35387 0366935-01-001 Lewis Chris W Lewis Appliance 50 Arnold Ave San Francisco 1 CA 1 94110 18 12/31/2003   12/31/2003   162 Reina Del Mar Pacifica 34 94044 60 CA     0 0     9 8 Bernal Heights 19   50 ARNOLD AVE San Francisco, CA 94110 (37.734341, -122.419679)
35516 0367476-02-001 Tran Loc Loc Tran 440 Fullerton St Pacifica 127 CA 1 94044 200 05/21/2013   05/21/2013   440 Fullerton St Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0           440 FULLERTON ST PACIFICA, CA 94044 (37.633948, -122.485114)
35520 0367476-03-001 Tran Loc Import Connection Motorsport 701 Bacon St San Francisco 1 CA 1 94134 26 05/21/2013   05/21/2013 05/22/2013 440 Fullerton St Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0     9 8 Portola 18   701 BACON ST San Francisco, CA 94134 (37.726048, -122.409646)
36193 1114921-09-161 Stephen Wilcox Ii Stephen Sf Inc 258 Imperial Dr Apt 5 Pacifica 127 CA 1 94044 200 02/13/2016   02/13/2016   258 Imperial Dr 5 Apt Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
37127 0372306-01-999 Pellandini John K Pellandini & Co 623 Beaumont Blvd Pacifica 127 CA 1 94044 200 11/26/2003   11/26/2003   623 Beaumont Blvd Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           623 BEAUMONT BLVD PACIFICA, CA 94044 (37.651556, -122.483855)
37131 0372306-02-001 Pellandini John K Pellandini And Company 2000 Mckinnon Ave San Francisco 1 CA 1 94124 8 11/26/2003   11/26/2003   623 Beaumont Blvd Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           2000 MCKINNON AVE San Francisco, CA 94124 (37.740159, -122.396834)
37180 0372445-01-001 Celtic Moving And Storage Inc Celtic Moving And Storage Inc 1480 Donner St San+francisco 8 CA 1 94124 8 01/01/2001   01/01/2001   303 Cutty Ct Pacifica 34 94044 60 CA 4800-4999 12 Transportation and Warehousing 12 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids       1480 DONNER ST San Francisco, CA 94124
37355 0373012-05-999 Edwards Paul J Exterior Remodeling Specialist 1030 Yosemite Dr Pacifica 127 CA 1 94044 200 07/08/2013   07/08/2013   1030 Yosemite Dr Pacifica 34 94044 60 CA 2300-2399 6 Construction 6 0 0           1030 YOSEMITE DR PACIFICA, CA 94044 (37.587444, -122.470553)
37873 0374467-02-001 Karo Timothy J Sf Bay Tvs Counseling 1700 Irving St San Francisco 1 CA 1 94122 19 02/19/2004   02/19/2004   1026 Big Bend Dr Pacifica 34 94044 60 CA 6100-6299 4 Private Education and Health Services 4 0 0     4 10 Inner Sunset 13   1700 IRVING ST San Francisco, CA 94122 (37.76366, -122.475167)
37874 0374467-03-001 Karo Timothy J Sf Bay Traffic Violator School 1700 Irving St San Francisco 1 CA 1 94122 19 02/19/2004   03/01/2005   1026 Big Bend Dr Pacifica 34 94044 60 CA 6100-6299 4 Private Education and Health Services 4 0 0     4 10 Inner Sunset 13   1700 IRVING ST San Francisco, CA 94122 (37.76366, -122.475167)
37963 0374649-01-001 Yee Group Llc The Yee Group Llc The 1401 Mason St San Francisco 1 CA 1 94133 11 02/25/2004   02/25/2004   1216 Crespi Dr. Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1401 MASON ST San Francisco, CA 94133 (37.79645, -122.411757)

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