HOLLIS [Permits for HOLLIS]

201 - 250 of 383



CMT Home Improvement, LLC

Business

Active



ADVENT GROUP PLUS INC

Business

Active


LA JUNE CARE

Business

Active


SUNSHINE HVAC LLC

Business

Active


JAMAICA HOME IMPROVEMENT, INC.

Business

Inactive


Skeldon Marketplace inc

Business

Inactive


NOV CONSTRUCTION

Business

Inactive


DYNAMIC ADIV SETHI CORP

Business

Active


DASILVA CONTRACTING INC.

Business

Active


CITY WIDE WIRELESS 7 INC

Business

Active


QUANTUM DESIGN INC

Business

Active



US PREMIER BUILDERS CORP

Business

Active



HILL LAUNDROMAT

Business

Active


MAA CONSTRUCTION

Business

Active



MO'S IRON WORK

Business

Active



AILA CONSTRUCTION CORP.

Business

Active



HOLLIS JEWELRY LLC

Business

Active


MAIN CONTRACTING CORP.

Business

Active


198 BODY SHOP, INC

Business

Active


SPARKLING CELL, LLC

Business

Active



HOLLIS REFRIGERATION

Business

Inactive


UNIQUE AUTO REPAIR NY INC

Business

Active


HOLLIS WOODS DELI CORP

Business

Inactive


Queens Best Auto

Business

Active


R DOORS & LOCKS CORP

Business

Active


UNIQUE AUTO REPAIR NY INC

Business

Active


LEE MYLES TRANSMISSIONS

Business

Active


CORONA RESTORATION INC

Business

Active


182 STREET PARKING CORP.

Business

Inactive


WALLIS,KHAN

Business

Inactive



AUTO DEALS LLC

Business

Inactive




TAKE & PAY INC.

Business

Active


JEWELRY EXCHANGE

Business

Active


R & S VILLAGE DELI LLC

Business

Active


T-Mobile

Business

Inactive


COMBINED AUTO LLC

Business

Active


T-MOBILE

Business

Inactive



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