MINEOLA [Permits for MINEOLA]

101 - 128 of 128

ERB, CASSANDRA

Individual

Inactive


ALERT PROCESS SERVICE, LLC

Business

Active


PERSAUD, YASPAL

Individual

Active


SILVA, CARLOS

Individual

Active


DI PASQUALE, JOHN

Individual

Active


DYNAIRE CORP.

Business

Active


LUZ, HUGO M

Individual

Active


DASILVA, CARLOS A

Individual

Inactive


Weitzman, Adam

Individual

Active


JOHN DI PASQUALE CO

Business

Active


CENGHER, CLAUDIU A

Individual

Active


LIMA, PHILIP

Individual

Active


GAL-DAL CONTRACTING, INC.

Business

Inactive


B & G CONTRACTING

Business

Active


RITTER, ROBERT J

Individual

Active


PIMENTEL, LUZ

Individual

Active


NUDO DECORATOR

Business

Active


LOPES, DOMINGOS C.

Individual

Active



CURILA CONSTRUCTION INC

Business

Inactive



MANNETTA, VINCENT J

Individual

Active



ALLEN ASSICIATES

Business

Active


R.K. CONSTRUCTION LLC

Business

Inactive


BRUNO'S BUILDING CORP.

Business

Inactive


SILVA CONTRACTORS CO. INC.

Business

Inactive


N J V CONSTRUCTION NY INC

Business

Active


(default) 2 queries took 741 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 ( '(+MINEOLA)' IN BOOLEAN MODE) LIMIT 100, 502828417
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+MINEOLA)' IN BOOLEAN MODE)11324