USBusinessLookup.com
Menu

Business location

Sfpuc Bruce Flynn Pump Station

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
1250145-04-201-1113499
Status
Location Ended
City
San Francisco
State or territory
California
Address
1595 Davidson Ave
Postal code
94124
Location start
March 30, 2020
Location identifier
1250145-04-201-1113499
Ownership name (as reported)
Melrose Metal Products, Inc.
DBA name
Sfpuc Bruce Flynn Pump Station
Location end (reported value)
04/28/2021

Names and reported roles

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

Business names

DBA name
Sfpuc Bruce Flynn Pump Station

Ownership names (as reported)

Ownership name (as reported)
Melrose Metal Products, Inc.

Download business record (JSON)

Directory details

Identifiers

Business Account
1113499
Location
1250145-04-201

Names

Ownership As Reported
Melrose Metal Products, Inc.
Dba
Sfpuc Bruce Flynn Pump Station

Addresses

Business · Text
1595 Davidson Ave
Business · City
San Francisco
Business · Region
CA
Business · Postal Code
94124

Dates

Business Start
2020-03-30
Business End
2021-04-28
Location Start
2020-03-30
Location End
2021-04-28

Taxes

Parking Tax Reported
No
Transient Occupancy Tax Reported
No

Geography

Reported Point
{"longitude":-122.391621,"latitude":37.745487}
Supervisor District
10
Neighborhood
Bayview Hunters Point

All reported fields

Other reported details

Uniqueid
1250145-04-201-1113499
Certificate number
1113499
Ttxid
1250145-04-201
Dba start date
03/30/2020
Dba end date
04/28/2021
Parking tax
false
Transient occupancy tax
false
Supervisor district
10
Neighborhoods analysis boundaries
Bayview Hunters Point
Data as of
2026/10/18 12:00:00 AM
Data loaded at
2026/10/18 04:12:51 AM
Current Supervisor Districts
9
Analysis Neighborhoods
1
Neighborhoods
56
SF Find Neighborhoods
56
Current Police Districts
2

Names and reported roles

Ownership name (as reported)
Melrose Metal Products, Inc.
Dba name
Sfpuc Bruce Flynn Pump Station

Addresses and locations

Full business address
1595 Davidson Ave
City
San Francisco
State
CA
Business zip
94124
Location start date
03/30/2020
Location end date
04/28/2021
Location
POINT (-122.391621 37.745487)

Request a correction or removal · Search public records