Ltdpropertiesny.com Search Results

$1,990,000

Discover this rare and beautifully maintained detached 2-family home in the heart of Little Neck, offering a generous 52x 28.5 building size and a layout ideal for both end-users and investors. The first floor features 3 bedrooms, a full bathroom, dining room, and a bright living room. The 2nd floor offers 3 bedrooms and 2 full bathrooms, along with a spacious living room, kitchen, and a rear deck that leads down to the backyard. The basement has a separate entrance, offering flexible space ideal for storage, a recreation room and home office. The backyard provides abundant outdoor space, perfect for family gatherings, gardening, excellent setting for relaxation or entertaining. This property is close to buses, parks, district 26 schools, golf club, supermarkets, major highway like Long Island expressway, easy commute to both Flushing and Long Island. There are express buses direct to manhattan and City Hall.

6 Beds ⋅ 3 Baths ⋅ 988006 MLS

Discover this rare and beautifully maintained detached 2-family home in the heart of Little Neck, offering a generous 52x 28.5 building size and a layout ideal for both end-users and investors. The first floor features 3 bedrooms, a full bathroom, dining room, and a bright living room. The 2nd floor offers 3 bedrooms and 2 full bathrooms, along with a spacious living room, kitchen, and a rear deck that leads down to the backyard. The basement has a separate entrance, offering flexible space ideal for storage, a recreation room and home office. The backyard provides abundant outdoor space, perfect for family gatherings, gardening, excellent setting for relaxation or entertaining. This property is close to buses, parks, district 26 schools, golf club, supermarkets, major highway like Long Island expressway, easy commute to both Flushing and Long Island. There are express buses direct to manhattan and City Hall.

251-43 57th Avenue, Little Neck

$1,648,888

Welcome to Fresh Meadows Living at Its Finest! Situated on a prime corner lot, this custom-built residence is a rare offering that effortlessly blends timeless elegance with modern functionality. Meticulously maintained, this expansive home features 4 generously sized bedrooms and 3.5 bathrooms, offering the perfect balance of space, comfort, and style. Step inside and experience the warmth of gleaming hardwood floors flowing throughout a thoughtfully designed layout. The heart of the home is a beautifully appointed kitchen, complete with granite countertops, custom cabinetry, and stainless steel appliances—ideal for both everyday living and seamless entertaining. A true standout is the sun-drenched, oversized sunroom, providing the perfect year-round space to relax, host, or simply enjoy an abundance of natural light. Upstairs, retreat to your private primary suite featuring a full en-suite bath, along with three additional spacious bedrooms and another full bathroom to accommodate guests with ease. Outdoor living is just as impressive, with a fully paved backyard oasis and a generous terrace offering open, elevated views—perfect for morning coffee or evening unwinding. The fully finished basement with a full bath adds valuable bonus space, ideal for recreation, extended living, or entertaining. Additional highlights include a detached one-car garage and a private driveway for added convenience. Perfectly located near top-rated schools, parks, shopping, supermarkets, restaurants, and public transportation, this home offers exceptional convenience for everyday living while maintaining a peaceful residential feel. Appearance: Excellent. A rare opportunity to own a truly special home in the heart of Fresh Meadows—don’t miss it!

4 Beds ⋅ 4 Baths ⋅ 986340 MLS

Welcome to Fresh Meadows Living at Its Finest! Situated on a prime corner lot, this custom-built residence is a rare offering that effortlessly blends timeless elegance with modern functionality. Meticulously maintained, this expansive home features 4 generously sized bedrooms and 3.5 bathrooms, offering the perfect balance of space, comfort, and style. Step inside and experience the warmth of gleaming hardwood floors flowing throughout a thoughtfully designed layout. The heart of the home is a beautifully appointed kitchen, complete with granite countertops, custom cabinetry, and stainless steel appliances—ideal for both everyday living and seamless entertaining. A true standout is the sun-drenched, oversized sunroom, providing the perfect year-round space to relax, host, or simply enjoy an abundance of natural light. Upstairs, retreat to your private primary suite featuring a full en-suite bath, along with three additional spacious bedrooms and another full bathroom to accommodate guests with ease. Outdoor living is just as impressive, with a fully paved backyard oasis and a generous terrace offering open, elevated views—perfect for morning coffee or evening unwinding. The fully finished basement with a full bath adds valuable bonus space, ideal for recreation, extended living, or entertaining. Additional highlights include a detached one-car garage and a private driveway for added convenience. Perfectly located near top-rated schools, parks, shopping, supermarkets, restaurants, and public transportation, this home offers exceptional convenience for everyday living while maintaining a peaceful residential feel. Appearance: Excellent. A rare opportunity to own a truly special home in the heart of Fresh Meadows—don’t miss it!

