Ltdpropertiesny.com Search Results

$680,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

$329,000

INCREDIBLE OPPORTUNITY TO ENJOY THE SPECTACULAR SUMMER SEASON AT NORTH SHORE TOWERS IN BUILDING # 1 IN THIS SOUGHT AFTER, HARD TO FIND 830 SQ. FT. 1 BEDROOM, WITH BALCONY AND FLOOR TO CEILING SLIDING GLASS DOOR! Great layout overlooking manicured golf course and tennis views! Dramatic expansive Living Room/Dining Room. Spacious oversized bedroom that can easily accommodate a full bedroom set with a king size bed. Enjoy incredible storage with four great professionally outfitted closets plus an additional 8 feet of custom “French Door” closets! Fully equipped, renovated opened kitchen with a breakfast bar, granite counters, full height cabinets, including an enclosed washer and dryer. Renovated fully tiled bathroom, with stall shower. Low, Low maintenance of only $1,450 includes an indoor parking space. DON’T MISS SEEING THIS INCREDIBLE FIND THAT WILL “MAKE YOUR MOVE AN EASY ONE!” PRICED FOR IMMEDIATE SALE AT ONLY $329,000!!

1 Beds ⋅ 1 Baths ⋅ 1012057 MLS

INCREDIBLE OPPORTUNITY TO ENJOY THE SPECTACULAR SUMMER SEASON AT NORTH SHORE TOWERS IN BUILDING # 1 IN THIS SOUGHT AFTER, HARD TO FIND 830 SQ. FT. 1 BEDROOM, WITH BALCONY AND FLOOR TO CEILING SLIDING GLASS DOOR! Great layout overlooking manicured golf course and tennis views! Dramatic expansive Living Room/Dining Room. Spacious oversized bedroom that can easily accommodate a full bedroom set with a king size bed. Enjoy incredible storage with four great professionally outfitted closets plus an additional 8 feet of custom “French Door” closets! Fully equipped, renovated opened kitchen with a breakfast bar, granite counters, full height cabinets, including an enclosed washer and dryer. Renovated fully tiled bathroom, with stall shower. Low, Low maintenance of only $1,450 includes an indoor parking space. DON’T MISS SEEING THIS INCREDIBLE FIND THAT WILL “MAKE YOUR MOVE AN EASY ONE!” PRICED FOR IMMEDIATE SALE AT ONLY $329,000!!

27110 Grand Central Parkway Unit #6Y, Floral Park

$1,580,000

Rare development opportunity in Bayside Queens near Bell Blvd & Northern Blvd !! offered at land value on a 50x90 zoning lot with current use as a detached legal two-family. The R4B/C2-2 zoning district permits subdivision into two 25x90 zoning lots, each eligible for a new building application for a semi-detached two-family residence, and also supports commercial building development with community facility can be daycare or doctor office !! Bell Boulevard's retail, and everyday conveniences are minutes away, and the Bayside LIRR station on the Port Washington Branch provides direct service to Penn Station. The Q12, Q31, Q27 and N20X bus lines serve the area, and the Cross Island Parkway and Long Island Expressway interchange puts regional highway access within close reach. Delivered as-is, exterior showing only.

1003908 MLS

Rare development opportunity in Bayside Queens near Bell Blvd & Northern Blvd !! offered at land value on a 50x90 zoning lot with current use as a detached legal two-family. The R4B/C2-2 zoning district permits subdivision into two 25x90 zoning lots, each eligible for a new building application for a semi-detached two-family residence, and also supports commercial building development with community facility can be daycare or doctor office !! Bell Boulevard's retail, and everyday conveniences are minutes away, and the Bayside LIRR station on the Port Washington Branch provides direct service to Penn Station. The Q12, Q31, Q27 and N20X bus lines serve the area, and the Cross Island Parkway and Long Island Expressway interchange puts regional highway access within close reach. Delivered as-is, exterior showing only.

211-53 46th Avenue, Bayside

$598,000

Welcome to Bay Terrace Gardens! A rare find.... Beautiful 2 Bedroom Duplex with 1 Full bathroom upstairs and a half bathroom on the first floor. Corner apartment with a beautiful large outdoor patio. In Unit Washer and Dryer. 2 air conditioners, dishwasher, pull down attic stairs, There are ample closets including a Cedar Closet in the Primary Bedroom. Nothing to do. Just bring your bags and move right in. Base maintenance is $750.16 Total Maintenance Of $835.96 Includes Washer, Dryer, 2 Air Conditioners, Dishwasher, Gas & Electric. Purchaser will get 1 assigned parking space for additional $23.65/month. No waiting list! Close To Bay Terrace Shopping Center, Library, Elementary / Middle School, Express Bus, Local Bus. Fort Totten, Little Bay Park, Clearview Golf Course.

