VALLEY STREAM [Permits for VALLEY STREAM]

51 - 100 of 410

CLASSICK CONSTRUCTION

Business

Inactive


SINGH, SUKHWINDER

Individual

Active



BEN RE-MODELING CORPORATION

Business

Inactive


GMP ENTERPRISES INC.

Business

Active


GIUBERGIA, ALEJANDRO

Individual

Active


FRUSCI, GERARD

Individual

Active


HOME CONSTRUCTION CORP.

Business

Active


PICHARDO, CARLOS M.

Individual

Active


SINGH, DROMATIE

Individual

Active


MAHI, AMRINDER

Individual

Active


RAM, GURDIAL

Individual

Active


M. MARIN RESTORATION, INC.

Business

Active


JP HANDA CONSTRUCTION INC

Business

Active


FELDMAN, DAVID P

Individual

Active


REYES, JUAN F

Individual

Inactive


KA HOME IMPROVEMENT NY INC

Business

Active


GREYLINE CONSTRUCTION CORP

Business

Active


KRAMER, ROBERT

Individual

Inactive



VISHAL, KUMAR

Individual

Active


HODGE, MARK H

Individual

Inactive


SUPER PRO CONTRACTING, INC.

Business

Active


RIEMENSCHNEIDER, JEFFREY S.

Individual

Inactive


PIPERNO, LEON

Individual

Active



Grunstein, steven

Individual

Active


AG REMODELING INCORPORATED

Business

Active


ROCKO'S CONSTRUCTION INC.

Business

Active



SANCHEZ, DOMINGO J.

Individual

Active


NY EMPIRE CONTRACTING CORP

Business

Active


LEAL, JOSE

Individual

Active


CAPPELLO, ERNEST M

Individual

Active


E&G INTERIOR CORP

Business

Active


SINGH, SARANJIT

Individual

Active


AVA CARE SUPPLY INC

Business

Active


EDWIN KENNEDY CORPORATION

Business

Active


singh, atinder

Individual

Active


AGM JUNK REMOVAL INC.

Business

Inactive


SUNRISE STREAM PETROLEUM CORP

Business

Inactive


AMERICAN BULL TOWING

Business

Inactive


GORELIK, ANNA

Individual

Active


HOMEPREMIER INC

Business

Active


HENEGHAN, MARTIN P

Individual

Inactive


RAMKISSOON, BHAGWANDEEN

Individual

Active


SINGH, SUKHWINDER

Individual

Active



BEN-YAISH, ORTAL

Individual

Active



(default) 2 queries took 291 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 50, 50505047
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)11244