LOS ANGELES [Permits for LOS ANGELES]

1 - 18 of 18

GUIAS Y ANGELES CORP.

Business

Inactive


Bastien, Edgar

Individual

Active



GLADSTONE, JAYSON

Individual

Active


HERNANDEZ, ANGELES

Individual

Active


GLADSTONE, JAYSON

Business

Active


CREMIN, DANA

Individual

Active


Bush, William

Individual

Inactive


Villarreal, Jason Colin

Individual

Active


PEARL, SANFORD

Individual

Active


COLLECTIVE SOLUTION, LLC

Business

Inactive


LEAVITT, JENNIFER

Individual

Active


GUIAS Y ANGELES CORP.

Business

Inactive


CECCARINI, CRISTINA

Individual

Active



THE BEST SERVICE CO., INC.

Business

Inactive


BIG COURTLANDT PAWN SHOP

Business

Inactive


ANGELES DELI GROCERY CORP

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 ( '(+LOS +ANGELES)' IN BOOLEAN MODE) LIMIT 501818211