2 Beds ⋅ 2 Baths ⋅ 997472 MLS

Welcome to Bay Terrace Gardens! A rare find.... Beautiful 2 Bedroom Duplex with 1 Full bathroom upstairs and a half bathroom on the first floor. Corner apartment with a beautiful large outdoor patio. In Unit Washer and Dryer. 2 air conditioners, dishwasher, pull down attic stairs, There are ample closets including a Cedar Closet in the Primary Bedroom. Nothing to do. Just bring your bags and move right in. Base maintenance is $750.16 Total Maintenance Of $835.96 Includes Washer, Dryer, 2 Air Conditioners, Dishwasher, Gas & Electric. Purchaser will get 1 assigned parking space for additional $23.65/month. No waiting list! Close To Bay Terrace Shopping Center, Library, Elementary / Middle School, Express Bus, Local Bus. Fort Totten, Little Bay Park, Clearview Golf Course.

12-14 Bell Boulevard Unit #109, Bayside

$1,548,888

Expanded 3-bedroom brick ranch in the heart of Bay Terrace • Situated on an oversized 8,125 sq. ft. corner lot on a quiet private street • Welcoming front slate patio and open-air foyer with dual entry doors • Formal dining room with tiled flooring • Spacious family room and oversized living room with fireplace • Hardwood floors throughout Kitchen Features • Fully equipped eat-in kitchen • Stainless steel refrigerator and dishwasher • Chef's stove in dedicated alcove with its own exhaust system • Center island with gas hookup for a second stove and separate exhaust • White cabinetry and Corian countertops • White tiled flooring and abundant workspace Bedrooms & Bathrooms • Large primary bedroom with space for a king-size bed • Wall-length double closet in primary bedroom • Corner location with abundant natural light • Spacious second bedroom with floor-to-ceiling closet • Generous third bedroom • Custom full bathroom featuring: o Jacuzzi tub o Separate shower o Bidet o Granite tile finishes • Second full bathroom with convenient Jack-and-Jill access Outdoor Living • Living room, dining room and kitchen with direct access to the backyard • Massive elevated south-facing wraparound concrete porch • Private patio and expansive backyard Additional Features • Finished basement with tiled floors • Recently installed water heater and mechanical systems • Unfinished attic with excellent storage potential • Opportunity to create cathedral ceilings in the living room Exceptional Potential • Ideal for a professional or medical office • Potential for an Accessory Dwelling Unit (ADU) for rental income or guest accommodations • Oversized lot offers expansion opportunities • Potential to add a second story or side extensions (subject to approvals) • Architectural plans available showing a main residence with auxiliary dwelling units Prime Location • Approximately 15 miles from Midtown Manhattan • MTA Express Bus just a few blocks away • Easy access to Downtown Flushing and the 7 Train or LIRR • Close to the Bell Boulevard LIRR Station • Near restaurants, cafés, and shopping • Minutes from Little Neck Bay and Fort Totten Park • Enjoy nearby trails, fishing, kayaking, and recreational facilities • Conveniently located near Bay Terrace Shopping Center • Close to Clearview Golf Course Don’t miss this rare opportunity to own a spacious home with endless possibilities in one of Bay Terrace's most desirable locations.

3 Beds ⋅ 2 Baths ⋅ 992392 MLS

