WHERE 1 AND `State` = 'NY' AND (`AddlSubCatList` like '%237%' OR `AddlSubCatList` like '%253%')
select * from `listing` WHERE 1 AND `State` = 'NY' AND (`AddlSubCatList` like '%237%' OR `AddlSubCatList` like '%253%') 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.

  • Fordham University

    441 East Fordham Road, Bronx, NY, 10458
    Phone: (718) 817-1000

  • Jay Heritage Center/Jay House

    210 Boston Post Road, Rye, NY, 10580
    Phone: (914) 698-9275

  • Saint Paul's Church National Historic Site

    897 S. Columbus Avenue, Mount Vernon, NY, 10550
    Phone: (914) 667-4116

Print