SPRING [Permits for SPRING]

1 - 50 of 183

M & N-1 CONSTRUCTION INC

Business

Inactive


TML BUILDERS INC

Business

Active


SPRING DELI & TOBACCO INC

Business

Inactive


ROSENFELD LAW GROUP LLC

Business

Active


CLAFFEY, CHARLES A

Individual

Active



SPRING BREEZE DRY CLEANER INC.

Business

Inactive


MR. LANDSCAPE, INC.

Business

Inactive



SPRING CLEANERS OF NY, INC.

Business

Inactive


K.M. SPRING CLEANERS

Business

Inactive


NEW SPRING CLEANERS INC.

Business

Inactive


SPRING LAUNDROMAT OF NY, INC.

Business

Inactive


GRAFE, JUDD T

Individual

Active


At&t AUTHORIZED RETAILER #1632

Business

Inactive


SPRING LAUNDROMAT, INC.

Business

Inactive


JAMES, HUMPHREY S

Individual

Active


SPRING NATURAL FOOD, INC.

Business

Active


SPRING ICONIC SWEET SHOP

Business

Active


STEINBOCK, JOSEPH PL

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


BUHRE, JAMES

Individual

Inactive


BUHRE, JAMES

Individual

Inactive


ZAF CORPORATION

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AL DIBIASI BUILDERS LLC

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


RIDGEWOOD AUTO SPRING

Business

Inactive


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


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