Walt-realtor.com Search Results

$3,888,888

This SPRAWLING Ranch in the heart of the waterfront community of Douglas Manor sits on an impressive 16,000 sq. ft. lot. With over 9,800 sq. ft. of living space, this home is elegant yet inviting and thoughtfully designed with generously sized rooms and exceptional amenities. From the moment you enter the grand foyer with its dramatic 20-foot domed ceiling, you’ll notice the beautiful custom millwork, elegant archways, architectural ceilings, and carefully placed skylights that bring an abundance of natural light into the home. An impressive gallery-style corridor, framed by graceful archways, runs through the heart of the home, creating a seamless flow from room to room. Radiant heat beneath all tile and stone floors, along with multiple heating and cooling zones throughout the home, provide exceptional year-round comfort. Over 4,800 sq. ft. of living space on the main floor featuring four spacious bedrooms, including an impressive primary suite with a spectacular two-level custom walk-in closet. A large home office offers the flexibility to serve as an additional bedroom. The sunken formal LR, formal DR, and den provide large spaces for both everyday living and entertaining. The gourmet kitchen and breakfast area feature a large center island with an additional sink and top of the line appliances including Sub-Zero refrigerator, Viking stove and warming drawer, wine refrigerator, dishwasher, microwave. Gas fireplaces add warmth and ambiance throughout the home, while radiant heating and central vacuum add another level of comfort and convenience. French doors from the kitchen open to the patio and backyard. Enjoy the in-ground pool, outdoor kitchen, and generous space for dining, lounging, and gathering with family and friends. And then there’s the lower level—another 4,800 sq. ft. and an entertainer’s dream! This expansive space features an in-law suite, large entertainment room, wine room, wet bar, gym, and your own private spa retreat complete with a steam room and sauna. An attached two-car garage and wide driveway with parking for four additional cars provide plenty of off-street parking. The Douglas Manor Association maintains the shared waterfront and provides private security. Residents also have the opportunity to join the Douglaston Club, which offers a pool, tennis courts, dining, and year-round social events.

5 Beds ⋅ 6 Baths ⋅ 1048749 MLS

This SPRAWLING Ranch in the heart of the waterfront community of Douglas Manor sits on an impressive 16,000 sq. ft. lot. With over 9,800 sq. ft. of living space, this home is elegant yet inviting and thoughtfully designed with generously sized rooms and exceptional amenities. From the moment you enter the grand foyer with its dramatic 20-foot domed ceiling, you’ll notice the beautiful custom millwork, elegant archways, architectural ceilings, and carefully placed skylights that bring an abundance of natural light into the home. An impressive gallery-style corridor, framed by graceful archways, runs through the heart of the home, creating a seamless flow from room to room. Radiant heat beneath all tile and stone floors, along with multiple heating and cooling zones throughout the home, provide exceptional year-round comfort. Over 4,800 sq. ft. of living space on the main floor featuring four spacious bedrooms, including an impressive primary suite with a spectacular two-level custom walk-in closet. A large home office offers the flexibility to serve as an additional bedroom. The sunken formal LR, formal DR, and den provide large spaces for both everyday living and entertaining. The gourmet kitchen and breakfast area feature a large center island with an additional sink and top of the line appliances including Sub-Zero refrigerator, Viking stove and warming drawer, wine refrigerator, dishwasher, microwave. Gas fireplaces add warmth and ambiance throughout the home, while radiant heating and central vacuum add another level of comfort and convenience. French doors from the kitchen open to the patio and backyard. Enjoy the in-ground pool, outdoor kitchen, and generous space for dining, lounging, and gathering with family and friends. And then there’s the lower level—another 4,800 sq. ft. and an entertainer’s dream! This expansive space features an in-law suite, large entertainment room, wine room, wet bar, gym, and your own private spa retreat complete with a steam room and sauna. An attached two-car garage and wide driveway with parking for four additional cars provide plenty of off-street parking. The Douglas Manor Association maintains the shared waterfront and provides private security. Residents also have the opportunity to join the Douglaston Club, which offers a pool, tennis courts, dining, and year-round social events.

23728 Beverly Road, Douglaston

$1,968,800

