GLENDALE [Permits for GLENDALE]

251 - 300 of 544

BSHARAT, SHAHER

Individual

Active


CORDERO, HENRY

Individual

Active


BOKSAN-GURILA, MARIUS

Individual

Inactive


TORRES, STEVEN

Individual

Inactive


ROSSI, JESSE P.

Individual

Inactive


PALERMO, CONRAD

Individual

Active


AMATO, SALVATORE.

Individual

Active


KURTI, ILIRJANA

Individual

Active


CRUZ, AGUSTIN

Individual

Active


BELIZARIO, FRANK

Individual

Inactive



ESPINAL, JUAN M

Individual

Inactive


CAMACHO, DANIEL R

Individual

Inactive


ANDERSON, AMADA

Individual

Active




LOS NITIDOS,INC.

Business

Active


REDLINE AUTOBODY INC

Business

Active



DELI & DISCOUNT INC

Business

Inactive




URBAN RENOVATORS NYC, LLC

Business

Active


VIK MGM CORP.

Business

Active


ERNIE GRIMES CARPENTRY

Business

Active


RT FRUIT MARKET CORP

Business

Inactive


COLEMAN CONTRACTING, CORP.

Business

Active


WIOLLA MEDICAL SUPPLY, INC

Business

Inactive


BAEK'S CLEANERS

Business

Inactive


CAPNCAZ LAUNDRY, INC.

Business

Inactive


MONTANI CORPORATION

Business

Inactive


R & L EXOTIC JEWELRY INC.

Business

Inactive


DELI-LICIOUS DELICATESSEN

Business

Inactive


BENNY & SONS GROCERY CORP.

Business

Active


LUCKY JNK INC

Business

Inactive



ADVANCED PHARMACY, INC.

Business

Active



G.C. TRI-BORO INC.

Business

Active


US TECH REHAB INC

Business

Active


JESSE GOURMET DELI CORP

Business

Active



STP CONSTRUCTION CO

Business

Active


SWIFT RENOVATIONS INC.

Business

Inactive


HOME DELI & CATERING

Business

Inactive


PUFFY MART INC

Business

Active



RENU PORCELAIN REFINISHING INC

Business

Inactive


TEJEDA BROS. FOOD CORP

Business

Active


CRUZ, AGUSTIN

Business

Inactive


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