Ltdpropertiesny.com Search Results

$3,195,000

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 Beds ⋅ 4 Baths ⋅ 1020611 MLS

Bayside

$1,388,000

Rare opportunity to own a solid brick three-family home situated on an expansive 25' x 200' lot that extends from block to block, offering access from two streets and valuable off-street parking from 14th Road. The owner's apartment features a unique loft-style layout with a spacious open living area, kitchen, full bath, and direct access to the beautifully landscaped backyard complete with a patio, swimming pool, and private parking. The second and third floors each offer spacious three-bedroom apartments, providing excellent income potential. The property also includes an unfinished basement that can be incorporated into the owner's apartment or maintained as a separate space, offering flexibility for future use. Additional features include two gas heating units, two separate gas hot water heaters, and ample off-street parking—a rare amenity in today's market. Conveniently located less than one block from the Q26 bus stop and close to shopping, schools, parks, and major roadways, this property is ideal for investors, owner-occupants, or multigenerational living.

7 Beds ⋅ 3 Baths ⋅ 826252 MLS

110-31 15th Avenue, College Point