50-43 192nd Street, Fresh Meadows

$2,488,000

A rare offering in Fresh Meadows, this stunning 7-year young contemporary brick Colonial delivers elevated design, cutting-edge comfort, and uncompromising privacy. Spanning 4 bedrooms and 4.5 baths, every inch of this residence has been curated with refined finishes and modern functionality! A bold open-concept layout featuring formal living spaces and a chef’s eat-in kitchen that showcases a center island and granite countertops, stainless steel appliances, sun-lit breakfast area, and sliders to a private backyard, creating the ultimate indoor-outdoor lifestyle. Upstairs offers a luxurious primary suite with custom closets and en-suite bath, plus three additional spacious bedrooms including a nursery with balcony, a secondary en-suite, and a fourth bedroom with walk-in closet and in-room laundry. The fully finished basement includes a family room, full bath, and oversized custom walk-in closet with Quartz center island large enough to turn into a spacious bedroom, enhancing the home’s versatility. Outdoor, enjoy a fully paved and private property complete with recreation space, two EV charging stations, French drain around the perimeter, and premium security infrastructure – including gated entry, surveillance, and perimeter protection. Additional features include custom wrought iron doors, heated flooring where there is tile, custom closets, central air cooling, a digital gas boiler with 4 zone heating and a tankless hot water heater, Sonos surround system connected for the first floor and yard, 3 split units upstairs, custom indoor-outdoor lighting, solar panels($195/month), high-end Pella windows with custom window treatments, a designed staircase with exquisite wrought iron details, and gleaming cherrywood floors. Located within the highly sought-after School District 26 and just moments away from top-tier amenities, this home represents a seamless blend of luxury and innovation!

4 Beds ⋅ 5 Baths ⋅ 979003 MLS

A rare offering in Fresh Meadows, this stunning 7-year young contemporary brick Colonial delivers elevated design, cutting-edge comfort, and uncompromising privacy. Spanning 4 bedrooms and 4.5 baths, every inch of this residence has been curated with refined finishes and modern functionality! A bold open-concept layout featuring formal living spaces and a chef’s eat-in kitchen that showcases a center island and granite countertops, stainless steel appliances, sun-lit breakfast area, and sliders to a private backyard, creating the ultimate indoor-outdoor lifestyle. Upstairs offers a luxurious primary suite with custom closets and en-suite bath, plus three additional spacious bedrooms including a nursery with balcony, a secondary en-suite, and a fourth bedroom with walk-in closet and in-room laundry. The fully finished basement includes a family room, full bath, and oversized custom walk-in closet with Quartz center island large enough to turn into a spacious bedroom, enhancing the home’s versatility. Outdoor, enjoy a fully paved and private property complete with recreation space, two EV charging stations, French drain around the perimeter, and premium security infrastructure – including gated entry, surveillance, and perimeter protection. Additional features include custom wrought iron doors, heated flooring where there is tile, custom closets, central air cooling, a digital gas boiler with 4 zone heating and a tankless hot water heater, Sonos surround system connected for the first floor and yard, 3 split units upstairs, custom indoor-outdoor lighting, solar panels($195/month), high-end Pella windows with custom window treatments, a designed staircase with exquisite wrought iron details, and gleaming cherrywood floors. Located within the highly sought-after School District 26 and just moments away from top-tier amenities, this home represents a seamless blend of luxury and innovation!

69-42 180th Street, Fresh Meadows

$279,000

Beautiful 1 Bedroom Upper Corner Unit Located in a Lovely Courtyard on a Tree Lined Street. This Sun Filled South Facing Co-op Unit Features Renovated Kitchen with Plenty of Oak Cabinetry with Crown Molding Trim, Granite Countertops, Sleek Marble Tiled Backsplash & Stainless Steel Appliances Including Vented Over-the-Range Microwave. Very Large Oversized Bedroom with Double Door Wardrobe Closet and Built-In Closet System, Two Corner Windows and Air Conditioner. Tiled Bathroom with Elegant Pedestal Sink, Accent Lighting & Sleek Finishes. Additional Features Include Custom Radiator Covers, Large Living Room Closet with Custom Built In Storage, 2 Air Conditioners, Exquisite Lighting Fixtures, Sleek Modern Ceiling Fans, Full Attic for Additional Storage, and Much More. Current Monthly Maintenance Includes All Utilities (Including Electric), Taxes & Parking. No Flip Tax. Close To All Shops, Schools & Transportation.

1 Beds ⋅ 1 Baths ⋅ 972526 MLS

