Ltdpropertiesny.com Search Results

$5,888,000

Custom Mediterranean-Contemporary Estate !!! An extraordinary opportunity to own a one-of-a-kind Mediterranean-Contemporary estate in desirable Bayside. Built in 2021, this architecturally distinctive residence offers approximately 5,144 sq. ft. and is set on an exceptional 100' × 100' / 10,000-sq.-ft. property, delivering remarkable scale, privacy and resort-style living rarely found in Queens. The striking exterior showcases a classic red-tile roof, elegant architectural detailing, contemporary metal railings, balconies and beautifully manicured landscaping. Inside, a dramatic double-height foyer immediately establishes a sense of grandeur with floor-to-ceiling windows, custom wall paneling, expansive marble-look flooring and a sculptural curved staircase. Above, a rotunda-style ceiling with dimensional detailing and cascading statement chandelier creates an unforgettable architectural centerpiece. The breathtaking double-height great room features exposed beams, an open second-floor gallery and a soaring fireplace feature wall anchored by a distinctive double-sided indoor/outdoor fireplace. Architectural metal-and-glass doors, designed to complement the dramatic front entry, bring abundant natural light into the space and create a seamless connection to the covered outdoor lounge, where the opposite side of the fireplace serves as an equally impressive focal point. The adjoining designer chef's kitchen features extensive custom cabinetry, sleek countertops, an oversized center island with generous seating, designer pendant lighting and a professional-grade multi-burner range beneath a striking metal hood and metallic backsplash. A separate pantry/service area provides additional cabinetry and workspace. A sun-filled breakfast area and elegant formal dining room with herringbone wood flooring, geometric coffered ceiling and statement chandelier complete the main entertaining spaces. Upstairs, the open gallery overlooks the foyer and great room. The expansive primary suite is a private sanctuary featuring custom ceiling treatments, a separate sitting area and spa-inspired bath with freestanding soaking tub, oversized glass-enclosed shower, dual vessel sinks, makeup area and illuminated architectural details. A beautifully designed walk-in dressing room offers extensive built-in cabinetry, shelving, hanging space, drawers and center storage. The exceptional lower level is conceived as a private entertainment and wellness retreat, featuring an expansive media lounge, dedicated recreation and billiards area, and a beautifully appointed private fitness studio. A bespoke hospitality-inspired bar and lounge offers generous seating, illuminated display shelving, beverage refrigeration, sink, rich wood detailing and brick accents, creating the ambiance of an exclusive private club. Outdoors, the estate transforms into a private resort, centered around a resort-style saltwater pool with elevated spa, expansive terraces and mature privacy landscaping. The covered alfresco living and dining pavilion features architectural ceiling detailing, fans, television and the outdoor face of the home's dramatic double-sided fireplace, creating an inviting open-air living room. A fully equipped outdoor culinary pavilion offers multiple cooking stations, sink, extensive cabinetry, generous preparation surfaces and bar seating. Completing this exceptional residence are an expansive second-floor rear terrace, a meticulously finished attached garage and thoughtfully designed indoor-outdoor living throughout. A truly distinctive Bayside estate combining grand architecture, sophisticated design, exceptional entertaining spaces and resort-style amenities on a rare 10,000-sq.-ft. property.

4 Beds ⋅ 6 Baths ⋅ 1047447 MLS

