SUMMIT [Permits for SUMMIT]

1 - 16 of 16

SUMMIT 888 LAUNDROMAT INC

Business

Inactive


DESANTO, MICHAEL

Individual

Active


Flower Construction

Business

Active


GLOBAL CHECK RECOVERY, INC.

Business

Active


NUSSBECK, PATRICK

Individual

Inactive


ALTERED STRUCTURE

Business

Active


JONES, MATTHEW

Individual

Inactive


FLOOD, EILEEN

Individual

Active


SUMMIT SHORING LLC

Business

Inactive


SUMMIT MOTORS CORP.

Business

Active


SUMMIT US

Business

Inactive


SUMMIT MOTORS CORP.

Business

Active



STEINWAY BILLARDS & CAFE

Business

Inactive


SUMMIT 888 LAUNDROMAT INC

Business

Active


OLYMPIAN SUMMIT INC.

Business

Active


(default) 1 query took 250 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 ( '(+SUMMIT)' IN BOOLEAN MODE) LIMIT 501616250