Expanded 3-bedroom brick ranch in the heart of Bay Terrace • Situated on an oversized 8,125 sq. ft. corner lot on a quiet private street • Welcoming front slate patio and open-air foyer with dual entry doors • Formal dining room with tiled flooring • Spacious family room and oversized living room with fireplace • Hardwood floors throughout Kitchen Features • Fully equipped eat-in kitchen • Stainless steel refrigerator and dishwasher • Chef's stove in dedicated alcove with its own exhaust system • Center island with gas hookup for a second stove and separate exhaust • White cabinetry and Corian countertops • White tiled flooring and abundant workspace Bedrooms & Bathrooms • Large primary bedroom with space for a king-size bed • Wall-length double closet in primary bedroom • Corner location with abundant natural light • Spacious second bedroom with floor-to-ceiling closet • Generous third bedroom • Custom full bathroom featuring: o Jacuzzi tub o Separate shower o Bidet o Granite tile finishes • Second full bathroom with convenient Jack-and-Jill access Outdoor Living • Living room, dining room and kitchen with direct access to the backyard • Massive elevated south-facing wraparound concrete porch • Private patio and expansive backyard Additional Features • Finished basement with tiled floors • Recently installed water heater and mechanical systems • Unfinished attic with excellent storage potential • Opportunity to create cathedral ceilings in the living room Exceptional Potential • Ideal for a professional or medical office • Potential for an Accessory Dwelling Unit (ADU) for rental income or guest accommodations • Oversized lot offers expansion opportunities • Potential to add a second story or side extensions (subject to approvals) • Architectural plans available showing a main residence with auxiliary dwelling units Prime Location • Approximately 15 miles from Midtown Manhattan • MTA Express Bus just a few blocks away • Easy access to Downtown Flushing and the 7 Train or LIRR • Close to the Bell Boulevard LIRR Station • Near restaurants, cafés, and shopping • Minutes from Little Neck Bay and Fort Totten Park • Enjoy nearby trails, fishing, kayaking, and recreational facilities • Conveniently located near Bay Terrace Shopping Center • Close to Clearview Golf Course Don’t miss this rare opportunity to own a spacious home with endless possibilities in one of Bay Terrace's most desirable locations.

214-40 24th Avenue, Bayside

$1,725,000

Welcome to 249-25 Cullman Avenue, a beautifully maintained brick home in Little Neck offering classic curb appeal, refined interior finishes, and flexible living space across multiple levels. A gated entry opens to a dramatic double-height foyer, setting the tone for the home’s light-filled layout, hardwood floors, crown molding, recessed lighting, and polished marble tile details. The main level features a formal living room with a gas fireplace, a formal dining room framed by bay windows, and a chef’s kitchen with an oversized center island, granite countertops, stainless steel appliances, custom cabinetry, and a detailed tile backsplash. Designed with an easy flow for everyday living and entertaining, this level is completed by a convenient powder room. Upstairs, the second level offers three versatile rooms, including a spacious primary suite with an en-suite full bathroom. The finished lower level provides additional flexible living space with a full bathroom and walk-out access. Outside, enjoy a private backyard with a deck, patio, pergola, and manicured landscaping. Additional highlights include central air conditioning, multi-zone European-style baseboard heating, Anderson windows, instant hot water, clay tile roof, private driveway, attached garage, and all-brick construction. Conveniently located near shopping, dining, parks, transportation, and the LIRR, this Little Neck home offers a polished blend of comfort, function, and accessibility in a desirable Queens location.

3 Beds ⋅ 3 Baths ⋅ 992485 MLS

Welcome to 249-25 Cullman Avenue, a beautifully maintained brick home in Little Neck offering classic curb appeal, refined interior finishes, and flexible living space across multiple levels. A gated entry opens to a dramatic double-height foyer, setting the tone for the home’s light-filled layout, hardwood floors, crown molding, recessed lighting, and polished marble tile details. The main level features a formal living room with a gas fireplace, a formal dining room framed by bay windows, and a chef’s kitchen with an oversized center island, granite countertops, stainless steel appliances, custom cabinetry, and a detailed tile backsplash. Designed with an easy flow for everyday living and entertaining, this level is completed by a convenient powder room. Upstairs, the second level offers three versatile rooms, including a spacious primary suite with an en-suite full bathroom. The finished lower level provides additional flexible living space with a full bathroom and walk-out access. Outside, enjoy a private backyard with a deck, patio, pergola, and manicured landscaping. Additional highlights include central air conditioning, multi-zone European-style baseboard heating, Anderson windows, instant hot water, clay tile roof, private driveway, attached garage, and all-brick construction. Conveniently located near shopping, dining, parks, transportation, and the LIRR, this Little Neck home offers a polished blend of comfort, function, and accessibility in a desirable Queens location.

249-25 Cullman Avenue, Little Neck

$429,000

** PRICED TO SELL ** Spacious 3-bedroom, 2-bath K-Line co-op offering over 1,500 sq ft of interior living space in the Kennedy Street Quad, ideally located in the Bay Terrace section of Bayside. This 2nd-floor, 6-room unit welcomes you with a large entry foyer that opens to a bright living room with an L-shaped dining area, perfect for everyday living and entertaining. The layout features 3 well-proportioned bedrooms, including a primary suite with a full ensuite bath and 2 walk-in closets for exceptional storage. Enjoy central air and heat, plus the convenience of included parking and no flip tax. The beautifully maintained community offers landscaped grounds, on-site laundry, a playground, bike storage, and full-time maintenance staff. Just steps from the Bay Terrace Shopping Center, with nearby local and express buses including the Q13, Q28, QM2, QM20, and QM32 providing convenient service to Manhattan. Bell Blvd's LIRR station, dining, and vibrant nightlife are only a short trip away, truly a wonderful lifestyle in one of Bayside's most desirable communities.

