MASPETH [Permits for MASPETH]

351 - 400 of 745

MASPETH EXPRESS MINIMART INC

Business

Inactive


A1 LAUNDROMAT

Business

Active


SYRENA GROCERY INC.

Business

Active


MALWOOD CRAFTS LLC

Business

Active



CHELSEA CONSTRUCTION LLC

Business

Inactive


QING QING LAUNDROMAT INC

Business

Active


NELJOS CONSTRUCTION INC

Business

Active


CVS PHARMACY #5773

Business

Inactive


GAUGE CONTRACTING CORP.

Business

Active


PRAGAT FARM, INC.

Business

Active



BIPI ELIOT NY INC

Business

Active


Choe's Cleaners

Business

Active


301 LAUNDROMAT INC.

Business

Active


Second Stroke LLC

Business

Active


FALAHERN CORP

Business

Active


RENOVATION WITH PASSION INC

Business

Active


APT WIRELESS

Business

Inactive


69-GRAND CORPORATION

Business

Inactive


EXECUTIVE TRUCK SALES, INC

Business

Inactive


D & D1 CORPORATION

Business

Active


FRIENDZ DELI & GROCERY INC

Business

Inactive





ADT GENERAL CONTRACTING LLC

Business

Inactive


TIMELINE RENOVATIONS INC.

Business

Active


FROST CONTRACTORS CORP.

Business

Active


ROOFUS RESTORATION LLC

Business

Active


OLYMPIC THREE INC.

Business

Active


MASPETH MIXIT MART

Business

Active


MASPETH DRY CLEANERS

Business

Inactive


DLUX CAFE

Business

Active


SEMA RESTORATION, CORP

Business

Active


MARAN CLEANERS

Business

Active


W. J. CONTRACTING CORP.

Business

Active


MIDDLE VILLAGE FARM, INC.

Business

Inactive


C/ZONE INC.

Business

Active



CITY LANDLORD SERVICE

Business

Active


VIP AUTO BODY, INC

Business

Active



ZOR CONSTRUCTION CORP.

Business

Active


NEW PJ'S CORP

Business

Active


A.W.P. CORPORATION

Business

Active



A-PART AUTO SALVAGE, INC.

Business

Inactive


R & JP BUILDERS INC

Business

Active


ORZEL SERVICES LLC

Business

Inactive


(default) 2 queries took 387 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 350, 505050140
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)11247