GLENDALE [Permits for GLENDALE]

501 - 544 of 544

EJP CONTRACTING CORP.

Business

Active


STEWART, GEORGE

Business

Active




FAMILY DOLLAR STORE #6437

Business

Inactive


CANELO & CARMYNE GROCERY CORP.

Business

Inactive


Stop & SHOP #539

Business

Active



SEQUOIA CONCEPTS, INC

Business

Inactive


CORONA JEWELERS, INC.

Business

Inactive


HOAS DELI & GROCERY INC

Business

Active


NACCO HVAC INC.

Business

Active



AT&T GET CONNECTED

Business

Inactive



R.A.B. CONSTRUCTION CORP.

Business

Active


DELI-LICIOUS DELICATESSEN

Business

Active


G.O.D. FIRST DELI CORP.

Business

Active


C.F.C. CONTRACTING CORP.

Business

Active


EMPIRE BUYERS

Business

Active


GLENDALE 5966, INC.

Business

Inactive



61ST STREET GROCERY INC.

Business

Inactive


SELMANI BROTHERS INC.

Business

Active


SHIVAUM GROCERY STORE, INC.

Business

Active


YBD UNIVERSAL CORP

Business

Active


EURO HOME

Business

Active


LANCER CONSTRUCTION CORP.

Business

Active


HOME DELI & CATERING CORP.

Business

Active


MG PETROLEUM, INC

Business

Active


BAY CARPET

Business

Active


FOREST PARK SERVICE, INC.

Business

Inactive



DECOR RENOVATIONS INC.

Business

Inactive


SPLENDID CONSTRUCTION INC.

Business

Inactive


GLENDALE LAUNDRY INC

Business

Inactive


NSA SUPERMARKETS

Business

Active


69-21 MINI MARKET, INC.

Business

Active


RENI-NICOLE CONTRACTING CORP.

Business

Inactive


CENTER GOOD FOODS, INC.

Business

Inactive


AUGUSTA CONSTRUCTION, INC.

Business

Active


MPS MOBILE PHONES INC.

Business

Active


M G CONSTRUCTION

Business

Active


MAGIC PAINTING INC.

Business

Inactive


(default) 2 queries took 532 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 500, 504444245
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)11287