GREEN BAY [Permits for GREEN BAY]

351 - 375 of 375

GREEN VILLAGE CORP

Business

Active



GREEN FAMILY MART

Business

Active


GREEN HEART HOME BUILDERS LLC

Business

Inactive


79 GREEN APPLE CORP

Business

Active


GREEN LAND DELI INC

Business

Inactive


FRESH GREEN GARDEN INC

Business

Active


SJ GREEN MARKET INC.

Business

Inactive



GREEN APPLE CLEANERS LLC

Business

Active


GREEN N GROCERY INC

Business

Active


GREEN PARK DELI INC

Business

Active


TREMONT GREEN MARKET, INC.

Business

Active


GREEN,GEOFFREY H

Business

Active


GREEN FOOD SUPERMARKET INC

Business

Active


GREEN CLEANERS

Business

Active




GREEN ARCH CONSTRUCTION

Business

Inactive



GREEN TOUCH CONTRACTING LLC

Business

Active


GREEN LIGHT DELI INC

Business

Inactive


STAY GREEN LANDSCRAPING

Business

Active


GREEN VALLEY DELI CORP.

Business

Inactive


GO GREEN DIRECT INC.

Business

Active


(default) 2 queries took 1675 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 ( '(+GREEN +BAY)' IN BOOLEAN MODE) LIMIT 350, 5025251173
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+GREEN +BAY)' IN BOOLEAN MODE)11502