Ltdpropertiesny.com Search Results

$3,450,000

Experience luxury living in this beautiful gated Mediterranean-style home. Set on an expansive 60 x 140 lot and approx. 3,948 sq. ft. of living space, this impressive home features 5 bedrooms, 4.5 recently renovated baths, soaring ceilings in the entrance and family room. The chefs kitchen has top of the line appliances and designed for everyday living and entertaining. additional highlights include radiant heated floors, central vacuum, full finished basement with full bath and garage access, alarm and camera security system. Enjoy your own private resort-style backyard featuring a heated saltwater pool, jacuzzi, outdoor kitchen and pizza oven perfect for entertaining. Take in the beautiful bridge views from the second floor terrace. Conveniently located near, parks, shopping, public transportation, and major bridges with easy access to Manhattan, this home offers luxury, privacy and convenience.

5 Beds ⋅ 5 Baths ⋅ 1044314 MLS

Experience luxury living in this beautiful gated Mediterranean-style home. Set on an expansive 60 x 140 lot and approx. 3,948 sq. ft. of living space, this impressive home features 5 bedrooms, 4.5 recently renovated baths, soaring ceilings in the entrance and family room. The chefs kitchen has top of the line appliances and designed for everyday living and entertaining. additional highlights include radiant heated floors, central vacuum, full finished basement with full bath and garage access, alarm and camera security system. Enjoy your own private resort-style backyard featuring a heated saltwater pool, jacuzzi, outdoor kitchen and pizza oven perfect for entertaining. Take in the beautiful bridge views from the second floor terrace. Conveniently located near, parks, shopping, public transportation, and major bridges with easy access to Manhattan, this home offers luxury, privacy and convenience.

318 147th Place, Whitestone

$3,590,000

Set on the corner of 85th Avenue and 218th Street in Queens Village (11427), on the Hollis Hills border, this ground-up 2021 residence offers 3,617 sq ft of finished living space plus an approximately 1,000 sq ft unfinished attic with 8-foot ceilings — a scale almost impossible to find in the neighborhood. Four bedrooms and five full bathrooms are laid out across two levels, opening from a dramatic double-height entry. The main floor flows from a formal living room into a dining area and an oversized eat-in kitchen, with oversized windows on three exposures thanks to the corner position. Every finish is original to the 2021 build — nothing deferred, nothing to update. A full basement with interior access and an attached garage adds storage, parking, and flexible bonus space. Rooftop solar was installed in 2024, keeping energy costs low. The 47 × 75 corner lot (5,960 sq ft) delivers light on three sides plus private outdoor space at the rear. Located in Queens Village near the Grand Central Parkway for a fast trip into Manhattan or out to Long Island, with the Queens Village LIRR station, Union Turnpike shopping, and neighborhood parks all close by. Turn-key, energy-efficient, and only a few years young — this is new construction in an established Queens Village neighborhood, not a gut renovation.

4 Beds ⋅ 4 Baths ⋅ 1041652 MLS

Set on the corner of 85th Avenue and 218th Street in Queens Village (11427), on the Hollis Hills border, this ground-up 2021 residence offers 3,617 sq ft of finished living space plus an approximately 1,000 sq ft unfinished attic with 8-foot ceilings — a scale almost impossible to find in the neighborhood. Four bedrooms and five full bathrooms are laid out across two levels, opening from a dramatic double-height entry. The main floor flows from a formal living room into a dining area and an oversized eat-in kitchen, with oversized windows on three exposures thanks to the corner position. Every finish is original to the 2021 build — nothing deferred, nothing to update. A full basement with interior access and an attached garage adds storage, parking, and flexible bonus space. Rooftop solar was installed in 2024, keeping energy costs low. The 47 × 75 corner lot (5,960 sq ft) delivers light on three sides plus private outdoor space at the rear. Located in Queens Village near the Grand Central Parkway for a fast trip into Manhattan or out to Long Island, with the Queens Village LIRR station, Union Turnpike shopping, and neighborhood parks all close by. Turn-key, energy-efficient, and only a few years young — this is new construction in an established Queens Village neighborhood, not a gut renovation.

Queens Village

$2,500,000

