Ltdpropertiesny.com Search Results

$1,390,000

One property. Multiple possibilities. This unique 2,605 sq. ft. home offers the space and flexibility that's increasingly difficult to find in Queens—whether you're looking to live comfortably while generating rental income, accommodate extended family, or add a multifamily property to your portfolio. The spacious owner's triplex features 3 bedrooms, 2 full baths, an entry foyer/home office and private access to the basement, creating a true home within the property. Two additional 1-bedroom living spaces each have their own private entrance, providing exceptional flexibility and privacy. The property is legally classified as a 2-family per the Certificate of Occupancy and has been assessed and taxed by NYC Department of Finance as a 3-family for approximately 15 years. With 3 separate entrances, 3 electric meters, a private driveway with parking for 2–3 cars, an attached garage and annual property taxes of just $12,927, the home's setup is difficult to duplicate. For an owner-occupant, the opportunity is especially compelling: enjoy the space of your own 3-bedroom home while additional living space provides the potential to help offset the cost of ownership. For multigenerational households, the separate living areas offer the ability to keep close without sacrificing privacy. Conveniently located near Union Turnpike shopping and dining, transportation and the Grand Central Parkway. More than simply a multifamily home, 69-33 Little Neck Pkwy offers flexibility for the way you want to live today—and options for the future.

5 Beds ⋅ 4 Baths ⋅ 988304 MLS

One property. Multiple possibilities. This unique 2,605 sq. ft. home offers the space and flexibility that's increasingly difficult to find in Queens—whether you're looking to live comfortably while generating rental income, accommodate extended family, or add a multifamily property to your portfolio. The spacious owner's triplex features 3 bedrooms, 2 full baths, an entry foyer/home office and private access to the basement, creating a true home within the property. Two additional 1-bedroom living spaces each have their own private entrance, providing exceptional flexibility and privacy. The property is legally classified as a 2-family per the Certificate of Occupancy and has been assessed and taxed by NYC Department of Finance as a 3-family for approximately 15 years. With 3 separate entrances, 3 electric meters, a private driveway with parking for 2–3 cars, an attached garage and annual property taxes of just $12,927, the home's setup is difficult to duplicate. For an owner-occupant, the opportunity is especially compelling: enjoy the space of your own 3-bedroom home while additional living space provides the potential to help offset the cost of ownership. For multigenerational households, the separate living areas offer the ability to keep close without sacrificing privacy. Conveniently located near Union Turnpike shopping and dining, transportation and the Grand Central Parkway. More than simply a multifamily home, 69-33 Little Neck Pkwy offers flexibility for the way you want to live today—and options for the future.

6933 Little Neck Parkway, Glen Oaks

$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

$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

$365,000

Great Opportunity To Own This First Floor Unit With Desirable Courtyard Location!Spacious First-Floor Two-Bedroom, One-Bathroom , Hardwood Floors, Washer in unit for Convenience, Den ,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, 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

Great Opportunity To Own This First Floor Unit With Desirable Courtyard Location!Spacious First-Floor Two-Bedroom, One-Bathroom , Hardwood Floors, Washer in unit for Convenience, Den ,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, 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 #A1, Oakland Gardens

$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

$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

$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