MASPETH [Permits for MASPETH]

601 - 650 of 745

TAURUS CONSTRUCTION CORP.

Business

Inactive



MASPETH GRILL & DELI CORP

Business

Active


CARPLEX AUTOS, INC.

Business

Active


RODAS, KLEVER

Business

Inactive


TOMCHRIS CONTRACTING CORP.

Business

Active


ALL AMERICAN AUTO BODY INC

Business

Active


MARIA DELI 6404 INC.

Business

Inactive


RMD FLOORS, INC.

Business

Active



ONE RATE WIRELESS NYC, INC.

Business

Inactive


KOST & KOST ROOFING, LLC

Business

Active


LAUNDRY XPRESS

Business

Active



WASHRITE LAUNDROMAT

Business

Active


METROPOLITAN WINDOW CLEANING

Business

Inactive


PETRO, INC.

Business

Active


SECUR-A-DOOR, INC.

Business

Active



S.K. CONTRACTING, INC.

Business

Active


1 STOP DELI AND GROCERY CORP

Business

Inactive


GINA USA DELI AND GROCERY INC.

Business

Inactive


AK MART AND CONVENIENCE INC

Business

Active


MYRNA'S DELI, INC.

Business

Active



ALL AMERICAN AUTO BODY INC.

Business

Active




GIAMPAPA, FRANCESCO

Business

Inactive





MASPETH HALL

Business

Active


GIO TIRES INC

Business

Active



MR. RICO CONSTRUCTION CORP.

Business

Active


ON THE ROAD AGAIN

Business

Active


BLATTWORLD INC

Business

Active


REVIEW ENTERTAINMENT, INC.

Business

Inactive



PARUCHS LLC

Business

Inactive


REVIVE HOME IMPROVEMENTS

Business

Active


HEST CONSTRUCTION CORP

Business

Active


PL WINDOW SERVICE INC

Business

Active


BLACKWATER TILING

Business

Inactive


LAFYES

Business

Active


PROKAST CONSTRUCTION INC.

Business

Active


FG-PH CORP

Business

Inactive


EURO CASTLE CONSTRUCTION CORP.

Business

Inactive


GRAND AVE. PHARMACY, INC.

Business

Inactive


(default) 2 queries took 771 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 600, 505050358
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)11413