S HEMPSTEAD [Permits for S HEMPSTEAD]

251 - 262 of 262

SUBURBAN CONTRACTING CORP.

Business

Inactive


D&L HOME IMPROVEMENT INC.

Business

Inactive


THOMPSON, ISAAC

Business

Inactive



NU LIFE HOME RENOVATIONS

Business

Inactive


FEBRES, RAYMOND

Business

Inactive


NIKO DEVELOPMENT CORP.

Business

Inactive


HEMPSTEAD AUTO CARE, INC.

Business

Active


HEMPSTEAD BEST DELI CORP

Business

Inactive



HEMPSTEAD PAWN BROKERS, INC

Business

Active


MANSTAR RECOVERY SERVICES INC.

Business

Inactive


(default) 2 queries took 545 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 ( '(+S +HEMPSTEAD)' IN BOOLEAN MODE) LIMIT 250, 501212314
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+S +HEMPSTEAD)' IN BOOLEAN MODE)11231