Welcome to 149-62 Powells Cove Boulevard, a beautiful contemporary home with stunning water and bridge views. This spacious 4-bedroom, 4.5-bath residence offers a comfortable and versatile layout, including a primary suite with breathtaking views right from the window and plenty of space to enjoy with family and friends. The full basement with a separate entrance adds even more flexibility for recreation, a home office, guests, or additional living space. Outside, the in-ground pool creates a wonderful setting for summer days, entertaining, or simply relaxing and taking in the views. Situated in prime Whitestone location, this home offers a special combination of contemporary style, beautiful surroundings, and plenty of space both inside and out. Don’t miss this one of a kind opportunity to own a truly special home in Whitestone!

4 Beds ⋅ 5 Baths ⋅ 1036365 MLS

Welcome to 149-62 Powells Cove Boulevard, a beautiful contemporary home with stunning water and bridge views. This spacious 4-bedroom, 4.5-bath residence offers a comfortable and versatile layout, including a primary suite with breathtaking views right from the window and plenty of space to enjoy with family and friends. The full basement with a separate entrance adds even more flexibility for recreation, a home office, guests, or additional living space. Outside, the in-ground pool creates a wonderful setting for summer days, entertaining, or simply relaxing and taking in the views. Situated in prime Whitestone location, this home offers a special combination of contemporary style, beautiful surroundings, and plenty of space both inside and out. Don’t miss this one of a kind opportunity to own a truly special home in Whitestone!

14962 Powells Cove Boulevard, Whitestone

$4,998,000

Nestled within the prestigious waterfront enclave of Malba, one of Queens’ most exclusive neighborhoods, this exceptional custom-built estate showcases timeless European-inspired architecture, modern luxury, and resort-style living just 25 minutes from Manhattan. Beautifully crafted with elegant stone detailing, graceful arches, custom wrought-iron railings, and a classic clay tile roof, the home welcomes you with a dramatic 40-foot grand foyer and a private elevator serving every level. This sophisticated smart home offers six bedrooms, six full bathrooms, three fireplaces, expansive living spaces, radiant heated floors throughout the first level, all second-floor bathrooms, and the finished lower level, as well as a whole-home surround sound system. Designed for effortless indoor-outdoor living, the resort-style backyard features a smart-controlled saltwater pool, outdoor BBQ kitchen, and an elegant limestone patio framed by architectural arches. An expansive second-floor terrace provides additional space for relaxing and entertaining. Set on one of Malba’s most desirable streets, this distinguished residence offers a rare opportunity to own an exceptional home in one of New York City’s premier waterfront communities.

6 Beds ⋅ 6 Baths ⋅ 1026678 MLS

Nestled within the prestigious waterfront enclave of Malba, one of Queens’ most exclusive neighborhoods, this exceptional custom-built estate showcases timeless European-inspired architecture, modern luxury, and resort-style living just 25 minutes from Manhattan. Beautifully crafted with elegant stone detailing, graceful arches, custom wrought-iron railings, and a classic clay tile roof, the home welcomes you with a dramatic 40-foot grand foyer and a private elevator serving every level. This sophisticated smart home offers six bedrooms, six full bathrooms, three fireplaces, expansive living spaces, radiant heated floors throughout the first level, all second-floor bathrooms, and the finished lower level, as well as a whole-home surround sound system. Designed for effortless indoor-outdoor living, the resort-style backyard features a smart-controlled saltwater pool, outdoor BBQ kitchen, and an elegant limestone patio framed by architectural arches. An expansive second-floor terrace provides additional space for relaxing and entertaining. Set on one of Malba’s most desirable streets, this distinguished residence offers a rare opportunity to own an exceptional home in one of New York City’s premier waterfront communities.

18 Boulevard, Malba

$3,888,000

