Ltdpropertiesny.com Search Results

$388,000

Welcome to this charming and spacious 3-bedroom upper level garden apartment located in the highly sought-after Beech Hills cooperative community in Douglaston. Offering approximately 1,050 square feet of living space, this inviting home is tucked away in a quiet courtyard setting and offers an abundance of natural light and generous room sizes. Set on approximately 45 acres of beautifully landscaped grounds with rolling hills and winding pathways, Beech Hills offers residents a peaceful, suburban setting with an impressive array of amenities. Enjoy a playground and spray park, community room with kitchen available for private parties, picnic areas, laundry facilities, bike storage, private sanitation pickup six days a week, and free parking. Adding to the exceptional value, the monthly maintenance includes ALL utilities — electric, gas, water, heat, taxes and snow removal. Conveniently located near the Douglaston Golf Course, shopping, supermarkets, restaurants and schools, with easy access to major expressways, local buses and express buses to Manhattan. Offering space, convenience, amenities and a wonderful community setting, this Beech Hills apartment is an opportunity not to be missed!

3 Beds ⋅ 1 Baths ⋅ 1050147 MLS

Welcome to this charming and spacious 3-bedroom upper level garden apartment located in the highly sought-after Beech Hills cooperative community in Douglaston. Offering approximately 1,050 square feet of living space, this inviting home is tucked away in a quiet courtyard setting and offers an abundance of natural light and generous room sizes. Set on approximately 45 acres of beautifully landscaped grounds with rolling hills and winding pathways, Beech Hills offers residents a peaceful, suburban setting with an impressive array of amenities. Enjoy a playground and spray park, community room with kitchen available for private parties, picnic areas, laundry facilities, bike storage, private sanitation pickup six days a week, and free parking. Adding to the exceptional value, the monthly maintenance includes ALL utilities — electric, gas, water, heat, taxes and snow removal. Conveniently located near the Douglaston Golf Course, shopping, supermarkets, restaurants and schools, with easy access to major expressways, local buses and express buses to Manhattan. Offering space, convenience, amenities and a wonderful community setting, this Beech Hills apartment is an opportunity not to be missed!

56-15 244 Street Unit #Upper, Douglaston

$2,150,000

To be provided 9/10/26.

8 Beds ⋅ 5 Baths ⋅ 1041536 MLS

To be provided 9/10/26.

1516 215th Street, Bayside

$1,248,800

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

3 Beds ⋅ 3 Baths ⋅ 1048253 MLS

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

26-15 Clearview Expressway, Bayside

$358,000

Just Listed! Welcome to this well-maintained 2–3 bedroom, second-floor co-op nestled on a quiet cul-de-sac. This home features a bright kitchen with the convenience of an in-unit washer and dryer. Two generously sized bedrooms offer ample closet space, while a versatile third room can easily serve as an additional bedroom, formal dining room, or home office. An attic provides additional storage space. Hardwood floors are now allowed .Enjoy peaceful golf course views from the rear of the unit, adding to the charm and tranquility of this lovely home. Residents benefit from ample parking, two decals per unit. A peaceful setting that blends comfort, style, and convenience. Monthly maintenance includes all utilities, electric, gas, water, heat, and hot water, plus real estate taxes, garbage removal and snow removal, private security, grounds maintenance, and security cameras. Ideally located near all transportation, including express and local buses to New York City, and close to shopping and restaurants. Outdoor barbecuing is permitted. Additional information: flip tax paid by seller. Minimum financing 80%. DTI must be under 36%, including mortgage and maintenance. Preapproval or proof of funds required prior to all showings per Seller request. Don't miss this rare opportunity to own a beautiful unit and a desirable, well-kept community.

2 Beds ⋅ 1 Baths ⋅ 1024520 MLS

Just Listed! Welcome to this well-maintained 2–3 bedroom, second-floor co-op nestled on a quiet cul-de-sac. This home features a bright kitchen with the convenience of an in-unit washer and dryer. Two generously sized bedrooms offer ample closet space, while a versatile third room can easily serve as an additional bedroom, formal dining room, or home office. An attic provides additional storage space. Hardwood floors are now allowed .Enjoy peaceful golf course views from the rear of the unit, adding to the charm and tranquility of this lovely home. Residents benefit from ample parking, two decals per unit. A peaceful setting that blends comfort, style, and convenience. Monthly maintenance includes all utilities, electric, gas, water, heat, and hot water, plus real estate taxes, garbage removal and snow removal, private security, grounds maintenance, and security cameras. Ideally located near all transportation, including express and local buses to New York City, and close to shopping and restaurants. Outdoor barbecuing is permitted. Additional information: flip tax paid by seller. Minimum financing 80%. DTI must be under 36%, including mortgage and maintenance. Preapproval or proof of funds required prior to all showings per Seller request. Don't miss this rare opportunity to own a beautiful unit and a desirable, well-kept community.

