GLENDALE [Permits for GLENDALE]

451 - 500 of 544

ART STAIRS CORP

Business

Active


BETTERBUILT, LLC

Business

Inactive


MANNY BEST CONTRACTOR CORP.

Business

Active


GOLD DRAGON LAUNDROMAT INC

Business

Active


MING'S LAUNDROMAT INC.

Business

Active


METROPCS

Business

Active


JOSE T. NUNEZ REYES

Business

Active



MYRTLE OK FARM, INC.

Business

Inactive


MYRTLE GAS CORP.

Business

Active


NEW YORK DELI GROCERY

Business

Active


MRA FURNITURE DEPOT

Business

Inactive


BLUE DELI & GRILL, CORP.

Business

Active




PAYAMPS CONSTRUCTION INC

Business

Inactive


G AND D COMMUNICATION INC.

Business

Inactive


MACIEJ, WOZNIAK T

Business

Inactive


VICTORY DELI CORP.

Business

Active


GRAND DRY CLEANERS, INC.

Business

Inactive


NATIONAL ATTORNEY SERVICES LLC

Business

Inactive



VECCHIO CONSTRUCTION CORP.

Business

Active


MRA FURNITURE DEPOT

Business

Active


RIDGEWOOD MOTORCARS INC.

Business

Inactive


SHALER AVE LAUNDRY CENTER

Business

Active



PARKWAY LAUNDROMAT

Business

Active


JS MOTORS INC.

Business

Active


MARCELINO CONTRACTING

Business

Inactive


DOLLAR GENERAL STORE#19222

Business

Active


LENDERLIVE NETWORK, INC.

Business

Inactive


TANTILLO CONSTRUCTION

Business

Active


MR. JEWELRY & PAWN

Business

Inactive



GLOBE K CONSTRUCTION CORP

Business

Active


BAEZ MINI MARKET CORP.

Business

Inactive


JSSA CONTRACTING LLC

Business

Active



DOLLAR EXPRESS

Business

Inactive


PAYAMPS CONSTRUCTION

Business

Inactive



SUPERHEROS GRILL & GROCERY

Business

Inactive


COOPER ISLAND INC

Business

Inactive


CAPNCAZ LAUNDRY

Business

Active


INTERIORS BY AJ LTD.

Business

Active


MARCELINO CONTRACTING INC

Business

Active


GLENDALE LAUNDROMAT NY INC

Business

Inactive


LONG LIFE INTERIORS, INC.

Business

Active


Dollar Express

Business

Active


(default) 2 queries took 407 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 450, 505050198
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)11209