VALLEY STREAM [Permits for VALLEY STREAM]

401 - 410 of 410

KRC HOME IMPROVEMENT, INC.

Business

Inactive


VALLEY CONSTRUCTION

Business

Inactive


MH DRYWALL, INC.

Business

Inactive


KERN CONSTRUCTION COMPANY

Business

Inactive


ALL AMERICAN REMODELING INC.

Business

Inactive



CONTESSA LEGAL PROCESS, CORP.

Business

Inactive


BRAZMEX PAINTING, INC.

Business

Active


ALL AMERICAN BUILDERS INC.

Business

Inactive



(default) 2 queries took 520 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 ( '(+VALLEY +STREAM)' IN BOOLEAN MODE) LIMIT 400, 501010285
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+VALLEY +STREAM)' IN BOOLEAN MODE)11235