A showstopper like no other. Reimagined and masterfully rebuilt in 2021, this stunning 3,600+ sqft residence effortlessly blends bold contemporary design with the timeless allure of a Mediterranean villa. With 3 bedrooms and 3.5 bathrooms, every inch of this home exudes style, sophistication, and seamless functionality. Soaring ceilings, dramatic walls of glass, and sleek, high-end finishes create a striking first impression. From the moment you enter, you’re welcomed by exquisite custom millwork, marble-wrapped accent walls, expansive porcelain flooring, and an abundance of natural light. The custom-designed chef’s kitchen by Showcase Kitchens features bespoke cabinetry, top-tier Wolf and Sub-Zero appliances, and dramatic quartzite countertops—a true culinary showpiece. The luxurious primary suite offers a private retreat with floor-to-ceiling windows, soaring ceilings, a spa-inspired designer bathroom, and a spacious walk-in closet. Additional features include a fully finished lower level, radiant heat, energy-efficient systems, and an attached two-car garage. Outside, the home is a work of art. Sculptural architectural lines, manicured hedges, and lush landscaping surround an entertainer’s dream: a resort-style pool, beautifully designed patios, vibrant gardens, and a custom outdoor kitchen. Every detail has been curated to perfection, making this one of Beechhurst’s most extraordinary residences—a true architectural gem.

3 Beds ⋅ 4 Baths ⋅ 1015057 MLS

A showstopper like no other. Reimagined and masterfully rebuilt in 2021, this stunning 3,600+ sqft residence effortlessly blends bold contemporary design with the timeless allure of a Mediterranean villa. With 3 bedrooms and 3.5 bathrooms, every inch of this home exudes style, sophistication, and seamless functionality. Soaring ceilings, dramatic walls of glass, and sleek, high-end finishes create a striking first impression. From the moment you enter, you’re welcomed by exquisite custom millwork, marble-wrapped accent walls, expansive porcelain flooring, and an abundance of natural light. The custom-designed chef’s kitchen by Showcase Kitchens features bespoke cabinetry, top-tier Wolf and Sub-Zero appliances, and dramatic quartzite countertops—a true culinary showpiece. The luxurious primary suite offers a private retreat with floor-to-ceiling windows, soaring ceilings, a spa-inspired designer bathroom, and a spacious walk-in closet. Additional features include a fully finished lower level, radiant heat, energy-efficient systems, and an attached two-car garage. Outside, the home is a work of art. Sculptural architectural lines, manicured hedges, and lush landscaping surround an entertainer’s dream: a resort-style pool, beautifully designed patios, vibrant gardens, and a custom outdoor kitchen. Every detail has been curated to perfection, making this one of Beechhurst’s most extraordinary residences—a true architectural gem.

14-69 165th Street, Whitestone

$1,295,000

Tucked on a tree-lined street in desirable Douglaston, this charming stucco Spanish Colonial Revival home offers timeless architecture and abundant original details that are rare to find today. Step inside to formal living and dining rooms anchored by a wood-burning fireplace with brick facade, a sunroom/sitting room, built-ins, stained glass accents, and excellent natural light throughout. The kitchen opens directly to the backyard and flows beautifully with the rest of the first floor. Upstairs you'll find three bedrooms plus a bright sunroom/office/nursery, beautiful red oak hardwood floors, unpainted hardwood doors, and two full bathrooms (one with dual access). A dramatic wraparound staircase leads to the third floor, partially finished with hardwood floors and full-size windows, offering fantastic expansion potential. The full unfinished basement includes a Weil-McLain boiler, AO Smith ProLine commercial-grade water heater, and laundry hookups. Outside, enjoy a fenced yard shaded by two very large mature oak trees, a garage, and paved side driveway access. This is a true renovation project that rewards creativity. With strong original bones and classic Spanish Colonial details, 12 Carolina Road presents an outstanding opportunity to create a one-of-a-kind home in one of Queens' most convenient neighborhoods. Matterport Available Upon Request.

4 Beds ⋅ 2 Baths ⋅ 1016122 MLS

