MEXICO [Permits for MEXICO]

1 - 21 of 21


AROMA A MEXICO INC

Business

Inactive



NOVEDADES MEXICO

Business

Active





MEXICO VARIEDAD GROCERY

Business

Active


PLAZA MEXICO MINI MARKET CORP.

Business

Inactive



NCO FINANCIAL SYSTEMS, INC.

Business

Inactive





MI MEXICO FRUIT GROCERY CORP.

Business

Inactive


MEXICO TIRE SHOP CORP.

Business

Inactive


VIVA MEXICO TIRE SHOP CORP

Business

Active



MEXICO LINDO E/S/C #431

Business

Inactive



MESA COYOACAN

Business

Active


(default) 1 query took 211 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 ( '(+MEXICO)' IN BOOLEAN MODE) LIMIT 502121211