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.
Do you have other availabilities? Add up to two additional timeframes.
Please select a valid date
Please select a valid time
Please select a valid date
Please select a valid time
How would you like to tour?
Select your preferred video platform(s).
Zoom
FaceTime
Facebook Messenger
Google Meet
WhatsApp
Other
Your health and safety are our top priority. That`s why we’ve added the option to tour properties you are interested in through a live video chat.
Additional info
Enter a valid phone number.
Any additional questions or comments?
Message (optional)
Additional Terms of Use
Before you continue, please review the VOW Terms of Use:
(a) the Registrant has received, read and understood the brochure published by the British Columbia Real Estate Association entitled "Privacy Notice and Consent";
(b) the Registrant acknowledges entering into a lawful REALTOR®/ consumer or REALTOR®/client relationship with the Member;
(c) all data obtained from the MLS® VOW is intended for and may only be used for the Registrant’s personal, non-commercial use;
(d) the Registrant has a bona fide interest in the purchase, sale or lease of real estate of the type being offered through the MLS® VOW;
(e) the Registrant will not himself, and will not permit or assist others to, directly or indirectly:
(i) copy, redistribute or retransmit any of the MLS® VOW Data or information provided;
(ii) display, post, disseminate, distribute, publish, broadcast, transfer, sell or sublicense any of the MLS® VOW Data to another person.
(iii) engage in Scraping (including "screen scraping" and "database scraping"), "data mining" or any other activity intended to collect, store, re-organize, summarize or manipulate any MLS® VOW Data or any related data;
(f) the Registrant acknowledges the Board’s ownership of, and the validity of the Board’s proprietary rights and copyright in the MLS® VOW Data, and listing information; and
(g) the Registrant expressly authorizes the Board or their duly authorized representatives, to access the MLS® VOW and Registrant’s information provided to the MLS® VOW Participant, for the purposes of verifying compliance with and pursuing enforcement of the Terms of Use and all applicable rules, regulations, bylaws, policies, and laws.
This website uses cookies to improve your experience. For more info, read our
Cookie Policy.
By clicking “Accept” or continuing to use this site, you agree to our use of cookies
Terms of Use
and
Privacy Policy.
You have access to 1 more listing!You have access to {value} more listings!
Sign up to view unlimited properties and connect with an agent.
Get connected and never miss another property
Create your free account today!
Receive timely updates on your searches
Get meaningful market data and price trends
Access the world’s largest off-market property network through your KW Agent