SYOSSET [Permits for SYOSSET]

51 - 89 of 89

BROWNE, GLORIA

Individual

Active


DORIA, JOSEPH

Individual

Active


CHITE, ROBERT T

Individual

Active


KIM, SUNG H

Individual

Active


GENERAL CONTRACTING

Business

Active


SUN, QIANG

Individual

Inactive


SIMMONS, JEFF A

Individual

Active


PALLADINO, ALBERT

Individual

Active


LINDEN REMODELING CORP.

Business

Active


LAKHI GENERAL CONTRACTOR

Business

Active


INNAMORATO, THOMAS J.

Individual

Inactive


BISTAKIS, MARKO

Individual

Active


RAMIREZ, JORGE A

Individual

Active


EPIX PROPERTIES INC

Business

Active


MICHAEL ALBANO CORP.

Business

Active


RAGIN, GARY

Individual

Active


BENKIN, RONNY

Individual

Inactive


RUKIN, AARON T

Individual

Active


YOUNUS, ABDULLAH

Individual

Inactive


HORNIK, STUART

Individual

Active


1 DAY WALL INC.

Business

Active


KIM, HYUNIL

Individual

Active


MULLAN, DANIEL

Individual

Active


TOTAL RESTORATION, INC.

Business

Active


SINGH, GURCHARAN

Individual

Active


GIL, HENRY

Individual

Active


ECONOMOU, STEPHAN N.

Individual

Inactive


EISEN, RICHARD, H

Individual

Inactive


ECONOMOU, STEPHAN N.

Individual

Active


Spartan Medical Supply Corp

Business

Active


SKY HOMES MANAGEMENT CORP.

Business

Active


HORNIK, MATTHEW

Individual

Active


WONG, KWAN K

Individual

Active


TROY HOME IMPROVEMENT INC

Business

Active




RJM ACQUISITIONS FUNDING LLC

Business

Inactive


CLASS A HOMES, INC.

Business

Inactive


ADDED DIMENSIONS

Business

Inactive


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