VALLEY STREAM [Permits for VALLEY STREAM]

251 - 300 of 410

BILTMORE CONTRACTING INC

Business

Active


XTREME CONCEPTS

Business

Inactive



ZUCCARO, JOSEPH

Individual

Active



ANWAR, NADEEM

Individual

Active



BEST ENERGY POWER LLC

Business

Inactive



SINANAN, VASHA

Individual

Active


DELAPENHA, HORACE

Individual

Active


Alpha Care Supply

Business

Active



UPPAL REMODELING INC.

Business

Active


NUMA, HARRY

Individual

Inactive


RED ROCK SPECIALTY CORP

Business

Inactive


BLAKE, DIANNA

Individual

Inactive


KENNEDY, EDWIN PETER

Individual

Inactive


BREDICE, CRISTIAN N

Individual

Active


A TEAM CONTRACTING

Business

Active


SANTAMARIA, MANUEL A

Individual

Active


CRUZ MALTEZ, JOSE N

Individual

Active


N.U.S. CONSTRUCTING CO

Business

Inactive


PADAVAN, JAMES

Individual

Active


GAOGUI LEASING CORP

Business

Active


STRIDE BUILDERS CORP

Business

Active


COSTA, JUAN J

Individual

Inactive


PAL, DAVINDER

Individual

Active


MANGAL, RAKESH

Individual

Active


JGL CONTRACTING CORP.

Business

Active


CHATTA, UMAR

Individual

Active


PINARD SR, JOHN

Individual

Inactive


STEWART, MICHAEL

Individual

Inactive



BERMEO, AIDA

Individual

Active


ALFIERI, ANTHONY

Individual

Active


TRADEWELL CONSTRUCTION INC.

Business

Active


MERCADO, JOSEPH

Individual

Inactive


TRETIN, SANDRA

Individual

Active


NORMAN, WILLIAM B

Individual

Active


PINTO, DJALMA

Individual

Active


SINGH, GURPREET

Individual

Active


VASQUEZ, RONALD

Individual

Active


MAGNONI, RENATA

Individual

Active


JAMIESON, DALTON A

Individual

Active


SINGH, URMILLA

Individual

Active


FERNANDEZ, PERCY L

Individual

Inactive





(default) 2 queries took 304 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 ( '(+VALLEY +STREAM)' IN BOOLEAN MODE) LIMIT 250, 50505081
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+VALLEY +STREAM)' IN BOOLEAN MODE)11223