SPRING [Permits for SPRING]

151 - 183 of 183

RIDGEWOOD AUTO SPRING

Business

Active


NEW SPRING CLEANERS INC.

Business

Active






RAR RENOVATIONS INC

Business

Inactive


SPRING FRESH LAUNDROMAT LLC

Business

Inactive


67 SPRING CORP.

Business

Inactive




CHEFS CLUB COUNTER

Business

Active





ACTUAL RECOVERY CORP

Business

Inactive


SPRING GOLF CORPORATION

Business

Active


SPRING CONSTRUCTION INC

Business

Active



SPRING WATERPROOF

Business

Active


SPRING DELI & TOBACCO INC

Business

Active


OXYGEN RECOVERY GROUP

Business

Active


AT&T Authorized Retailer #1613

Business

Inactive


SPRING NATURAL

Business

Active


ATLAS AUTO SPRING CO.

Business

Inactive


SPRING CALLING CARDS

Business

Inactive


AT&T AUTHORIZED RETAILER #1115

Business

Inactive



ATLAS AUTO SPRING CO. LLC

Business

Active


14 SPRING STREET CAFE LLC

Business

Inactive


NEW YORK AUTO SPRING CORP

Business

Active


RIDGEWOOD AUTO SPRING INC.

Business

Inactive



(default) 2 queries took 512 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 150, 503333261
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)11251