LAFAYETTE [Permits for LAFAYETTE]

1 - 27 of 27

LAFAYETTE SUPER LAUNDROMAT INC

Business

Inactive


NEXT CLEANERS

Business

Inactive


CAFE SELECT

Business

Active


Singleton, Joseph

Individual

Active


LAFAYETTE, ELIZABETH

Individual

Active


GROSS, LAFAYETTE

Individual

Inactive


COMPTON, LAFAYETTE

Individual

Inactive


AGOSTO, YANIRA

Individual

Active


LAFAYETTE SMOKE SHOP

Business

Inactive


LAFAYETTE

Business

Active



PINCHE TAQUERIA

Business

Inactive


BOTTEGA FALAI

Business

Inactive




258-262 LAFAYETTE LLC

Business

Active


LAFAYETTE FOOD CENTER, INC.

Business

Inactive


ATLA LAFAYETTE LLC

Business

Active


159 LAFAYETTE AVE. FOOD CORP.

Business

Inactive


LUCKY LAUNDROMAT

Business

Active


HONEYBRAINS LAFAYETTE LLC

Business

Active


WASH & PLAY

Business

Active


LAFAYETTE PLACE PARKING LLC

Business

Active


403 LAFAYETTE LLC

Business

Active




NEXT @ LAFAYETTE, INC.

Business

Active


(default) 1 query took 329 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 ( '(+LAFAYETTE)' IN BOOLEAN MODE) LIMIT 502727329