Tucked on a tree-lined street in desirable Douglaston, this charming stucco Spanish Colonial Revival home offers timeless architecture and abundant original details that are rare to find today. Step inside to formal living and dining rooms anchored by a wood-burning fireplace with brick facade, a sunroom/sitting room, built-ins, stained glass accents, and excellent natural light throughout. The kitchen opens directly to the backyard and flows beautifully with the rest of the first floor. Upstairs you'll find three bedrooms plus a bright sunroom/office/nursery, beautiful red oak hardwood floors, unpainted hardwood doors, and two full bathrooms (one with dual access). A dramatic wraparound staircase leads to the third floor, partially finished with hardwood floors and full-size windows, offering fantastic expansion potential. The full unfinished basement includes a Weil-McLain boiler, AO Smith ProLine commercial-grade water heater, and laundry hookups. Outside, enjoy a fenced yard shaded by two very large mature oak trees, a garage, and paved side driveway access. This is a true renovation project that rewards creativity. With strong original bones and classic Spanish Colonial details, 12 Carolina Road presents an outstanding opportunity to create a one-of-a-kind home in one of Queens' most convenient neighborhoods. Matterport Available Upon Request.

12 Carolina Road, Douglaston

$2,598,000

Final Building Inspection has PASSED and Brand-NEW Certificate of Occupancy is actively processing!! Welcome to this Mediterranean design inspired beauty, nestled in one of the most sought-after locations in Northeast Queens., centrally located to ALL transportation, shopping, parks, schools and more! Sitting on a corner lot and just down the street from Little Neck Bay and The Bayside Marina, this magnificent 5BR, 5Bath home features a grand entry with high ceilings, adding a sense of space and grandeur. Custom built gourmet kitchen featuring solid oak cabinetry, granite, high end appliances and upscale features. Radiant floor heating throughout, oversized rooms, and an abundance of windows (Pella) allowing plenty of natural light to flood the interior. Detail in this home is stunning. Out back is a fabulous yard with built in kitchen, great for entertaining, plenty of space to make it your own and a separate dedicated electric line in place for those that desire to add a pool. A Hallmark of elegance with a European flair and a must see!!

5 Beds ⋅ 5 Baths ⋅ 1012612 MLS

Final Building Inspection has PASSED and Brand-NEW Certificate of Occupancy is actively processing!! Welcome to this Mediterranean design inspired beauty, nestled in one of the most sought-after locations in Northeast Queens., centrally located to ALL transportation, shopping, parks, schools and more! Sitting on a corner lot and just down the street from Little Neck Bay and The Bayside Marina, this magnificent 5BR, 5Bath home features a grand entry with high ceilings, adding a sense of space and grandeur. Custom built gourmet kitchen featuring solid oak cabinetry, granite, high end appliances and upscale features. Radiant floor heating throughout, oversized rooms, and an abundance of windows (Pella) allowing plenty of natural light to flood the interior. Detail in this home is stunning. Out back is a fabulous yard with built in kitchen, great for entertaining, plenty of space to make it your own and a separate dedicated electric line in place for those that desire to add a pool. A Hallmark of elegance with a European flair and a must see!!

28-05 216th Street, Bayside

$3,288,000

Located in the prestigious enclave of Malba, this extraordinary custom-built Mediterranean-style residence blends timeless elegance with exceptional craftsmanship. A grand entryway with soaring vaulted ceilings and a striking chandelier sets the tone for the home’s impressive design. The main level features a beautifully appointed sitting room and formal dining room with gleaming marble floors, along with an expansive open living area that seamlessly connects the gourmet kitchen and family room. The kitchen is designed for both everyday living and entertaining, offering a center island, maple wood cabinetry, granite countertops, and a convenient butler’s pantry for additional preparation and storage space. The adjoining family room is anchored by a gas fireplace and coffered ceiling, creating a warm and inviting gathering space. French doors open to a terrace overlooking the pool, spa, and outdoor kitchen—perfect for indoor-outdoor entertaining. The main level also includes a stylish powder room and laundry area. Upstairs, a grand wrought-iron staircase leads to a spacious landing and the luxurious primary suite, complete with a sitting area, French doors to a private balcony overlooking the backyard, a large walk-in closet, and a spa-like bath with double vanities, shower, and soaking tub. A spiral staircase from the primary suite leads to a spacious loft. Three additional generously sized bedrooms offer ample closet space and Brazilian cherry hardwood floors, including one with its own full en-suite bath. A full hall bath serves the remaining bedrooms. The full basement expands the home’s living space, while nine radiant heating zones and four central air-conditioning zones provide year-round comfort. With exceptional architectural detail, thoughtful design, and resort-style outdoor amenities, this remarkable residence offers a rare opportunity to experience luxury living in Malba.

