home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

199 rows where City = 110

View and edit SQL

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

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
4556 0043636-51-999 Pacific Bell Telephone Company Pacific Bell Telephone Company 870 N Mccarthy Milpitas 110 CA 1 95035 175 10/01/1968   01/01/2012   1010 Pine St. Rm. 7e B 02 St Louis 67 63101 294 MO 5100-5199 15 Information 15 0 0           870 N MCCARTHY MILPITAS, CA 95035 (37.438463, -121.924022)
4932 0064007-01-999 B T Mancini Co Inc B T Mancini Co Inc P O Box 361930 Milpitas Ca Milpitas 110 CA 1 95036 185 10/01/1968   10/01/1968   Po Box 361930 Milpitas 264 95036 379 CA 2300-2399 6 Construction 6 0 0            
6396 0487459-01-999 Ferreira Tony F Tff Heating & A/c 299 Corning Ave Milpitas 110 CA 1 95035 175 02/26/2014 02/27/2014 02/26/2014 02/27/2014             0 0           299 CORNING AVE MILPITAS, CA 95035 (37.42374, -121.910469)
9377 1091388-08-161 Cesar Calilung Jr Cesar Calilung Jr 755 Capitol Ave Apt E108 Milpitas 110 CA 1 95035 175 08/15/2016 05/31/2017 08/15/2016 05/31/2017         4800-4999 12 Transportation and Warehousing 12 0 0            
12098 0167536-01-999 Superior Automatic Sprklr Etc Superior Automatic Sprklr Etc 308 Sango Ct Milpitas 110 CA 1 95035 175 12/17/1987   12/17/1987   4378 Enterprise St Fremont 2 94538 131 CA 2300-2399 6 Construction 6 0 0           308 SANGO CT MILPITAS, CA 95035 (37.406959, -121.894627)
12798 0180026-01-999 Blues Roofing Co Blues Roofing Co 182 Topaz St Milpitas 110 CA 1 95035 175 09/01/1988   09/01/1988   182 Topaz St Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           182 TOPAZ ST MILPITAS, CA 95035 (37.428068, -121.899418)
12907 0180492-01-999 Swanson Gary G Swanson G Construction 1658 Watson Ct Milpitas 110 CA 1 95035 175 08/08/1988   08/08/1988   1658 Watson Ct Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           1658 WATSON CT MILPITAS, CA 95035 (37.410837, -121.884649)
16857 0189688-02-999 Balch Petroleum Contr & Bldr Balch Petroleum Contr & Bldr 930 Ames Ave Milpitas 110 CA 1 95035 175 12/13/2001   12/13/2001   930 Ames Avenue Po Box 361230 Milpitas 264 95036 379 CA 2300-2399 6 Construction 6 0 0           930 AMES AVE MILPITAS, CA 95035 (37.420257, -121.888287)
22658 0194909-02-999 Devcon Construction Inc Devcon Construction Inc 690 Gibraltar Dr Milpitas 110 CA 1 95035 175 01/29/2001   01/29/2001   690 Gibraltar Dr Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           690 GIBRALTAR DR MILPITAS, CA 95035 (37.416947, -121.889047)
26938 0339180-04-999 Preston Pipelines Inc Preston Pipelines 133 Bothelo Av Milpitas 110 CA 1 95035 175 08/25/2000   08/16/2012   133 Bothelo Avenue Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           133 BOTHELO AV MILPITAS, CA 95035 (37.428219, -121.90426)
28565 0345026-02-999 Vic Sotto Landscaping Inc Vic Sotto Landscaping Inc 844 Las Lomas Dr Milpitas 110 CA 1 95035 175 06/20/2003   06/20/2003   844 Las Lomas Dr Milpitas 264 95035 718 CA     0 0           844 LAS LOMAS DR MILPITAS, CA 95035 (37.439373, -121.891959)
31726 0355991-02-999 Summers & Sons Electric Inc Summers & Sons Electric Inc 808 So Main St Milpitas 110 CA 1 95035 175 09/30/2010 01/01/2011 09/30/2010 01/01/2011             0 0           808 SO MAIN ST MILPITAS, CA 95035 (37.419367, -121.903841)
36380 0369961-02-999 Marketshare Inc Marketshare Inc 2001 Tarob Ct Milpitas 110 CA 1 95035 175 05/21/2013   05/21/2013   2001 Tarob Ct Milpitas 264 95035 718 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2001 TAROB CT MILPITAS, CA 95035 (37.404808, -121.890998)
39662 0372463-02-999 Ferreira Eudo B Signature Coach 1259 Aberfeldy Way Milpitas 110 CA 1 95035 175 12/01/2003 06/01/2013 12/08/2005 06/01/2013             0 0           1259 ABERFELDY WAY MILPITAS, CA 95035 (37.424536, -121.88249)
40161 0380501-01-999 Realm Communications Group Inc Realm Communications Group Inc 840 Yosemite Way Milpitas 110 CA 1 95035 175 08/27/2004   08/27/2004   840 Yosemite Way Milpitas 264 95035 718 CA 3100-3399 4200-4299 23 Multiple 13 0 0           840 YOSEMITE WAY MILPITAS, CA 95035 (37.423599, -121.884862)
40497 0381257-03-999 Xl Construction Corporation Xl Construction Corp 851 Buckeye Ct Milpitas 110 CA 1 95035 175 02/15/2006   12/31/2011   851 Buckeye Court Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           851 BUCKEYE CT MILPITAS, CA 95035 (37.406608, -121.915403)
41584 0374417-01-999 Safco Sound & Security Systems Safco Sound & Security Systems 150 S. Main St. Milpitas 110 CA 1 95035 175 01/01/2003   01/01/2003   4436 Technology Drive Fremont 2 94538 131 CA     0 0           150 S MAIN ST MILPITAS, CA 95035 (37.42844, -121.906302)
43529 0388751-02-999 Lifetime Partners Inc Bc Electric 308 S Abbott Ave Milpitas 110 CA 1 95035 175 01/12/2011 03/31/2014 01/12/2011 03/31/2014             0 0           308 S ABBOTT AVE MILPITAS, CA 95035 (37.425369, -121.913201)
43913 0389631-01-999 Globalstar Usa Llc Globalstar Usa Llc 461 Milpitas Blvd Milpitas 110 CA 1 95035 175 05/01/2005   05/01/2005   0000 Undeliverable Mail San Francisco 1 99999 12 CA 5100-5199 15 Information 15 0 0           461 MILPITAS BLVD MILPITAS, CA 95035 (37.426033, -121.895204)
44713 0385310-01-999 H V Welker Co Inc Welker Bros 970 South Milpitas Blvd Milpitas 110 CA 1 95035 175 02/17/2005   02/17/2005   970 S Milpitas Blvd Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           970 SOUTH MILPITAS BLVD MILPITAS, CA 95035 (37.420091, -121.891283)
45917 0394365-02-999 Oviedo Raul Raul Oviedo Clean Serv 555 S Park Victoria Dr 409 Milpitas 110 CA 1 95035 175 01/04/2006   06/25/2009   663 Santos Ct Milpitas 264 95035 718 CA     0 0           555 S PARK VICTORIA DR MILPITAS, CA 95035 (37.4273, -121.881276)
47513 0397680-02-999 Defender Security Company Defender Security Company 1605 So Main St 125 Milpitas 110 CA 1 95035 175 04/15/2006   07/01/2008 07/29/2016 3750 Priority Way South Dr Suite 200 Indianapolis 105 46240 1698 IN     0 0           1605 SO MAIN ST MILPITAS, CA 95035 (37.406076, -121.902916)
48378 0394365-03-999 Oviedo Raul Raul Oviedo Clean Serv 663 Santos Ct Milpitas 110 CA 1 95035 175 01/04/2006   08/20/2010   663 Santos Ct Milpitas 264 95035 718 CA     0 0           663 SANTOS CT MILPITAS, CA 95035 (37.445273, -121.884631)
51420 0405612-01-999 Adem Kusmelah Z Adem Kusmelah Z 1001 So Main St #Q111 Milpitas 110 CA 1 95035 175 01/01/2007   01/01/2007   16900 Cobble Creek Way Lathrop 1053 95330 1800 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1001 SO MAIN ST MILPITAS, CA 95035 (37.41735, -121.902983)
51542 0405799-01-999 Ali Nadim Ali Nadim 1171 N. Abbott Ave Milpitas 110 CA 1 95035 175 01/01/2007 05/25/2015 01/01/2007 05/25/2015             0 0           1171 N ABBOTT AVE MILPITAS, CA 95035 (37.443796, -121.914923)
51548 0405806-01-999 Ali Zulfiqar Ali Zulfiqar 1171 N Abbott Ave Milpitas 110 CA 1 95035 175 01/01/2007   01/01/2007   6254 Montcalm Ave Newark 376 94560 587 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1171 N ABBOTT AVE MILPITAS, CA 95035 (37.443796, -121.914923)
51881 0406462-01-999 Brantvein Antoli Brantvein Antoli 1882 Golden Hill Dr Milpitas 110 CA 1 95035 175 01/01/2007 10/01/2008 01/01/2007 10/01/2008             0 0           1882 GOLDEN HILL DR MILPITAS, CA 95035 (37.440411, -121.874837)
53706 0406848-01-999 Chow Simon K Chow Simon K 154 Serenity Pl Milpitas 110 CA 1 95035 175 01/01/2007   01/01/2007   Po Box 361692 Milpitas 264 95036 379 CA     0 0           154 SERENITY PL MILPITAS, CA 95035 (37.419701, -121.90018)
56791 0413287-01-999 Ohana Partners Inc The Stuart Rental Company 454 South Abbott Ave Milpitas 110 CA 1 95035 175 03/11/2004   03/11/2004   454 South Abbott Ave Milpitas 264 95035 718 CA     0 0           454 SOUTH ABBOTT AVE MILPITAS, CA 95035 (37.421343, -121.914367)
63133 0426984-27-999 At&t Services Inc At&t Services 870 Mccarthy Milpitas 110 CA 1 95035 175 01/01/2004   01/01/2011   909 Chestnut St 28-R-08 St Louis 67 63101 294 MO     0 0           870 MCCARTHY MILPITAS, CA 95035 (37.41508, -121.921239)
65474 0430619-02-999 Wang Kai Kai General Contractor 450 S Abel St 361691 Milpitas 110 CA 1 95035 175 07/16/2008 07/31/2013 10/29/2012 07/31/2013             0 0           450 S ABEL ST MILPITAS, CA 95035 (37.423113, -121.906811)
65475 0430619-03-999 Wang Kai Kai Design And Build 1016 Luz Del Sol Loop Milpitas 110 CA 1 95035 175 07/16/2008 07/31/2013 05/28/2013 07/31/2013             0 0           1016 LUZ DEL SOL LOOP MILPITAS, CA 95035 (37.420645, -121.911924)
67433 0434701-01-999 Comfort Zone Mechanical Air Comfort Zone Mechanical Air 1532 Centre Pointe Dr Milpitas 110 CA 1 95035 175 12/24/2008   12/24/2008   1465 N Milpitas Blvd Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           1532 CENTRE POINTE DR MILPITAS, CA 95035 (37.409555, -121.897212)
70406 0439301-02-999 Pappas Piping Services Inc Pappas Piping Services Inc 356 S Milpitas Blvd Milpitas 110 CA 1 95035 175 03/22/2010   03/22/2010 04/30/2014 1450 Koll Cir #108 San Jose 10 95112 25 CA 2300-2399 6 Construction 6 0 0           356 S MILPITAS BLVD MILPITAS, CA 95035 (37.426567, -121.895497)
70407 0439301-03-999 Pappas Piping Services Inc Pappas Hvac Services 356 S Milpitas Blvd Milpitas 110 CA 1 95035 175 03/22/2010   03/31/2010 04/30/2014 1450 Koll Cir #108 San Jose 10 95112 25 CA 2300-2399 6 Construction 6 0 0           356 S MILPITAS BLVD MILPITAS, CA 95035 (37.426567, -121.895497)
72326 0442618-01-999 Auriga Corporation Auriga Corporation 890 Hillview Ct 130 Milpitas 110 CA 1 95035 175 10/01/2009   10/01/2009   890 Hillview Ct #130 Milpitas 264 95035 718 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           890 HILLVIEW CT MILPITAS, CA 95035 (37.435552, -121.891858)
74888 0447250-01-999 Aircom Mechanical Inc Aircom Mechanical Inc 340 S Milpitas Blvd Milpitas 110 CA 1 95035 175 03/01/2010   03/01/2010   340 S Milpitas Blvd Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           340 S MILPITAS BLVD MILPITAS, CA 95035 (37.427806, -121.896189)
74937 0447331-00-000 Uri Refrigeration Inc Uri Refrigeration Inc 483 Los Coches Street Milpitas 110 CA 1 95035 175 03/09/2010 11/15/2013 03/09/2010 11/15/2013             0 0           483 LOS COCHES STREET MILPITAS, CA 95035 (37.431044, -121.896747)
75235 0447840-01-999 Lopez Evodio E L Construction 1835 Canton Dr Milpitas 110 CA 1 95035 175 04/01/2010   04/01/2010   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           1835 CANTON DR MILPITAS, CA 95035 (37.434614, -121.872843)
75479 0448196-01-999 Jmx Electric Inc Jmx Electric Inc 1313 N Milpitas Blvd 181 Milpitas 110 CA 1 95035 175 04/07/2010   04/07/2010   5669 Snell Ave #360 San Jose 10 95123 1771 CA 2300-2399 6 Construction 6 0 0           1313 N MILPITAS BLVD MILPITAS, CA 95035 (37.450427, -121.909946)
75832 0448744-01-999 Builders Drapery Service Inc Builders Drapery Service Inc 1494 Gladding Ct Milpitas 110 CA 1 95035 175 06/12/2010   06/12/2010   1494 Gladding Ct Milpitas 264 95035 718 CA 3100-3399 8100-8139 204 Multiple 13 0 0           1494 GLADDING CT MILPITAS, CA 95035 (37.410896, -121.888185)
78290 0452353-01-999 Gonzalez Jose D Jm Gonzalez Remodeling 135 Valmy St Milpitas 110 CA 1 95035 175 09/07/2010   09/07/2010   1496 Edsel Dr Milpitas 264 95035 718 CA     0 0           135 VALMY ST MILPITAS, CA 95035 (37.453877, -121.907985)
79010 0453002-01-999 Kirsch Jenifer L Juror2net 1589 Carl Ave Milpitas 110 CA 1 95035 175 09/30/2010   09/30/2010   1589 Carl Ave Milpitas 264 95035 718 CA     0 0           1589 CARL AVE MILPITAS, CA 95035 (37.439402, -121.878936)
79727 0454442-01-999 Oviedo Juan Juan Oviedo 663 Santos Ct Milpitas 110 CA 1 95035 175 12/01/2010   12/01/2010   663 Santos Ct Milpitas 264 95035 718 CA     0 0           663 SANTOS CT MILPITAS, CA 95035 (37.445273, -121.884631)
80700 0455722-01-999 Silver Construction Inc Silver Creek Electric 1650 Watson Ct Milpitas 110 CA 1 95035 175 01/25/2011   01/25/2011   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           1650 WATSON CT MILPITAS, CA 95035 (37.410837, -121.884649)
81158 0456325-01-999 3s Communications Inc 3s Communications Inc 105 Serra Wy 312 Milpitas 110 CA 1 95035 175 03/01/2011   03/01/2011   105 Serra Wy #312 Milpitas 264 95035 718 CA     0 0           105 SERRA WY MILPITAS, CA 95035 (37.427791, -121.908864)
83508 0459152-01-999 Sotto Vicente R Vicent Landscaping 844 Las Lamas Dr Milpitas 110 CA 1 95035 175 05/16/2011   05/16/2011   844 Las Lomas Dr Milpitas 264 95035 718 CA     0 0           844 LAS LAMAS DR MILPITAS, CA 95035 (37.439373, -121.891959)
84349 0460250-01-999 Regency General Contractors Regency General Contractors 336 Los Coches St Milpitas 110 CA 1 95035 175 01/04/2011   01/04/2011   336 Los Coches St Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           336 LOS COCHES ST MILPITAS, CA 95035 (37.429637, -121.899323)
85689 0461843-01-999 Abc Constr/engineering Svc Inc Abc Constr/engineering Svc Inc 1525 Mccarthy Bl 1000 Milpitas 110 CA 1 95035 175 08/17/2011   08/17/2011   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           1525 MCCARTHY MILPITAS, CA 95035 (37.406919, -121.919675)
86889 0463362-02-999 Valdiviezo Silvia R Silvias Housecleaning 418 Moretti Lane Milpitas 110 CA 1 95035 175 10/13/2011 04/16/2012 07/24/2012 04/16/2012             0 0           418 MORETTI LANE MILPITAS, CA 95035 (37.440837, -121.889109)
87421 0464004-02-002 Hiqu Advance Inc Hiqu Advance Inc 342 Alvarez Common Milpitas 110 CA 1 95035 175 09/10/2013   09/10/2013   342 Alvarez Common Milpitas 264 95035 718 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           342 ALVAREZ COMMON MILPITAS, CA 95035 (37.422455, -121.910285)
88927 0465755-01-999 Serpas Farina Farina Serpas Janitorial Svcs 133 N Temple Dr 111 Milpitas 110 CA 1 95035 175 01/25/2012   01/25/2012   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           133 N TEMPLE DR MILPITAS, CA 95035 (37.440336, -121.877312)
88969 0465801-03-999 Pacific Plumbing & Sewer Servi Pac Plumbing & Underground Con 329 Sango Ct Milpitas 110 CA 1 95035 175 09/25/2013   09/25/2013   329 Sango Court Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           329 SANGO CT MILPITAS, CA 95035 (37.406916, -121.894195)
89040 0465882-01-999 Martinez Gleidis Gleidis Martinez 133 N Temple Dr 111 Milpitas 110 CA 1 95035 175 01/26/2012   01/26/2012   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           133 N TEMPLE DR MILPITAS, CA 95035 (37.440336, -121.877312)
89640 0466548-01-999 Black Mountain Construction In Black Mountain Construction In 146 S Temple Dr Milpitas 110 CA 1 95035 175 02/17/2012 06/01/2015 02/17/2012 06/01/2015             0 0           146 S TEMPLE DR MILPITAS, CA 95035 (37.435338, -121.875264)
90960 0468084-01-999 Trinh Ninh T Ninh T Trinh 1514 Carl Av Milpitas 110 CA 1 95035 175 04/01/2012   04/01/2012   3258 Mattos Ave San Jose 10 95132 2054 CA     0 0           1514 CARL AV MILPITAS, CA 95035 (37.439148, -121.880051)
91979 0469272-01-999 Fireeye Inc Fireeye Inc 1390 Mccarthy Blvd Milpitas 110 CA 1 95035 175 02/01/2011   02/01/2011   1440 Mccarthy Blvd Milpitas 264 95035 718 CA 5100-5199 15 Information 15 0 0           1390 MCCARTHY BLVD MILPITAS, CA 95035 (37.410123, -121.921048)
93527 0470981-01-999 All Temperature Srvc Aircondit All Temperature Srvc Aircondit 773 Ames Ave Milpitas 110 CA 1 95035 175 07/16/2012   07/16/2012   773 Ames Ave Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           773 AMES AVE MILPITAS, CA 95035 (37.419688, -121.889911)
96360 0474069-01-999 Triana Jonathan Jonathan Triana 663 Santos Ct Milpitas 110 CA 1 95035 175 11/05/2012   11/05/2012   663 Santos Ct Milpitas 264 95035 718 CA     0 0           663 SANTOS CT MILPITAS, CA 95035 (37.445273, -121.884631)
96764 0474509-01-999 Phong Sam S First Air Heating And A/c 405 Roswell Ct Milpitas 110 CA 1 95035 175 11/26/2012 02/02/2014 11/26/2012 02/02/2014             0 0           405 ROSWELL CT MILPITAS, CA 95035 (37.430834, -121.876865)
97164 0474950-01-999 Tlg Enterprises Inc Blr Sign Systems 1823 Houret Ct Milpitas 110 CA 1 95035 175 12/11/2012   12/11/2012   1823 Houret Ct Milpitas 264 95035 718 CA     0 0           1823 HOURET CT MILPITAS, CA 95035 (37.405986, -121.896693)
99544 0477421-01-999 Rural/metro Of Northern Ca Inc Rural/metro Of Northern Ca Inc 550 Sycamore Dr Milpitas 110 CA 1 95035 175 04/01/2012 09/30/2017 04/01/2012 09/30/2017             0 0           550 SYCAMOR DR MILPITAS, CA 95035 (37.409691, -121.914118)
101918 0479876-01-999 Kim Kyung C Ocean Wave Time 1182 Park Brook Ct Milpitas 110 CA 1 95035 175 05/31/2013 01/01/2014 05/31/2013 01/01/2014             0 0           1182 PARK BROOK CT MILPITAS, CA 95035 (37.438351, -121.886188)
102134 0480097-01-999 Markowski Arthur A R Tek Construction 551 Costigan Cir Milpitas 110 CA 1 95035 175 06/01/2013 12/31/2014 06/01/2013 12/31/2014             0 0           551 COSTIGAN CIR MILPITAS, CA 95035 (37.448243, -121.89854)
102508 0480459-01-999 S J Distributors Inc S J Distributors Inc 625 Vista Wy Milpitas 110 CA 1 95035 175 07/01/2012   07/01/2012   625 Vista Way Milpitas 264 95035 718 CA 4800-4999 12 Transportation and Warehousing 12 0 0           625 VISTA WY MILPITAS, CA 95035 (37.425096, -121.888539)
102625 0480599-01-999 Daylight Foods Inc Daylight Foods Inc 660 Vista Way Milpitas 110 CA 1 95035 175 01/01/2013   01/01/2013   660 Vista Way Milpitas 264 95035 718 CA 7220-7229 8 Food Services 8 0 0           660 VISTA WAY MILPITAS, CA 95035 (37.425889, -121.888776)
103565 0481494-01-999 Barreto Luis / Murillo Mabel Mabel Services 418 Moretti Ln Milpitas 110 CA 1 95035 175 07/16/2013 05/12/2016 07/16/2013 05/12/2016             0 0           418 MORETTI LN MILPITAS, CA 95035 (37.440837, -121.889109)
104895 0482907-01-999 Ceron Miguel Ceron Heating & Cooling 770 E Capitol Ave Milpitas 110 CA 1 95035 175 09/03/2013   09/03/2013   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           770 E CAPITOL AVE MILPITAS, CA 95035 (37.406913, -121.888009)
111299 0489187-01-999 Bradley Concrete Bradley Concrete 853 Buckeye Ct Milpitas 110 CA 1 95035 175 04/20/2014   04/20/2014   853 Buckeye Ct Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           853 BUCKEYE CT MILPITAS, CA 95035 (37.406815, -121.914876)
112409 0490262-01-999 Sayed Humayoon Humayoon Sayed 1717 Clear Lake Ave Milpitas 110 CA 1 95035 175 06/01/2014 12/01/2015 06/01/2014 12/01/2015         4800-4999 12 Transportation and Warehousing 12 0 0           1717 CLEAR LAKE AVE MILPITAS, CA 95035 (37.418804, -121.872211)
118558 0941643-02-999 Riverview Systems Group Inc Riverview Systems Group Inc 1101 Cadillac Ct Milpitas 110 CA 1 95035 175 05/01/1995   07/01/2012   1101 Cadillac Ct Milpitas 264 95035 718 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1101 CADILLAC CT MILPITAS, CA 95035 (37.443605, -121.918667)
119092 0944518-03-999 Tong & Associates Inc Pacific General Construction 1150 Cadillac Ct Milpitas 110 CA 1 95035 175 05/06/2009   05/01/2010   1150 Cadillac Ct Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           1150 CADILLAC CT MILPITAS, CA 95035 (37.44409, -121.918629)
119518 0946565-02-999 Andys Roofing Co Inc Andys Roofing Co Inc 897 Ames Ave Milpitas 110 CA 1 95035 175 08/09/2006   08/09/2006 02/28/2014 2161 Adams Ave San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           897 AMES AVE MILPITAS, CA 95035 (37.42101, -121.884456)
120419 0950834-01-999 Custom Drywall Inc Custom Drywall Inc 1570 Gladding Ct Milpitas 110 CA 1 95035 175 03/25/1996   03/25/1996   1570 Gladding Ct Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           1570 GLADDING CT MILPITAS, CA 95035 (37.410399, -121.887949)
122807 1003207-07-141 Raw Skate Parks Inc Creative Solutions 1010 S Milpitas Blvd Milpitas 110 CA 1 95035 175 07/17/2014   07/17/2014   1010 S Milpitas Blvd Milpitas 264 95035 718 CA 4400-4599 3 Retail Trade 3 0 0           1010 S MILPITAS BLVD MILPITAS, CA 95035 (37.418844, -121.890034)
127382 1011654-11-141 Burvee Robert Custom Glassworks 930 Wrigley Way Milpitas 110 CA 1 95035 175 11/10/2014   11/10/2014   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           930 WRIGLEY WAY MILPITAS, CA 95035 (37.428348, -121.887508)
130032 1016038-01-151 Bluebox Security Inc Bluebox Security Inc 1521 California Cir 2 Milpitas 110 CA 1 95035 175 05/17/2012 05/16/2016 09/01/2014 05/16/2016             0 0           1521 CALIFORNIA CIR MILPITAS, CA 95035 (37.451833, -121.920293)
138440 1030745-06-151 Social Venture Technology Grp Svt Group 715 Vasona St Milpitas 110 CA 1 95035 175 01/12/2009 05/10/2015 11/30/2013 05/10/2015             0 0           715 VASONA ST MILPITAS, CA 95035 (37.438169, -121.910337)
141178 1035386-07-151 Motwani Manit Cutting Chai 229 Images Cir Milpitas 110 CA 1 95035 175 07/27/2015 07/28/2015 07/27/2015 07/28/2015             0 0           229 IMAGES CIR MILPITAS, CA 95035 (37.434626, -121.907994)
141932 1036535-08-151 Rehoboth Construction Group Rehoboth Construction Fire Sprinkler 105 Serra Way #372 Milpitas 110 CA 1 95035 175 08/13/2015   08/13/2015 05/30/2017 105 Serra Way #372 Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           105 SERRA WAY MILPITAS, CA 95035 (37.427791, -121.908864)
143234 1038579-09-151 Eat On Monday Inc Eat On Monday 1558 Gladding Ct Milpitas 110 CA 1 95035 175 09/01/2015 03/01/2017 09/01/2015 03/01/2017         7220-7229 8 Food Services 8 0 0           1558 GLADDING CT MILPITAS, CA 95035 (37.410571, -121.888026)
144483 1040841-09-151 Duran & Venables Inc Duran & Venables Inc 748 Hillview Dr Milpitas 110 CA 1 95035 175 11/01/1995   01/01/2011   748 S Hillview Dr Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           748 HILLVIEW DR MILPITAS, CA 95035 (37.424646, -121.891162)
146779 1044898-11-151 Tf Mcguckin Inc Mcroskey Mattress Co 777 Folsom Cir Milpitas 110 CA 1 95035 175 10/05/2015 02/29/2016 10/05/2015 02/29/2016             0 0           777 FOLSOM CIR MILPITAS, CA 95035 (37.438656, -121.904299)
154978 1061947-04-161 United Comfort Solutions Inc United Comfort Solutions Inc 1623 S Main St Milpitas 110 CA 1 95035 175 07/01/2015   07/01/2015   142 N Milpitas Dr #308 Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           1623 S MAIN ST MILPITAS, CA 95035 (37.406035, -121.902915)
155162 1062282-04-161 Yyb Construction Construction 500 Amalfi Loop Apt 488 Milpitas 110 CA 1 95035 175 04/15/2016   04/17/2016   0000 Undeliverable Mail San Francisco 1 99999 12 CA 2300-2399 6 Construction 6 0 0           500 AMALFI LOOP MILPITAS, CA 95035
155254 1062431-04-161 James B Smith James B Smith 496 Dempsey Rd Unit 299 Milpitas 110 CA 1 95035 175 04/18/2016   04/18/2016   496 Dempsey Rd 299 Unit Milpitas 264 95035 718 CA 4800-4999 12 Transportation and Warehousing 12 0 0           496 DEMPSEY RD MILPITAS, CA 95035 (37.428606, -121.884665)
155920 1063732-04-161 Louie C Truong Dba 1578 Jupiter Dr Milpitas 110 CA 1 95035 175 04/15/2016 04/15/2016 04/15/2016 04/15/2016         4800-4999 12 Transportation and Warehousing 12 0 0           1578 JUPITER DR MILPITAS, CA 95035 (37.43628, -121.878059)
156284 1064419-04-161 Fjv Transportation Fjv Transportation 1012 Tice Dr Milpitas 110 CA 1 95035 175 01/01/2016   01/01/2016   1012 Tice Dr Milpitas 264 95035 718 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1012 TICE DR MILPITAS, CA 95035 (37.448703, -121.894448)
158397 1068452-05-161 Iron Electric Inc Iron Electric Inc 231 Dixon Landing Rd 158 Milpitas 110 CA 1 95035 175 05/11/2016   05/11/2016   231 Dixon Landing Rd Apt #158 Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           231 DIXON LANDING RD MILPITAS, CA 95035 (37.456274, -121.915342)
158412 1068479-05-161 Mabel's Services Mabel's Services 418 Moretti Ln Milpitas 110 CA 1 95035 175 05/12/2016   05/12/2016   418 Moretti Ln Milpitas 264 95035 718 CA     0 0           418 MORETTI LN MILPITAS, CA 95035 (37.440837, -121.889109)
159066 1069785-05-161 Louie C Truong Dba Louie C Truong Dba 1578 Jupiter Dr Milpitas 110 CA 1 95035 175 05/15/2016 05/15/2016 05/15/2016 05/15/2016         4800-4999 12 Transportation and Warehousing 12 0 0           1578 JUPITER DR MILPITAS, CA 95035 (37.43628, -121.878059)
160085 1071686-05-161 John's Uber Business Not Applicable 502 Walnut Dr Milpitas 110 CA 1 95035 175 05/20/2016   05/20/2016   502 Walnut Dr Milpitas 264 95035 718 CA 4800-4999 12 Transportation and Warehousing 12 0 0           502 WALNUT DR MILPITAS, CA 95035 (37.436455, -121.916464)
160408 1072305-05-161 L & U Online Transport Service L & U Online Transport Service 1578 Jupiter Dr Milpitas 110 CA 1 95035 175 05/23/2016 05/23/2016 05/23/2016 05/23/2016         4800-4999 12 Transportation and Warehousing 12 0 0           1578 JUPITER DR MILPITAS, CA 95035 (37.43628, -121.878059)
161196 1073749-05-161 L & U Online Transport Service L & U Online Transport Service 1578 Jupiter Dr Milpitas 110 CA 1 95035 175 05/28/2016   05/28/2016   1578 Jupiter Dr Milpitas 264 95035 718 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1578 JUPITER DR MILPITAS, CA 95035 (37.43628, -121.878059)
161233 1073822-05-161 Ajay Tallam Ajay Tallam 370 Chad Dr Milpitas 110 CA 1 95035 175 12/19/2015   01/01/2016   370 Chad Dr Milpitas 264 95035 718 CA     0 0           370 CHAD DR MILPITAS, CA 95035 (37.44264, -121.902246)
161713 1074635-06-161 Joseph Sawaya Joseph Sawaya 974 Hanson Ct Milpitas 110 CA 1 95035 175 09/11/2015 09/11/2015 09/11/2015 09/11/2015         4800-4999 12 Transportation and Warehousing 12 0 0           974 HANSON CT MILPITAS, CA 95035 (37.444314, -121.908614)
162333 1075752-06-161 Jeffrey Orr Jeffrey Orr 1614 Jupiter Dr Milpitas 110 CA 1 95035 175 06/08/2016   06/08/2016   1614 Jupiter Dr Milpitas 264 95035 718 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1614 JUPITER DR MILPITAS, CA 95035 (37.43659, -121.877394)
162858 1076738-06-161 Floor Seal Technology Inc Floor Seal Technology Inc 1005 Ames Ave Milpitas 110 CA 1 95035 175 06/01/1999   06/01/1999   1005 Ames Ave Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0           1005 AMES AVE MILPITAS, CA 95035 (37.420729, -121.885908)
164293 1079417-06-161 Phong Sam First Air Heating & A/c 405 Roswell Ct Milpitas 110 CA 1 95035 175 06/29/2016 05/24/2017 06/29/2016 05/24/2017         2300-2399 6 Construction 6 0 0            
166467 1082588-07-161 Tp Construction Tp Construction 1786 Butano Dr Milpitas 110 CA 1 95035 175 07/11/2016   07/11/2016   1786 Butano Dr Milpitas 264 95035 718 CA 2300-2399 6 Construction 6 0 0            

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