245-12 62 Avenue Unit #2nd Floor, Douglaston

$1,548,000

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

6 Beds ⋅ 5 Baths ⋅ 1036736 MLS

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

21266 16th Avenue, Bayside

$1,795,000

A meticulously maintained home in the coveted Douglaston, NY neighborhood. Only one block from the historic Douglas Manor. During the winter months enjoy views of Manhattan and Little Neck bay from the two upstairs bedrooms providing a potential upgrade opportunity. Experience the perfect blend of suburban tranquility and New York City convenience in this 5-bedroom, 3 full bath, and 1 half bath home, ideally situated in this highly sought-after neighborhood. Designed with flexibility in mind, this exceptional residence is thoughtfully configured for multi-generational living, offering an ideal layout for extended family, guests, or private living arrangements while maintaining comfort and privacy. Spacious living areas, generous bedrooms, and thoughtful updates make this home perfect for both everyday living and entertaining. Located in the award-winning NYC School District 26, this home is just a short walk to the Long Island Rail Road, shopping, restaurants, houses of worship, parks, and schools, providing unmatched convenience while preserving the charm of a suburban lifestyle. Enjoy proximity to the prestigious Douglaston Club and the Douglaston Golf Course, along with access to Little Neck Bay for boating, kayaking, paddle boarding, or simply enjoying the waterfront lifestyle. Whether you're looking for top-rated schools, a home designed for multi-generational living, or an unbeatable location, this property presents a rare opportunity to own one of Douglaston's finest homes.

5 Beds ⋅ 4 Baths ⋅ 1032539 MLS

A meticulously maintained home in the coveted Douglaston, NY neighborhood. Only one block from the historic Douglas Manor. During the winter months enjoy views of Manhattan and Little Neck bay from the two upstairs bedrooms providing a potential upgrade opportunity. Experience the perfect blend of suburban tranquility and New York City convenience in this 5-bedroom, 3 full bath, and 1 half bath home, ideally situated in this highly sought-after neighborhood. Designed with flexibility in mind, this exceptional residence is thoughtfully configured for multi-generational living, offering an ideal layout for extended family, guests, or private living arrangements while maintaining comfort and privacy. Spacious living areas, generous bedrooms, and thoughtful updates make this home perfect for both everyday living and entertaining. Located in the award-winning NYC School District 26, this home is just a short walk to the Long Island Rail Road, shopping, restaurants, houses of worship, parks, and schools, providing unmatched convenience while preserving the charm of a suburban lifestyle. Enjoy proximity to the prestigious Douglaston Club and the Douglaston Golf Course, along with access to Little Neck Bay for boating, kayaking, paddle boarding, or simply enjoying the waterfront lifestyle. Whether you're looking for top-rated schools, a home designed for multi-generational living, or an unbeatable location, this property presents a rare opportunity to own one of Douglaston's finest homes.

3850 Hillcrest Avenue, Douglaston

$1,098,000

Exceptional opportunity to own a spacious Colonial on a quiet, tree-lined street in the desirable Hollis Hills section of Oakland Gardens, Queens. Situated on a 42' x 95' lot and offering approximately 1,830 square feet of living space, this home features 3 bedrooms, 1.5 bathrooms, a full finished basement, a private driveway, an attached one-car garage, and a large private backyard with endless possibilities for entertaining and relaxation. Perfect for an end user looking to customize their dream home or an investor seeking a value-add opportunity, this property offers tremendous potential in an unbeatable location with low taxes, zoned for School District Queens 26. Ideally situated just off Union Turnpike and Springfield Boulevard, you'll enjoy convenient access to major highways, shopping, dining, public transportation, and everyday conveniences, with both Alley Pond Park and Cunningham Park just minutes away. A rare opportunity to create lasting value in one of Northeast Queens' most accessible neighborhoods.

3 Beds ⋅ 2 Baths ⋅ 1033665 MLS

Exceptional opportunity to own a spacious Colonial on a quiet, tree-lined street in the desirable Hollis Hills section of Oakland Gardens, Queens. Situated on a 42' x 95' lot and offering approximately 1,830 square feet of living space, this home features 3 bedrooms, 1.5 bathrooms, a full finished basement, a private driveway, an attached one-car garage, and a large private backyard with endless possibilities for entertaining and relaxation. Perfect for an end user looking to customize their dream home or an investor seeking a value-add opportunity, this property offers tremendous potential in an unbeatable location with low taxes, zoned for School District Queens 26. Ideally situated just off Union Turnpike and Springfield Boulevard, you'll enjoy convenient access to major highways, shopping, dining, public transportation, and everyday conveniences, with both Alley Pond Park and Cunningham Park just minutes away. A rare opportunity to create lasting value in one of Northeast Queens' most accessible neighborhoods.

78-28 222nd Street, Oakland Gardens

$648,000

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

2 Beds ⋅ 2 Baths ⋅ 1024938 MLS

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

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

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

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

$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

$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