THIS IS A HOME THAT MUST BE EXPERIENCED !! Set on a magnificent 82x100 property, this beautifully appointed Little Neck Hills residence offers something photographs and measurements alone cannot capture. Designed with warmth and texture throughout, the home is expansive where it matters, with virtually every space thoughtfully considered for the way people actually live. The stunning open first floor offers both a generous living room with gas fireplace and a beautiful great room—creating an effortlessly airy everyday living as well as gracious entertaining. At its heart, the spacious custom eat-in kitchen pairs exceptional design with serious functionality, featuring top-of-the-line appliances, abundant cabinetry and storage, and thoughtfully conceived space for cooking, dining and gathering. With 4 bedrooms and 3.5 baths, the home balances shared living with beautifully appointed private spaces. The primary suite is a destination of its own, highlighted by a state-of-the-art bath designed with the comfort, materials and finishes of a private retreat. Throughout, fine craftsmanship and sophisticated details create a quiet sense of quality rather than excess. The exceptionally versatile finished lower level sets itself apart with ceiling heights of approximately 7.5 to 8 feet, creating genuinely livable space with tremendous flexibility for guest accommodations, recreation, a home office, fitness or additional gathering. And then there are the remarkable grounds. Nestled on a quiet, low-traffic cul-de-sac, the exquisite landscaping and hardscaping transform the generous property into a seamless extension of the home, with inviting spaces for dining, entertaining and serenity surrounded by meticulously planned mature plantings and privacy. Extensive improvements throughout reflect thoughtful investment not simply in how a home looks, but in how beautifully and comfortably it lives, a true turn-key retreat. Every space has been considered. Every detail has a reason. This is a home that must be experienced !!

4 Beds ⋅ 4 Baths ⋅ 1049388 MLS

THIS IS A HOME THAT MUST BE EXPERIENCED !! Set on a magnificent 82x100 property, this beautifully appointed Little Neck Hills residence offers something photographs and measurements alone cannot capture. Designed with warmth and texture throughout, the home is expansive where it matters, with virtually every space thoughtfully considered for the way people actually live. The stunning open first floor offers both a generous living room with gas fireplace and a beautiful great room—creating an effortlessly airy everyday living as well as gracious entertaining. At its heart, the spacious custom eat-in kitchen pairs exceptional design with serious functionality, featuring top-of-the-line appliances, abundant cabinetry and storage, and thoughtfully conceived space for cooking, dining and gathering. With 4 bedrooms and 3.5 baths, the home balances shared living with beautifully appointed private spaces. The primary suite is a destination of its own, highlighted by a state-of-the-art bath designed with the comfort, materials and finishes of a private retreat. Throughout, fine craftsmanship and sophisticated details create a quiet sense of quality rather than excess. The exceptionally versatile finished lower level sets itself apart with ceiling heights of approximately 7.5 to 8 feet, creating genuinely livable space with tremendous flexibility for guest accommodations, recreation, a home office, fitness or additional gathering. And then there are the remarkable grounds. Nestled on a quiet, low-traffic cul-de-sac, the exquisite landscaping and hardscaping transform the generous property into a seamless extension of the home, with inviting spaces for dining, entertaining and serenity surrounded by meticulously planned mature plantings and privacy. Extensive improvements throughout reflect thoughtful investment not simply in how a home looks, but in how beautifully and comfortably it lives, a true turn-key retreat. Every space has been considered. Every detail has a reason. This is a home that must be experienced !!

250-18 Rushmore Terrace, Little Neck

$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

$430,000

Very Rare For Sale And Very Desirable Location Of The Development, A True Three Bedroom Clearview Gardens Coop Corner Lower Unit ( Size 5.5, With 857 Square Footage) In The Residential Area Bayside Zip Coop. Living Room,Dining Room,Three Bedrooms All On Hardwood Floors, Updated Open Concept Kitchen With Granite CounterTop,Solid Wooden Cabinents,Stainless Steel Appliances, Wood Molding Trim, Solid Wood Doors, High hat Lighting, Separate Dining Area With Window, Washer,Dryer, And Dishwasher In The Unit,Updated Approved Electric Circuit Breaker, Updated Tiled And Extended Bathroom With Jacuzzi Tub(Sold AS IS Condition) With Storage Area Shelving In The Bathroom, Several Closets For Storage, Parking Spot And Garage Available(Waitlist),Free Public Basement Storage, Close To Shopping, Dining, Parks, NYC Local And Express Bus, Conveniently Close Access To Major Roadways, Highway, Access To Bridges And Airports, Whitestone School District 25,Side Yard For Enjoyment.

