HILLSIDE [Permits for HILLSIDE]

51 - 61 of 61

HILLSIDE ELECTRONICS INC

Business

Active


A & R HILLSIDE AVENUE INC.

Business

Inactive


HILLSIDE MOTORS LLC

Business

Inactive


HILLSIDE AUTO REPAIR INC.

Business

Inactive


AW MOBILE OF HILLSIDE

Business

Inactive



FRANHILL DELI

Business

Inactive



HILLSIDE PHARMACY

Business

Active



HILLSIDE CANDY & GROCERY, INC.

Business

Inactive


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