Magnificent sprawling ranch located in the prestigious waterfront community of Douglaston Manor, offering rare water views and breathtaking sunsets throughout the year. One of the few nonconforming properties in the neighborhood, with no restrictions to expand this property to a 5/6 bedroom home, this exceptional residence seamlessly blends luxury, comfort, and the convenience of one-level living. The main floor features a spacious living room, formal dining room, family room with a new wood-burning fireplace insert, three bedrooms with an abundance of closet space, and 1.5 beautifully updated bathrooms. The stunning chef's eat-in kitchen, completely renovated in 2020, is appointed with Corian countertops, premium appliances, and elegant tile flooring. The home underwent a complete gut renovation in 2020, including all-new electrical wiring, plumbing, walls, ceilings, and refinished hardwood floors throughout. Additional upgrades include four separate heating and cooling zones, a new 5-ton central air conditioning system, four Mitsubishi split units, a new 75-gallon hot water heater, spray foam insulation throughout, Anderson windows installed in 2022, a central vacuum system, a new alarm system, and 4K security cameras surrounding the property. All built-ins and installed electronics will remain. A new septic tank was installed in 2024. A new roof in August 2026. The fully finished basement features approximately 8-foot ceilings and offers exceptional entertaining space with a spacious entertainment area showcasing beautiful porcelain tile flooring, a custom bar, gym, laundry room, and full bathroom. A finished second-floor bonus area, completed in 2020 with 8-foot ceilings and custom cabinetry, provides tremendous flexibility and can easily accommodate two to three additional bedrooms, a home office, playroom, or recreation area. The exterior is equally impressive, showcasing professionally designed landscaping, an in-ground sprinkler system, new sidewalks, and a new driveway. The fully enclosed backyard serves as a private oasis with beautiful pavers, a Jacuzzi hot tub, and a full canvas tent enclosure, perfect for year-round enjoyment and entertaining. A two-car garage with an insulated automatic garage door completes this remarkable offering. Situated on an oversized 82.17' x 100' lot with a building size of approximately 69.5' x 44', this extraordinary property also benefits from the Douglaston Manor Association, with an annual fee of just $900 providing private security, shoreline parking privileges, and access to boat docking facilities. Residents can also enjoy membership opportunities at the renowned Douglaston Club, featuring a pool, tennis courts, dining, and year-round social events. This is a rare opportunity to own a truly exceptional home in one of Queens' most coveted waterfront communities