3 Beds ⋅ 1 Baths ⋅ 1048608 MLS

Very Rare For Sale And Very Desirable Location Of The Development, A True Three Bedroom Clearview Gardens Coop Corner Lower Unit ( Size 5.5, With 857 Square Footage) In The Residential Area Bayside Zip Coop. Living Room,Dining Room,Three Bedrooms All On Hardwood Floors, Updated Open Concept Kitchen With Granite CounterTop,Solid Wooden Cabinents,Stainless Steel Appliances, Wood Molding Trim, Solid Wood Doors, High hat Lighting, Separate Dining Area With Window, Washer,Dryer, And Dishwasher In The Unit,Updated Approved Electric Circuit Breaker, Updated Tiled And Extended Bathroom With Jacuzzi Tub(Sold AS IS Condition) With Storage Area Shelving In The Bathroom, Several Closets For Storage, Parking Spot And Garage Available(Waitlist),Free Public Basement Storage, Close To Shopping, Dining, Parks, NYC Local And Express Bus, Conveniently Close Access To Major Roadways, Highway, Access To Bridges And Airports, Whitestone School District 25,Side Yard For Enjoyment.

17-06 201st Street Unit #2-103, Bayside

$1,375,000

Nestled in the highly desirable Douglaston–Little Neck neighborhood, this exceptional Tudor-style residence seamlessly blends timeless architecture with modern luxury. Featuring 3 spacious bedrooms and 2.5 bathrooms, this meticulously home offers an elegant balance of character, comfort, and functionality. The inviting entry foyer opens to a thoughtfully designed floor plan featuring a bright sunroom with built-in speakers, a formal dining room, and a warm living room centered around a wood-burning fireplace. Rich hardwood floors, detailed craftsmanship, and abundant natural light create an inviting atmosphere throughout. The custom designed kitchen is a standout, offering stone countertops, cabinetry, stainless steel appliances, a Thermador oven and dishwasher, built-in microwave, pot filler, beverage station, and a refrigerator, perfectly suited for everyday living and entertaining. Additional living space includes a finished attic and an impressive renovated basement with approximately 8-foot ceilings, a full bathroom, laundry area, wet bar, generous storage, and flexible recreation space. Major mechanical systems have been updated, including the boiler, hot water heater, electrical service, gas lines, and plumbing. Modern conveniences include split-system air conditioning and motorized Hunter Douglas window treatments that can be operated by remote control or smartphone. Multiple entrances from the front, side, and rear enhance both accessibility and convenience. The private backyard is designed for entertaining and relaxation, featuring an outdoor kitchen complete with a built-in gas grill, sink, and refrigerator. A heated in-ground pool, outdoor speaker system, tranquil koi pond, and full irrigation system create a true backyard retreat. Completing the property are beautifully crafted stone and bluestone hardscapes, elegant wrought-iron fencing and gates, and a classic slate roof that perfectly complements the home's distinguished Tudor architecture. Note: Approximate living area of 1,780 sq. ft. includes the finished attic. Approximate total of 2,205 sq. ft. includes both the finished attic and the finished basement.

3 Beds ⋅ 3 Baths ⋅ 1033227 MLS

Nestled in the highly desirable Douglaston–Little Neck neighborhood, this exceptional Tudor-style residence seamlessly blends timeless architecture with modern luxury. Featuring 3 spacious bedrooms and 2.5 bathrooms, this meticulously home offers an elegant balance of character, comfort, and functionality. The inviting entry foyer opens to a thoughtfully designed floor plan featuring a bright sunroom with built-in speakers, a formal dining room, and a warm living room centered around a wood-burning fireplace. Rich hardwood floors, detailed craftsmanship, and abundant natural light create an inviting atmosphere throughout. The custom designed kitchen is a standout, offering stone countertops, cabinetry, stainless steel appliances, a Thermador oven and dishwasher, built-in microwave, pot filler, beverage station, and a refrigerator, perfectly suited for everyday living and entertaining. Additional living space includes a finished attic and an impressive renovated basement with approximately 8-foot ceilings, a full bathroom, laundry area, wet bar, generous storage, and flexible recreation space. Major mechanical systems have been updated, including the boiler, hot water heater, electrical service, gas lines, and plumbing. Modern conveniences include split-system air conditioning and motorized Hunter Douglas window treatments that can be operated by remote control or smartphone. Multiple entrances from the front, side, and rear enhance both accessibility and convenience. The private backyard is designed for entertaining and relaxation, featuring an outdoor kitchen complete with a built-in gas grill, sink, and refrigerator. A heated in-ground pool, outdoor speaker system, tranquil koi pond, and full irrigation system create a true backyard retreat. Completing the property are beautifully crafted stone and bluestone hardscapes, elegant wrought-iron fencing and gates, and a classic slate roof that perfectly complements the home's distinguished Tudor architecture. Note: Approximate living area of 1,780 sq. ft. includes the finished attic. Approximate total of 2,205 sq. ft. includes both the finished attic and the finished basement.

