MINEOLA [Permits for MINEOLA]

51 - 100 of 128

BRUNO'S BUILDING CORP.

Business

Active


SINGH, GURDIP

Individual

Active



Ottaviano, John

Individual

Active


KEMPF, JOHN A

Individual

Active


BIBIMED INC

Business

Active


210 CONSTRUCTION CORP.

Business

Active


DALY, JOHN

Individual

Inactive



REIS, DOMINGOS

Individual

Active


VALDERRAMA, CARLOS

Individual

Active


SHEEHAN, SORAYA

Individual

Inactive


MIISUPPLY LLC

Business

Active


TSABASIS, NICHOLAS

Individual

Active


GROSS, IRA

Individual

Active


JOHN WHIGHAM, INC.

Business

Active


REBAZA, MIRIAM

Individual

Inactive


CLARK, TYRONE

Individual

Inactive


WEBB, BRIAN

Individual

Active


BAYSIDE HOMES INC.

Business

Active


RAISER & KENNIFF, P.C.

Business

Active


WALKER-MCLEES, KELLY L

Individual

Active


AIR-IDEAL INC.

Business

Active


Figliolia, Steven

Individual

Active


PORTAMCO GROUP, LLC

Business

Active


GALGANO, ANDREW

Individual

Active


CLAUDIU, CENGHER A

Individual

Inactive


SOFILLAS, VASILIOS

Individual

Active


GRACE RENOVATIONS, INC.

Business

Active


QUICKSILVER INC.

Business

Active


GRAHAM, JOHN T

Individual

Active


RD CONSTRUCTION I CORP.

Business

Active


RADHA, GUANASE

Individual

Active


Luna, Leonardo

Individual

Inactive


CABINET MD INC

Business

Active


PAPAKOSTOPOULOS, GEORGE

Individual

Active


CREATIVE STRUCTURES INC.

Business

Active


HAIK, NOAM

Individual

Active


DESOUZA, RONY K

Individual

Active


RYAN, DAVID J

Individual

Active


XU, HANG

Individual

Active


EISEN, DANIEL

Individual

Inactive


BNL CONSTRUCTION CORP

Business

Active



A.B.LAKE CONSTRUCTION CORP

Business

Active


SANO, CHRISTOPHER

Individual

Active


VICARI, FRANK

Individual

Active



BERRY, JUSTIN J

Individual

Active


D & Y CONSTRUCTION COMPANY

Business

Active


(default) 2 queries took 763 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 50, 505050195
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)11568