WHITE PLAINS [Permits for WHITE PLAINS]

151 - 172 of 172

CHRISPAULY CONSTRUCTION LLC

Business

Inactive


FRANKIE'S CLEANERS

Business

Active


CALLAHAN HOLDINGS, LLC

Business

Inactive




THOMAS, DWIGHT

Individual

Active



BRADY, MARK

Business

Inactive


TONY D'AMORE LANDSCAPING

Business

Inactive


213 WHITE PLAINS DELI CORP

Business

Inactive


WEC CONTRACTING CORP

Business

Active



MEADOW CONTRACTING

Business

Inactive




MEYERS, TAMERRA

Individual

Active


NORTH STAR WHITE PLAINS CORP

Business

Inactive




ZAIDIAC CONSTRUCTION, LLC

Business

Active



2168 WHITE PLAINS RD INC

Business

Inactive


(default) 2 queries took 471 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 ( '(+WHITE +PLAINS)' IN BOOLEAN MODE) LIMIT 150, 502222255
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+WHITE +PLAINS)' IN BOOLEAN MODE)11216