BLUE ASH [Permits for BLUE ASH]

1 - 50 of 168


NY'S FINEST FRENCH CLEANERS

Business

Inactive


BLUE LAUNDRY INC

Business

Inactive


BLUE WATER LAUNDROMAT II INC

Business

Inactive


THE BOWERY BALLROOM

Business

Inactive


ANGEL BRIGHT INC.

Business

Inactive


THE BOWERY BALLROOM

Business

Inactive


BLUE ETHER, INC.

Business

Inactive


BLUE STAR LAUNDROMAT INC.

Business

Inactive


BLUE SKY LAUNDROMAT

Business

Inactive


BLUE WATER LAUNDROMAT INC.

Business

Inactive


SKY BLUE LAUNDROMAT, INC.

Business

Inactive


BLUE BIRD LAUNDROMAT INC.

Business

Inactive


BUBBLE'S SUPERCLEAN

Business

Inactive


THE GOOD EARTH CLEANERS

Business

Inactive


Blue Haven, Inc.

Business

Inactive


AQUA BLUE LAUNDROMAT CORP.

Business

Inactive


MAGENTA BLUE INC.

Business

Active


LENDKEY TECHNOLOGIES, INC

Business

Active


SAVO, ASHLEY

Individual

Inactive


blue wave accessories inc

Business

Active


BLUE BELL CONTRACTING

Business

Active



NELSON BLUE

Business

Active




BLUE SKY TECH TRADING INC

Business

Active


BLUE, SHANON

Individual

Active


Blue Hill Top Corp.

Business

Active



BLUE WATER ASTORIA LLC

Business

Active


BLUE BLOOD TOWING CORP

Business

Inactive


BLUE CREEK HOMES, INC

Business

Inactive


AR RESOURCES, INC.

Business

Active


Blue Raven Solar, LLC

Business

Inactive


LO DUCA ASSOCIATES INC

Business

Active


BLUE SKY TECH TRADING INC.

Business

Inactive


BROWNIE, JEREMY J

Individual

Active



BLUE PORT CONSTRUCTION INC.

Business

Active


LODUCA, RICHARD

Individual

Active


BLUE WAVE ACCESSORIES INC.

Business

Active


BLUE SKY TECH TRADING INC.

Business

Inactive


PRECISION PAINTING PLUS

Business

Active




VARIETY GIFT AND SMOKE SHOP

Business

Active


BUBBLE'S SUPERCLEAN

Business

Active


CANTINE PARISIENNE

Business

Inactive


BLUE STORE DELI INC

Business

Active


(default) 2 queries took 347 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 505050104
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)11243