CENTRAL VLY [Permits for CENTRAL VLY]

251 - 300 of 412


GRAHAM CENTRAL CAFE LTD.

Business

Inactive








REAL ESTATE ADVENTURES LLC

Business

Inactive



CENTRAL AUTO GLASS, INC.

Business

Active


HAVANA CENTRAL AT THE WEST END

Business

Inactive






CENTRAL P BUYERS

Business

Inactive


CENTRAL AUTO INC.

Business

Active


A & M PARKING LOT

Business

Inactive


CENTRAL FOOD OF NY CORP.

Business

Inactive


LUNA PARK

Business

Active


LUNA PARK

Business

Active











LUNA PARK

Business

Active






ASTORIA CENTRAL PARKING LLC

Business

Active










973 CENTRAL CLEANER CORP

Business

Active






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