Custom Mediterranean-Contemporary Estate !!! An extraordinary opportunity to own a one-of-a-kind Mediterranean-Contemporary estate in desirable Bayside. Built in 2021, this architecturally distinctive residence offers approximately 5,144 sq. ft. and is set on an exceptional 100' × 100' / 10,000-sq.-ft. property, delivering remarkable scale, privacy and resort-style living rarely found in Queens. The striking exterior showcases a classic red-tile roof, elegant architectural detailing, contemporary metal railings, balconies and beautifully manicured landscaping. Inside, a dramatic double-height foyer immediately establishes a sense of grandeur with floor-to-ceiling windows, custom wall paneling, expansive marble-look flooring and a sculptural curved staircase. Above, a rotunda-style ceiling with dimensional detailing and cascading statement chandelier creates an unforgettable architectural centerpiece. The breathtaking double-height great room features exposed beams, an open second-floor gallery and a soaring fireplace feature wall anchored by a distinctive double-sided indoor/outdoor fireplace. Architectural metal-and-glass doors, designed to complement the dramatic front entry, bring abundant natural light into the space and create a seamless connection to the covered outdoor lounge, where the opposite side of the fireplace serves as an equally impressive focal point. The adjoining designer chef's kitchen features extensive custom cabinetry, sleek countertops, an oversized center island with generous seating, designer pendant lighting and a professional-grade multi-burner range beneath a striking metal hood and metallic backsplash. A separate pantry/service area provides additional cabinetry and workspace. A sun-filled breakfast area and elegant formal dining room with herringbone wood flooring, geometric coffered ceiling and statement chandelier complete the main entertaining spaces. Upstairs, the open gallery overlooks the foyer and great room. The expansive primary suite is a private sanctuary featuring custom ceiling treatments, a separate sitting area and spa-inspired bath with freestanding soaking tub, oversized glass-enclosed shower, dual vessel sinks, makeup area and illuminated architectural details. A beautifully designed walk-in dressing room offers extensive built-in cabinetry, shelving, hanging space, drawers and center storage. The exceptional lower level is conceived as a private entertainment and wellness retreat, featuring an expansive media lounge, dedicated recreation and billiards area, and a beautifully appointed private fitness studio. A bespoke hospitality-inspired bar and lounge offers generous seating, illuminated display shelving, beverage refrigeration, sink, rich wood detailing and brick accents, creating the ambiance of an exclusive private club. Outdoors, the estate transforms into a private resort, centered around a resort-style saltwater pool with elevated spa, expansive terraces and mature privacy landscaping. The covered alfresco living and dining pavilion features architectural ceiling detailing, fans, television and the outdoor face of the home's dramatic double-sided fireplace, creating an inviting open-air living room. A fully equipped outdoor culinary pavilion offers multiple cooking stations, sink, extensive cabinetry, generous preparation surfaces and bar seating. Completing this exceptional residence are an expansive second-floor rear terrace, a meticulously finished attached garage and thoughtfully designed indoor-outdoor living throughout. A truly distinctive Bayside estate combining grand architecture, sophisticated design, exceptional entertaining spaces and resort-style amenities on a rare 10,000-sq.-ft. property.

214-47 33rd Avenue, Bayside

$2,150,000

To be provided 9/10/26.

8 Beds ⋅ 5 Baths ⋅ 1041536 MLS

To be provided 9/10/26.

1516 215th Street, Bayside

$1,248,800

Welcome to this detached one-family home in Bayside highly sought-after School District 26. Situated on an approximately 4,000 SF lot, this spacious residence offers approximately 2,079 SF of living space with 3 bedrooms and 2.5 bathrooms. The home features a finished basement with a separate entrance, providing flexible space for recreation, storage, or additional living needs, plus a dedicated laundry area. Enjoy the privacy and outdoor space of a detached home combined with the convenience of Bayside living. Conveniently located near schools, shopping, dining, transportation, and everyday amenities. A great opportunity for homeowners seeking space, privacy, and a desirable school district.

3 Beds ⋅ 3 Baths ⋅ 1048253 MLS

Welcome to this detached one-family home in Bayside highly sought-after School District 26. Situated on an approximately 4,000 SF lot, this spacious residence offers approximately 2,079 SF of living space with 3 bedrooms and 2.5 bathrooms. The home features a finished basement with a separate entrance, providing flexible space for recreation, storage, or additional living needs, plus a dedicated laundry area. Enjoy the privacy and outdoor space of a detached home combined with the convenience of Bayside living. Conveniently located near schools, shopping, dining, transportation, and everyday amenities. A great opportunity for homeowners seeking space, privacy, and a desirable school district.

26-15 Clearview Expressway, Bayside

$1,548,000

