SAN CARLOS [Permits for SAN CARLOS]

251 - 282 of 282

FLOWERS BY LUNELLY

Business

Active



CARLOS JR. TIRE SHOP INC.

Business

Active




DIAZ, CARLOS

Business

Active


NEW YORK FLAT FIX

Business

Inactive


FRANCHESCA MINI MARKET

Business

Active


FLUSHING TOWING

Business

Inactive


JCR METAL WORK

Business

Inactive


ALMONTE, CARLOS

Business

Active


C.N. AUTO SOUND & SECURITY

Business

Active





INFANTE GROCERY

Business

Active


GUARIO TOWING SERVICE

Business

Inactive


CARLOS LOPEZ

Business

Active



LIBERTY COMMUNICATIONS

Business

Active


LIBERTY COMMUNICATION

Business

Inactive


CARLOS DIAZ IMPROVEMENT

Business

Active


CARLOS HANDYMAN

Business

Active


CARLOS DELI & GROCERY INC

Business

Active


C CONSTRUCTION

Business

Active


CMC CONTRACTING

Business

Inactive


LOPEZ, CARLOS

Individual

Active



NUEVA GENERACION GROCERY

Business

Inactive



EL TERRIBLE TIRE-SHOP

Business

Active



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