BLUE ASH [Permits for BLUE ASH]

51 - 100 of 168

BLUE SMOKE, LLC

Business

Active



BLUE BALLOON INC

Business

Inactive


UNIPAC IX, LLC

Business

Active


BLUE STAR GROUP, LLC

Business

Active


CAFE AMRITA

Business

Active


BLUE MARK DESIGN INC.

Business

Inactive



Blue Haven, Inc.

Business

Active



BLUE BALLOON PARTIES

Business

Inactive


BLUE LINE RENOVATIONS INC

Business

Active


BLUE SKY AC INCORPORATED

Business

Inactive


BLUE WAVE LAUNDROMAT, INC.

Business

Inactive








BLUE BALLOON PARTIES

Business

Inactive


BLUE BALLOON INC

Business

Inactive


BLUE CHIP CONTRACTING LTD.

Business

Active


BLUE CASTLE LAUNDROMAT INC

Business

Inactive


BLUE BALLOON PARTIES

Business

Inactive


ICE BLUE

Business

Active


FIDELIS CONTRACTORS LLC

Business

Inactive





BLUE BALLOON INC

Business

Inactive



INDIGO BLUE GROUP, INC.

Business

Active



BLUE SKY DELI INC.

Business

Inactive


SUN BLUE ENERGY

Business

Inactive


ROYAL BLUE AUTO INC.

Business

Inactive



ANGEL BRIGHT

Business

Active


BLUE BALLOON PARTIES

Business

Inactive


BLUE BALLOON PARTIES

Business

Inactive





CHOCOLAT RESTAURANT LOUNGE

Business

Inactive


BLUE WATER LAUNDROMAT INC.

Business

Active



BLUE BALLOON INC

Business

Inactive


BLUE LAUNDRY INC

Business

Active


BLUE BALLOON PARTIES

Business

Inactive


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