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

Located just off Historic Route 1 is Ferry Farm, Virginia, the boyhood home of George Washington. Ferry Farm inspired the fable about George cutting down his father's cherry tree and is the spot where George threw a stone (or was it a silver dollar?) across the Rappahannock River.

More Fun Facts

A short drive from New York, New Jersey, and Boston, Connecticut blends high culture to stimulate the mind and scenic landscapes to relax the soul.

  • Harbor House Inn

    165 Shore Road, Old Greenwich, CT, 06870
    Phone: (203) 637-0145

  • Hyatt Regency Greenwich

    Route 1, Old Greenwich, CT, 06870
    Phone: (203) 637-1234

  • Inn at Mystic

    3 Williams Avenue, Mystic, CT, 06355

  • New Haven Premiere Hotel and Suites

    3 Long Wharf Drive, New Haven, CT, 06510

  • The Study at Yale Hotel

    1157 Chapel Street, New Haven, CT, 06510
    Phone: (203) 503-3900