UNIONDALE [Permits for UNIONDALE]

51 - 61 of 61

MOUSTOUKA, NICHOLAS

Individual

Inactive


DANNY'S HOME IMPROVEMENT NYC

Business

Inactive


O.D.P. CONSTRUCTION

Business

Active


Barnes, Monique

Individual

Inactive


VASQUEZ, MANUEL

Individual

Active


HARMONY ENTERPRISES NY INC.

Business

Active


MONTALVAN, OSCAR

Individual

Active


HOME PRIDE LANDSCAPING

Business

Inactive


HARMONY CONSTRUCTION COMPANY

Business

Inactive


STANLEY GELBER & SONS INC.

Business

Active



(default) 2 queries took 490 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 ( '(+UNIONDALE)' IN BOOLEAN MODE) LIMIT 50, 501111225
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+UNIONDALE)' IN BOOLEAN MODE)11265