CAMBRIA HEIGHTS [Permits for CAMBRIA HEIGHTS]

51 - 100 of 101

INFINITYCELLS INC.

Business

Inactive






NYC ALL PRO RENOVATIONS LLC

Business

Active




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


LJ HUB

Business

Active


KNIGHT-WILLIAMS, NATASHA

Business

Inactive


MIRELLE CHEZ

Business

Active


LUMAL CLEANERS, INC.

Business

Active


METAMILT SERVICE INC.

Business

Active


AMR FOOD CORP

Business

Active



N.D.E. CONSTRUCTION INC.

Business

Active


Hess Express #32504

Business

Inactive



HOSANNA GOLD

Business

Inactive


STORE #29345

Business

Active


KHINTH CONSTRUCTION CO

Business

Active


ELITE WIRELESS GROUP NY LLC

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


PALMER CLEANING CENTER

Business

Active


MIRACLE RENOVATIONS LLC

Business

Inactive


R & K CONTRACTORS

Business

Active


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



BOBB CONSTRUCTION

Business

Active




BOBBY'S AUTO CENTER INC.

Business

Active




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