SAN ANTONIO [Permits for SAN ANTONIO]

151 - 164 of 164

TONY D'AMORE LANDSCAPING

Business

Inactive


NITTI, ANTONIO

Business

Active


RODRIGUEZ DRY CLEANERS

Business

Active


LOBIANCO, ANTONIO

Individual

Active


CUNHA HOME IMPROVEMENT

Business

Inactive


HOMETOWN CONSTRUCTION

Business

Active


CATARRA, ANTONIO

Individual

Active


MELENDEZ GROCERY

Business

Active



NEW AMERICAN USED AUTO PARTS

Business

Inactive


RAMOS, ANTONIO

Business

Inactive


ANTHONY'S CONSTRUCTION

Business

Active


ULERIO DELI GROCERY

Business

Inactive


ANTONIO CIAMPA, LLC

Business

Inactive


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