5022 Overbrook Street, Douglaston

$1,199,000

Welcome to this well-maintained single-family home located in the highly sought-after Little Neck Hills neighborhood. This charming residence features 3 spacious bedrooms and 1 full bath, offering a comfortable and functional layout perfect for everyday living. As you enter the home, you step into a foyer area with a coat closet. You then continue into the living room which opens to the dining area which leads into the kitchen. The basement steps are in the kitchen as well as a side entrance to the home. Situated on a 23 x 27 building footprint, this property provides excellent potential for expansion. Zoned R2A, and with a FAR of .75, the home allows for an additional 1,760 square feet to be built, making it an ideal opportunity for those looking to customize or grow their living space. With annual taxes of just $9,111, this home offers both value and long-term potential. Conveniently located near the LIRR, public transportation, local eateries, parks, and more. You’ll enjoy easy access to everything the neighborhood has to offer while still maintaining a peaceful residential setting. Whether you’re looking to move right in or expand and create your dream home, this property presents a rare opportunity in a prime location. This home is being sold in its current condition- "as is".

3 Beds ⋅ 1 Baths ⋅ 1031708 MLS

Welcome to this well-maintained single-family home located in the highly sought-after Little Neck Hills neighborhood. This charming residence features 3 spacious bedrooms and 1 full bath, offering a comfortable and functional layout perfect for everyday living. As you enter the home, you step into a foyer area with a coat closet. You then continue into the living room which opens to the dining area which leads into the kitchen. The basement steps are in the kitchen as well as a side entrance to the home. Situated on a 23 x 27 building footprint, this property provides excellent potential for expansion. Zoned R2A, and with a FAR of .75, the home allows for an additional 1,760 square feet to be built, making it an ideal opportunity for those looking to customize or grow their living space. With annual taxes of just $9,111, this home offers both value and long-term potential. Conveniently located near the LIRR, public transportation, local eateries, parks, and more. You’ll enjoy easy access to everything the neighborhood has to offer while still maintaining a peaceful residential setting. Whether you’re looking to move right in or expand and create your dream home, this property presents a rare opportunity in a prime location. This home is being sold in its current condition- "as is".

24829 Cambria Avenue, Little Neck

$1,398,000

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

4 Beds ⋅ 2 Baths ⋅ 1030199 MLS

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

41-35 219th Street, Bayside

$2,189,000

Welcome to an architectural masterpiece set in the heart of Douglaston. Custom-built with uncompromising quality and the finest craftsmanship, this remarkable 4-bedroom, 3-bathroom modern residence sits gracefully on a beautifully manicured lot, offering meticulously designed living space. Step into a breathtaking entrance foyer featuring soaring 20-foot open ceilings that set an immediate tone of grandeur. The main level showcases a seamless open-concept layout where the living room and dining area flow into a gourmet kitchen outfitted with premium quartz countertops, custom high-end cabinetry, and elite appliances. Perfect for indoor-outdoor entertaining, the kitchen extends gracefully onto a vast backyard deck and private yard. The sprawling primary suite serves as a peaceful retreat with serene views, dual custom-fitted closets, and a spa-inspired marble ensuite complete with a double vanity, a deep jacuzzi soaking tub, and a stall shower. Three additional graciously sized bedrooms each feature sunny exposures and ample closet space. A full walk-in-level basement adds exceptional flexible space for a recreation room, home gym, or guest quarters. Complete with central air conditioning. Ideally situated just blocks from the LIRR Station for an easy Manhattan commute, and minutes from major highways, fine dining, shopping, and top-rated schools. Experience the absolute pinnacle of Douglaston Luxury. Schedule your private viewing today!

