CENTRAL VLY [Permits for CENTRAL VLY]

151 - 200 of 412



NY TIRE CENTRAL INC

Business

Active





LUNA PARK

Business

Inactive


CENTRAL FRESH MART INC.

Business

Active



VICTORIAN GARDENS

Business

Inactive





LUNA PARK

Business

Active









CENTRAL PARKING SYSTEM

Business

Active


VIT'S CORNER

Business

Active


SCREAM ZONE

Business

Active




Central Moving & Storage

Business

Active







BIKE CENTRAL PARK INC.

Business

Active





CENTRAL SUPER MARKET CORP.

Business

Inactive



VICTORIAN GARDENS

Business

Inactive




THE CYCLONE ROLLER COASTER

Business

Active


CENTRAL NYC

Business

Inactive


CENTRAL HARLEM GARAGE CORP.

Business

Active


BIKE RENTAL CENTRAL PARK

Business

Inactive




CARPETS & MORE

Business

Active




(default) 2 queries took 463 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 150, 505050232
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)11231