GLENDALE [Permits for GLENDALE]

351 - 400 of 544

DOLLAR GENERAL STORE# 19222

Business

Active



MYRTLE SUPERWASH

Business

Inactive


MORENZONI CONSTRUCTION LLC

Business

Active


K DRY CLEANERS

Business

Active






ENZO'S HOME IMPROVEMENT CORP.

Business

Inactive



HIGH RISE GENERAL CONSTRUCTION

Business

Inactive


MYRTLE AVENUE TRADING LLC

Business

Active


KAPOS AUTO REPAIR

Business

Active


R & I RESTORATION CORP.

Business

Inactive


THREE W ENTERPRISES INC

Business

Active


LAUNDROMAT

Business

Active


SAM'S DELI

Business

Active



PROMSUN, LLC

Business

Active


PAYLESS LAUNDRY SERVICE INC.

Business

Inactive


AAA GOLDEN LAUNDROMAT INC

Business

Active


RX PLUS PHARMACY

Business

Active


CYPRESS EXPRESS DELI INC.

Business

Active


FLOWERS BY SANCHEZ

Business

Active


MAESTRO DESIGN/BUILD CORP

Business

Active


HARI'S FOOD MARAT

Business

Inactive


MARTY'S HOME REPAIR LLC

Business

Active


SCHUMACHER'S

Business

Active


NEW GRAND LAUNDROMAT INC

Business

Active



STANDARD PARKING CORPORATION

Business

Inactive


ROMA DELI, CORP.

Business

Active


D & A Interiors Corporation

Business

Active


RADIOSHACK STORE #2623

Business

Inactive



A.R. WOODWORKING, INC.

Business

Inactive


AK CONTRACTING CORP.

Business

Active


ACTION GLASS CO. INC.

Business

Active


L&A GOURMET DELI, INC.

Business

Inactive



ARMATO'S PHOTO SERVICES, INC.

Business

Inactive


ATLAS NEWS

Business

Active


SIGAL HOME IMPROVEMENT CORP

Business

Active


HOME DEPOT STORE #1220

Business

Active


COOPER PETROLEUM INC

Business

Inactive


BENROCK SALES, LLC

Business

Inactive


SUPERIOR GRILL & DELI INC.

Business

Inactive


Hess Express #32507

Business

Inactive


CAPNCAZ LAUNDRY, INC.

Business

Inactive


(default) 2 queries took 564 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 ( '(+GLENDALE)' IN BOOLEAN MODE) LIMIT 350, 505050246
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+GLENDALE)' IN BOOLEAN MODE)11318