CENTRAL VLY [Permits for CENTRAL VLY]

201 - 250 of 412

CENTRAL RANGE SERVICE CORP.

Business

Active



CENTRAL HVAC SERVICES INC

Business

Inactive





CENTRAL CREDIT SERVICES, INC.

Business

Inactive



HI TECH CENTRAL AIR, INC

Business

Inactive












LUNA PARK

Business

Active





MAXXUM CONSTRUCTION CORP.

Business

Active



VICTORIAN GARDENS

Business

Inactive





1320 CENTRAL AVE CORP

Business

Active






MEYERS PARKING SYSTEM

Business

Inactive





Park West Cleaners II

Business

Active


313 CENTRAL DELI CORP

Business

Inactive


CENTRAL TIME CLOCK INC.

Business

Active





Central City Laundromat

Business

Active







(default) 2 queries took 401 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 200, 505050184
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)11217