4 Beds ⋅ 3 Baths ⋅ 1029460 MLS

Welcome to an architectural masterpiece set in the heart of Douglaston. Custom-built with uncompromising quality and the finest craftsmanship, this remarkable 4-bedroom, 3-bathroom modern residence sits gracefully on a beautifully manicured lot, offering meticulously designed living space. Step into a breathtaking entrance foyer featuring soaring 20-foot open ceilings that set an immediate tone of grandeur. The main level showcases a seamless open-concept layout where the living room and dining area flow into a gourmet kitchen outfitted with premium quartz countertops, custom high-end cabinetry, and elite appliances. Perfect for indoor-outdoor entertaining, the kitchen extends gracefully onto a vast backyard deck and private yard. The sprawling primary suite serves as a peaceful retreat with serene views, dual custom-fitted closets, and a spa-inspired marble ensuite complete with a double vanity, a deep jacuzzi soaking tub, and a stall shower. Three additional graciously sized bedrooms each feature sunny exposures and ample closet space. A full walk-in-level basement adds exceptional flexible space for a recreation room, home gym, or guest quarters. Complete with central air conditioning. Ideally situated just blocks from the LIRR Station for an easy Manhattan commute, and minutes from major highways, fine dining, shopping, and top-rated schools. Experience the absolute pinnacle of Douglaston Luxury. Schedule your private viewing today!

233-25 38th Drive, Douglaston

$688,000

2 bedroom , on suite bedroom , washer /dryer combo in unit , large Balcony, Hardwood floor ,floor to ceiling Window. one block to LLRR . close to all shopping , resturant ,supermarket, library. the rooftop deck and fitness room is included in maintenance .. Dimond condition , Copper Tower is located in heart of Bayside , with tax abatement till 2028/2029 , half block from Northern Blvd, and Bell Blvd , and two blocks from LIRR, One assigned Parking is available for sale separately!

2 Beds ⋅ 2 Baths ⋅ 1028358 MLS

2 bedroom , on suite bedroom , washer /dryer combo in unit , large Balcony, Hardwood floor ,floor to ceiling Window. one block to LLRR . close to all shopping , resturant ,supermarket, library. the rooftop deck and fitness room is included in maintenance .. Dimond condition , Copper Tower is located in heart of Bayside , with tax abatement till 2028/2029 , half block from Northern Blvd, and Bell Blvd , and two blocks from LIRR, One assigned Parking is available for sale separately!

43-12 214th Place Unit #3E, Bayside

$1,970,000

An exceptional opportunity to own a beautifully renovated oversized Duplex residence in the heart of the highly desirable Jamaica Estates. This move-in-ready property offers generous living space, modern updates, and outstanding versatility for both homeowners and investors. The first-floor unit features three spacious bedrooms, a stunning renovated interior, a fully finished basement and direct access to an attached two-car garage. The second-floor unit offers three generously sized bedrooms, a bright and airy layout, and a private terrace—perfect for relaxing or entertaining. Step outside to a spacious backyard, ideal for outdoor gatherings, barbecues, and family enjoyment. Conveniently located near shopping, restaurants, parks, schools, public transportation, and major highways, this exceptional property combines luxury, comfort, and convenience in one of Queens’ most prestigious neighborhoods. A truly rare offering, don’t miss this incredible opportunity!

6 Beds ⋅ 3 Baths ⋅ 1024930 MLS

An exceptional opportunity to own a beautifully renovated oversized Duplex residence in the heart of the highly desirable Jamaica Estates. This move-in-ready property offers generous living space, modern updates, and outstanding versatility for both homeowners and investors. The first-floor unit features three spacious bedrooms, a stunning renovated interior, a fully finished basement and direct access to an attached two-car garage. The second-floor unit offers three generously sized bedrooms, a bright and airy layout, and a private terrace—perfect for relaxing or entertaining. Step outside to a spacious backyard, ideal for outdoor gatherings, barbecues, and family enjoyment. Conveniently located near shopping, restaurants, parks, schools, public transportation, and major highways, this exceptional property combines luxury, comfort, and convenience in one of Queens’ most prestigious neighborhoods. A truly rare offering, don’t miss this incredible opportunity!

186-32 Avon Road, Jamaica Estates

$2,299,000

