home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

1,259 rows where City = 38

View and edit SQL

Suggested facets: State, Source Zipcode, Mail State, NAICS Code, NAICS Code Description, Transient Occupancy Tax, LIC Code, LIC Code Description

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
875 0000707-01-999 Allan Auto Sprinkler Corp Allan Auto Sprinkler Corp 20303 Mack St Hayward Hayward 38 CA 1 94545 64 10/01/1968   10/01/1968   20303 Mack St Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           20303 MACK ST HAYWARD HAYWARD, CA 94545 (37.654301, -122.13198)
1440 0359481-03-999 Olszewski Jerzy Jerry Olszewski General Contr 1150 W. Winton Ave 122 Hayward 38 CA 1 94545 64 04/12/2012 04/22/2015 07/03/2013 04/22/2015             0 0           1150 W WINTON AVE HAYWARD, CA 94545 (37.653025, -122.112557)
1676 0029049-02-999 Tully Wihr Co Tully Wihr Company 1672 Delta Ct Hayward 38 CA 1 94544 90 11/16/1999   11/16/1999   Po Box 1780 Colfax 121 95713 182 CA     0 0           1672 DELTA CT HAYWARD, CA 94544 (37.613801, -122.062951)
1916 0382177-02-999 Landaverde Wilfredo W L Electric 404 Ranker Pl Hayward 38 CA 1 94544 90 06/18/2011   06/18/2011   404 Ranker Place Hayward 82 94544 199 CA 2300-2399 6 Construction 6 0 0           404 RANKER PL HAYWARD, CA 94544 (37.640093, -122.073607)
2400 0399030-02-999 Grundfos Cbs Inc Paco Pumps 25568 Seaboard Ln Hayward 38 CA 1 94545 64 03/01/2006   04/01/2007   25568 Seaboard Ln Hayward 82 94545 123 CA     0 0           25568 SEABOARD LN HAYWARD, CA 94545 (37.634063, -122.124808)
2599 0406639-01-999 Casperian Barnaby Casperian Barnaby 427 Ginger Ave Hayward 38 CA 1 94541 109 01/01/2007   01/01/2007   427 Ginger Ave Hayward 82 94541 244 CA     0 0           427 GINGER AVE HAYWARD, CA 94541 (37.67477, -122.120247)
2640 0003683-01-999 Bradley E B Co Inc Bradley E B Co Inc 26250 Corporate Dr B & C Hayward 38 CA 1 94545 64 01/01/1980   01/01/1980   Po Box 58548 Vernon 167 90058 247 CA 4200-4299 7 Wholesale Trade 7 0 0           26250 CORPORATE DR B & C HAYWARD, CA 94545 (37.629198, -122.114695)
2666 0409284-02-999 Logwood Kenneth A Kenneth A Logwood 28560 Etta Ave Hayward 38 CA 1 94544 90 01/01/2007   11/01/2012   Po Box 20471 Oakland 27 94620 249 CA     0 0           28560 ETTA AVE HAYWARD, CA 94544 (37.62856, -122.066445)
2838 0062861-01-999 The Pressure Group Co Pressure Grout Co 1975 National Ave Hayward 38 CA 1 94545 64 11/08/1996   11/08/1996   1975 National Ave Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           1975 NATIONAL AVE HAYWARD, CA 94545 (37.649613, -122.12492)
3156 0129909-02-999 Cell-Crete Corp Cell-Crete Corporation 995 Zephyr Ave Hayward 38 CA 1 94544 90 01/01/1980   04/02/2003   995 Zephyr Ave Hayward 82 94544 199 CA 2300-2399 6 Construction 6 0 0           995 ZEPHYR AVE HAYWARD, CA 94544 (37.611445, -122.04568)
3379 0089446-01-999 Arrow Acoustics Inc Arrow Acoustics Inc 23773 Foley St Hayward 38 CA 1 94545 64 03/01/1975   03/01/1975   23773 Foley St Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           23773 FOLEY ST HAYWARD, CA 94545 (37.639516, -122.131348)
3562 0130386-01-999 Danco Waterproofing Corp Danco Waterproofing Corp 3142 Diablo Ave Hayward 38 CA 1 94545 64 01/01/1979   01/01/1979   Po Box P.o. Box 1840 Pleasanton 202 94556 300 CA 2300-2399 6 Construction 6 0 0           3142 DIABLO AVE HAYWARD, CA 94545 (37.635728, -122.122426)
3869 0145444-01-999 Tele-Dynamic Communication In Teledynamic Communications 3501 Breakwater Ave Hayward 38 CA 1 94545 64 03/14/1984   03/08/1999   26010 Eden Landing Rd Ste 1d Hayward 82 94545 123 CA     0 0           3501 BREAKWATER AVE HAYWARD, CA 94545 (37.62947, -122.12106)
4018 0098823-03-999 Automatic Control Enginr Corp Automatic Controls Enginr Corp 20788 Corsair Blvd Hayward 38 CA 1 94545 64 04/12/1999   04/12/1999   20788 Corsair Blvd Hayward 82 94545 123 CA     0 0           20788 CORSAIR BLVD HAYWARD, CA 94545 (37.657583, -122.126106)
4927 0063991-02-999 Anning Johnson Company Anning Johnson Company 22955 Kidder St Hayward 38 CA 1 94545 64 05/26/2011   05/26/2011   1959 Anson Dr Melrose Park 263 60160 378 IL 2300-2399 6 Construction 6 0 0           22955 KIDDER ST HAYWARD, CA 94545 (37.644309, -122.134336)
4953 0465008-01-999 Sharps Solutions Llc Sharps Solutions 3563 Investment Blvd 6 Hayward 38 CA 1 94545 64 12/12/2011   12/12/2011   3563 Investment Bl #6 Hayward 82 94545 123 CA     0 0           3563 INVESTMENT BLVD HAYWARD, CA 94545 (37.624501, -122.122215)
5200 0468629-01-999 Lowe Gregory I Le Petit Bateau 2277 National Ave Hayward 38 CA 1 94545 64 06/09/2012   06/09/2012   670 Dunn Cir Sparks 234 89431 395 NV     0 0           2277 NATIONAL AVE HAYWARD, CA 94545 (37.649345, -122.128006)
5330 0321708-02-999 Il Mechanical Inc Il Mechanical Inc 28306 Industrial Blvd J Hayward 38 CA 1 94545 64 11/23/1998   09/21/2013   28306 Industrial Blvd #J Hayward 82 94545 123 CA     0 0           28306 INDUSTRIAL BLVD J HAYWARD, CA 94545 (37.617883, -122.094875)
6449 0488231-01-999 Ssjcg Engineering Enterprises Ssjcg Engineering Enterprises 25060 Monte Vista Dr Hayward 38 CA 1 94545 64 03/21/2014   03/21/2014   234 Weeping Willow Ct Brentwood 44 94513 71 CA     0 0           25060 MONTE VISTA DR HAYWARD, CA 94545 (37.640985, -122.113988)
6738 0022252-01-999 Bottling Group,llc Pepsi Bottling Group 29000 Hesperian Blvd Hayward 38 CA 1 94545 64 01/23/2005   04/17/2009   29000 Hesperian Blvd Hayward 82 94545 123 CA 3100-3399 4200-4299 4800-4999 50 Multiple 13 0 0           29000 HESPERIAN BLVD HAYWARD, CA 94545 (37.611299, -122.084608)
6822 0122407-02-999 Millbrae Glass Ltd Capitol Glass Co 2112 American Ave Hayward 38 CA 1 94545 64 01/06/2006   01/06/2006   2112 American Avenue Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           2112 AMERICAN AVE HAYWARD, CA 94545 (37.646411, -122.121718)
7685 1010509-10-141 Accurate Firestop Inc Accurate Firestop Inc 25613 Dollar St #7 Hayward 38 CA 1 94544 90 05/01/2014   05/01/2014   25613 Dollar St #7 Hayward 82 94544 199 CA 2300-2399 6 Construction 6 0 0           25613 DOLLAR ST HAYWARD, CA 94544 (37.653909, -122.071164)
8067 1019044-02-151 Dones Jimmy A+ Electrical Services 1710 Canterbury Ln Hayward 38 CA 1 94544 90 02/13/2015 07/08/2015 02/13/2015 07/08/2015             0 0           1710 CANTERBURY LN HAYWARD, CA 94544 (37.620237, -122.068239)
8362 1025296-04-151 Severn Safety Supply Llc Severn Safety Supply Llc 2008 National Ave Hayward 38 CA 1 94545 64 08/21/2013 10/30/2014 04/01/2015 10/30/2014             0 0           2008 NATIONAL AVE HAYWARD, CA 94545 (37.649606, -122.12592)
8706 1030281-06-151 Gymdoc Inc Gym Doctors 3488 Arden Rd Hayward 38 CA 1 94545 64 03/15/2010   09/02/2014   3488 Arden Rd Hayward 82 94545 123 CA     0 0           3488 ARDEN RD HAYWARD, CA 94545 (37.621066, -122.110656)
9297 1096006-08-161 Uber Uber 820 A St Apt 83 Hayward 38 CA 1 94541 109 10/15/2015   10/15/2015   820 W A St 83 Apt Hayward 82 94541 244 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9599 1109317-08-161 Jerome Encabo Antoys 2417 Cobblestone Dr. Hayward 38 CA 1 94542 318 08/26/2015 08/26/2015 08/31/2016 08/26/2015         4800-4999 12 Transportation and Warehousing 12 0 0            
9749 1112696-08-161 Anali Munoz Doing Business As A Lyft Driver 2659 Ocala St Hayward 38 CA 1 94545 64 03/03/2016   03/03/2016   2659 Ocala St Hayward 82 94545 123 CA     0 0            
9780 1110386-08-161 Stephanie Chapman Stephanie Chapman 636 Dean St Hayward 38 CA 1 94541 109 08/01/2016   08/01/2016   636 Dean St Hayward 82 94541 244 CA     0 0            
9811 1091280-08-161 Dibesh Joshi Dibesh 910 Central Blvd Hayward 38 CA 1 94542 318 08/01/2016   08/01/2016   910 Central Blvd Hayward 82 94542 597 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9889 1124010-10-161 Ottoniel Rodriguez-Batres Ottoniel 18011 Incline Pl Hayward 38 CA 1 94541 109 10/14/2016   10/14/2016   18011 Incline Pl Hayward 82 94541 244 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9989 0060325-01-999 Gallo Sales Co Gallo Sales Co 30825 Wiegman Rd Hayward 38 CA 1 94544 90 10/01/1970   10/01/1970   Po Box 1266 Union City 352 94587 537 CA 4200-4299 7 Wholesale Trade 7 0 0           30825 WIEGMAN RD HAYWARD, CA 94544 (37.611663, -122.061272)
10146 0152554-01-999 Quad Express Printing Inc Quad Express Printing Inc 3324 Investment Blvd Hayward 38 CA 1 94545 64 09/16/1985   01/01/2011   3324 Investment Blvd Hayward 82 94545 123 CA 3100-3399 10 Manufacturing 10 0 0           3324 INVESTMENT BLVD HAYWARD, CA 94545 (37.627086, -122.116073)
12166 0168147-02-999 Riomet Inc Metropolitan Interiors 2314 Tripaldi Way Hayward 38 CA 1 94545 64 12/07/2001   12/07/2001   2314 Tripaldi Way Hayward 82 94545 123 CA 4200-4299 7 Wholesale Trade 7 0 0           2314 TRIPALDI WAY HAYWARD, CA 94545 (37.614494, -122.082849)
12371 0169515-03-999 Golden Bay Construction Inc Golden Bay Construction Inc 3826 Depot Rd Hayward 38 CA 1 94545 64 01/24/2014 05/07/2014 01/24/2014 05/07/2014         2300-2399 6 Construction 6 0 0           3826 DEPOT RD HAYWARD, CA 94545 (37.637945, -122.13354)
12724 0043636-39-999 Pacific Bell Telephone Company Pac Bell 1129 B St Hayward 38 CA 1 94541 109 10/01/1968   01/01/2010   1010 Pine St. Rm. 7e B 02 St Louis 67 63101 294 MO 5100-5199 15 Information 15 0 0           1129 B ST HAYWARD, CA 94541 (37.674481, -122.080395)
13180 0182300-02-999 Turf Star Inc Turf Star Inc 2438 Radley Ct Hayward 38 CA 1 94545 64 11/10/1988   11/01/2000   2438 Radley Ct Hayward 82 94545 123 CA 4200-4299 7 Wholesale Trade 7 0 0           2438 RADLEY CT HAYWARD, CA 94545 (37.647798, -122.13946)
13379 0183443-02-999 Ca Mechanical Inc Ca Mechanical Inc 2227 American Ave Hayward 38 CA 1 94545 64 10/01/1996   10/01/1996   2227 American Ave Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           2227 AMERICAN AVE HAYWARD, CA 94545 (37.646373, -122.123334)
13660 0185094-01-999 Inland Industrial No Inc Inland Industrial Tire No Inc 30900 San Antonio St Hayward 38 CA 1 94544 90 01/01/1989   01/01/1989   30900 San Antonio St Hayward 82 94544 199 CA     0 0           30900 SAN ANTONIO ST HAYWARD, CA 94544 (37.614636, -122.048352)
14014 0187173-01-999 Vista Universal Inc Vista Universal Inc 2430 American Ave Hayward 38 CA 1 94545 64 01/01/1989   01/01/1989   2430 American Ave Hayward 82 94545 123 CA     0 0           2430 AMERICAN AVE HAYWARD, CA 94545 (37.646726, -122.126989)
14142 0170924-01-999 Neopost Inc Neopost Inc. 30955 Huntwood Ave Hayward 38 CA 1 94544 90 05/09/1988   05/09/1988   478 Wheelers Farms Rd Milford 443 06461 705 CT 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           30955 HUNTWOOD AVE HAYWARD, CA 94544 (37.614105, -122.054801)
14819 0191408-01-999 Bay City Boiler & Eng Co Inc Bay City Boiler & Eng Co Inc 23312 Cabot Blvdhaywardca Hayward 38 CA 1 94545 64 09/12/1989   09/12/1989   23312 Cabot Blvd Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           23312 CABOT BLVDHAYWARDCA HAYWARD, CA 94545 (37.641059, -122.135361)
15099 0193955-02-999 American Asphalt Repair Etc American Asphalt Repair Etc 24200 Clawiter Rd Hayward 38 CA 1 94545 64 01/01/1989   05/01/2008   24200 Clawiter Rd Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           24200 CLAWITER RD HAYWARD, CA 94545 (37.643819, -122.119937)
15597 0196894-02-999 Golden Bear Fire Protect'n Inc Golden Bear Fire Protection 23315 Connecticut St Hayward 38 CA 1 94545 64 04/01/2012   04/01/2012   Po Box 4731 Hayward 82 94540 401 CA 2300-2399 6 Construction 6 0 0           23315 CONNECTICUT ST HAYWARD, CA 94545 (37.642457, -122.129413)
16249 0129777-01-999 Malcolm Drilling Co Inc Malcolm Drilling Co Inc 3503 Breakwater Court Hayward 38 CA 1 94545 64 01/01/1980   01/01/1980   92 Natoma Street Suite 400 San Francisco 1 94105 5 CA 2300-2399 6 Construction 6 0 0           3503 BREAKWATER COURT HAYWARD, CA 94545 (37.629959, -122.122167)
16315 0202412-02-999 Crown Equipment Corporation Crown Lift Trucks 1400 Crocker Ave Hayward 38 CA 1 94544 90 12/11/2001   12/11/2001   44 So Washington St New Bremen 543 45869 873 OH 3100-3399 4400-4599 5300-5399 8100-8139 87 Multiple 13 0 0           1400 CROCKER AVE HAYWARD, CA 94544 (37.616902, -122.054912)
16504 0203718-01-999 Palm John E Western Pacific Distrib Inc 2368 W Winton Ave Hayward Hayward 38 CA 1 94545 64 01/01/1991 06/30/2016 01/01/1991 06/30/2016         4200-4299 7 Wholesale Trade 7 0 0           2368 W WINTON AVE HAYWARD HAYWARD, CA 94545 (37.652752, -122.137288)
16642 0204962-01-999 Res Com Insulation Inc Res Com Insulation Inc 3474 Investment Bl Hayward 38 CA 1 94545 64 01/01/1991 12/31/2016 01/01/1991 12/31/2016         2300-2399 6 Construction 6 0 0           3474 INVESTMENT BL HAYWARD, CA 94545 (37.625856, -122.118504)
16645 0204984-02-999 Roche Charlotte C Bay Area Court Reporters 22320 Foothill Blvd 210 Hayward 38 CA 1 94541 109 01/01/1991   09/20/2012   22320 Foothill Blvd #210 Hayward 82 94541 244 CA 5400-5499 5600-5699 69 Multiple 13 0 0           22320 FOOTHILL BLVD HAYWARD, CA 94541 (37.678172, -122.083695)
16803 0180681-03-999 Rago Neon Llc. Rago Neon 235 Laurel Avenue Hayward 38 CA 1 94541 109 10/31/1996   10/31/1996   235 Laurel Ave Hayward 82 94541 244 CA 3100-3399 10 Multiple 13 0 0           235 LAUREL AVENUE HAYWARD, CA 94541 (37.670279, -122.09942)
17404 0150385-01-999 Dominski Anthony J West Edge-West Edge Design 25064 Viking St Hayward 38 CA 1 94545 64 03/27/1985   04/01/2007   25064 Viking Street Hayward 82 94545 123 CA     0 0           25064 VIKING ST HAYWARD, CA 94545 (37.63656, -122.124908)
17651 0186202-02-999 Bryant J H Jr Inc J H Bryant Jr Inc 19809 Cabot Blvd Hayward 38 CA 1 94545 64 11/14/2013   11/14/2013   19809 Cabot Bl Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           19809 CABOT BLVD HAYWARD, CA 94545 (37.654079, -122.138732)
17791 0302050-03-999 Bermudez Liliana P Eclipse Galleria 26953 Mission Bl B413 Hayward 38 CA 1 94544 90 01/01/1997   05/17/2010   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           26953 MISSION HAYWARD, CA 94544 (37.645489, -122.062547)
17954 0188346-01-999 Bigham Stephen E Bigham Taylor Rfg 22721 Alice St Hayward 38 CA 1 94541 109 05/01/1989 05/01/1989 05/01/1989 05/01/1989             0 0           22721 ALICE ST HAYWARD, CA 94541 (37.667769, -122.090318)
18436 0195686-03-999 Hayward Electric Company Hayward Electric Company 3150 Diablo Ave Hayward 38 CA 1 94545 64 03/01/2014   03/01/2014   3150 Diablo Ave Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           3150 DIABLO AVE HAYWARD, CA 94545 (37.635728, -122.122851)
18954 0306542-01-999 Rjms Corporation Toyota Material Handling N Ca 31010 San Antonio Rd Hayward Hayward 38 CA 1 94544 90 04/02/1997   04/02/1997   6999 Southfront Rd Livermore 63 94551 155 CA     0 0           31010 SAN ANTONIO RD HAYWARD HAYWARD, CA 94544 (37.610965, -122.048359)
19760 0310406-01-999 Pacific Tile & Marble Inc Pacific Tile & Marble Inc 24167 Clawiter Rd Hayward 38 CA 1 94545 64 10/08/1997   10/08/1997   24167 Clawiter Rd Rd Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           24167 CLAWITER RD HAYWARD, CA 94545 (37.64464, -122.119967)
19902 0310968-02-999 Hsq Technology, A Corporation Hsq Technology, A Corporation 26227 Research Rd Hayward 38 CA 1 94545 64 10/01/1997   10/01/2002   26227 Research Road Hayward 82 94545 123 CA     0 0           26227 RESEARCH RD HAYWARD, CA 94545 (37.623964, -122.126656)
20107 0312099-01-999 Har Bro Of Northern Calif Har Bro Of Northern Calif 26067 Bernhardt St Hayward 38 CA 1 94545 64 12/15/1997   12/15/1997   2750 Signal Parkway Signal Hill 303 90755 448 CA 2300-2399 6 Construction 6 0 0           26067 BERNHARDT ST HAYWARD, CA 94545
20348 0312976-02-999 Rocha Marcos S Rocha Electrical & Services 249 W Jackson St 249 Hayward 38 CA 1 94544 90 11/20/2000   11/20/2000   249 W Jackson St #249 Hayward 82 94544 199 CA 2300-2399 6 Construction 6 0 0           249 W JACKSON ST HAYWARD, CA 94544 (37.651505, -122.090411)
20569 0301721-01-999 Alameda Newspaper Group San Mateo County Times 116 W Winton Ave Hayward 38 CA 1 94540 558 01/01/1997   01/01/1997   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           116 W WINTON AVE HAYWARD, CA 94540 (37.659275, -122.093845)
20743 0314531-01-999 H & L International Inc H & L International 3130 Diablo Ave Hayward 38 CA 1 94545 64 03/09/1998   03/09/1998   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           3130 DIABLO AVE HAYWARD, CA 94545 (37.63573, -122.121889)
20822 0314726-01-999 Dapper Tire Co Inc Dapper Tire Co Inc 20380 Corsair Blvd Hayward 38 CA 1 94545 64 01/01/1998   01/01/1998   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           20380 CORSAIR BLVD HAYWARD, CA 94545 (37.66055, -122.132499)
21660 0318767-01-999 Marelich Mechanical Co Inc Marelich Mechanical Co Inc 24041 Amador St Hayward Hayward 38 CA 1 94544 90 07/01/1998   07/01/1998   24041 Amador St Hayward 82 94544 199 CA 2300-2399 6 Construction 6 0 0           24041 AMADOR ST HAYWARD HAYWARD, CA 94544 (37.660677, -122.095091)
22406 0321708-01-999 Il Mechanical Inc Il Mechanical Inc 28306 Industrial Blvd J Hayward 38 CA 1 94545 64 11/23/1998   11/23/1998   28306 Industrial Blvd #J Hayward 82 94545 123 CA     0 0           28306 INDUSTRIAL BLVD J HAYWARD, CA 94545 (37.617883, -122.094875)
22415 0321760-02-999 Vaden Industries Inc Vaden Industries Inc 2479 Industrial Pkwy West O Hayward 38 CA 1 94545 64 05/06/2002 06/30/2016 05/06/2002 06/30/2016             0 0           2479 INDUSTRIAL PKWY WEST O HAYWARD, CA 94545 (37.617908, -122.085194)
22523 0322098-09-999 Siemens Industry Inc Siemens Industry Inc 25821 Industrial Bl Hayward 38 CA 1 94545 64 01/01/1999   01/02/2012   Po Box 80600 Indianapolis 105 46280 248 IN 2300-2399 6 Construction 6 0 0           25821 INDUSTRIAL BL HAYWARD, CA 94545 (37.634096, -122.111629)
22863 0323398-01-999 Perez Ismael/perez Emiliano Xlr8 Services 28312 Industrial Blvd H Hayward 38 CA 1 94545 64 10/01/1998   10/01/1998 09/29/2017 22568 Mission Blvd 425 Ste Hayward 82 94541 244 CA 2300-2399 6 Construction 6 0 0           28312 INDUSTRIAL BLVD H HAYWARD, CA 94545 (37.617847, -122.094812)
22998 0197394-03-999 Bel Aire Engineering Inc Belaire Engineering Inc 22740 Alice St Hayward 38 CA 1 94541 109 09/10/2013   09/10/2013   22740 Alice St Hayward 82 94541 244 CA     0 0           22740 ALICE ST HAYWARD, CA 94541 (37.667407, -122.090081)
23475 0325926-01-999 Ahmadzai Rahima Lpt Service 25800 Industrial Blvd Q1122 Hayward 38 CA 1 94545 64 04/20/1999   04/20/1999   Po Box 3602 Hayward 82 94540 401 CA     0 0           25800 INDUSTRIAL BLVD HAYWARD, CA 94545 (37.634975, -122.11305)
23626 0326739-03-999 Campanella Corporation Campanella Corporation 2216 Dunn Rd Hayward 38 CA 1 94545 64 10/19/2009   10/19/2009   2216 Dunn Rd Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           2216 DUNN RD HAYWARD, CA 94545 (37.644985, -122.122397)
23946 0304527-01-999 Li Tony Xd T L Electrical Co 27479 Ponderosa Ct Hayward 38 CA 1 94545 64 11/03/2006 06/04/2015 11/03/2006 06/04/2015             0 0           27479 PONDEROSA CT HAYWARD, CA 94545 (37.627485, -122.096119)
23984 0328316-01-999 R Q Electric Inc R Q Electric Inc 1248 A Street Hayward 38 CA 1 94541 109 03/06/2002   03/06/2002   3056 Castro Valley Blvd Castro Valley 92 94546 138 CA     0 0           1248 A STREET HAYWARD, CA 94541 (37.67693, -122.079561)
24434 0330125-03-999 Corporate Interior Solutions Corporate Interior Solutions 25546 Seaboard Lane Hayward 38 CA 1 94545 64 12/25/2003   01/01/2006   25546 Seaboard Lane Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           25546 SEABOARD LANE HAYWARD, CA 94545 (37.634347, -122.124805)
24577 0330676-01-999 Northern Cal Paper Recyclers Northern Cal Paper Recyclers 1609 Whipple Rd Hayward 38 CA 1 94544 90 06/01/1998   06/01/1998 01/07/2016 3544 Arden Rd Hayward 82 94545 123 CA     0 0           1609 WHIPPLE RD HAYWARD, CA 94544 (37.606014, -122.04665)
25095 0332424-03-999 Russ Will Mechanical Inc Russ Will Mechanical Inc 20684 Corsair Blvd Hayward 38 CA 1 94545 64 02/28/2011 08/31/2015 02/28/2011 09/01/2014         2300-2399 6 Construction 6 0 0           20684 CORSAIR BLVD HAYWARD, CA 94545 (37.657927, -122.127104)
25214 0332903-02-999 Li Jun Ljsfh Company 1004 Clubhouse Dr Hayward 38 CA 1 94541 109 12/07/2001   02/23/2005   118 Halsey Court Ct Hercules 222 94547 324 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1004 CLUBHOUSE DR HAYWARD, CA 94541 (37.668011, -122.124527)
25261 0333084-01-999 Hi-Tech Electric Llc Hi-Tech Electric Llc 2230 W Winton Ave Hayward 38 CA 1 94545 64 01/14/2000   01/14/2000   24209 Clawiter Rd Hayward 82 94545 123 CA     0 0           2230 W WINTON AVE HAYWARD, CA 94545 (37.652791, -122.135387)
25313 0333253-02-999 Waller George D Energy Management Technologies 2308 Tripaldi Way Hayward 38 CA 1 94545 64 01/21/2000   01/01/2004 01/01/2014 873 Nw Waterlily Jensen Beach 696 34957 1140 FL 2300-2399 6 Construction 6 0 0           2308 TRIPALDI WAY HAYWARD, CA 94545 (37.614496, -122.082908)
25543 0334111-04-999 Ferguson Enterprises Inc Air Cold Supply 26999 Industrial Blvd Hayward 38 CA 1 94545 64 01/01/2001   05/01/2013   Po Box 2778 Newport News 702 23609 1147 VA 4200-4299 7 Wholesale Trade 7 0 0           26999 INDUSTRIAL BLVD HAYWARD, CA 94545 (37.629338, -122.109023)
25674 0325135-01-999 Signet Testing Labs Inc Signet Testing Labs Inc 3121 Diablo Ave Hayward 38 CA 1 94545 64 03/30/1998   03/30/1998   Po Box 201088 Tax Department Austin 253 78720 1151 TX     0 0           3121 DIABLO AVE HAYWARD, CA 94545 (37.635735, -122.121392)
25701 0334490-01-999 Amer Blinds & Draperies Inc American Blinds & Draperies 1168 San Luis Obispo Ave Hayward 38 CA 1 94544 90 02/05/1999   02/05/1999   30776 Huntwood Ave Hayward 82 94544 199 CA     0 0           1168 SAN LUIS OBISPO AVE HAYWARD, CA 94544 (37.607913, -122.049786)
25747 0334683-03-999 American Technologies Inc American Technologies Inc 25000 Industrial Blvd Hayward 38 CA 1 94545 64 03/06/2000   06/01/2012   210 Baywood Ave Orange 408 92865 1154 CA 2300-2399 6 Construction 6 0 0           25000 INDUSTRIAL BLVD HAYWARD, CA 94545 (37.637565, -122.115977)
25821 0334916-01-999 Ophthalmic Instruments Inc Opthalmic Instruments Inc 26062 Eden Landing 8 Hayward 38 CA 1 94545 64 03/13/2000   03/13/2000 10/01/2004 1 Musick Irvine 112 92618 167 CA 4400-4599 3 Retail Trade 3 0 0           26062 EDEN LANDING HAYWARD, CA 94545 (37.627045, -122.12093)
26823 0338792-04-999 Mission Valley Electric Inc Mission Valley Electric Inc 22520 3rd St 307 Hayward 38 CA 1 94541 109 07/25/2013 03/10/2015 07/25/2013 03/10/2015             0 0           22520 3RD ST HAYWARD, CA 94541 (37.677489, -122.078635)
26873 0316103-02-999 Mesa Energy Systems Inc Emcor Services Mesa 24051 Amador St Hayward 38 CA 1 94544 90 02/01/1998   11/01/2008   2 Cromwell Irvine 112 92618 167 CA     0 0           24051 AMADOR ST HAYWARD, CA 94544 (37.660421, -122.094961)
27070 0339705-02-999 Chase Contracting Quality Air Services Inc. 29229 Pacific Street Hayward 38 CA 1 94544 90 09/21/2000   01/06/2004 12/31/2012 14551 Griffith St San Leandro 25 94577 49 CA     0 0           29229 PACIFIC STREET HAYWARD, CA 94544 (37.629679, -122.055764)
27093 0322736-02-999 Alameda Electrical Dist Inc Alameda Electrical Dist Inc 3875 Bay Center Pl Hayward 38 CA 1 94545 64 09/07/2013   09/07/2013   3875 Bay Center Place Hayward 82 94545 123 CA 4200-4299 7 Wholesale Trade 7 0 0           3875 BAY CENTER PL HAYWARD, CA 94545 (37.627708, -122.127573)
28639 0345259-01-999 A & B Mechanical Inc A & B Mechanical Inc 24179 Park St Hayward 38 CA 1 94544 90 04/18/2001   04/18/2001   24179 Park St Hayward 82 94544 199 CA     0 0           24179 PARK ST HAYWARD, CA 94544 (37.661587, -122.086416)
28933 0346473-01-999 Segale Bros Wood Products Inc Segale Bros Wood Products Inc 1705 Sabre St Hayward 38 CA 1 94545 64 01/01/2001   01/01/2001   1705 Sabre St Hayward 82 94545 123 CA 3100-3399 10 Manufacturing 10 0 0           1705 SABRE ST HAYWARD, CA 94545 (37.656477, -122.12727)
29349 0347934-01-999 Axis Construction Inc Axis Construction Inc 2566 Barrington Ct Hayward 38 CA 1 94545 64 08/03/2001   08/03/2001   2566 Barrington Ct Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           2566 BARRINGTON CT HAYWARD, CA 94545 (37.655328, -122.141653)
29391 1095040-08-161 Angela Martin Angela Martin 21690 Marydee Court Hayward 38 CA 1 94541 109 08/25/2016   08/25/2016   21690 Marydee Court Hayward 82 94541 244 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
29405 0326185-01-999 Sound On Stage Inc Sound On Stage Inc 3182 Diablo Ave Hayward 38 CA 1 94545 64 04/01/1999   04/01/1999   3182 Diablo Ave Hayward 82 94545 123 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           3182 DIABLO AVE HAYWARD, CA 94545 (37.635728, -122.123907)
30442 0351760-02-999 Fred E Turner Co Fred E Turner Co 3362 Arden Rd Hayward 38 CA 1 94545 64 05/01/2004   08/03/2009   19825 Cabot Blvd Hayward 82 94545 123 CA 4200-4299 7 Wholesale Trade 7 0 0           3362 ARDEN RD HAYWARD, CA 94545 (37.620187, -122.106488)
31977 0356787-03-999 Adal Woldu Y Woldu Trucking Co 3447 Investment Blvd 4 Hayward 38 CA 1 94545 64 11/14/2011   11/14/2011   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           3447 INVESTMENT BLVD HAYWARD, CA 94545 (37.625951, -122.118313)
32547 0358767-01-999 Barrientos Mario E Mb Marble Resurfacing 27921 Capetown Ave Hayward 38 CA 1 94545 64 08/01/2002 05/28/2015 08/01/2002 05/28/2015             0 0           27921 CAPETOWN AVE HAYWARD, CA 94545 (37.623271, -122.096138)
32773 0359481-02-999 Olszewski Jerzy Jerry Olszewski General Contr 22040 Arbor Ave 3 Hayward 38 CA 1 94541 109 04/12/2012 04/22/2015 04/12/2012 04/22/2015             0 0           22040 ARBOR AVE HAYWARD, CA 94541 (37.667034, -122.107142)
32845 0344904-00-000 Vanguard Properties Inc Vanguard Properties Inc 1393 West St Hayward 38 CA 1 94545 64 04/01/2001 04/02/2013 04/01/2001 04/02/2013             0 0           1393 WEST ST HAYWARD, CA 94545 (37.646684, -122.11061)
32989 0360224-01-999 Calderon Elio R Calderon & Sons Constructn Co 618 Fairway St Hayward 38 CA 1 94544 90 08/30/2004 06/03/2015 08/30/2004 06/03/2015             0 0           618 FAIRWAY ST HAYWARD, CA 94544 (37.623598, -122.036518)
33016 0360301-01-999 Midwest Sign & Screen Printing Midwest Sign & Screen Printing 21054 Alexander Ct Hayward 38 CA 1 94545 64 10/01/2002   10/01/2002   21054 Alexander Ct Hayward 82 94545 123 CA 4200-4299 4400-4599 13 Multiple 13 0 0           21054 ALEXANDER CT HAYWARD, CA 94545 (37.65208, -122.130853)

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