PHOENIX [Permits for PHOENIX]

51 - 70 of 70

PHOENIX SUTTON STR, INC.

Business

Active


FIFTH WHEEL PHOENIX LLC

Business

Active


PHOENIX REMODELING CORP

Business

Inactive


ACTION FINANCIAL IV, LLC

Business

Active


PHOENIX ANTIQUES

Business

Inactive



PHOENIX APPLIANCE INC

Business

Active


PHOENIX SEAFOOD INC

Business

Active


7 Eleven Store#35987A

Business

Inactive


PHOENIX REALTY GROUP, LLC

Business

Active


PHOENIX BUILDERS, INC.

Business

Active



NEW PHOENIX LAUNDROMAT CORP

Business

Active




PHOENIX CREDIT, L.L.C.

Business

Inactive



PHOENIX CONSTRUCTION

Business

Active


PHOENIX APPLIANCE INC

Business

Active


PHOENIX WIRELESS INC.

Business

Inactive


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