Exceptional opportunity in the heart of Bay Terrace! Offered by the original owners, this spacious brick semi-attached legal two-family home sits on an approximately 29.25' x 100' lot. It offers an outstanding combination of space, income potential, parking, and location. *There is a public swimming pool directly behind the backyard. Daily rates apply. The convenience is simply marvelous! The first-floor apartment features five rooms, two bedrooms, one full bath, and a 1/2 bath in the primary bedroom. The spacious second-floor owner's apartment offers six rooms, including a living room, formal dining room, updated kitchen, three bedrooms, and 1.5 baths, with a private half-bath in the primary bedroom. The home also features a main entrance, finished walk-in level with an additional bathroom, providing valuable additional space and flexibility. Many neighboring properties have taken advantage of the R5 zoning district by converting this lower-level space into a legal apartment. Increasing the use to THREE Family. The building size is approx. 20X52. Exceptional off-street parking is another major advantage, with a front driveway leading to the built-in garage plus a long private side driveway, accommodating approximately four vehicles including the garage. Located in an R5 zoning district, the property offers particularly attractive potential for conversion to a legal three-family residence, as has been done with numerous similar properties throughout the surrounding neighborhood. (presently showing 1800+ buildable sf FAR) Such a conversion may significantly enhance rental income potential, financing opportunities, and the property's long-term inherent value, while requiring only a relatively modest investment relative to the benefits. Buyers should independently verify conversion requirements and feasibility with their architect and other appropriate professionals. The location is quintessential Bay Terrace, just a few short blocks from coveted P.S. 169 Bay Terrace and immediately convenient to the Bay Terrace Shopping Center, with supermarkets, restaurants, shopping, banking, entertainment, movie theaters, and exciting new fitness and lifestyle amenities. Nearby bus transportation provides convenient connections to Downtown Flushing, the LIRR, and Manhattan. The waterfront and beautiful Fort Totten Park are also close by, offering miles of enjoyable walking, recreation, and open space. A rare opportunity to acquire a substantial Bay Terrace two-family with exceptional parking, tremendous versatility, strong income potential, and the possibility of creating an even more valuable legal three-family residence.

6 Beds ⋅ 5 Baths ⋅ 1036736 MLS

Exceptional opportunity in the heart of Bay Terrace! Offered by the original owners, this spacious brick semi-attached legal two-family home sits on an approximately 29.25' x 100' lot. It offers an outstanding combination of space, income potential, parking, and location. *There is a public swimming pool directly behind the backyard. Daily rates apply. The convenience is simply marvelous! The first-floor apartment features five rooms, two bedrooms, one full bath, and a 1/2 bath in the primary bedroom. The spacious second-floor owner's apartment offers six rooms, including a living room, formal dining room, updated kitchen, three bedrooms, and 1.5 baths, with a private half-bath in the primary bedroom. The home also features a main entrance, finished walk-in level with an additional bathroom, providing valuable additional space and flexibility. Many neighboring properties have taken advantage of the R5 zoning district by converting this lower-level space into a legal apartment. Increasing the use to THREE Family. The building size is approx. 20X52. Exceptional off-street parking is another major advantage, with a front driveway leading to the built-in garage plus a long private side driveway, accommodating approximately four vehicles including the garage. Located in an R5 zoning district, the property offers particularly attractive potential for conversion to a legal three-family residence, as has been done with numerous similar properties throughout the surrounding neighborhood. (presently showing 1800+ buildable sf FAR) Such a conversion may significantly enhance rental income potential, financing opportunities, and the property's long-term inherent value, while requiring only a relatively modest investment relative to the benefits. Buyers should independently verify conversion requirements and feasibility with their architect and other appropriate professionals. The location is quintessential Bay Terrace, just a few short blocks from coveted P.S. 169 Bay Terrace and immediately convenient to the Bay Terrace Shopping Center, with supermarkets, restaurants, shopping, banking, entertainment, movie theaters, and exciting new fitness and lifestyle amenities. Nearby bus transportation provides convenient connections to Downtown Flushing, the LIRR, and Manhattan. The waterfront and beautiful Fort Totten Park are also close by, offering miles of enjoyable walking, recreation, and open space. A rare opportunity to acquire a substantial Bay Terrace two-family with exceptional parking, tremendous versatility, strong income potential, and the possibility of creating an even more valuable legal three-family residence.

21266 16th Avenue, Bayside

$1,398,000

