Listing Tools

Listed by Minas Styponias of Realty Executives Today (718-274-2400)
A truly rare offering and the last of its kind, this fully detached Center Hall Colonial in Weeks Woodland sits on an extraordinary double lot measuring 106' x 100' , presenting a unique opportunity for both luxury living and future development potential. Meticulously maintained and rich in character, the residence offers three spacious bedrooms, three and a half bathrooms, formal living and dining rooms, and multiple gathering spaces designed for both everyday comfort and elegant entertaining. A warm dual sided gas fireplace anchors the den & formal living room, while the impressive Great Room, complete with a wood-burning fireplace, creates the perfect setting for memorable family gatherings. An enclosed upper-level porch provides flexible space for a sunroom, fitness studio, home office, or wellness retreat. The finished lower level includes an additional concourse suite with a private entrance and full bathroom, offering exceptional versatility for extended family, guests, or multi-generational living. Outside, a gated private driveway accommodates up to four vehicles and leads to a coveted two-car garage, with potential to convert the existing structure into an Auxiliary Dwelling Unit (ADU), subject to applicable approvals. The expansive backyard offers a private oasis with ample room for outdoor entertaining, recreation, and future possibilities. Recent capital improvements include recent woodworking, recent painting, new wallpapering, a new boiler and hot water heater installed in 2025, along with HVAC servicing the lower and main levels. Located within highly regarded School District 26 and just moments from over 100 acres of parkland at John Golden and Crocheron Parks, as well as Little Neck Bay and Marina, this exceptional residence combines timeless architecture, unmatched lot size, and an enviable lifestyle in one of the area's most sought-after neighborhoods.

Property Details of

Property Details

Interior Features

Exterior Features

Utilities and Appliances

Community

Other Details

Map Location

Driving Directions

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of August 12, 2026 9:54 AM UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers’ personal noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. The use of the MLS GRID Data may be subject to an end user license agreement.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from The Greene Realty Group. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.