4 Beds ⋅ 4 Baths ⋅ 1008001 MLS

Located in the prestigious enclave of Malba, this extraordinary custom-built Mediterranean-style residence blends timeless elegance with exceptional craftsmanship. A grand entryway with soaring vaulted ceilings and a striking chandelier sets the tone for the home’s impressive design. The main level features a beautifully appointed sitting room and formal dining room with gleaming marble floors, along with an expansive open living area that seamlessly connects the gourmet kitchen and family room. The kitchen is designed for both everyday living and entertaining, offering a center island, maple wood cabinetry, granite countertops, and a convenient butler’s pantry for additional preparation and storage space. The adjoining family room is anchored by a gas fireplace and coffered ceiling, creating a warm and inviting gathering space. French doors open to a terrace overlooking the pool, spa, and outdoor kitchen—perfect for indoor-outdoor entertaining. The main level also includes a stylish powder room and laundry area. Upstairs, a grand wrought-iron staircase leads to a spacious landing and the luxurious primary suite, complete with a sitting area, French doors to a private balcony overlooking the backyard, a large walk-in closet, and a spa-like bath with double vanities, shower, and soaking tub. A spiral staircase from the primary suite leads to a spacious loft. Three additional generously sized bedrooms offer ample closet space and Brazilian cherry hardwood floors, including one with its own full en-suite bath. A full hall bath serves the remaining bedrooms. The full basement expands the home’s living space, while nine radiant heating zones and four central air-conditioning zones provide year-round comfort. With exceptional architectural detail, thoughtful design, and resort-style outdoor amenities, this remarkable residence offers a rare opportunity to experience luxury living in Malba.

138-15 13th Avenue, Malba

$4,990,000

A true Mediterranean masterpiece nestled in the heart of prestigious Malba, this extraordinary luxury estate showcases impeccable craftsmanship and the finest materials throughout. From the moment you enter the grand, inviting foyer, you are immersed in a world of refined elegance and designer sophistication. Rich mahogany wood and exquisite marble finishes span the entire home, creating a timeless sense of grandeur. This state-of-the-art showplace features a stunning primary suite complete with a private en-suite retreat and an expansive balcony overlooking the resort-style backyard. Enjoy breathtaking views of the dramatic pool—perfect for both relaxation and upscale entertaining. An exceptional dual Asian and Western chef’s kitchen is masterfully designed to accommodate both refined culinary experiences and grand-scale gatherings. Outfitted with top-tier appliances, including a Wolf gas cooktop, Sub-Zero refrigeration, and a full suite of Miele appliances, this space exemplifies both performance and sophistication. A dramatic marble island serves as the centerpiece, while three dishwashers and two wine coolers offer unparalleled convenience for modern luxury living. A sun-filled sunroom showcases a beautifully crafted wood-paneled ceiling and refined wood flooring. A full wall of French sliding doors creates a seamless indoor-outdoor flow to the backyard, while intricate ornamental moldings add a touch of timeless sophistication. Designed for ultimate comfort and elevated living, the lower level offers a private media room, a temperature-controlled wine cellar, and a billiards room—creating an unparalleled lifestyle experience. Combining privacy, scale, and elegance, this dream residence defines the pinnacle of luxury living. This is a home you truly have to see to believe.

5 Beds ⋅ 6 Baths ⋅ 984505 MLS

A true Mediterranean masterpiece nestled in the heart of prestigious Malba, this extraordinary luxury estate showcases impeccable craftsmanship and the finest materials throughout. From the moment you enter the grand, inviting foyer, you are immersed in a world of refined elegance and designer sophistication. Rich mahogany wood and exquisite marble finishes span the entire home, creating a timeless sense of grandeur. This state-of-the-art showplace features a stunning primary suite complete with a private en-suite retreat and an expansive balcony overlooking the resort-style backyard. Enjoy breathtaking views of the dramatic pool—perfect for both relaxation and upscale entertaining. An exceptional dual Asian and Western chef’s kitchen is masterfully designed to accommodate both refined culinary experiences and grand-scale gatherings. Outfitted with top-tier appliances, including a Wolf gas cooktop, Sub-Zero refrigeration, and a full suite of Miele appliances, this space exemplifies both performance and sophistication. A dramatic marble island serves as the centerpiece, while three dishwashers and two wine coolers offer unparalleled convenience for modern luxury living. A sun-filled sunroom showcases a beautifully crafted wood-paneled ceiling and refined wood flooring. A full wall of French sliding doors creates a seamless indoor-outdoor flow to the backyard, while intricate ornamental moldings add a touch of timeless sophistication. Designed for ultimate comfort and elevated living, the lower level offers a private media room, a temperature-controlled wine cellar, and a billiards room—creating an unparalleled lifestyle experience. Combining privacy, scale, and elegance, this dream residence defines the pinnacle of luxury living. This is a home you truly have to see to believe.

