BELLEROSE [Permits for BELLEROSE]

251 - 280 of 280


BURREN ENTERPRISES CO., INC.

Business

Inactive



JESUS E GONZALEZ

Business

Active


SURGE INC

Business

Inactive


SAHEET CONSTRUCTION CORP.

Business

Active


ARCHTON INC

Business

Active


JAI HIND ENTERPRISES, INC.

Business

Active



RMS GARAGE DOORS, INC.

Business

Active



WANG'S STATIONERY, INC.

Business

Active


ELIM DELI & GROCERY

Business

Active


K&C DELI INC.

Business

Inactive



MYK INDUSTRIES LLC

Business

Inactive




NOORI CONSTRUCTION CORP

Business

Active


BRR RESTORATION CORP

Business

Active


MYK INDUSTRIES LLC

Business

Active



LUCKY FOOD MART, INC.

Business

Inactive



MODEL DRY CLEANER

Business

Inactive




LVL GROUP, INC.

Business

Active


SSP GEN CONTRACTING CORP

Business

Active


GO GREEN DIRECT INC.

Business

Active


(default) 2 queries took 954 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 ( '(+BELLEROSE)' IN BOOLEAN MODE) LIMIT 250, 503030525
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+BELLEROSE)' IN BOOLEAN MODE)11429