Beautiful 1 Bedroom Upper Corner Unit Located in a Lovely Courtyard on a Tree Lined Street. This Sun Filled South Facing Co-op Unit Features Renovated Kitchen with Plenty of Oak Cabinetry with Crown Molding Trim, Granite Countertops, Sleek Marble Tiled Backsplash & Stainless Steel Appliances Including Vented Over-the-Range Microwave. Very Large Oversized Bedroom with Double Door Wardrobe Closet and Built-In Closet System, Two Corner Windows and Air Conditioner. Tiled Bathroom with Elegant Pedestal Sink, Accent Lighting & Sleek Finishes. Additional Features Include Custom Radiator Covers, Large Living Room Closet with Custom Built In Storage, 2 Air Conditioners, Exquisite Lighting Fixtures, Sleek Modern Ceiling Fans, Full Attic for Additional Storage, and Much More. Current Monthly Maintenance Includes All Utilities (Including Electric), Taxes & Parking. No Flip Tax. Close To All Shops, Schools & Transportation.

60-22 251st Street Unit ##2-504, Little Neck

$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

$1,880,000

Brand-New Fresh Meadows Home in School District 26 | Lower Taxes, Lower Monthly Costs Welcome to this brand-new single-family home in the heart of Fresh Meadows, located in top-rated School District 26. Built as new construction, this home has lower property taxes—an important advantage for buyers looking to keep monthly costs more affordable. This home features 4 bedrooms and 3.5 bathrooms with a layout designed for high quality living. The open-concept main floor is bright and welcoming, highlighted by a double-height living room that brings in great natural light and creates a strong sense of space. The modern kitchen flows naturally into the living and dining areas, making the home both functional and comfortable for daily life and entertaining. A first-floor bedroom and full bath add flexibility for guests, or anyone who prefers to avoid stairs. Upstairs offers three additional bedrooms, including a spacious primary suite. There is also a walk-up attic that provides valuable bonus space for storage, a home office, playroom, or other flexible use. The home is equipped with newly installed solar panels, helping reduce electricity costs and lower overall monthly home expenses. Additional features include garage and driveway parking, plus a lower level with plumbing already in place for future flexibility. Set on a quiet residential block yet close to shops, parks, restaurants, buses, major highways, and St. John’s University, this is a rare opportunity to own a brand-new home in Fresh Meadows that combines modern design, a practical family-friendly layout, strong school district value, and lower long-term carrying costs.

4 Beds ⋅ 4 Baths ⋅ 970183 MLS

Brand-New Fresh Meadows Home in School District 26 | Lower Taxes, Lower Monthly Costs Welcome to this brand-new single-family home in the heart of Fresh Meadows, located in top-rated School District 26. Built as new construction, this home has lower property taxes—an important advantage for buyers looking to keep monthly costs more affordable. This home features 4 bedrooms and 3.5 bathrooms with a layout designed for high quality living. The open-concept main floor is bright and welcoming, highlighted by a double-height living room that brings in great natural light and creates a strong sense of space. The modern kitchen flows naturally into the living and dining areas, making the home both functional and comfortable for daily life and entertaining. A first-floor bedroom and full bath add flexibility for guests, or anyone who prefers to avoid stairs. Upstairs offers three additional bedrooms, including a spacious primary suite. There is also a walk-up attic that provides valuable bonus space for storage, a home office, playroom, or other flexible use. The home is equipped with newly installed solar panels, helping reduce electricity costs and lower overall monthly home expenses. Additional features include garage and driveway parking, plus a lower level with plumbing already in place for future flexibility. Set on a quiet residential block yet close to shops, parks, restaurants, buses, major highways, and St. John’s University, this is a rare opportunity to own a brand-new home in Fresh Meadows that combines modern design, a practical family-friendly layout, strong school district value, and lower long-term carrying costs.

75-31 175th Street, Fresh Meadows

$239,000

