SAG HARBOR [Permits for SAG HARBOR]

51 - 87 of 87

DESIGN EXPRESSIONS

Business

Active



APA, RAPHAEL

Individual

Active


CARPENZANO, ROSARIO

Individual

Active


LEONARD, JOHN R.

Individual

Active


Plenefisch, William

Individual

Active


PARADISE WATERLSIDE

Business

Inactive


SNUG HARBOR MASONRY

Business

Active


HARBOR VIEW

Business

Active


TROPICAL PARADISE COMNO

Business

Inactive


MOONWALK SLIDE

Business

Inactive


MONSTER WAVE WATER SLIDE

Business

Inactive


KATZ WOODWORK LLC

Business

Inactive


HARBOR CLEANING CORPORATION

Business

Active


T-BALL GAMES TO GO

Business

Inactive



TWISTER GAME

Business

Inactive


TODDLER ZONE

Business

Inactive


HARBOR HOME COLLECTION LLC

Business

Inactive


ANTIGNANI, CARLO

Individual

Active


BACKYARD WATERSLIDE

Business

Inactive


FORTRESS OBSTACLE COURSE

Business

Inactive


BON APPETIT

Business

Active


IVAN SMITH'S HOME IMPROVEMENT

Business

Inactive


FRONT WATERSLIDE

Business

Inactive


BELLE HARBOR FOODS

Business

Active


30' BACK YARD OBSTACLE COURSE

Business

Inactive


Stop & Shop Store # 2591

Business

Active


NYKIDSTIME INC.

Business

Inactive


BAY HARBOR MOTORS CORP.

Business

Active


NYKIDSTIME INC.

Business

Inactive


CASTLE

Business

Inactive


4 IN 1 COMBO

Business

Inactive


SLIP'N'SLIDE

Business

Inactive


NYKIDSTIME INC.

Business

Inactive


BOUNCE HOUSE MEDIUM

Business

Inactive


MEDIUM BOUNCE

Business

Inactive


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