NEW CASTLE [Permits for NEW CASTLE]

51 - 76 of 76

OLD CASTLE FRESH FARM CORP

Business

Active



GREEN CASTLE .A. MGMT CORP.

Business

Active


CASTLE OIL CORPORATION

Business

Inactive


ABDULLAH KOC

Business

Active



CASTLE HILL MINI MALL INC

Business

Active


EURO CASTLE CONSTRUCTION CORP.

Business

Inactive


CASTLE GOURMET DELI CORP

Business

Active



CASTLE HILL DRUGS INC.

Business

Inactive


CASTLE

Business

Inactive



5 IN 1 EXCALIBUR CASTLE COMBO

Business

Inactive


CASTLE SUPERMARKET CORP

Business

Inactive


NU CASTLE JEWELERS

Business

Active


CASTLE BEST DEAL CORP

Business

Inactive



MINI CASTLE COMBO

Business

Inactive


CASTLE BEST DEALS CORP

Business

Active


OLD CASTLE FRESH FARM CORP

Business

Active



CASTLE CONCEPTS NY, LLC

Business

Inactive


NU-CASTLE JEWELERS

Business

Active


BX CASTLE ENTERPRISES INC

Business

Active


CASTLE HILL CLOSEOUTS INC

Business

Active


(default) 2 queries took 739 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 ( '(+NEW +CASTLE)' IN BOOLEAN MODE) LIMIT 50, 502626456
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+NEW +CASTLE)' IN BOOLEAN MODE)11283