Designer-Inspired Expanded Cape in Bayside. Beautifully renovated 4 BEDROOM, 2 BATHROOM residence featuring custom craftsmanship and high-end finishes throughout. MAIN LEVEL * Living & Dining: Welcoming foyer with French doors leading to an elegant living room with a custom marble fireplace mantel (electric insert). Formal dining room with an Andersen picture window. * Chef’s Kitchen: Custom wood cabinetry, quartz countertops, Viking appliance suite, pot filler, and exterior-vented hood. * Bedrooms & Bath: Two spacious main-floor bedrooms (currently used as a den and office) and a full bath with a Jacuzzi tub, tiled recessed shower, designer vanity, and Kohler fixtures. UPPER LEVEL: * Primary Suite: Vaulted ceilings, split A/C unit, bonus sitting/office area, and a luxury marble en-suite bath with a sauna, Grohe fixtures, silver-leaf vanity, Toto toilet, and fully tiled shower. * Additional Bedroom: Oversized second bedroom featuring vaulted ceilings and split A/C. BASEMENT & OUTDOOR: * Basement: Full finished basement with high ceilings, separate laundry room, utilities, and flexible living space. * Sunroom & Yard: All-weather sunroom with removable glass/screen panels and split A/C overlooking a fully fenced, professionally landscaped yard with a paver patio, decorative fountains, and lighting. * PARKING & EXTRAS: Hardwood floors, crown molding, central A/C, custom Silhouette blinds, long paver driveway, and a detached 1-car garage. Conveniently located near Northern Boulevard shopping, dining, and public transportation.

4 Beds ⋅ 2 Baths ⋅ 1030199 MLS

Designer-Inspired Expanded Cape in Bayside. Beautifully renovated 4 BEDROOM, 2 BATHROOM residence featuring custom craftsmanship and high-end finishes throughout. MAIN LEVEL * Living & Dining: Welcoming foyer with French doors leading to an elegant living room with a custom marble fireplace mantel (electric insert). Formal dining room with an Andersen picture window. * Chef’s Kitchen: Custom wood cabinetry, quartz countertops, Viking appliance suite, pot filler, and exterior-vented hood. * Bedrooms & Bath: Two spacious main-floor bedrooms (currently used as a den and office) and a full bath with a Jacuzzi tub, tiled recessed shower, designer vanity, and Kohler fixtures. UPPER LEVEL: * Primary Suite: Vaulted ceilings, split A/C unit, bonus sitting/office area, and a luxury marble en-suite bath with a sauna, Grohe fixtures, silver-leaf vanity, Toto toilet, and fully tiled shower. * Additional Bedroom: Oversized second bedroom featuring vaulted ceilings and split A/C. BASEMENT & OUTDOOR: * Basement: Full finished basement with high ceilings, separate laundry room, utilities, and flexible living space. * Sunroom & Yard: All-weather sunroom with removable glass/screen panels and split A/C overlooking a fully fenced, professionally landscaped yard with a paver patio, decorative fountains, and lighting. * PARKING & EXTRAS: Hardwood floors, crown molding, central A/C, custom Silhouette blinds, long paver driveway, and a detached 1-car garage. Conveniently located near Northern Boulevard shopping, dining, and public transportation.

41-35 219th Street, Bayside

$615,000

Luxury Coop Centrally Located . Move in Ready. Hardwood Floors, 3 Bedrooms ,Oversized Living Room , Dining Room, 2 Full Baths, 2 Terraces, Beautiful View of Little Neck Bay +the Whitestone Bridge.Multiple Closets includes 2 Walk in Closets . Amenities Include 24 Hr. Doorman,Shopping Arcade, Heated Pool,Full Service Health Club,5 Tennis/Pickle Ball Courts, Underground Parking. Close To Bay Terrace Shopping Ctr. Express Bus To Manhattan. NYCT Bus To LIRR (Bayside)Station& Flushing Main Street Subway Station Located One Block Away. Total Maintenance $2,230.10 + Assessment of $151.80 ends 3/29, + Assessment of $129.12 ends 1/28 = Total monthly outlay = $2511.08 Includes Central Heat ,Central Air Conditioning, Gas, Electric, Water & Real estate Taxes. Indoor Parking Available @ $190 Month. Cable and Special Spectrum pkg available Cable +Internet $70 per month.

3 Beds ⋅ 2 Baths ⋅ 1025545 MLS

