NEW HYDE PARK [Permits for NEW HYDE PARK]

151 - 200 of 359

REID, DESMOND I

Individual

Active


SRAN, SUKHWANT

Individual

Active


YELLIN, LAWRENCE M

Individual

Active


WOODCRAFT FLOORS, INC.

Business

Active


EHRET, MICHAEL J

Individual

Active


SKYLARK CONSTRUCTION CORP.

Business

Active



Barry I Siegel Esq

Business

Active


MALLILO, RONALD

Individual

Inactive


MANNION, FRANK M

Individual

Active



ALLBRITE INTERIORS INC.

Business

Active


ISURPLY LLC

Business

Active


DAMARI, YIZHAR

Individual

Active


LOPEZ, ROSA M

Individual

Active


NEW YORK O&P ASSOCIATES, LLC

Business

Inactive


USA 2 CONSTRUCTION, INC

Business

Active


NORTH EAST STONES INC.

Business

Active


STAR IRON WORKS INC.

Business

Active


BALASINGAM, BALACHANTHIRAN

Individual

Active


Domeny, Jozsef

Individual

Active


MATHEWS, JIJU

Individual

Active


RAHI, IMTIAZ A

Individual

Active


KAUR, RAVINDER

Individual

Active



SINGH, JASWANT

Individual

Active


TELA CONTRACTING CORP.

Business

Active


MEDALLION SECURITY DOOR

Business

Active


CASTLE INDUSTRIES, INC.

Business

Active


SINGH, SIMARJEET

Individual

Inactive




KUREK, ZELJKO

Individual

Active


GUJRAL, TEJINDER

Individual

Active


LICARI, ALESSANDRO

Individual

Active


COPPOLINO, STEVEN

Individual

Active


CONSTANTIN, NANU

Individual

Active



PRECISION MASTER INC.

Business

Active


JOHN ALVAREZ CORP.

Business

Active



DZIOMBA, EUGENE

Individual

Inactive


RAMNARAIN, SAISNARAINE

Individual

Active


KAMBOURAS, ELLI

Individual

Active


LAPINSKI, ANDREW J

Individual

Active


HECKLER, BRIAN

Individual

Active


GCP CONSTRUCTION INC

Business

Active


GE, XUDONG

Individual

Active


ZHAO, YUNTONG

Individual

Active


RUSSO, JOHN S.

Individual

Active


(default) 2 queries took 345 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 ( '(+NEW +HYDE +PARK)' IN BOOLEAN MODE) LIMIT 150, 50505078
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+NEW +HYDE +PARK)' IN BOOLEAN MODE)11267