3 Beds ⋅ 2 Baths ⋅ 991577 MLS

** PRICED TO SELL ** Spacious 3-bedroom, 2-bath K-Line co-op offering over 1,500 sq ft of interior living space in the Kennedy Street Quad, ideally located in the Bay Terrace section of Bayside. This 2nd-floor, 6-room unit welcomes you with a large entry foyer that opens to a bright living room with an L-shaped dining area, perfect for everyday living and entertaining. The layout features 3 well-proportioned bedrooms, including a primary suite with a full ensuite bath and 2 walk-in closets for exceptional storage. Enjoy central air and heat, plus the convenience of included parking and no flip tax. The beautifully maintained community offers landscaped grounds, on-site laundry, a playground, bike storage, and full-time maintenance staff. Just steps from the Bay Terrace Shopping Center, with nearby local and express buses including the Q13, Q28, QM2, QM20, and QM32 providing convenient service to Manhattan. Bell Blvd's LIRR station, dining, and vibrant nightlife are only a short trip away, truly a wonderful lifestyle in one of Bayside's most desirable communities.

18-75 Corporal Kennedy Street Unit #2K, Bayside

$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,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

$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

$835,000

ENJOY INCREDIBLE LOCATION, VIEWS AND RENOVATION! HARD TO FIND! HIGH FLOOR 2 BEDROOM, 2.5 BATH, 1,600 SQUARE FOOT CORNER. SOUGHT AFTER OUTSIDE CORNER WITH UNOBSTRUCTED PANORAMIC SOUTHEAST AND NORTHWEST EXPOSURES WITH WESTERN SKYLINE VIEWS! MAGNIFICENT GOLF, LAKE, TENNIS AND CITY VIEWS FROM YOUR LARGE WALK-OUT TERRACE AND 2 BALCONIES! ENJOY DRAMATIC SUNSETS! Traditional elegance abounds from the moment you enter this gracious sundrenched home! Gourmet eat-in kitchen with windowed dinette area, new full-height cabinets and granite counters, fully equipped with an enclosed washer / dryer. Large formal dining room with a full walk-out TERRACE, opens to an oversized living room with a BALCONY. Second bedroom, “At Home Office,” DEN has a BALCONY with sliding glass doors and enlarged ensuite with stall shower. Primary bedroom has a professionally outfitted walk-in closet and an expanded, exquisite fully tiled ensuite bath with an enlarged vanity and a stall shower! Many, many custom extras throughout! Indoor parking. THIS STUNNING HOME WILL MAKE YOUR MOVE AN EASY ONE! CAN NOT BE DUPLICATED FOR ONLY $835,000.

2 Beds ⋅ 3 Baths ⋅ 965926 MLS

ENJOY INCREDIBLE LOCATION, VIEWS AND RENOVATION! HARD TO FIND! HIGH FLOOR 2 BEDROOM, 2.5 BATH, 1,600 SQUARE FOOT CORNER. SOUGHT AFTER OUTSIDE CORNER WITH UNOBSTRUCTED PANORAMIC SOUTHEAST AND NORTHWEST EXPOSURES WITH WESTERN SKYLINE VIEWS! MAGNIFICENT GOLF, LAKE, TENNIS AND CITY VIEWS FROM YOUR LARGE WALK-OUT TERRACE AND 2 BALCONIES! ENJOY DRAMATIC SUNSETS! Traditional elegance abounds from the moment you enter this gracious sundrenched home! Gourmet eat-in kitchen with windowed dinette area, new full-height cabinets and granite counters, fully equipped with an enclosed washer / dryer. Large formal dining room with a full walk-out TERRACE, opens to an oversized living room with a BALCONY. Second bedroom, “At Home Office,” DEN has a BALCONY with sliding glass doors and enlarged ensuite with stall shower. Primary bedroom has a professionally outfitted walk-in closet and an expanded, exquisite fully tiled ensuite bath with an enlarged vanity and a stall shower! Many, many custom extras throughout! Indoor parking. THIS STUNNING HOME WILL MAKE YOUR MOVE AN EASY ONE! CAN NOT BE DUPLICATED FOR ONLY $835,000.

26910 Grand Central Parkway Unit #31N, Floral Park

$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