Luxury Coop Centrally Located . Move in Ready. Hardwood Floors, 3 Bedrooms ,Oversized Living Room , Dining Room, 2 Full Baths, 2 Terraces, Beautiful View of Little Neck Bay +the Whitestone Bridge.Multiple Closets includes 2 Walk in Closets . Amenities Include 24 Hr. Doorman,Shopping Arcade, Heated Pool,Full Service Health Club,5 Tennis/Pickle Ball Courts, Underground Parking. Close To Bay Terrace Shopping Ctr. Express Bus To Manhattan. NYCT Bus To LIRR (Bayside)Station& Flushing Main Street Subway Station Located One Block Away. Total Maintenance $2,230.10 + Assessment of $151.80 ends 3/29, + Assessment of $129.12 ends 1/28 = Total monthly outlay = $2511.08 Includes Central Heat ,Central Air Conditioning, Gas, Electric, Water & Real estate Taxes. Indoor Parking Available @ $190 Month. Cable and Special Spectrum pkg available Cable +Internet $70 per month.

18-05 215th Street Unit #5D, Bayside

$648,000

Welcome to the 16th floor of The Versailles, set within the luxury, resort-style waterfront community of Towers at Water’s Edge. This high-floor H-model 2-bedroom, 2-bathroom unit offers over 1,000 square feet of living space, with oversized windows and 24-foot balcony framing expansive, unobstructed bridge and open-water views overlooking Little Neck Bay. Renovated in 2018, this turnkey home pairs wood-look tile flooring, crown molding, stone counters, and stainless steel appliances, including gas range with exterior-vented exhaust and dishwasher, with an open living/dining area designed for both everyday comfort and entertaining. The flexible second bedroom with French doors opens to the living room and can function as a formal dining room, home office, or traditional 2nd bedroom, giving you options as your lifestyle evolves. The spacious primary suite features dual closets and a private en-suite bathroom, while the additional full bathroom with serves guests and day-to-day living. Thoughtful modern updates throughout and a neutral palette make this a true move-in ready home. The community offers a heated outdoor pool with sun deck, fitness center with Peloton equipment and group classes, four tennis courts including pickleball, basketball court, playground, landscaped common areas, an on-site cafe/deli, spa, dry cleaning, and a full calendar of seasonal events, turning everyday living into a curated five-star experience. Residents also have peace of mind with a 24-hour doorman and attended garage parking. Commuters have easy access to nearby Q12/Q13/Q31 buses, express buses to Manhattan, and Port Washington LIRR, while nature lovers have Fort Totten waterfront and Little Neck Bay moments away, and foodies or night-owls can head to Bay Terrace and Bell Boulevard for upscale dining and a night on the town.

2 Beds ⋅ 2 Baths ⋅ 1024938 MLS

Welcome to the 16th floor of The Versailles, set within the luxury, resort-style waterfront community of Towers at Water’s Edge. This high-floor H-model 2-bedroom, 2-bathroom unit offers over 1,000 square feet of living space, with oversized windows and 24-foot balcony framing expansive, unobstructed bridge and open-water views overlooking Little Neck Bay. Renovated in 2018, this turnkey home pairs wood-look tile flooring, crown molding, stone counters, and stainless steel appliances, including gas range with exterior-vented exhaust and dishwasher, with an open living/dining area designed for both everyday comfort and entertaining. The flexible second bedroom with French doors opens to the living room and can function as a formal dining room, home office, or traditional 2nd bedroom, giving you options as your lifestyle evolves. The spacious primary suite features dual closets and a private en-suite bathroom, while the additional full bathroom with serves guests and day-to-day living. Thoughtful modern updates throughout and a neutral palette make this a true move-in ready home. The community offers a heated outdoor pool with sun deck, fitness center with Peloton equipment and group classes, four tennis courts including pickleball, basketball court, playground, landscaped common areas, an on-site cafe/deli, spa, dry cleaning, and a full calendar of seasonal events, turning everyday living into a curated five-star experience. Residents also have peace of mind with a 24-hour doorman and attended garage parking. Commuters have easy access to nearby Q12/Q13/Q31 buses, express buses to Manhattan, and Port Washington LIRR, while nature lovers have Fort Totten waterfront and Little Neck Bay moments away, and foodies or night-owls can head to Bay Terrace and Bell Boulevard for upscale dining and a night on the town.