A remarkable showcase of craftsmanship, sophistication, and timeless design, this newly constructed custom all-brick Colonial offers an exceptional luxury lifestyle in the highly desirable Malba Gardens section of Whitestone. Encompassing approximately 2,900 square feet of refined living space and 3,426 square feet of total building area, every detail has been thoughtfully curated with uncompromising quality and elegance. The striking exterior makes an unforgettable first impression with two designer wrought-iron balconies and magnificent custom bronze double entry doors featuring operable crushed-glass panels, decorative iron security grilles, and exquisite artisan detailing. A dramatic two-story foyer welcomes you inside, where oversized custom Pella windows bathe the home in natural light while highlighting the home's impressive architectural finishes. Designed for both everyday comfort and grand-scale entertaining, the residence features three spacious bedrooms and three designer full baths. Rich architectural details include elegant tray ceilings enhanced by LED recessed, cove, and undermount lighting, custom ceiling treatments, extensive crown, dental, and base moldings, and three spectacular cascading multi-tier cut-glass chandeliers that create a luxurious ambiance throughout. The chef-inspired kitchen is beautifully appointed with quartz countertops, a designer glass tile backsplash, premium stainless-steel appliances, and gas cooking, seamlessly flowing into the home's open and inviting living spaces. Comfort is assured year-round with five-zone gas heating, including two-zone radiant heat, central air conditioning complemented by ductless split systems, and premium mechanical systems throughout. Upstairs, a versatile finished bonus playroom provides the perfect space for a media room, home office, or creative studio. The fully finished lower level is equally impressive. With the foundation being excavated deeper, this home is now featuring soaring 8-foot ceilings, a beautifully appointed summer chef's kitchen with private exterior entrance, fitness room, laundry room, utility area, and exceptional flexible living space ideal for extended family, entertaining, or recreation. The resort-inspired backyard is a private oasis designed for unforgettable gatherings. Professionally landscaped and illuminated with custom landscape and security lighting, the outdoor space features elegant paver patios and walkways, a sparkling in-ground swimming pool, a fully equipped outdoor summer kitchen with high end appliances and recessed lighting, and a stylish cabana created from the converted garage with dramatic bifold doors and custom lighting. The entire property is enclosed by maintenance-free vinyl PVC fencing, offering Privacy and a Professional Grade Security System, LTS Platinum 4K PTZ security camera with 36x optical zoom, for piece of mind! A rare opportunity to own a masterfully built custom residence where luxury, craftsmanship, and exceptional outdoor living come together in one of Whitestone's most sought-after neighborhoods. This extraordinary home truly defines modern elegance without compromise.

3 Beds ⋅ 4 Baths ⋅ 1019649 MLS

A remarkable showcase of craftsmanship, sophistication, and timeless design, this newly constructed custom all-brick Colonial offers an exceptional luxury lifestyle in the highly desirable Malba Gardens section of Whitestone. Encompassing approximately 2,900 square feet of refined living space and 3,426 square feet of total building area, every detail has been thoughtfully curated with uncompromising quality and elegance. The striking exterior makes an unforgettable first impression with two designer wrought-iron balconies and magnificent custom bronze double entry doors featuring operable crushed-glass panels, decorative iron security grilles, and exquisite artisan detailing. A dramatic two-story foyer welcomes you inside, where oversized custom Pella windows bathe the home in natural light while highlighting the home's impressive architectural finishes. Designed for both everyday comfort and grand-scale entertaining, the residence features three spacious bedrooms and three designer full baths. Rich architectural details include elegant tray ceilings enhanced by LED recessed, cove, and undermount lighting, custom ceiling treatments, extensive crown, dental, and base moldings, and three spectacular cascading multi-tier cut-glass chandeliers that create a luxurious ambiance throughout. The chef-inspired kitchen is beautifully appointed with quartz countertops, a designer glass tile backsplash, premium stainless-steel appliances, and gas cooking, seamlessly flowing into the home's open and inviting living spaces. Comfort is assured year-round with five-zone gas heating, including two-zone radiant heat, central air conditioning complemented by ductless split systems, and premium mechanical systems throughout. Upstairs, a versatile finished bonus playroom provides the perfect space for a media room, home office, or creative studio. The fully finished lower level is equally impressive. With the foundation being excavated deeper, this home is now featuring soaring 8-foot ceilings, a beautifully appointed summer chef's kitchen with private exterior entrance, fitness room, laundry room, utility area, and exceptional flexible living space ideal for extended family, entertaining, or recreation. The resort-inspired backyard is a private oasis designed for unforgettable gatherings. Professionally landscaped and illuminated with custom landscape and security lighting, the outdoor space features elegant paver patios and walkways, a sparkling in-ground swimming pool, a fully equipped outdoor summer kitchen with high end appliances and recessed lighting, and a stylish cabana created from the converted garage with dramatic bifold doors and custom lighting. The entire property is enclosed by maintenance-free vinyl PVC fencing, offering Privacy and a Professional Grade Security System, LTS Platinum 4K PTZ security camera with 36x optical zoom, for piece of mind! A rare opportunity to own a masterfully built custom residence where luxury, craftsmanship, and exceptional outdoor living come together in one of Whitestone's most sought-after neighborhoods. This extraordinary home truly defines modern elegance without compromise.

