CAMBRIA [Permits for CAMBRIA]

101 - 150 of 163

A.HINDS ENTERPRISES

Business

Inactive


C & H HOME IMPROVEMENT

Business

Active


KEUM LIMITED

Business

Inactive



MARK MANROOP

Business

Active


LINDEN MINI MART FOOD CORP

Business

Inactive


QUEENSBRIDGE CLEANING CORP

Business

Inactive


LJ HUB

Business

Active


KNIGHT-WILLIAMS, NATASHA

Business

Inactive


MIRELLE CHEZ

Business

Active


LUMAL CLEANERS, INC.

Business

Active


METAMILT SERVICE INC.

Business

Active


SPRINGFIELD CANDY & GROCERY

Business

Inactive


AMR FOOD CORP

Business

Active


MORNING GLORY HOME IMPROVEMENT

Business

Inactive



N.D.E. CONSTRUCTION INC.

Business

Active


VOILA GROCERY CORP.

Business

Inactive


Hess Express #32504

Business

Inactive



HOSANNA GOLD

Business

Inactive


CHEZ MIREILLE GROCERY INC.

Business

Inactive


BECKFORD HOME IMPROVEMENT LTD.

Business

Inactive


STAR PETROLEUM MANAGEMENT INC.

Business

Inactive


STORE #29345

Business

Active


SIMMONS, ADRIAN P

Business

Inactive


KHINTH CONSTRUCTION CO

Business

Active


ELITE WIRELESS GROUP NY LLC

Business

Active


BATISTA MINI GROCERY

Business

Active



LINDEN JEWELS CORP.

Business

Active



THOMPSON WHOLESALE

Business

Inactive


D&J GROCERY DELI CORP

Business

Inactive


147TH ST. HOMES INC.

Business

Active


HJB HOME IMPROVEMENTS INC.

Business

Active


TREVOR'S CONSTRUCTION

Business

Active


CVS PHARMACY #3138

Business

Inactive


PALMER CLEANING CENTER

Business

Active


MIRACLE RENOVATIONS LLC

Business

Inactive


R & K CONTRACTORS

Business

Active


INFINITYCELLS INC.

Business

Inactive


BOBBY'S AUTO CENTER INC.

Business

Inactive


PROPERTY MANAGEMENT, INC.

Business

Active


KAMBRIA GROCERY DELI CORP.

Business

Active


PASSMORE COPELAND JR

Business

Active


HOLMES HOME IMPROVEMENT

Business

Inactive


6 BROTHERS FOOD CORP

Business

Inactive


BIRCHWOOD, ANDRE A

Business

Inactive



(default) 2 queries took 418 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 ( '(+CAMBRIA)' IN BOOLEAN MODE) LIMIT 100, 505050205
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+CAMBRIA)' IN BOOLEAN MODE)11213