18-05 215th Street Unit #16H, Bayside

$1,498,000

***What a solid brick 2 family townhouse condo in prime location of Bayside*** With beautiful surroundings and convenient life choices. The known school district is #26 , close to the well-known PS.203, Junior H.S. 158 or applying for Junior H.S. 74, Cardozo H.S. and Queens Community College (QCC). Walking 5 minutes distance to***Buses Q27 to Flushing,Q30 to Jamaica Lirr.,Q75 to Jamaica, as well, Q74 to Forest Hills, and Qm5 at the corner of Springfield Blvd. & Horace Harding Exwy to Midtown Manhattan. More buses on Northern Blvd. also, there are ***Q12, Q13to Flushing, Q16 in Queens, N20X and LIRR on Bell Blvd to NYC; 9 minutes to ***Bay Terrace Mall with many nice stores*** and Little Neck Bay with fantastic and dark blue ocean view like a beautiful oil painting. 6 minutes distance to the charming**** Oakland Lake, the beauty of Bayside, has been shining through, for so many years, no matter what the weather is. Together with Wildflowers Meadows as parts of famous Alley Pond Park. Walking South across the bridge over LIE/495, it's the community center including 2 community malls on both sides of Springfield Blvd., where there are banks, coffee shops, post office, restaurants, supermarkets, various stores and much more. Just so convenient. As a 3 story building above the ground, its living space is SQF 3374 totally (20.83X54X3 Stories), which offers 6 bedrooms with 18 windows, 3 spacious living rooms, 2 dining rooms, 3,55 renovated bathrooms, 2 EIK. 2 laundry rooms with 2 sets of washer and dryer systems. Featuring hardwood floors, high ceilings, bright, comfortable and full of sunlight. Balcony on the 3rd floor, entrance to the backyard from the 1st floor. 1 Garage. New oil burner for heating. Electric stove for cooking. Maintained well with care and love. Easy access to major roads and highways. A rare opportunity of living with family while collecting rent as an investor, in such a nice and quiet and convenient community. Birdsong and fragrant flowers. Seeing is believing.

6 Beds ⋅ 5 Baths ⋅ 971508 MLS

***What a solid brick 2 family townhouse condo in prime location of Bayside*** With beautiful surroundings and convenient life choices. The known school district is #26 , close to the well-known PS.203, Junior H.S. 158 or applying for Junior H.S. 74, Cardozo H.S. and Queens Community College (QCC). Walking 5 minutes distance to***Buses Q27 to Flushing,Q30 to Jamaica Lirr.,Q75 to Jamaica, as well, Q74 to Forest Hills, and Qm5 at the corner of Springfield Blvd. & Horace Harding Exwy to Midtown Manhattan. More buses on Northern Blvd. also, there are ***Q12, Q13to Flushing, Q16 in Queens, N20X and LIRR on Bell Blvd to NYC; 9 minutes to ***Bay Terrace Mall with many nice stores*** and Little Neck Bay with fantastic and dark blue ocean view like a beautiful oil painting. 6 minutes distance to the charming**** Oakland Lake, the beauty of Bayside, has been shining through, for so many years, no matter what the weather is. Together with Wildflowers Meadows as parts of famous Alley Pond Park. Walking South across the bridge over LIE/495, it's the community center including 2 community malls on both sides of Springfield Blvd., where there are banks, coffee shops, post office, restaurants, supermarkets, various stores and much more. Just so convenient. As a 3 story building above the ground, its living space is SQF 3374 totally (20.83X54X3 Stories), which offers 6 bedrooms with 18 windows, 3 spacious living rooms, 2 dining rooms, 3,55 renovated bathrooms, 2 EIK. 2 laundry rooms with 2 sets of washer and dryer systems. Featuring hardwood floors, high ceilings, bright, comfortable and full of sunlight. Balcony on the 3rd floor, entrance to the backyard from the 1st floor. 1 Garage. New oil burner for heating. Electric stove for cooking. Maintained well with care and love. Easy access to major roads and highways. A rare opportunity of living with family while collecting rent as an investor, in such a nice and quiet and convenient community. Birdsong and fragrant flowers. Seeing is believing.

56-18 Cloverdale Boulevard, Bayside