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.
3 days
|
210
|
6
|
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Realty Executives Today718-274-2400,
Minas Styponias646-530-3224
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1020611
Loading...
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 4
Full bathrooms: 3
1/2 bathrooms: 1
Bedroom 1
Description: Master bedroom featuring newly renovated ensuite bathroom
Level: Second
Bedroom 2
Description: Large secondary bedroom with direct access to sunroom/fitness room
Level: Second
Bedroom 3
Description: Queen sized 3rd bedroom with direct access to sunroom/fitness room
Level: Second
Bathroom 1
Description: Half bath next to Chef's Kitchen
Level: First
Bathroom 1
Description: Newly renovated full bathroom with shower
Level: Basement
Bathroom 2
Description: Newly renovated full bathroom in common hallway
Level: Second
Other
Description: Concourse level fully renovated with both interior and exterior entrances featuring a spacious bedroom area.
Level: Basement
Bonus room
Description: Additional room next to entry foyer
Level: First
Den
Description: Den with dual burning fireplace
Level: First
Exercise room
Description: Solarium designed exercise room
Level: Second
Family room
Description: Great room featuring formal dining room, living room, wood burning fireplace, Jack & Jill balcony and backyard access.
Level: First
Kitchen
Description: Chef's kitchen with custom cabinetry, custom/updated appliances, with copper kitchen sink and kitchen ceiling.
Level: First
Living room
Description: Formal living room with double sided gas fireplace
Level: First
Heating
Natural Gas, Steam
Cooling
Central Air, Wall/Window Unit(s)
Appliances
Included: Dishwasher, ENERGY STAR Qualified Appliances, Exhaust Fan, Freezer, Gas Cooktop, Gas Oven, Gas Range, Microwave, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater
Laundry: In Basement
Features
Breakfast Bar, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), Chefs Kitchen, Crown Molding, Eat-in Kitchen, Entrance Foyer, Formal Dining, Granite Counters, High Ceilings, In-Law Floorplan, Natural Woodwork, Open Floorplan, Pantry, Quartz/Quartzite Counters, Recessed Lighting, Sound System, Speakers, Storage, Walk Through Kitchen, Wired for Sound
Fireplace features: Family Room, Gas, Living Room, Wood Burning
Interior area
Total structure area: 3,500
Total interior livable area: 3,500 sqft
Property
Parking
Total spaces: 6
Parking features: Detached, Driveway, Garage, Garage Door Opener, Off Street, Private
Garage spaces: 2
Has uncovered spaces: Yes
Features
Levels: Three Or More
Patio & porch: Covered, Patio, Porch
Fencing: Other,Perimeter
Has view: Yes
View description: Neighborhood, Park/Greenbelt
Lot
Size: 10,600 Square Feet
Dimensions: 106 x 100
Features: Back Yard, Corner Lot, Front Yard, Landscaped, Level, Near Public Transit, Near School, Near Shops, Other, Private, Split Possible, Sprinklers In Front, Sprinklers In Rear, Subdivided, Views
Details
Additional structures: Greenhouse
Parcel number: 060560039
Special conditions: None
Other equipment: Dehumidifier
Construction
Type & style
Home type: SingleFamily
Architectural style: Colonial
Property subtype: Single Family Residence, Residential
Materials
Brick, Other
Foundation: Other, Brick/Mortar
Condition
Updated/Remodeled
Year built: 1940
Utilities & green energy
Sewer: Public Sewer
Water: Public
Utilities for property: Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected
Community & HOA
Community
Security: Security System, Video Cameras
Subdivision: Weeks Woodland
HOA
Has HOA: No
Location
Region: Bayside
Financial & listing details
Price per square foot: $913/sqft
Tax assessed value: $107,280
Annual tax amount: $15,492
Date on market: 7/13/2026
Cumulative days on market: 4 days
Listing agreement: Exclusive Agency
Listing terms: Cash,Conventional
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
7/13/2026
Listed for sale
$3,195,000+565.6%$913/sqft
Source: OneKey® MLS as distributed by MLS GRID #1020611Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.