Located in the historic and picturesque Douglas Manor, this 2,300-SF full gut-renovation with every luxury upgrade began as a 4-bed and was re-imagined as a 3-bed retreat with a spacious primary suite—steam shower, Kohler Numi smart toilet/bidet, and walk-in closet—while two additional bedrooms share a stunning marble hall bath. The main level boasts an open-concept vaulted great room with gas fireplace and in-ceiling Sonos audio adjoins an all-Thermador chef’s kitchen: quartz waterfall island, marble backsplash, Instant-Hot tap—ideal for modern living and entertaining. Finished lower level offers a 100 inch home theater, custom wet bar, LG smart laundry, gym/office zone, third full bath, and private keyed entry. Smart & Efficient: SmartThings/Alexa lighting, Alarm.com security + HD cams, Nest-controlled high-efficiency 2-zone HVAC, Rachio sprinklers, whole-house water filter, hardwired internet & Fios fiber. Curb Appeal: Brick/cedar façade, heated radiant snow melt double-wide driveway leads to a 2-car climate controlled garage (EV charger inside, Tesla Wall Connector outside), bluestone patio with fire pit, enclosed yard. Just an 8-minute walk to Little Neck LIRR (28 min to Midtown) and zoned for award-winning District 26 schools—timeless charm meets cutting-edge convenience.