Bridge-view unit on the top floor with great water views of Little Neck Bay. This One Bedroom (Junior 4) features a fully enclosed second room for office or Den. large living room/dining area, and closets everywhere! Premium parking spot (#194) is included in your purchase (and visible from the unit), Steps from the QM2/QM32 express bus and Q13/Q31 local buses, walk to one of Bayside's best public schools, Bay Terrace Shopping Center, Bell Boulevard dining and nightlife, and the Bay Terrace Pool Club. Building amenities include fitness center, tennis court, playground, picnic areas, bike storage, storage unit on site, and video surveillance.

1 Beds ⋅ 1 Baths ⋅ 968557 MLS

Bridge-view unit on the top floor with great water views of Little Neck Bay. This One Bedroom (Junior 4) features a fully enclosed second room for office or Den. large living room/dining area, and closets everywhere! Premium parking spot (#194) is included in your purchase (and visible from the unit), Steps from the QM2/QM32 express bus and Q13/Q31 local buses, walk to one of Bayside's best public schools, Bay Terrace Shopping Center, Bell Boulevard dining and nightlife, and the Bay Terrace Pool Club. Building amenities include fitness center, tennis court, playground, picnic areas, bike storage, storage unit on site, and video surveillance.

23-25 Bell Boulevard Unit #6J, Bayside

$385,000

Welcome to Windsor Oaks in the heart of Bayside’s desirable Oakland Gardens! This spacious first-floor two-bedroom, one-bathroom co-op with Courtyard location offers Hardwood Floors, washer in unit for convenience, spacious bedrooms with nice size closets, Granite counter tops, stainless Steel Appliances, Den and parking spaces. Pet Friendly Community! Enjoy easy access to top-rated schools, shops, restaurants, and public transportation Maintenance fee includes heat, cooking gas, water, property tax, garbage removal, ground maintenance. Pet Friendly and NO flip tax ! Minimum downpayment required is 20% and Debt to income ratio must not exceed 30%. Current income must be $85,000.00 minimum per person and $140,000.00 per couple

2 Beds ⋅ 1 Baths ⋅ 966479 MLS

Welcome to Windsor Oaks in the heart of Bayside’s desirable Oakland Gardens! This spacious first-floor two-bedroom, one-bathroom co-op with Courtyard location offers Hardwood Floors, washer in unit for convenience, spacious bedrooms with nice size closets, Granite counter tops, stainless Steel Appliances, Den and parking spaces. Pet Friendly Community! Enjoy easy access to top-rated schools, shops, restaurants, and public transportation Maintenance fee includes heat, cooking gas, water, property tax, garbage removal, ground maintenance. Pet Friendly and NO flip tax ! Minimum downpayment required is 20% and Debt to income ratio must not exceed 30%. Current income must be $85,000.00 minimum per person and $140,000.00 per couple

21947 74th Avenue Unit #First Floor, Oakland Gardens

$268,000

Deepdale Gardens One Bedroom Lower Corner Unit Located in a Tree Lined Courtyard in Great Location. This Sun Soaked Co-op Unit Features New Recessed Lighting, Updated Kitchen with Plenty of Cabinetry, Ceramic Tiled Floor, Quartz Countertops, Ultra Convenient In-Unit Washer, Dryer & Dishwasher, and a Beautiful Open Kitchen Wall Pass Through With Eat-in Breakfast Bar. Open Concept L-Shaped Living Room and Dining Area is Great for Entertaining, and Custom Built Wall Mounted Folding Desk Making For Versatile Flex Work Space if Needed. Oversized Bright Bedroom with Two Corner Windows for Plenty of Sunlight, Modern Sliding Closet Doors, Finished with Closet System. Tiled Bathroom with Marble Pencil Tile Trim and Stone Tiled Flooring. Additional Features Include Co-op Approved Flooring, Two Air Conditioners, Chair Rail Molding, Unit Recently Painted, Convenient Access to Large Parking Lot Nearby, and Large Walk-In Living Room Closet for Plenty of Extra Storage Space. Current Maintenance Includes All Utilities (Including Electric), Taxes and Parking. No Flip Tax. Close To All Shops, Schools and Transportation.

1 Beds ⋅ 1 Baths ⋅ 961717 MLS

Deepdale Gardens One Bedroom Lower Corner Unit Located in a Tree Lined Courtyard in Great Location. This Sun Soaked Co-op Unit Features New Recessed Lighting, Updated Kitchen with Plenty of Cabinetry, Ceramic Tiled Floor, Quartz Countertops, Ultra Convenient In-Unit Washer, Dryer & Dishwasher, and a Beautiful Open Kitchen Wall Pass Through With Eat-in Breakfast Bar. Open Concept L-Shaped Living Room and Dining Area is Great for Entertaining, and Custom Built Wall Mounted Folding Desk Making For Versatile Flex Work Space if Needed. Oversized Bright Bedroom with Two Corner Windows for Plenty of Sunlight, Modern Sliding Closet Doors, Finished with Closet System. Tiled Bathroom with Marble Pencil Tile Trim and Stone Tiled Flooring. Additional Features Include Co-op Approved Flooring, Two Air Conditioners, Chair Rail Molding, Unit Recently Painted, Convenient Access to Large Parking Lot Nearby, and Large Walk-In Living Room Closet for Plenty of Extra Storage Space. Current Maintenance Includes All Utilities (Including Electric), Taxes and Parking. No Flip Tax. Close To All Shops, Schools and Transportation.

251-16 58th Avenue Unit #Unit #25-1, Little Neck

$369,000

Renovated Kitchen, Large Living Rm/Din. Rm, Bedroom has a Huge Walk In Closet. Terrace With South East Water View . Luxury High Rise Bldg. 24 Hr. Doorman & Security. State Of Art Gym. Shopping Arcade W/ Restaurant/Deli/Grocery Store. Beauty Spa, Pool, Gym, Tennis & Party Room. Monthly Outlay of $1,482.02 + assessments of 165+100= 1,747. Includes G+E , Taxes, Central A/C + Heat + Assessments. Indoor Garage parking Avail $190 Monthly, Cable and Special Spectrum pkg available Cable +Internet $70 per month, Additional information: Appearance: Mint

1 Beds ⋅ 1 Baths ⋅ 961551 MLS

Renovated Kitchen, Large Living Rm/Din. Rm, Bedroom has a Huge Walk In Closet. Terrace With South East Water View . Luxury High Rise Bldg. 24 Hr. Doorman & Security. State Of Art Gym. Shopping Arcade W/ Restaurant/Deli/Grocery Store. Beauty Spa, Pool, Gym, Tennis & Party Room. Monthly Outlay of $1,482.02 + assessments of 165+100= 1,747. Includes G+E , Taxes, Central A/C + Heat + Assessments. Indoor Garage parking Avail $190 Monthly, Cable and Special Spectrum pkg available Cable +Internet $70 per month, Additional information: Appearance: Mint

18-15 215th Street Unit #6 A, Bayside

$278,000

Discover this oversized, move-in ready Junior 4 co-op in the heart of Oakland Gardens, Bayside. Thoughtfully designed for comfortable living, Separate formal dining room Bright and airy living room .this home offers a beautifully renovated kitchen, ample closet space including a walk-in closet, and a flexible layout that can easily be converted into a second bedroom, home office, or den. and Capital Assessment is 185.83 On-site parking lot behind the building (first-come, first-served). Buses Q27, Q88, Q46, Q48 QM6 & QM36 stop right outside. Top-Rated Schools Nearby: * P.S. 188 Kingsbury * P.S. 203 * M.S. 172 * Benjamin N. Cardozo High School Close to Alley Pond Park, Cunningham Park, Bayside LIRR Station, and the vibrant Bell Blvd shopping & dining district.

2 Beds ⋅ 1 Baths ⋅ 962106 MLS

Discover this oversized, move-in ready Junior 4 co-op in the heart of Oakland Gardens, Bayside. Thoughtfully designed for comfortable living, Separate formal dining room Bright and airy living room .this home offers a beautifully renovated kitchen, ample closet space including a walk-in closet, and a flexible layout that can easily be converted into a second bedroom, home office, or den. and Capital Assessment is 185.83 On-site parking lot behind the building (first-come, first-served). Buses Q27, Q88, Q46, Q48 QM6 & QM36 stop right outside. Top-Rated Schools Nearby: * P.S. 188 Kingsbury * P.S. 203 * M.S. 172 * Benjamin N. Cardozo High School Close to Alley Pond Park, Cunningham Park, Bayside LIRR Station, and the vibrant Bell Blvd shopping & dining district.

224-24 Union Turnpike Unit #4N, Oakland Gardens

$269,000

Welcome to the stunning Valerie Arms Building, located in the desirable Little Neck area. This updated one-bedroom apartment, situated on the top floor, offers breathtaking bay and bridge views. This apartment features a spacious living room, bedroom, bathroom, and a kitchen equipped with a dishwasher, and a separate dining area. It offers plenty of natural light and ample closet space. The well-maintained building provides excellent amenities including elevator access, 24-hour security, a gym, two laundry rooms, a pool, a deck, courtyard, and easy parking for residents and guests. Conveniently located nearby shopping at Little Neck Plaza, transportation, places of worship, restaurants and hospitals. This CO-OP is also close to Manhattan, Long Island, and local airports.

1 Beds ⋅ 1 Baths ⋅ 956137 MLS

Welcome to the stunning Valerie Arms Building, located in the desirable Little Neck area. This updated one-bedroom apartment, situated on the top floor, offers breathtaking bay and bridge views. This apartment features a spacious living room, bedroom, bathroom, and a kitchen equipped with a dishwasher, and a separate dining area. It offers plenty of natural light and ample closet space. The well-maintained building provides excellent amenities including elevator access, 24-hour security, a gym, two laundry rooms, a pool, a deck, courtyard, and easy parking for residents and guests. Conveniently located nearby shopping at Little Neck Plaza, transportation, places of worship, restaurants and hospitals. This CO-OP is also close to Manhattan, Long Island, and local airports.

54-40 Little Neck Parkway Unit #6M, Little Neck

$239,000

Lovely One Bedroom Upper Corner Unit Nestled in a Beautiful Tree Lined Courtyard. This Bright & Sunny Co-op Unit Features Nicely Maintained Kitchen with Modern Sleek Cabinetry, Marble Tiled Backsplash and Window Sill Trim, New Laminate Flooring, Washing Machine Hook-up, and Open Space to Add Finishing Touches. Open Concept L-Shaped Living Room and Dining Room is Great for Entertaining. Oversized Bedroom with 2 Corner Windows for Plenty of Sunlight and Double Door Wardrobe Closet. Tiled Bathroom with New Flooring. Additional Features Include Large Walk-in Living Room Closet with Shelving, Unit Recently Painted, Brand New Hallway Staircase Carpeting & Full Attic for Additional Storage. Current Maintenance Includes All Utilities (Including Electric), Taxes and Parking. No Flip Tax. Close to All Shops, Schools and Transportation.

1 Beds ⋅ 1 Baths ⋅ 952453 MLS

Lovely One Bedroom Upper Corner Unit Nestled in a Beautiful Tree Lined Courtyard. This Bright & Sunny Co-op Unit Features Nicely Maintained Kitchen with Modern Sleek Cabinetry, Marble Tiled Backsplash and Window Sill Trim, New Laminate Flooring, Washing Machine Hook-up, and Open Space to Add Finishing Touches. Open Concept L-Shaped Living Room and Dining Room is Great for Entertaining. Oversized Bedroom with 2 Corner Windows for Plenty of Sunlight and Double Door Wardrobe Closet. Tiled Bathroom with New Flooring. Additional Features Include Large Walk-in Living Room Closet with Shelving, Unit Recently Painted, Brand New Hallway Staircase Carpeting & Full Attic for Additional Storage. Current Maintenance Includes All Utilities (Including Electric), Taxes and Parking. No Flip Tax. Close to All Shops, Schools and Transportation.

249-36 63rd Avenue Unit ##4-1282, Little Neck

$389,000

It's all about the View. Totally Renovated with an Open Kitchen, Large Living Rm/Din. Rm, Bedroom has a Huge Walk In Closet. Pvt. Terrace With Gorgeous Full South East unobstructed Water View . Luxury High Rise Bldg. 24 Hr. Doorman & Security. State Of Art Gym. Shopping Arcade W/ Restaurant/Deli/Grocery Store. Beauty Spy, Pool, Gym, Tennis & Party Room. Monthly Outlay of $1,737.90 Includes G+E , Taxes, Central A/C + Heat + Assessments. Indoor Garage parking Avail $190 Monthly, Cable and Special Spectrum pkg available Cable +Internet $70 per month, Additional information: Appearance: Mint

1 Beds ⋅ 1 Baths ⋅ 955304 MLS

It's all about the View. Totally Renovated with an Open Kitchen, Large Living Rm/Din. Rm, Bedroom has a Huge Walk In Closet. Pvt. Terrace With Gorgeous Full South East unobstructed Water View . Luxury High Rise Bldg. 24 Hr. Doorman & Security. State Of Art Gym. Shopping Arcade W/ Restaurant/Deli/Grocery Store. Beauty Spy, Pool, Gym, Tennis & Party Room. Monthly Outlay of $1,737.90 Includes G+E , Taxes, Central A/C + Heat + Assessments. Indoor Garage parking Avail $190 Monthly, Cable and Special Spectrum pkg available Cable +Internet $70 per month, Additional information: Appearance: Mint

18-15 215th Street Unit #14 B, Bayside

$265,000

Welcome to this Jr 4 Apt. Plenty of windows, plenty of closets, hardwood floors, updated Kitchen, large size rooms. Apt can be used as a two bedroom. Conveniently located near all transportation and shops., Additional information: Interior Features:Efficiency Kitchen,Lr/Dr

1 Beds ⋅ 1 Baths ⋅ 951238 MLS

Welcome to this Jr 4 Apt. Plenty of windows, plenty of closets, hardwood floors, updated Kitchen, large size rooms. Apt can be used as a two bedroom. Conveniently located near all transportation and shops., Additional information: Interior Features:Efficiency Kitchen,Lr/Dr

18-50 211 Street Unit #6B, Bayside

$1,999,999

Now Offered Under $2 Million – Exceptional Value! Discover the perfect blend of space, comfort, and versatility at 23-10 Waters Edge Drive. This beautifully maintained multi-family residence offers an expansive and flexible floor plan designed to accommodate today's lifestyle, whether you're seeking room for extended family, guest quarters, or additional living space. Filled with natural light, the home features generously sized living and dining areas, spacious bedrooms, and a thoughtfully designed layout that provides both privacy and functionality. Every level offers comfortable living spaces ideal for everyday living and entertaining alike. Enjoy an elevated setting with seasonal water views, while being just minutes from parks, shopping, restaurants, schools, major highways, and public transportation. With its recent price improvement, this home represents an outstanding opportunity to own a spacious, move-in-ready property in one of Northeast Queens' most desirable neighborhoods. Don't miss your chance to experience everything 23-10 Waters Edge Drive has to offer—schedule your private showing today!

8 Beds ⋅ 5 Baths ⋅ 937863 MLS

Now Offered Under $2 Million – Exceptional Value! Discover the perfect blend of space, comfort, and versatility at 23-10 Waters Edge Drive. This beautifully maintained multi-family residence offers an expansive and flexible floor plan designed to accommodate today's lifestyle, whether you're seeking room for extended family, guest quarters, or additional living space. Filled with natural light, the home features generously sized living and dining areas, spacious bedrooms, and a thoughtfully designed layout that provides both privacy and functionality. Every level offers comfortable living spaces ideal for everyday living and entertaining alike. Enjoy an elevated setting with seasonal water views, while being just minutes from parks, shopping, restaurants, schools, major highways, and public transportation. With its recent price improvement, this home represents an outstanding opportunity to own a spacious, move-in-ready property in one of Northeast Queens' most desirable neighborhoods. Don't miss your chance to experience everything 23-10 Waters Edge Drive has to offer—schedule your private showing today!

23-10 Waters Edge Drive, Bayside

$1,100,000

Income-producing two-family home located in the heart of Bayside, offering comfortable living with excellent rental income. Features a fully finished basement with a separate entrance, granite countertops, recently renovated bathrooms, and numerous upgrades throughout. Enjoy outstanding indoor and outdoor living in one of Bayside’s most desirable neighborhoods. Conveniently located near Bayside High School, shops, the LIRR, and major expressways. Turn-key and move-in ready—this one won’t last!

3 Beds ⋅ 2 Baths ⋅ 946162 MLS

Income-producing two-family home located in the heart of Bayside, offering comfortable living with excellent rental income. Features a fully finished basement with a separate entrance, granite countertops, recently renovated bathrooms, and numerous upgrades throughout. Enjoy outstanding indoor and outdoor living in one of Bayside’s most desirable neighborhoods. Conveniently located near Bayside High School, shops, the LIRR, and major expressways. Turn-key and move-in ready—this one won’t last!

207-01 34th Avenue, Bayside

$628,000

Luxury High Rise Bldg With an Unobstructed South East Water View. Totally Renovated with a stunning Open Kitchen. 24 hour doorman/Security, Gym, Tennis/ Pickle Ball , Heated Swimming pool,& indoor Garage. Close to all shopping and transportation. Top rated schools make this a great choice. Shopping Arcade with a Beauty Salon, Dry cleaner/ Tailor, Deli/Grocery Store, Card / Game Room. Maintenance $2,202.04 includes Gas, Elec,, Heat, Central A/C ,Real Estate Taxes + Water . Parking garage available $190 monthly per spot . Special Spectrum pkg available Cable +Internet $70 per month. Appearance: Gorgeous.

2 Beds ⋅ 2 Baths ⋅ 922106 MLS

Luxury High Rise Bldg With an Unobstructed South East Water View. Totally Renovated with a stunning Open Kitchen. 24 hour doorman/Security, Gym, Tennis/ Pickle Ball , Heated Swimming pool,& indoor Garage. Close to all shopping and transportation. Top rated schools make this a great choice. Shopping Arcade with a Beauty Salon, Dry cleaner/ Tailor, Deli/Grocery Store, Card / Game Room. Maintenance $2,202.04 includes Gas, Elec,, Heat, Central A/C ,Real Estate Taxes + Water . Parking garage available $190 monthly per spot . Special Spectrum pkg available Cable +Internet $70 per month. Appearance: Gorgeous.

18-15 215th Street Unit #10 P, Bayside

$4,280,000

A High-End Custom Resort Style Modern Mansion in Little Neck. Welcome to an extraordinary custom mansion, built in 2016, in the prestigious Little Neck area, where architectural vision meets uncompromising luxury on an expansive 11,520 sq ft lot (60x198). This 5,640 sq ft masterpiece begins with a breathtaking 20-foot grand foyer that sets the tone for unparalleled craftsmanship throughout. The coffered ceiling living room and formal dining room create sophisticated entertaining spaces, with oversized windows flooding each room with natural light. At the heart of this resort-style sanctuary lies your crown jewel—a magnificent 400 sq ft climate-controlled indoor heated pool with humidifier, delivering year-round aquatic luxury. The culinary experience reaches new heights with a custom Cambridge kitchen showcasing premium Wolf and Sub-Zero appliances, complemented by a secondary service kitchen that ensures effortless entertaining for any occasion. Comfort is elevated to an art form through ten-zone radiant floor heating, eight-zone central air, and centralized fresh air circulation with 24-hour filtration throughout every corner of this architectural marvel. Indoor and outdoor living merge seamlessly through a stunning gazebo-style sunroom that opens to your lush backyard oasis, complete with a built-in DSC BBQ set for the ultimate alfresco dining experience. Exceptional craftsmanship reveals itself in every detail—from floor-to-ceiling stonework and rich engineered hardwood to the distinctive Welsh slate roof and elegant copper gutters. Your personal wellness retreat features an authentic Canadian cedar sauna, therapeutic soaking Jacuzzi tub, and a glass-enclosed double shower with commercial-grade Hansgrohe systems, creating a spa-inspired bathroom that rivals the world's finest resorts. Entertainment reaches cinematic heights in your dedicated 7-seat home theater, where leather recliners face a commanding 120-inch screen powered by 1,240 watts of premium audio-visual technology. The formal wine cellar satisfies the most distinguished connoisseur while enhancing daily living with sophisticated storage for your finest vintages. Thoughtful luxury extends throughout with an integrated 12-zone music system, central vacuum convenience, and dual laundry rooms for seamless daily living. The grand, curved staircase, adorned with bespoke iron railings, serves as a stunning architectural focal point, while energy efficiency is maximized through the use of spray foam insulation. Quaker windows and doors frame picturesque views while flooding interiors with natural beauty. The fully finished basement expands your living possibilities with an additional 1,800+ sq ft of entertainment space, while a two-car garage provides practical luxury. This architectural masterpiece transcends ordinary luxury living, creating a private resort where every carefully crafted detail serves both beauty and function—the ultimate expression of modern sophistication and refined comfort.

5 Beds ⋅ 6 Baths ⋅ 896180 MLS

A High-End Custom Resort Style Modern Mansion in Little Neck. Welcome to an extraordinary custom mansion, built in 2016, in the prestigious Little Neck area, where architectural vision meets uncompromising luxury on an expansive 11,520 sq ft lot (60x198). This 5,640 sq ft masterpiece begins with a breathtaking 20-foot grand foyer that sets the tone for unparalleled craftsmanship throughout. The coffered ceiling living room and formal dining room create sophisticated entertaining spaces, with oversized windows flooding each room with natural light. At the heart of this resort-style sanctuary lies your crown jewel—a magnificent 400 sq ft climate-controlled indoor heated pool with humidifier, delivering year-round aquatic luxury. The culinary experience reaches new heights with a custom Cambridge kitchen showcasing premium Wolf and Sub-Zero appliances, complemented by a secondary service kitchen that ensures effortless entertaining for any occasion. Comfort is elevated to an art form through ten-zone radiant floor heating, eight-zone central air, and centralized fresh air circulation with 24-hour filtration throughout every corner of this architectural marvel. Indoor and outdoor living merge seamlessly through a stunning gazebo-style sunroom that opens to your lush backyard oasis, complete with a built-in DSC BBQ set for the ultimate alfresco dining experience. Exceptional craftsmanship reveals itself in every detail—from floor-to-ceiling stonework and rich engineered hardwood to the distinctive Welsh slate roof and elegant copper gutters. Your personal wellness retreat features an authentic Canadian cedar sauna, therapeutic soaking Jacuzzi tub, and a glass-enclosed double shower with commercial-grade Hansgrohe systems, creating a spa-inspired bathroom that rivals the world's finest resorts. Entertainment reaches cinematic heights in your dedicated 7-seat home theater, where leather recliners face a commanding 120-inch screen powered by 1,240 watts of premium audio-visual technology. The formal wine cellar satisfies the most distinguished connoisseur while enhancing daily living with sophisticated storage for your finest vintages. Thoughtful luxury extends throughout with an integrated 12-zone music system, central vacuum convenience, and dual laundry rooms for seamless daily living. The grand, curved staircase, adorned with bespoke iron railings, serves as a stunning architectural focal point, while energy efficiency is maximized through the use of spray foam insulation. Quaker windows and doors frame picturesque views while flooding interiors with natural beauty. The fully finished basement expands your living possibilities with an additional 1,800+ sq ft of entertainment space, while a two-car garage provides practical luxury. This architectural masterpiece transcends ordinary luxury living, creating a private resort where every carefully crafted detail serves both beauty and function—the ultimate expression of modern sophistication and refined comfort.

264-11 60th Avenue, Little Neck