SPRING VALLEY [Permits for SPRING VALLEY]

1 - 50 of 64

M & N-1 CONSTRUCTION INC

Business

Inactive


ROSENFELD LAW GROUP LLC

Business

Active



MR. LANDSCAPE, INC.

Business

Inactive



GRAFE, JUDD T

Individual

Active


JAMES, HUMPHREY S

Individual

Active


Fair Capital LLC

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


ZAF CORPORATION

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


Yablonsky, Shlomo

Individual

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


FRIED, WILLIAM

Individual

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


ZIEGLER, MENACHEM

Individual

Inactive


AIR FAIR ENTERTAINMENT INC.

Business

Active


AMRAM, MEIR

Individual

Inactive




DOSCH, JOSEPH T

Individual

Inactive


KUKAJ, KUJTIM

Individual

Inactive


Szachtel, Avi

Individual

Inactive


POWER UP ENERGY INC

Business

Active


PADILLA HUERTA, MANUEL

Individual

Active


SAMY CONSTRUCTION CORP.

Business

Active


GRAMA, TUVIA

Individual

Active


MARCUS, JAY V.

Individual

Active


VELEZ, NERI

Individual

Inactive


GARCIA, LUIS

Individual

Inactive


JAMES, REBECCA R

Individual

Active


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