MASPETH [Permits for MASPETH]

1 - 50 of 745

WALSH, JOSEPH

Individual

Active


POTOCKI, KRZYSZTOF

Individual

Inactive


DOBROWOLSKI, JESSICA

Individual

Inactive


PAN, ZI

Individual

Active


BRZUZAN, ROBERT

Individual

Active


DANKEL, PAUL

Individual

Active


LIPAROTO, FRANCESCO

Individual

Active


ROA, MARIA P

Individual

Inactive


ZAROWNY, JESSICA

Individual

Inactive


DUSHI, ELVIS

Individual

Active


AVILES, JOSHUA

Individual

Active


BIELEN, LUKASZ

Individual

Active


BYRUS, MICHAEL

Individual

Active


GUZMAN, IVAN

Individual

Active


MAHER, JOHN N

Individual

Inactive


A1 Laundromat

Business

Inactive


MEI, JAING HAY

Individual

Inactive



NIEVES, MARLENE

Individual

Active


GERONIMO, STEPHEN

Individual

Active


NEW FLUSHING LAUNDROMAT INC

Business

Inactive


301 LAUNDROMAT INC.

Business

Inactive



ZHI YING INC.

Business

Inactive


MASPETH DRY CLEANERS

Business

Inactive


LOPEZ, STEVEN

Individual

Active


CLEANING CONCEPT 88 CORP.

Business

Inactive


KWICK TOWING & RECOVERY INC

Business

Active


MARAN CLEANERS

Business

Inactive


SINGH, JASWANT

Individual

Inactive


FAY, JAMES L

Individual

Inactive


B & E LAUNDROMAT CENTER INC.

Business

Inactive


MCGEOWN, MICHAEL

Individual

Active


RIVERA, LUIS

Individual

Inactive


MERCADO, ROBERT

Individual

Active


QING QING LAUNDROMAT INC

Business

Inactive


CHRONOWSKI, MONIKA A

Individual

Inactive


PIECHOTA, ADAM W

Individual

Active


GRAND YI LI LAUNDRY INC.

Business

Inactive


FALANDYSZ, SLAWOMIR P

Individual

Active


PASTEWSKI, PIOTR

Individual

Active


ROBERTS, EDWARD A

Individual

Active


giugliano, serafino

Individual

Active


AQUA CLEAN LAUNDROMAT INC.

Business

Inactive


CITYSCAPES

Business

Inactive


KOWALSKI, ANDREW

Individual

Inactive


CLEANING CONCEPT 88 CORP.

Business

Inactive


DI LORENZO, CARMELO

Individual

Active


MASPETH FAMILY LAUNDROMAT INC

Business

Inactive


LAUNDRYXPRESS

Business

Inactive


(default) 2 queries took 226 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+MASPETH)' IN BOOLEAN MODE) LIMIT 50505016
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+MASPETH)' IN BOOLEAN MODE)11210