GREENLAWN [Permits for GREENLAWN]

1 - 17 of 17

TEJEGONLI CORP.

Business

Active


STELMACH, CEZARY

Individual

Active


RED ROCK CONSTRUCTION

Business

Active


CHRISTOPHER, ROY W.

Individual

Active


HIS NY2, INC.

Business

Active


Mule, Brett

Individual

Inactive


TAORMINA, MICHAEL

Individual

Active


COSKUN, YUNUS

Individual

Active


ARACO, JEFF V

Individual

Active


ILYAS, MUHAMMAD

Individual

Inactive


Bonilla, Fredis

Individual

Inactive


NUNEZ, JOSE

Individual

Active


SATRAN, MICHAEL

Individual

Inactive


MEJIA, JEREMIAS

Individual

Active


EALY, ANTHONY

Individual

Active



J.P.O. CONTRACTORS CORP.

Business

Active


(default) 1 query took 438 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 ( '(+GREENLAWN)' IN BOOLEAN MODE) LIMIT 501717438