home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

4,512 rows where NAICS Code Description = 9

View and edit SQL

Suggested facets: State, Mail State, Parking Tax, Transient Occupancy Tax, LIC Code Description, Supervisor District, Business Corridor

NAICS 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
45 0046744-01-001 Giovanni Albert & Eleanor Etc 918 Taraval Bldg 918 Taraval St San Francisco 1 CA 1 94116 23 10/01/1968   10/01/1968   400 Light Springs Rd Aptos 8 95003 21 CA 7210-7219 9 Accommodations 9 0 0     4 10 Sunset/Parkside 14   918 TARAVAL ST San Francisco, CA 94116 (37.743048, -122.476)
58 0059503-01-001 Giusto Enterprises Inc Town House Motel 1650 Lombard St San Francisco 1 CA 1 94123 3 06/01/1970   06/01/1970   7525 Mission St Daly City 11 94014 26 CA 7210-7219 9 Accommodations 9 0 1     2 Marina 2   1650 LOMBARD ST San Francisco, CA 94123 (37.800837, -122.428629)
149 0416090-01-001 Belani Suesh/ravi 92-98 Webster St Apts 92-98 Webster St San Francisco 1 CA 1 94117 33 03/31/2007   03/31/2007   11645 Putter Wy Los Altos 23 94024 41 CA 7210-7219 9 Accommodations 9 0 0     5 7 Hayes Valley 10   92 98 WEBSTER ST San Francisco, CA 94117 (37.77121, -122.428606)
201 0026320-01-001 Kim Oy Lee Kim Oy Lee 801 Pacific Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   Po Box 330568 San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 1     3 1 Chinatown 7   801 PACIFIC AVE San Francisco, CA 94133 (37.79672, -122.408311)
232 0099786-03-001 Patel Dahyabhai R & S Etal Econo Lodge 2505 Lombard St San Francisco 1 CA 1 94123 3 08/01/1975   08/01/1975   2 W Clay St San Francisco 1 94121 17 CA 7210-7219 9 Accommodations 9 0 1 H56 Swimming Pools (Year-Round) 2 Marina 2   2505 LOMBARD ST San Francisco, CA 94123 (37.798916, -122.442921)
379 0084492-04-001 Patel Mangiben & Ramesh Trust Francisco Bay Inn 1501 Lombard St San Francisco 1 CA 1 94123 3 06/01/1972   01/03/1995   1630 Pacific Ave San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     2 Marina 2   1501 LOMBARD ST San Francisco, CA 94123 (37.801014, -122.426448)
393 0084492-05-001 Patel Mangiben & Ramesh Trust Nob Hill Motor Inn 1630 Pacific Ave San Francisco 1 CA 1 94109 24 06/01/1972   03/30/2000   1630 Pacific Ave San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Russian Hill 5   1630 PACIFIC AVE San Francisco, CA 94109 (37.794944, -122.422194)
420 0031820-01-001 Gong George 1025 Powell Apts 1025 Powell St San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   637 Beacon St #1 Oakland 27 94610 83 CA 7210-7219 9 Accommodations 9 0 0     3 1 Nob Hill 17   1025 POWELL ST San Francisco, CA 94108 (37.794266, -122.409631)
503 0040533-01-001 Louie Shew Ping 446 20th Av Apts 446 20th Ave San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   446 20TH AVE San Francisco, CA 94121 (37.779367, -122.479321)
515 0031829-01-001 Leong Do Yen 1026 Pine Rentals 1026 Pine St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1026 Pine St San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Nob Hill 17   1026 PINE ST San Francisco, CA 94109 (37.790603, -122.412832)
609 0127335-01-001 Guitron Santiago Los Hermanos 2026 Chestnut St San Francisco 1 CA 1 94123 3 01/01/1981   01/01/1981   2026 Chestnut St San Francisco 1 94123 48 CA 7210-7219 9 Accommodations 9 0 0 H24 Restaurant Less Than 1,000 Sqft 2 Marina 2   2026 CHESTNUT ST San Francisco, CA 94123 (37.800723, -122.436974)
828 0040856-01-001 Soracco George & Josephine 490 Lombard Apts 490 Lombard St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1845 Stockton St San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 1     3 1 North Beach 6   490 LOMBARD ST San Francisco, CA 94133 (37.803276, -122.409497)
996 0086585-01-001 Lee Jennie M 3421 Anza Apts 3421 Anza St San Francisco 1 CA 1 94121 15 01/01/1975   01/01/1975   640 27th Av San Francisco 1 94121 17 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   3421 ANZA ST San Francisco, CA 94121 (37.778155, -122.484968)
1169 0086830-02-001 Lambert Claude Jeanne D'arc 715 Bush St San Francisco 1 CA 1 94108 9 01/01/1974   01/01/1974   715 Bush St San Francisco 1 94108 22 CA 7210-7219 9 Accommodations 9 0 0 H25 Restaurant 1,000 - 2,000 Sqft 3 1 Nob Hill 17   715 BUSH ST San Francisco, CA 94108 (37.790124, -122.409114)
1319 0013256-03-001 Patel K C/patel Shantaben K 201-209 6th St Bldg 201 6th St San Francisco 1 CA 1 94103 25 01/01/1975   01/01/1975   432 Geary St San Francisco 1 94102 16 CA 7210-7219 9 Accommodations 9 0 0     6 3 South of Market 15   201 6TH ST San Francisco, CA 94103 (37.779538, -122.406928)
1325 0013256-04-001 Patel K C/patel Shantaben K Union Square Plaza Hotel 432 Geary St San Francisco 1 CA 1 94102 16 01/01/1975   01/01/1990   432 Geary St San Francisco 1 94102 16 CA 7210-7219 9 Accommodations 9 0 1     3 1 Tenderloin 11   432 GEARY ST San Francisco, CA 94102 (37.787093, -122.410336)
1326 0013271-01-001 Beresford Corporation Beresford Hotel 635 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   10/01/1968   582 Market Street #912 San Francisco 1 94104 1 CA 7210-7219 9 Accommodations 9 0 1     3 1 Nob Hill 17   635 SUTTER ST San Francisco, CA 94102 (37.788943, -122.410904)
1334 0013271-02-001 Beresford Corporation Beresford Arms Hotel 701 Post St San Francisco 1 CA 1 94109 24 10/01/1968   01/01/1976   582 Market Street #912 San Francisco 1 94104 1 CA 7210-7219 9 Accommodations 9 0 1     3 1 Tenderloin 11   701 POST ST San Francisco, CA 94109 (37.787627, -122.413583)
1340 0013271-04-001 Beresford Corporation White Horse Tavern 635 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   01/01/1972   582 Market Street #912 San Francisco 1 94104 1 CA 7210-7219 9 Accommodations 9 0 0 H26 Restaurant Greater Than 2,000 Sqft 3 1 Nob Hill 17   635 SUTTER ST San Francisco, CA 94102 (37.788943, -122.410904)
1341 0013290-01-001 Feinstein Dianne Etal Carlton Hotel 1075 Sutter St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1075 Sutter St San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Nob Hill 17   1075 SUTTER ST SAN FRANCISCO, CA 94109 (37.788035, -122.417968)
1361 0013301-01-001 Chancellor Hotel Assoc, Lp Chancellor Hotel 433 Powell St San Francisco 1 CA 1 94102 16 10/01/1968   10/01/1968   433 Powell St San Francisco 1 94102 16 CA 7210-7219 9 Accommodations 9 0 1 D03 P54 Multiple 3 1 Nob Hill 17   433 POWELL ST San Francisco, CA 94102 (37.78871, -122.408513)
1362 0087092-01-001 Hing Bill O Etal 2216 Clay Apts 2216 Clay St San Francisco 1 CA 1 94115 4 01/01/1974   01/01/1974   69 Castenada Ave San Francisco 1 94116 45 CA 7210-7219 9 Accommodations 9 0 0     2 Pacific Heights 16   2216 CLAY ST San Francisco, CA 94115 (37.791286, -122.430151)
1420 0034818-01-001 Parasol Richard & Gun 166 Locksley Apts 166 Locksley Ave San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   775 East Blithedale Ave 212 Suite Mill Valley 26 94941 50 CA 7210-7219 9 Accommodations 9 0 0     7 9 Inner Sunset 13   166 LOCKSLEY AVE San Francisco, CA 94122 (37.757215, -122.462832)
1438 0141986-01-001 Zimmermann Klaus D The Grove Inn 890 Grove St San Francisco 1 CA 1 94117 33 06/15/1983   06/15/1983   890 Grove St San Francisco 1 94117 80 CA 7210-7219 9 Accommodations 9 0 1     5 7 Hayes Valley 10   890 GROVE ST San Francisco, CA 94117 (37.776789, -122.431195)
1492 0101151-01-001 Lee Benjamin & Alice 1234 47th Av Apts 1234 47th Ave San Francisco 1 CA 1 94122 19 05/14/1976   05/14/1976   90 Lomita Ave San Francisco 1 94122 15 CA 7210-7219 9 Accommodations 9 0 0     4 10 Sunset/Parkside 14   1234 47TH AVE San Francisco, CA 94122 (37.763392, -122.507213)
1517 0101151-02-001 Lee Benjamin & Alice 145 Lincoln Apts 145 Lincoln Way San Francisco 1 CA 1 94122 19 05/14/1976   11/29/1976   90 Lomita Ave San Francisco 1 94122 15 CA 7210-7219 9 Accommodations 9 0 0     5 7 Inner Sunset 13   145 LINCOLN WAY San Francisco, CA 94122 (37.766225, -122.459694)
1611 0034874-03-001 Di Pasqua Rino 1200 3rd Ave Apts 1200 3rd Ave San Francisco 1 CA 1 94122 19 03/01/2007   03/01/2007   3423 3423 Terra Linda Dr Santa Rosa 73 95404 180 CA 7210-7219 9 Accommodations 9 0 0     5 7 Inner Sunset 13   1200 3RD AVE San Francisco, CA 94122 (37.766159, -122.459825)
1672 0116739-01-001 Griffin Michael J 1378 8th Ave Apts 1378 8th Ave San Francisco 1 CA 1 94122 19 03/19/1979   03/19/1979   95 Country Club Drive San Francisco 1 94132 56 CA 7210-7219 9 Accommodations 9 0 0     5 7 Inner Sunset 13   1378 8TH AVE San Francisco, CA 94122 (37.76263, -122.465136)
1742 0050726-01-001 Woo Billy 237 Columbus Apts 237 Columbus Ave San Francisco 1 CA 1 94133 11 01/01/1969   01/01/1969   237 Columbus Ave San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 1     3 1 Chinatown 7   237 COLUMBUS AVE San Francisco, CA 94133 (37.797419, -122.406116)
1743 0073752-01-001 Comfort California Inc Three Greenhorns 2775 Van Ness Ave San Francisco 1 CA 1 94109 24 12/01/1972   12/01/1972   10750 Columbia Pike Ste 300 Silver Spring 126 20901 188 MD 7210-7219 9 Accommodations 9 0 0     2 Marina 2   2775 VAN NESS AVE San Francisco, CA 94109 (37.801039, -122.424546)
1745 0116776-01-001 Ockander Donald & Naomi 34 Hugo Apts 34 Hugo St San Francisco 1 CA 1 94122 19 10/15/1975   10/15/1975   1199 Pacific Dr Hwy Unit 504 San Diego 127 92101 189 CA 7210-7219 9 Accommodations 9 0 0     5 7 Inner Sunset 13   34 HUGO ST San Francisco, CA 94122 (37.765315, -122.458386)
1750 0050726-02-001 Woo Billy 217-241 Columbus Bldg 217-241 Columbus Ave San Francisco 1 CA 1 94133 11 01/01/1969   01/01/1969   237 Columbus Ave San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 0     3 1 Chinatown 7   217 241 COLUMBUS AVE San Francisco, CA 94133 (37.797413, -122.4061)
1766 0073752-03-001 Comfort California Inc Quality Inn-San Francisco 2775 Van Ness Ave San Francisco 1 CA 1 94109 24 12/01/1972   03/31/2009   10750 Columbia Pike Ste 300 Silver Spring 126 20901 188 MD 7210-7219 9 Accommodations 9 0 1 D04 D26 Multiple 2 Marina 2   2775 VAN NESS AVE San Francisco, CA 94109 (37.801039, -122.424546)
1806 0117039-01-001 Cushner John 606-610 Steiner Apts 606 Steiner St San Francisco 1 CA 1 94117 33 03/30/1977   08/31/2011   610 Steiner St #3 San Francisco 1 94117 80 CA 7210-7219 9 Accommodations 9 0 0     5 7 Hayes Valley 10   606 STEINER ST San Francisco, CA 94117 (37.775071, -122.432745)
1814 0087657-01-001 Egan Donald E & Konowski B 425 Walnut Apts 425 Walnut St San Francisco 1 CA 1 94118 6 05/10/1974   05/10/1974   4220 Blackhawk Meadow Ct Danville 70 94506 195 CA 7210-7219 9 Accommodations 9 0 0     2 Presidio Heights 3   425 WALNUT ST San Francisco, CA 94118 (37.787551, -122.448586)
1838 0041500-01-001 Mears Victoria Duffett Marc Ocean Park Motel 2690 46th Ave San Francisco 1 CA 1 94116 23 10/01/1968   10/01/1968   2690 46th Ave San Francisco 1 94116 45 CA 7210-7219 9 Accommodations 9 0 1 H56 Swimming Pools (Year-Round) 4 10 Sunset/Parkside 14   2690 46TH AVE San Francisco, CA 94116 (37.73648, -122.504236)
1882 0117118-03-001 Edmondson James P 750 Battery St Building 750 Battery St San Francisco 1 CA 1 94111 35 04/21/1979   01/01/1988   1380 S Harbor Blvd Anaheim 133 92802 197 CA 7210-7219 9 Accommodations 9 0 0     3 1 Financial District/South Beach 1   750 BATTERY ST San Francisco, CA 94111 (37.798255, -122.400991)
1885 0117118-04-001 Edmondson James P 720 Battery St Parking Lot 720 Battery St San Francisco 1 CA 1 94111 35 04/21/1979   04/21/1979   1380 S Harbor Blvd Anaheim 133 92802 197 CA 7210-7219 9 Accommodations 9 0 0     3 1 Financial District/South Beach 1   720 BATTERY ST San Francisco, CA 94111 (37.797914, -122.400925)
1955 0101610-01-001 Perkins Grace J 1865 Sacramento Apts 1865 Sacramento St San Francisco 1 CA 1 94109 24 12/26/1975   10/29/2000   75 Cervantes Blvd San Francisco 1 94123 48 CA 7210-7219 9 Accommodations 9 0 0     2 Pacific Heights 16   1865 SACRAMENTO ST San Francisco, CA 94109 (37.791159, -122.423581)
2057 0073839-01-001 Chin Him Hai 302 24th Av Apts 302 24th Ave San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968 07/10/2014 830 Union St Apt 3 San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   302 24TH AVE San Francisco, CA 94121 (37.783715, -122.483927)
2093 0073839-04-001 Chin Him Hai 3-5 Varennes Apts 3 Varennes St San Francisco 1 CA 1 94133 11 10/01/1968   01/01/1973 10/31/2014 830 Union St Apt 3 San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 0     3 1 North Beach 6   3 VARENNES ST San Francisco, CA 94133 (37.799832, -122.406633)
2262 0101866-01-001 Leong James S 5845 Geary Apts 5845 Geary Blvd San Francisco 1 CA 1 94121 15 01/01/1976   01/01/1976   1666 Chestnut St San Francisco 1 94123 48 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   5845 GEARY BLVD San Francisco, CA 94121 (37.780132, -122.482362)
2288 0041895-01-001 Chan Ralph 636 Hyde Apts 636 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   261 Crestmont Dr Oakland 27 94619 229 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   636 HYDE ST San Francisco, CA 94109 (37.786774, -122.41656)
2306 0101948-01-001 Gallagher David F 3269-3271 Mission Bldg 3269 Mission St San Francisco 1 CA 1 94110 18 01/01/1976 09/15/2017 11/01/1976 01/03/2012         7210-7219 9 Accommodations 9 0 0           3269 MISSION ST San Francisco, CA 94110 (37.744608, -122.420526)
2310 0101948-02-001 Gallagher David F Gallagher Frank J Realty Co 3269 Mission St San Francisco 1 CA 1 94110 18 01/01/1976 09/15/2017 01/01/1976 01/03/2012         7210-7219 9 Accommodations 9 0 0           3269 MISSION ST San Francisco, CA 94110 (37.744608, -122.420526)
2372 0102235-01-001 Toy Mei Kin L 517 Minna Apts 517 Minna St A San Francisco 1 CA 1 94103 25 08/06/1976   08/06/1976   2815 Van Ness Ave 9 Apt San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     6 3 South of Market 15   517 MINNA ST A San Francisco, CA 94103 (37.780174, -122.408643)
2376 0102264-01-001 Tang K K 1261 10th Av Apts 1261 10th Ave San Francisco 1 CA 1 94122 19 02/10/1976   02/10/1976   508 5th Ave San Francisco 1 94118 28 CA 7210-7219 9 Accommodations 9 0 0     5 7 Inner Sunset 13   1261 10TH AVE San Francisco, CA 94122 (37.764678, -122.467435)
2397 0074429-01-001 Kam Ying Wong & David Y J 703-709 Balboa Apts 703 Balboa St San Francisco 1 CA 1 94118 6 08/11/1972   08/11/1972   707 Balboa St San Francisco 1 94118 28 CA 7210-7219 9 Accommodations 9 0 0     1 6 Inner Richmond 21   703 BALBOA ST San Francisco, CA 94118 (37.777127, -122.466402)
2444 0118056-01-001 Drogitis Art & Mary Ann 948 South Van Ness Apts 948 Van Ness Ave San Francisco 1 CA 1 94109 24 06/27/1978   06/27/1978   1309 Murchison Dr Millbrae 17 94030 34 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   948 VAN NESS AVE San Francisco, CA 94109 (37.784423, -122.421056)
2455 0118098-01-001 Campbell Edwin M 107-113 Webster Apts 107 Webster St San Francisco 1 CA 1 94117 33 03/13/1979   03/13/1979   4248 N Wishon Fresno 161 93704 236 CA 7210-7219 9 Accommodations 9 0 0     5 7 Hayes Valley 10   107 WEBSTER ST San Francisco, CA 94117 (37.771595, -122.428681)
2493 0062444-01-001 Giovannini Charles & Miranda 760-766 Green Apts 760 Green St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   764 Green St San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 0     3 1 Chinatown 7   760 GREEN ST San Francisco, CA 94133 (37.799163, -122.411667)
2554 0088298-01-001 Lee Chung Ning Sun 1047 Bush St Apts 1047 Bush St San Francisco 1 CA 1 94109 24 01/01/1975   01/01/1975   1459 8th Ave San Francisco 1 94122 15 CA 7210-7219 9 Accommodations 9 0 0     3 1 Nob Hill 17   1047 BUSH ST San Francisco, CA 94109 (37.789434, -122.414552)
2615 0035603-01-001 Herbert & Jannie Wu 1896 Market Apts 1896 Market St San Francisco 1 CA 1 94102 16 10/01/1968   10/01/1968   4 Laguna St San Francisco 1 94102 16 CA 7210-7219 9 Accommodations 9 0 0     8 5 Hayes Valley 10   1896 MARKET ST San Francisco, CA 94102 (37.770873, -122.424812)
2682 0074694-02-001 Quon Richard & Lorene 1550 Vallejo Apts 1550 Vallejo St San Francisco 1 CA 1 94109 24 06/14/1972   01/01/1974   1550 Vallejo St #4 San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     3 1 Russian Hill 5   1550 VALLEJO ST San Francisco, CA 94109 (37.796784, -122.42284)
2804 0042554-01-001 Dilena Frank & Daisy Etal 75 Heather Apts 75 Heather Ave San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   201 West Santa Inez Av Hillsborough 48 94010 75 CA 7210-7219 9 Accommodations 9 0 0     2 Presidio Heights 3   75 HEATHER AVE San Francisco, CA 94118 (37.784653, -122.452853)
2816 0035677-01-001 William B Noland Etal 1910 California Apts 1910 California St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1910 1910 California St San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     2 Pacific Heights 16   1910 CALIFORNIA ST San Francisco, CA 94109 (37.789893, -122.426096)
2865 0062865-01-001 Grider Clarence 880 25th Av Apts 880 25th Ave San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968   190 Upland Dr San Francisco 1 94127 46 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   880 25TH AVE San Francisco, CA 94121 (37.773017, -122.484234)
2884 0062865-02-001 Grider Clarence 110 6th Av Apts 110 6th Ave San Francisco 1 CA 1 94118 6 10/01/1968   05/11/1971   190 Upland Dr San Francisco 1 94127 46 CA 7210-7219 9 Accommodations 9 0 0     2 Inner Richmond 21   110 6TH AVE San Francisco, CA 94118 (37.786423, -122.464672)
2885 0415994-01-001 Low Jennie 334 26th Ave Apartments 334 26th Ave San Francisco 1 CA 1 94102 16 03/01/2007   03/01/2007   7132 Mound Ct El Cerrito 15 94530 31 CA 7210-7219 9 Accommodations 9 0 0           334 26TH AVE San Francisco, CA 94102 (37.78316, -122.486038)
3174 0075217-03-001 Lau Louis Y 559 7th Av Apts 559 7th Ave San Francisco 1 CA 1 94118 6 03/01/2007   03/01/2007   21608 Rainbow Dr Cupertino 68 95014 108 CA 7210-7219 9 Accommodations 9 0 0     1 6 Inner Richmond 21   559 7TH AVE San Francisco, CA 94118 (37.777942, -122.465143)
3184 0042771-01-001 Murphy Doris C 795 Vienna Apts 795 Vienna St San Francisco 1 CA 1 94112 28 10/01/1968   10/01/1968   15 Dellbrook Ave San Francisco 1 94131 14 CA 7210-7219 9 Accommodations 9 0 0     11 Excelsior 23   795 VIENNA ST San Francisco, CA 94112 (37.71596, -122.433829)
3188 0036612-01-001 Wong Wing W & Henry 2232 Larkin St Apts 2232 Larkin St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968 12/31/2013 2312 Larkin St San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     3 1 Russian Hill 5   2232 LARKIN ST San Francisco, CA 94109 (37.798547, -122.420613)
3256 0035862-01-001 Ito Will K 1964 Post Apts 1964 Post St San Francisco 1 CA 1 94115 4 10/01/1968   10/01/1968   1964 Post St San Francisco 1 94115 2 CA 7210-7219 9 Accommodations 9 0 0     5 7 Japantown 22   1964 POST ST San Francisco, CA 94115 (37.785031, -122.434206)
3421 0036012-01-001 Tang Bow Y 201-207 Divisadero Apts 201 Divisadero St San Francisco 1 CA 1 94117 33 02/22/1996   02/22/1996   1728 Ocean Ave 170 Suite San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     8 5 Haight Ashbury 32   201 DIVISADERO ST San Francisco, CA 94117 (37.7705, -122.436947)
3481 0053062-01-001 Ziegler Family Llc Ziegler Family Partnership 601 Eddy St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   605 Chance Lane Reno 177 89521 298 NV 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   601 EDDY ST San Francisco, CA 94109 (37.783236, -122.418092)
3568 0089874-01-001 Derdevanis Gus 1201-1205 Willard Apts 1201 Willard St San Francisco 1 CA 1 94117 33 09/17/1973   09/17/1973   2143 24th Av San Francisco 1 94116 45 CA 7210-7219 9 Accommodations 9 0 0     5 7 Inner Sunset 13   1201 WILLARD ST San Francisco, CA 94117 (37.765933, -122.454546)
3730 0098396-01-001 Hunkiewicz Ron & Susan 943-953 Guerrero Apts 943 Guerrero St San Francisco 1 CA 1 94110 18 08/11/1975   08/11/1975   625 Darien Wy San Francisco 1 94127 46 CA 7210-7219 9 Accommodations 9 0 0     8 5 Mission 12   943 GUERRERO ST San Francisco, CA 94110 (37.756102, -122.423223)
3818 0036636-01-001 Sommer Gail B 2240 Balboa Apts 2240 Balboa St San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968   2240 Balboa St 4 San Francisco 1 94121 17 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   2240 BALBOA ST San Francisco, CA 94121 (37.77635, -122.483093)
3851 0098477-01-001 Low Raymond & Irene 1010 Anza Apts 1010 Anza St San Francisco 1 CA 1 94118 6 06/20/1974   06/20/1974   16 Calafia Ct San Rafael 20 94903 69 CA 7210-7219 9 Accommodations 9 0 0     1 6 Inner Richmond 21   1010 ANZA ST San Francisco, CA 94118 (37.779321, -122.459087)
4009 0098799-01-001 Mart Bkd Llc Rodeway Inn 101 9th St San Francisco 1 CA 1 94103 25 04/01/1976   04/01/1976 12/10/2014 101 9th St San Francisco 1 94103 32 CA 7210-7219 9 Accommodations 9 0 0     6 3 South of Market 15   101 9TH ST San Francisco, CA 94103 (37.77601, -122.414455)
4135 0036433-02-001 Hom Samuel Lee & Myrna Kin 217 15th Av Apts 217 15th Ave San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   370 15th Av San Francisco 1 94118 28 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   217 15TH AVE San Francisco, CA 94118 (37.78396, -122.474222)
4165 0036478-01-001 Gwilliam Arthur 2199 Pacific Ave Apts 2199 Pacific Ave San Francisco 1 CA 1 94115 4 10/01/1968   10/01/1968   66 Allen Street, Apt# 5 New York 49 10002 331 NY 7210-7219 9 Accommodations 9 0 0     2 Pacific Heights 16   2199 PACIFIC AVE San Francisco, CA 94115 (37.793792, -122.431236)
4622 0053365-01-001 Reininga Corp Reininga Corp 456 Montgomery St 1000 San Francisco 1 CA 1 94104 1 07/01/1969   01/01/2006   Po Box 3089 Greenwood Village 250 80155 357 CO 7210-7219 9 Accommodations 9 0 0     3 1 Financial District/South Beach 1   456 MONTGOMERY ST San Francisco, CA 94104 (37.793425, -122.4029)
4664 0032200-01-001 Marine Memorial Assn Marine Memorial Assn 609 Sutter St San Francisco 1 CA 1 94102 16 01/01/1977   01/01/1977   609 Sutter St, Suite 2m San Francisco 1 94102 16 CA 7210-7219 9 Accommodations 9 0 1 D03 D04 H73 P23 Multiple 3 1 Nob Hill 17   609 SUTTER ST San Francisco, CA 94102 (37.788991, -122.410533)
4674 0032200-01-002 Marine Memorial Assn Marine Memorial Assn 609 Sutter St San Francisco 1 CA 1 94102 16 01/01/1977   01/01/1977   609 Sutter St, Suite 2m San Francisco 1 94102 16 CA 7210-7219 9 Accommodations 9 0 0 H26 H86 Multiple 3 1 Nob Hill 17   609 SUTTER ST San Francisco, CA 94102 (37.788991, -122.410533)
4690 0036873-01-001 Michael And Stven Pera 2301 Polk St Apts 2301 Polk St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   2301 Polk St 1 San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 0     3 1 Russian Hill 5   2301 POLK ST San Francisco, CA 94109 (37.798035, -122.422204)
4796 0032249-01-001 Wong Kai 1136 Kearny Apts 1136 Kearny St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1136 Kearny St San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 0     3 1 North Beach 6   1136 KEARNY ST San Francisco, CA 94133 (37.79855, -122.405562)
4816 0146342-01-001 Huey King J & Sam Etal 269 4th Av Apts 269 4th Ave San Francisco 1 CA 1 94118 6 01/01/1984   01/01/1984   924 Judah St San Francisco 1 94122 15 CA 7210-7219 9 Accommodations 9 0 0     1 6 Inner Richmond 21   269 4TH AVE San Francisco, CA 94118 (37.783606, -122.462323)
4832 0076715-02-001 Kleinen Rae E 683 21st Av Apts 683 21st Ave San Francisco 1 CA 1 94121 15 10/01/1968   06/10/1971   685 21st Ave San Francisco 1 94121 17 CA 7210-7219 9 Accommodations 9 0 0     1 6 Outer Richmond 9   683 21ST AVE San Francisco, CA 94121 (37.774883, -122.480071)
4851 0076720-01-001 Ng Fu Kwock & Y-Chao Peter & 4727 California Apts 4727 California St San Francisco 1 CA 1 94118 6 09/08/1971   09/08/1971   4727 California St San Francisco 1 94118 28 CA 7210-7219 9 Accommodations 9 0 0     1 6 Inner Richmond 21   4727 CALIFORNIA ST San Francisco, CA 94118 (37.784644, -122.468295)
4901 0053761-01-001 Ellen Lowenthal 28-38 Harwood Apts 28 Bob Kaufman Aly San Francisco 1 CA 1 94133 11 10/01/1968   02/13/2002   21602 Villa Maria Ct Cupertino 68 95014 108 CA 7210-7219 9 Accommodations 9 0 0     3 1 North Beach 6   28 BOB KAUFMAN ALY San Francisco, CA 94133 (37.801416, -122.407443)
5154 0318727-01-001 Yatsu Nami Housing Inc Yatsu Nami Housing Inc 1911 Bush St San Francisco 1 CA 1 94115 4 01/01/1972   01/01/1972   1911 Bush St #2a San Francisco 1 94115 2 CA 7210-7219 9 Accommodations 9 0 0     5 7 Pacific Heights 16   1911 BUSH ST San Francisco, CA 94115 (37.787595, -122.42898)
5203 0019920-02-001 Cole Dennis Et Al 900 Franklin Blvd 900 Franklin St San Francisco 1 CA 1 94109 24 06/30/2004   06/30/2004   219 Lucas Park Dr San Rafael 20 94903 69 CA 7210-7219 9 Accommodations 9 0 0           900 FRANKLIN ST San Francisco, CA 94109 (37.78291, -122.42252)
5217 0019921-01-001 Sf Pacifica Inc 1301 La Playa Apts 1301 Laplaya St San+francisco 8 CA 1 94122 19 10/01/1968 07/29/2016 09/29/2007 07/29/2016         7210-7219 9 Accommodations 9 0 0           1301 LAPLAYA ST San Francisco, CA 94122 (37.761207, -122.509201)
5223 0019921-02-002 Sf Pacifica Inc Great Highway Motor Inn 1234 Great Hwy San Francisco 1 CA 1 94122 19 10/01/1968 07/29/2016 10/01/1968 07/29/2016         7210-7219 9 Accommodations 9 0 0     4 10 Sunset/Parkside 14   1234 GREAT HWY San Francisco, CA 94122 (37.763074, -122.509729)
5229 0019926-02-001 Royal Pacific Motel Royal Pacific Motor Inn 661 Broadway San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   661 Broadway San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 1     3 1 Chinatown 7   661 BROADWAY San Francisco, CA 94133 (37.797721, -122.407848)
5253 0064458-01-001 Boschetti Paul 508 Octavia Apts 508 Octavia St San Francisco 1 CA 1 94102 16 10/04/1989   10/30/1992   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     5 7 Hayes Valley 10   508 OCTAVIA ST San Francisco, CA 94102 (37.776917, -122.424693)
5257 0032543-02-001 Chiao Johnson L & Diane W 1215 Bay Apts 1215 Bay St San Francisco 1 CA 1 94123 3 01/01/1968   01/01/1968   Po Box 641756 San Francisco 1 94164 132 CA 7210-7219 9 Accommodations 9 0 0     2 Marina 2   1215 BAY ST San Francisco, CA 94123 (37.803903, -122.427068)
5260 0064458-03-001 Boschetti Paul 156 Central Apts 156 Central Ave San Francisco 1 CA 1 94117 33 10/04/1989   06/17/1971   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     5 7 Haight Ashbury 32   156 CENTRAL AVE San Francisco, CA 94117 (37.771077, -122.443779)
5264 0032543-03-001 Chiao Johnson L & Diane W 1991 California Apts 1991 California St San Francisco 1 CA 1 94109 24 01/01/1968   05/01/1974   Po Box 641756 San Francisco 1 94164 132 CA 7210-7219 9 Accommodations 9 0 0     2 Pacific Heights 16   1991 CALIFORNIA ST San Francisco, CA 94109 (37.789777, -122.427021)
5275 0092934-01-001 Kubein Bishara 919 Sutter Apts 919 Sutter St San Francisco 1 CA 1 94109 24 04/18/1975   04/18/1975   1344 Palos Verdes San Mateo 32 94403 58 CA 7210-7219 9 Accommodations 9 0 0     3 1 Nob Hill 17   919 SUTTER ST San Francisco, CA 94109 (37.788351, -122.41552)
5277 0064458-07-001 Boschetti Paul 1419 Fulton Apts 1419 Fulton St San Francisco 1 CA 1 94117 33 10/04/1989   08/29/1980   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     5 7 Hayes Valley 10   1419 FULTON ST San Francisco, CA 94117 (37.776621, -122.44013)
5279 0092947-01-001 Patel Enterprises Delbex Hotel 2126 Mission St San Francisco 1 CA 1 94110 18 04/01/1975 06/30/2016 04/01/1975 06/30/2016         7210-7219 9 Accommodations 9 0 0     9 8 Mission 12   2126 MISSION ST San Francisco, CA 94110 (37.762908, -122.419475)
5292 0064458-08-001 Boschetti Paul 322-330 Eddy Apartments 322 Eddy St San Francisco 1 CA 1 94102 16 10/04/1989   04/04/1983   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   322 EDDY ST San Francisco, CA 94102 (37.783868, -122.413129)
5316 0064458-09-001 Boschetti Paul 471 Ellis Apartments 471 Ellis St San Francisco 1 CA 1 94102 16 10/04/1989   05/08/1985   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   471 ELLIS ST San Francisco, CA 94102 (37.784736, -122.413869)
5324 0064458-10-001 Boschetti Paul 222 Leavenworth Apartments 222 Leavenworth St San Francisco 1 CA 1 94102 16 10/04/1989   06/29/1988   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   222 LEAVENWORTH ST San Francisco, CA 94102 (37.783172, -122.414138)
5331 0064458-11-001 Boschetti Paul 355 Eddy Apartments 355 Eddy St San Francisco 1 CA 1 94102 16 10/04/1989   03/21/1980   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     6 3 Tenderloin 11   355 EDDY ST San Francisco, CA 94102 (37.783823, -122.413485)
5370 0064458-13-001 Boschetti Paul 257-263 Pierce Apts 257 Pierce St San Francisco 1 CA 1 94117 33 10/04/1989   01/01/1988   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     5 7 Haight Ashbury 32   257 PIERCE ST San Francisco, CA 94117 (37.772489, -122.433911)
5374 0064458-14-001 Boschetti Paul 815 Page St Apts 815 Page St San Francisco 1 CA 1 94117 33 10/04/1989   11/25/1977   955 Prague St San Francisco 1 94112 20 CA 7210-7219 9 Accommodations 9 0 0     5 7 Haight Ashbury 32   815 PAGE ST San Francisco, CA 94117 (37.772538, -122.434595)
5382 0146790-01-001 Beeson Lynne 4533-4535 California Apts 4533 California St San Francisco 1 CA 1 94118 6 01/01/1984   01/01/1984   4535 A California St San Francisco 1 94118 28 CA 7210-7219 9 Accommodations 9 0 0     1 6 Inner Richmond 21   4533 CALIFORNIA ST San Francisco, CA 94118 (37.784787, -122.466185)

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