SCARSDALE [Permits for SCARSDALE]

51 - 100 of 101

TAHIRAJ, GZIM

Individual

Active


VALENTI, FRANK M

Individual

Active


LEBWOHL, ZACHARY

Individual

Active



PEJOVIC, BOBAN

Individual

Inactive


YETERIAN, SARKIS

Individual

Inactive


HH BUILDING SERVICES INC.

Business

Active


AVELLINO, JOSEPH

Individual

Active


RUSCIANO, ANTHONY

Individual

Inactive


PLAGOS, NICK

Individual

Active


HORNE, CHRISTOPHER A.

Individual

Active


HIGGINS, KEVIN

Individual

Active


TIEDT, ROBERT J.

Individual

Active


LING PING LTD.

Business

Inactive



PEJOVIC, BOBAN

Individual

Active


Galactic Construction

Business

Active


Chiltern Construction LLC

Business

Inactive


PARLATO, RONALD H

Individual

Active


RAFAJAC, GORDAN M

Individual

Active


LAU, CHUEN

Individual

Active


LEBWOHL, ZACHARY

Business

Active


Choi, KOON S

Individual

Active


WHITE, THOMAS

Individual

Inactive


GONCALVES, CELSO A

Individual

Active


Z-DAR CONTRACTING, INC.

Business

Active



STEPHEN MOON INC

Business

Active


NAC CONTRACTING CORP.

Business

Active


BAEZ, LEOPOLDO

Individual

Active


RIDULFO, BLAISE

Individual

Active


AVLONITIS, LEONIDAS

Individual

Active


FRANCIAMORE, GINA MARIA

Individual

Inactive


MAN, GEORGE

Individual

Inactive


P JOE CONSTRUCTION CORP.

Business

Active


MOON, STEPHEN

Individual

Inactive


BERGMAN, JACOB

Individual

Active


MR APPLIANCE OF SCARSDALE

Business

Active


SHARP END DESIGN CORPORATION

Business

Inactive


BLAISE CONSTRUCTION CORP.

Business

Active


LEONIDAS INTERIORS LLC

Business

Active


MAYFLOWER CONSTRUCTION

Business

Active



BINDELA CORP

Business

Inactive


SHELL BUILDERS CORP.

Business

Active


FRANK FRANCIAMORE, INC.

Business

Inactive


BYRNES, BRIAN

Individual

Active


BEIRNE ASSOCIATES, INC.

Business

Inactive



LEEWOOD CONTRACTING CORP.

Business

Active


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