AURORA [Permits for AURORA]

1 - 17 of 17

IQMS

Business

Active


AURORA NY CONSTRUCTION INC.

Business

Active


SCHERRER, RUSS

Individual

Active


AURORA BUILDERS LLC

Business

Active


D'AURORA, AURORA M

Individual

Active


HOWARD, UTA L

Individual

Active



AURORA, PASQUALE VINCENT

Individual

Active


WAKEFIELD & ASSOCIATES, INC

Business

Active


AURORA ACOUSTICS INC

Business

Inactive


AURORA RENOVATIONS LLC

Business

Inactive


WINDHAM PROFESSIONALS, INC.

Business

Inactive


AURORA VEGETABLE MARKET CORP

Business

Inactive


AURORA VEGETABLE MARKET CORP.

Business

Inactive


150 AURORA GROCERY CORP.

Business

Inactive


AURORA FG, INC

Business

Active


CREDITORS FINANCIAL GROUP LLC

Business

Inactive


(default) 1 query took 242 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 ( '(+AURORA)' IN BOOLEAN MODE) LIMIT 501717242