BELLEROSE [Permits for BELLEROSE]

201 - 250 of 280

BRADDOCK PHARMACY LLC

Business

Active


BALLY CONTRACTING CORP.

Business

Inactive


UBREAKIT WEFIXIT CORP.

Business

Inactive


LEE CLEANERS

Business

Active


ARP HOME IMPROVEMENT, CORP.

Business

Active



DEMA SERVICES

Business

Inactive


DSB CONSTRUCTION, INC.

Business

Active


JUPITER INTERIORS INC.

Business

Active




ZORIA EMPIRE CONSTRUCTION CORP

Business

Inactive


COLLAZO, ARTHUR

Individual

Active


JASON DELI & GROCERY

Business

Inactive



SAHARA CONSTRUCTION CORP.

Business

Inactive


MAHARAJA FARMERS MARKET

Business

Active


UBREAKIT WEFIXIT CORP.

Business

Inactive


TATA CONSTRUCTION, CORP.

Business

Active



TROY, DENIS M

Individual

Active


DOLUT CONSTRUCTION INC.

Business

Active


VAN VAKETIS, ROVERT J

Business

Inactive



FIDELIS CONTRACTING INC

Business

Active


SLAL CONSTRUCTION, INC.

Business

Active


LOVELY CONSTRUCTION CORP.

Business

Active




UNION TOP CLEAN INC.

Business

Active


SNEE CONSTRUCTION CORP.

Business

Active



ASHMAN CONSTRUCTION, CORP.

Business

Active


SLAL CONSTRUCTION

Business

Inactive



A UNITED CITY CONTRACTING INC

Business

Inactive



DEP CUSTOM HOMES LLC

Business

Active


DELUXE CONSTRUCTION

Business

Inactive


PAUL AND SON CONSTRUCTION CORP

Business

Inactive


MF SOAP BOX LAUNDROMAT INC.

Business

Active



ACCARDI CLEANERS

Business

Active


GRAND AUCTION MART INC

Business

Active


BELLEROSE CLEANER, INC.

Business

Active


DJG CONSTRUCTION INC.

Business

Active


RAJ AUTO CENTER INC

Business

Active


KHATRA CONSTRUCTION CORP

Business

Active


YOUR WIRELESS

Business

Active



(default) 2 queries took 655 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 ( '(+BELLEROSE)' IN BOOLEAN MODE) LIMIT 200, 505050315
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+BELLEROSE)' IN BOOLEAN MODE)11340