Description
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 suitesteam shower, Kohler Numi smart toilet/bidet, and walk-in closetwhile 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 tapideal 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 faade, 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 schoolstimeless charm meets cutting-edge convenience.
-
3BEDS
-
0.16ACRES
-
3BATHS
-
01/2 BATHS
-
2,300SQFT
-
$0$/SQFT
School Information
Description
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 suitesteam shower, Kohler Numi smart toilet/bidet, and walk-in closetwhile 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 tapideal 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 faade, 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 schoolstimeless charm meets cutting-edge convenience.
© 2026 OneKey MLS. All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or DeSimone Real Estate. Data last updated: 2026-04-22T22:19:06.19.