MASPETH [Permits for MASPETH]

101 - 150 of 745

PINE NONFERROUS INC.

Business

Active


BORYK, JORDAN N

Individual

Active


EDWARDS, DAVID L

Individual

Active


Bekios Florists Inc.

Business

Active


Moya, Jhonny

Individual

Inactive


METRO-TECH ERECTORS CORP.

Business

Active


A&R COLLISION SPECIALISTS INC

Business

Inactive



Impressive AutoTowing Inc

Business

Inactive


HEALY, ENDA

Individual

Active


VIP AUTO RECOVERY, INC.

Business

Active


RODAS, KLEVER

Individual

Inactive


ROJAS, VICTOR

Individual

Inactive


VIP AUTO BODY, INC.

Business

Inactive


BREEN, KIERAN

Individual

Inactive


ESCALA, VANESSA

Individual

Active


AMERICAN TOWING SERVICE INC.

Business

Inactive


DJ'S TOWING NY INC

Business

Inactive


MASPETH HALL, INC.

Business

Active


Rivera, Michelle

Individual

Inactive


FAY, JAMES L

Individual

Active



LUCKY STATION INC.

Business

Inactive


Individual

Inactive


MCCORMACK, JOSEPH P

Individual

Inactive


MANNINO, CALOGERO

Individual

Active


ASAP TOWING INC.

Business

Inactive


Honey Deli & Grocery Inc

Business

Active


BIRSKI, LUKASZ

Individual

Active


ABBOTT, TIMOTHY P

Individual

Active


BARAN, ADAM

Individual

Active


PRYMAS CONTRACTING INC.

Business

Active


LAMBE, LUKE D

Individual

Active


ROMEJ, PAWEL

Individual

Active


AMERICAN AUTO BODY & RECOVERY

Business

Inactive


ALL AMERICAN AUTO BODY INC

Business

Inactive


USZYNSKI, RAFAL

Individual

Active


PIGNATELLI, VINCENTZO

Individual

Active


KAPUSNIAK, SLAWOMIR

Individual

Active


AAA NORTHEAST

Business

Inactive


UNITED BODY WORKS INC.

Business

Active


CZARNIAK, MARCIN C

Individual

Active



GIERLACHOWSKI, KRZYSZTOF

Individual

Inactive


TRUSZKOWSKI, DARIUSZ

Individual

Active


GUACHICHULCA, LUIS

Individual

Active



TONER, TARA

Individual

Active


LEE, SEUNGJUN

Individual

Inactive


MURRAY, HUGH

Individual

Active


(default) 2 queries took 273 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 100, 50505060
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)11213