Selling 'as is' . A Rare Gem: Breathtaking Waterfront Home in Prestigious Beechhurst" This stunning waterfront property offers an exclusive view of the EAST RIVER/LITTLE BAY/ LONG ISLAND SOUND, a privilege enjoyed by only a few homeowners. The master bedroom opens onto a full-size front balcony, providing captivating water views, while the living and dining rooms boast soaring cathedral ceilings with decorative beams. The eat-in kitchen features a cozy breakfast nook with sliding doors that lead to a backyard deck, perfect for relaxing. A separate back entrance to the basement adds convenience, and the tastefully designed stone fireplace adds charm and elegance. Upstairs, you'll find three spacious bedrooms and two full bathrooms, all thoughtfully designed for comfort. The lower level includes a large family room, an additional bedroom, a full bathroom, and a 2-car garage. Enjoy scenic walks and jogs in the nearby park, making this home the perfect blend of luxury, tranquility, and convenience. Building dimensions 38.5 feet x 44 feet. Livable space 2945 Sqft per floor plan. All Information Is Deemed Reliable But Is Not Guaranteed. Buyer Is Advised To Verify The Accuracy Of All Information Independently.