FLORAL PK [Permits for FLORAL PK]

251 - 261 of 261

GOLDEN INTERIORS INC

Business

Active


SUNNY IMPROVEMENT INC.

Business

Inactive


NYC FLORAL DECORATORS

Business

Inactive


FANTASIA FLORAL DESIGN

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive


BM VALUE CONSTRUCTION INC.

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive



NEW PAL CONSTRUCTION CORP.

Business

Inactive


WALLET RECOVERY LTD.

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive


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