USBusinessLookup.com
Menu

Business location

Seahorse Aquarium

This listing describes a business location. Location dates are not company formation dates.

Record reference date: October 18, 2026. Details may be incomplete or outdated.

Record type
Business location
Record identifier
1393514-07-251-0459123
Status
Location Ended
City
San Francisco
State or territory
California
Address
1377 31st Ave
Postal code
94122
Location start
July 1, 2025
Location identifier
1393514-07-251-0459123
Ownership name (as reported)
Yu Tammy Q
DBA name
Seahorse Aquarium
Location end (reported value)
07/01/2025

Names and reported roles

Roles are shown as reported. Agents, officers and principals are not automatically owners.

Business names

DBA name
Seahorse Aquarium

Ownership names (as reported)

Ownership name (as reported)
Yu Tammy Q

Download business record (JSON)

Directory details

Identifiers

Business Account
0459123
Location
1393514-07-251

Names

Ownership As Reported
Yu Tammy Q
Dba
Seahorse Aquarium

Addresses

Business · Text
1377 31st Ave
Business · City
San Francisco
Business · Region
CA
Business · Postal Code
94122
Mailing · Street 1
18958 Santa Maria Ave
Mailing · City
Castro Valley
Mailing · Region
CA
Mailing · Postal Code
94546

Dates

Business Start
2011-06-01
Location Start
2025-07-01
Location End
2025-07-01

Industry

Naics Code
81

Taxes

Parking Tax Reported
No
Transient Occupancy Tax Reported
No

Geography

Reported Point
{"longitude":-122.4900405,"latitude":37.76166}
Supervisor District
4
Neighborhood
Sunset/Parkside

All reported fields

Other reported details

Uniqueid
1393514-07-251-0459123
Certificate number
0459123
Ttxid
1393514-07-251
Dba start date
06/01/2011
Parking tax
false
Transient occupancy tax
false
Supervisor district
4
Neighborhoods analysis boundaries
Sunset/Parkside
Data as of
2026/10/18 12:00:00 AM
Data loaded at
2026/10/18 04:12:51 AM
Current Supervisor Districts
7
Analysis Neighborhoods
35
Neighborhoods
39
SF Find Neighborhoods
39
Current Police Districts
10

Names and reported roles

Ownership name (as reported)
Yu Tammy Q
Dba name
Seahorse Aquarium

Addresses and locations

Full business address
1377 31st Ave
City
San Francisco
State
CA
Business zip
94122
Location start date
07/01/2025
Location end date
07/01/2025
Location
POINT (-122.4900405 37.76166)

Mailing information

Mailing address 1
18958 Santa Maria Ave
Mail city
Castro Valley
Mail state
CA
Mail zipcode
94546

Industry and classification

Self reported naics code
81

Request a correction or removal · Search public records