HOLLIS [Permits for HOLLIS]

251 - 300 of 383

JDEJ RENOVATION CORP

Business

Active


S & D CONTRACTING INC.

Business

Active


BOBBY AUTO BODY, INC

Business

Inactive



VALERY GROCERY CORP.

Business

Active


HOLLIS NYC CONSTRUCTION INC

Business

Active



EXPRESS SHOE REPAIR

Business

Inactive


JODINA HILLSIDE CORP.

Business

Active


PAWN AND SELL PAWNBROKERS

Business

Active


FORTUNE EMPIRE GROUP INC.

Business

Inactive


A&E LOSADA CONTRACTORS CORP.

Business

Inactive



ELIJAH HOME IMPROVEMENT, INC.

Business

Inactive


HILLSIDE AVATAR INC.

Business

Active


SMART CHOICE AUTO SALES LLC

Business

Inactive


DA CONSTRUCTION INC

Business

Active


CHUCK'S IRON WORKS

Business

Inactive


JAMAICA DELI & GRILL INC.

Business

Active


R DOORS & LOCKS CORP

Business

Inactive


INTEGRITY 24 HOUR TOWING INC.

Business

Inactive



LISA TRANSMISSIONS, INC.

Business

Inactive


K S HOME IMPROVEMENT

Business

Inactive


PHANTOM AUTO COLLISION INC.

Business

Active



TIP TOP AUTO CARE, INC.

Business

Active


ABI'S AUTO & TOWING INC

Business

Inactive


BNW CONTRACTING

Business

Active


DUKE & SONS CONSTRUCTION CORP.

Business

Inactive




185 ST GAS CORP

Business

Inactive


QUICKSCRIPT PHARMACY

Business

Inactive


LEO TIRE REPAIR CORP.

Business

Active


JAMAICA AUTO REPAIR INC.

Business

Inactive



KING OF JAMAICA AUTO INC.

Business

Active


PURAN'S PAWN SHOP

Business

Active



PROMASTER#1 AUTO BODY INC

Business

Active


Shine Construction CORP

Business

Active


JAMAICA AUTO REPAIR INC.

Business

Inactive


ABI'S AUTO & TOWING INC

Business

Inactive


AW MOBILE OF HOLLIS

Business

Inactive


ABREU MINIMARKET, INC

Business

Active


R DOOR & LOCKS

Business

Inactive


RYAN'S TOWING 1, INC.

Business

Inactive


HOLLIS REFRIGERATION

Business

Active


NICK'S TOWING INC.

Business

Inactive


(default) 2 queries took 506 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 250, 505050269
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)11237