UNIONDALE [Permits for UNIONDALE]

1 - 50 of 61

HERNANDEZ, LUIS A

Individual

Active


MANDERSON & ASSOCIATES INC

Business

Active


EZEANI, LAWERENCE O

Individual

Active


PALENCIA, OSCAR D

Individual

Inactive


NAVARRETE, ANTONIO

Individual

Active


NOBREGA, DAVID

Individual

Active



POOLE, ELEANOR V

Individual

Active



GORDON, EDWARD M

Individual

Inactive


CORAISACA, JAIME

Individual

Active


GELBER, MICHAEL S

Individual

Active


MORALES, OSCAR

Individual

Inactive


S.A.J. DEVELOPMENT INC.

Business

Active


A PLUS FENCES

Business

Active




REYES AGUILERA, JOSE

Individual

Active


MOOR, RONALD

Individual

Active



JAMES, KERRY

Individual

Inactive


ERWIN-JONES, MARK

Individual

Inactive


Zuniga, Jonathan

Individual

Active


BARNES, JR. DAVID

Individual

Inactive


SHATARA, ELHAM I.

Individual

Active


MARTINEZ, JOSE

Individual

Active


V & O MONTALVAN FENCE CORP

Business

Active


SHARINN & LIPSHIE, P.C

Business

Active


RECINOS, FERNANDO

Individual

Inactive


BURNETT, TASHA

Individual

Inactive


REID, GEORGE

Individual

Active


GARCIA, OSCAR

Individual

Active


DOORN, ANDREW

Individual

Active


ARITA, EDGAR

Individual

Active


ALLWOOD, CLAYTON R

Individual

Active


DOCUSERVE INC

Business

Inactive


L JR HOME IMPROVEMENTS CORP

Business

Active


AMARO, NATHANIEL M

Individual

Active


JF CONSTRUCTION

Business

Inactive


JAMES HOME IMPROVEMENT

Business

Active


LEWIS, SHERWIN

Individual

Active


GONZALEZ, LUIS

Individual

Inactive



MARTINEZ, JOSE

Business

Active


JCA CONTRACTING CORP.

Business

Active


WILLIAMS, LEONARD R

Individual

Active


SHATARA, ELHAM I.

Individual

Inactive


DELPESHE, CHRISTOPHER

Individual

Active


J C JUNK REMOVAL, CORP.

Business

Inactive


JAMES, ALRICKO DECOSTA

Individual

Inactive


(default) 2 queries took 305 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 ( '(+UNIONDALE)' IN BOOLEAN MODE) LIMIT 50505090
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+UNIONDALE)' IN BOOLEAN MODE)11215