WHERE 1 AND `State` = 'NY' AND (`AddlSubCatList` like '%170%' OR `AddlSubCatList` like '%252%')
select * from `listing` WHERE 1 AND `State` = 'NY' AND (`AddlSubCatList` like '%170%' OR `AddlSubCatList` like '%252%') AND Listingid NOT IN (720,658)
Start Exploring
Route 1 Fun Facts
Fun Fact #12

New Haven, Connecticut, home to Yale University, could also be called the "city of gardens." It has some 70 gardens planted by residents and community groups.

More Fun Facts

Driving through New York City requires a steady hand and some edge and attitude. But you'll be rewarded by an indescribable symphony of sights, sounds, and people.

  • Bronx Zoo

    2300 Southern Avenue, Bronx, NY, 10460

  • Capitol Theater Port Chester

    149 West Chester Ave, Port Chester, NY, 10573
    Phone: (914) 937-4126

  • Funfuzion

    19 LeCount Place, New Rochelle, NY, 10801
    Phone: (914) 637-7575

  • Loew's King Theater

    1025 Flatbush Avenue, Brooklyn, NY, 11223

  • New York Botanical Garden

    2900 Southern Blvd, Bronx, NY, 10458
    Phone: (718) 817-8700

Print