NEW HYDE PARK [Permits for NEW HYDE PARK]

351 - 359 of 359


BLOOM CONSTRUCTION, INC.

Business

Active


KANG CONSTRUCTION, INC.

Business

Inactive


PLEASANT CONSTRUCTION INC.

Business

Inactive


MUKTI 77 PETROLEUM INC

Business

Active


TWISTED TWISTER SLIDE

Business

Inactive


CHOCO CATERPILLAR

Business

Inactive


MCU AND ASSOCIATES LLC

Business

Inactive


MIGNON, GABRIELE

Business

Inactive


(default) 2 queries took 514 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 +HYDE +PARK)' IN BOOLEAN MODE) LIMIT 350, 5099290
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+NEW +HYDE +PARK)' IN BOOLEAN MODE)11224