OLD BRIDGE [Permits for OLD BRIDGE]

51 - 66 of 66

BRIDGE GOURMET MARKET, INC

Business

Active



BRIDGE MOTORS CORP.

Business

Active



BRIDGE FRESH, INC.

Business

Active




Broadway Bridge Wash & Lube

Business

Active


Bridge Cleaners & Tailors

Business

Active


KING'S QULITY FURNITURE

Business

Inactive


COLGATE SCAFFOLDING

Business

Active



BRIDGE PARKING CORP.

Business

Inactive


BAY BRIDGE SERVICE CENTER INC.

Business

Inactive


ALL BRIDGE CONTRACTING CORP

Business

Active


WOW BRIDGE CAFE LLC

Business

Inactive


(default) 2 queries took 461 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 ( '(+OLD +BRIDGE)' IN BOOLEAN MODE) LIMIT 50, 501616253
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+OLD +BRIDGE)' IN BOOLEAN MODE)11208