145-75 6th Avenue, Whitestone

$440,000

Move right into this updated 3-bedroom, Co-op in Le Havre in Whitestone. Featuring a private terrace, updated designer kitchen w/ quartz counters and stainless-steel appliance, updated bathroom, new flooring/carpeting, fresh paint, etc. Le Havre has 2 Outdoor Pools, 3 Tennis Courts, A Fitness Center, Club House, etc. Close to shopping, transportation, parkways and local amenities. Don’t miss out on this opportunity!

3 Beds ⋅ 1 Baths ⋅ 1018631 MLS

Move right into this updated 3-bedroom, Co-op in Le Havre in Whitestone. Featuring a private terrace, updated designer kitchen w/ quartz counters and stainless-steel appliance, updated bathroom, new flooring/carpeting, fresh paint, etc. Le Havre has 2 Outdoor Pools, 3 Tennis Courts, A Fitness Center, Club House, etc. Close to shopping, transportation, parkways and local amenities. Don’t miss out on this opportunity!

166-10 Powells Cove Boulevard Unit #2C, Whitestone

$289,000

Well maintained corner unit on first floor. Spacious combination living/dining room. Eat in kitchen, windows on two sides. Easy parking and access to public transportation, highways, shopping and restaurants. Renting allowed after 2 years.

1 Beds ⋅ 1 Baths ⋅ 965570 MLS

Well maintained corner unit on first floor. Spacious combination living/dining room. Eat in kitchen, windows on two sides. Easy parking and access to public transportation, highways, shopping and restaurants. Renting allowed after 2 years.

8105 268th Street Unit #228A, New Hyde Park

$315,000

Tenants currently occupied. Maintenance is $1,742.76/month and assessment fee $259.17/month total $2001.93 cover all utilities except electricity. On-site parking is available in the rear lot (first-come, first-served; $35 initial application fee). Located on the 6th-floor penthouse level, this bright and spacious 2-bedroom, 1-bath co-op offers peaceful open views and a comfortable, practical layout. The apartment includes a large living room, a dedicated dining area, an updated kitchen, and two well-sized bedrooms with excellent storage. The bathroom is set between the bedrooms for added convenience. The building provides outstanding amenities, including an Olympic-size outdoor pool, a BBQ area, bike room, laundry facilities, and a live-in super. Cats are allowed, and subletting is permitted after one year. Transportation options include the Q27, Q46, Q88, Q48, QM6, and QM36, with top-rated schools, parks, and shopping hubs nearby. A great opportunity to enjoy a quiet top-floor home in a highly convenient location.

2 Beds ⋅ 1 Baths ⋅ 931245 MLS

Tenants currently occupied. Maintenance is $1,742.76/month and assessment fee $259.17/month total $2001.93 cover all utilities except electricity. On-site parking is available in the rear lot (first-come, first-served; $35 initial application fee). Located on the 6th-floor penthouse level, this bright and spacious 2-bedroom, 1-bath co-op offers peaceful open views and a comfortable, practical layout. The apartment includes a large living room, a dedicated dining area, an updated kitchen, and two well-sized bedrooms with excellent storage. The bathroom is set between the bedrooms for added convenience. The building provides outstanding amenities, including an Olympic-size outdoor pool, a BBQ area, bike room, laundry facilities, and a live-in super. Cats are allowed, and subletting is permitted after one year. Transportation options include the Q27, Q46, Q88, Q48, QM6, and QM36, with top-rated schools, parks, and shopping hubs nearby. A great opportunity to enjoy a quiet top-floor home in a highly convenient location.

