BLUE ASH [Permits for BLUE ASH]

151 - 168 of 168


BLUE NILE, LTD.

Business

Active



BLUE STAR GROCERY INC

Business

Inactive


BLUE DRAFT CORPORATION

Business

Active


THE GOOD EARTH CLEANERS

Business

Active


Blue Bonnet Rarities, LLC

Business

Active


ROYAL BLUE AUTO INC.

Business

Inactive


BLUE SKY LAUNDROMAT

Business

Active



BLUE SKY NY DELI GROCERY INC

Business

Inactive



BLUE SKY CONSTRUCTION CORP.

Business

Inactive




BLUE BIRD LAUNDROMAT INC.

Business

Active


BLUE OCEAN LAUNDROMAT INC.

Business

Inactive


UNIFUND CCR PARTNERS

Business

Active


(default) 2 queries took 455 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 150, 501818240
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)11215