GARFIELD [Permits for GARFIELD]

1 - 21 of 21

NOBOA, OTIS

Individual

Active


BOUATIA, BADR

Individual

Active


GREY, GARFIELD A

Individual

Active


FRANKELIS, PETER

Individual

Active


RODRIGUEZ, ENRIQUEZ

Individual

Inactive


CLEMENDORE, GARFIELD

Individual

Inactive


MCCUMMINGS GREEN, TINEKWA

Individual

Inactive


BROWNE, GARFIELD

Individual

Inactive




SANCHEZ CAMILO, JAIME

Individual

Inactive


DARIUSZ, KOWAL

Individual

Active



CLEMENDORE, GARFIELD

Individual

Active


THE GARFIELD GARAGE LLC

Business

Active


GARFIELD CONSTRUCTION

Business

Inactive


COMPUDOC

Business

Inactive


GARFIELD COLLISION CORP.

Business

Inactive


GARFIELD FARM MARKET INC.

Business

Inactive


GARCIA, MILDRED

Individual

Active


GARFIELD SERVICE GARAGE

Business

Inactive


(default) 1 query took 396 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 ( '(+GARFIELD)' IN BOOLEAN MODE) LIMIT 502121396