224-24 Union Turnpike Unit #6G, Oakland Gardens

$4,899,000

Stunning Luxury Residence in Prestigious Jamaica Estates 4,400 Sq. Ft. | Diamond Condition | Spa-Level Amenities This extraordinary custom-built residence offers the pinnacle of luxury living in one of Jamaica Estates’ most sought-after locations. Sitting on an expansive 8,050 sq. ft. lot and crafted in 2011 with steel-beam construction, this 4,400 sq. ft. home is a masterpiece of design, comfort, and modern craftsmanship. Grand Entrance & Exceptional Craftsmanship A dramatic foyer welcomes you with intricate porcelain mosaic flooring, soaring ceilings, and crystal chandeliers. Rich mahogany paneling, detailed custom moldings, and a sweeping wrought-iron staircase set an unmistakably elegant tone throughout the home. Sophisticated Main Level Designed for both refined entertaining and relaxed everyday living, the main floor features: A spacious formal living room An elegant dining room A gourmet eat-in kitchen equipped with Sub-Zero appliances, three sinks, a large center island, and an exclusive breakfast nook A semi-enclosed dining alcove perfect for intimate meals Radiant heated floors run throughout all three levels, ensuring year-round comfort. Luxurious Private Suites The upper level hosts three expansive master bedrooms, each with its own en-suite bath. Two include walk-in closets, while the main primary suite offers a serene, spa-like retreat with premium finishes and abundant storage. Resort-Style Lower Level The custom-finished basement provides exceptional additional living and entertainment space, featuring: High ceilings A playroom and entertainment lounge A wet bar A full bathroom Private spa amenities including a sauna and steam room Separate entrance Laundry area Outdoor Living & Entertaining The beautifully manicured backyard is ideal for gatherings of any size, offering a peaceful retreat along with an outdoor kitchen perfect for effortless entertaining. Modern Comfort & Convenience Smart home security system Central vacuum Guest quarters Marble bath Diamond condition appearance Unbeatable Location Just steps from shopping, houses of worship, and major expressways, this home delivers both tranquility and unmatched convenience—all within the prestigious enclave of Jamaica Estates.

4 Beds ⋅ 5 Baths ⋅ 932946 MLS

Stunning Luxury Residence in Prestigious Jamaica Estates 4,400 Sq. Ft. | Diamond Condition | Spa-Level Amenities This extraordinary custom-built residence offers the pinnacle of luxury living in one of Jamaica Estates’ most sought-after locations. Sitting on an expansive 8,050 sq. ft. lot and crafted in 2011 with steel-beam construction, this 4,400 sq. ft. home is a masterpiece of design, comfort, and modern craftsmanship. Grand Entrance & Exceptional Craftsmanship A dramatic foyer welcomes you with intricate porcelain mosaic flooring, soaring ceilings, and crystal chandeliers. Rich mahogany paneling, detailed custom moldings, and a sweeping wrought-iron staircase set an unmistakably elegant tone throughout the home. Sophisticated Main Level Designed for both refined entertaining and relaxed everyday living, the main floor features: A spacious formal living room An elegant dining room A gourmet eat-in kitchen equipped with Sub-Zero appliances, three sinks, a large center island, and an exclusive breakfast nook A semi-enclosed dining alcove perfect for intimate meals Radiant heated floors run throughout all three levels, ensuring year-round comfort. Luxurious Private Suites The upper level hosts three expansive master bedrooms, each with its own en-suite bath. Two include walk-in closets, while the main primary suite offers a serene, spa-like retreat with premium finishes and abundant storage. Resort-Style Lower Level The custom-finished basement provides exceptional additional living and entertainment space, featuring: High ceilings A playroom and entertainment lounge A wet bar A full bathroom Private spa amenities including a sauna and steam room Separate entrance Laundry area Outdoor Living & Entertaining The beautifully manicured backyard is ideal for gatherings of any size, offering a peaceful retreat along with an outdoor kitchen perfect for effortless entertaining. Modern Comfort & Convenience Smart home security system Central vacuum Guest quarters Marble bath Diamond condition appearance Unbeatable Location Just steps from shopping, houses of worship, and major expressways, this home delivers both tranquility and unmatched convenience—all within the prestigious enclave of Jamaica Estates.

181-30 Tudor Road, Jamaica Estates

$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