17 North Drive, Malba

$2,450,000

154-96 Riverside Drive | Whitestone, NY A Masterpiece of Modern Luxury Living Welcome to this fully customized smart home on a premier 60x100 corner lot in Whitestone, offering approximately 4,000 square feet of living space (excluding the finished basement), with four bedrooms, two full and two half baths. Radiant heated floors on the first level, heated second-floor bathrooms and laundry, central air, and individual climate controls in every bedroom provide ultimate comfort year-round. A gas fireplace anchors the main living space. Designed for modern living, the home features full smart home integration with app-controlled lighting and systems. Enjoy in-ceiling Bose speakers throughout, a Sonos audio system, and surround sound in both the living room and finished basement for a seamless entertainment experience. The chef’s kitchen is equipped with top-of-the-line Wolf and Sub-Zero appliances, including an 8-burner stove, built-in espresso machine, double Bosch dishwashers, wine fridge, disposal/compactor, and two farmhouse sinks with point-of-use filtration. A custom pantry with a pullout desk adds convenience, along with a first-floor powder room. Upstairs, the king-sized primary suite offers a spa-like en-suite bath and California Closets, with Restoration Hardware chandeliers enhancing every bedroom. A top-floor laundry room completes the level. The finished basement extends the living space with indoor-outdoor flow, ideal for entertaining. Outside, enjoy a private resort-style setting with a heated saltwater pool (7 ft to 3 ft) with automated cover, plus an outdoor kitchen featuring a Wolf barbecue and Blaze refrigerator. A rare opportunity to own a turn-key luxury smart home combining scale, comfort, technology, and high-end finishes in one of Whitestone’s most desirable locations. Featured Residential Sales.

4 Beds ⋅ 4 Baths ⋅ 974294 MLS

154-96 Riverside Drive | Whitestone, NY A Masterpiece of Modern Luxury Living Welcome to this fully customized smart home on a premier 60x100 corner lot in Whitestone, offering approximately 4,000 square feet of living space (excluding the finished basement), with four bedrooms, two full and two half baths. Radiant heated floors on the first level, heated second-floor bathrooms and laundry, central air, and individual climate controls in every bedroom provide ultimate comfort year-round. A gas fireplace anchors the main living space. Designed for modern living, the home features full smart home integration with app-controlled lighting and systems. Enjoy in-ceiling Bose speakers throughout, a Sonos audio system, and surround sound in both the living room and finished basement for a seamless entertainment experience. The chef’s kitchen is equipped with top-of-the-line Wolf and Sub-Zero appliances, including an 8-burner stove, built-in espresso machine, double Bosch dishwashers, wine fridge, disposal/compactor, and two farmhouse sinks with point-of-use filtration. A custom pantry with a pullout desk adds convenience, along with a first-floor powder room. Upstairs, the king-sized primary suite offers a spa-like en-suite bath and California Closets, with Restoration Hardware chandeliers enhancing every bedroom. A top-floor laundry room completes the level. The finished basement extends the living space with indoor-outdoor flow, ideal for entertaining. Outside, enjoy a private resort-style setting with a heated saltwater pool (7 ft to 3 ft) with automated cover, plus an outdoor kitchen featuring a Wolf barbecue and Blaze refrigerator. A rare opportunity to own a turn-key luxury smart home combining scale, comfort, technology, and high-end finishes in one of Whitestone’s most desirable locations. Featured Residential Sales.

15496 Riverside Drive, Whitestone