SAN JOSE [Permits for SAN JOSE]

601 - 615 of 615

JOSE TIRE SHOP

Business

Inactive


SAN JOSE TULCINGO DELI INC.

Business

Inactive


LA FE DELI GROCERY

Business

Inactive



QUIMAR GENERAL CONSTRUCTION

Business

Active


VEGANO DELI AND GROCERY

Business

Active


SKY SERVICES

Business

Inactive


BROTHER'S WIRELESS

Business

Active


CASH BUY & SELL

Business

Active



JM CONTRACTING

Business

Active


DOMINGUEZ, JOSE

Business

Inactive


ELECTRONIC LABORATORY

Business

Active




(default) 2 queries took 559 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 ( '(+SAN +JOSE)' IN BOOLEAN MODE) LIMIT 600, 501515241
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SAN +JOSE)' IN BOOLEAN MODE)11318