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

Ernest Hemingway wrote some of his best works while living on Historic Route 1, in the Florida Keys. These include "Death in the Afternoon," "For Whom the Bell Tolls," "To Have and Have Not," and "Green Hills of Africa."

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.

  • Arthur Avenue Café

    2329 Arthur Avenue, Bronx, NY, 10458
    Phone: (718) 562-0129

  • Arthur Avenue Little Italy Bronx

    Route 1 and Arthur Avenue, Bronx, NY, 10458

  • Barnacle BBQ

    181 Ease Boston Post Road, Mamaroneck, NY, 10543
    Phone: (914) 777-6610

  • Bronx Zoo

    2300 Southern Avenue, Bronx, NY, 10460

  • Dominick's

    2335 Arthur Avenue, Bronx, NY, 10458
    Phone: (718) 733-2807

Print